Business Analyst to Data Analyst

Course fee

Cost: R4 320.00

Deposit: R1 080.00

Monthly instalment: R810.00 x 4

Duration: You will have Skillsoft access to this course for 12 months. The average time required to work through the syllabus is:

• 38 courses (47h 35m) / 4 labs (32h)
• Optional additional resources are available to enhance your learning in your own time.

About the course

Course code: C01322

Course overview:

In this Skillsoft Aspire journey, a stage is set by covering comprehensive courses on Excel, a powerful, most common, and widely used data analysis tool in the industry. It then teaches you the most popular Data Visualization tools and techniques. You will also learn the about Data Analysis using Python. Here, you will explore data gathering, exploration, cleaning, and transforming using Python. You will also learn BigML which is a popular Machine Learning platform.

The tracks you will be covering are:

• Track 1: Business Analyst
• Track 2: Decision Analyst
• Track 3: Systems Analyst
• Track 4: Data Analyst

What are Aspire Journeys?

Aspire Journeys are guided learning paths designed and published by Skillsoft. These courses provide:

• A clear starting point across the roles and responsibilities of tomorrow.
• Exercises for on-the-job applications to put what you’ve learned into practice.
• Verifiable, shareable, and portable digital badges so you can celebrate accomplishments along the way.
• A diverse array of learning tools from the books to audiobooks to video courses, and more.

The learning path for each journey comprises tracks of content in a recommended order. Completing all content within a track completes the track. Completing all tracks within the journey completes the journey.

Modules and topics covered:

Track 1: Business Analyst

• Complete Guide to Excel 365: Getting Started
• Complete Guide to Excel 365: Working With Charts & Sparklines
• Complete Guide to Excel 365: Using Formatting, Styles, & Themes
• Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks
• Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
• Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak
• Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
• Final Exam: Business Analyst

Track 2: Decision Analyst

• Tableau for Data Visualization: Introduction
• Tableau for Data Visualization: Exploring Visualizations & Data Formats
• Tableau for Data Visualization: Advanced Features
• Business Reporting: Getting Started with Power BI Desktop for Data Analysis
• Business Reporting: Visualizing & Merging Data in Power BI
• Business Reporting: Creating & Formatting Matrix Visualizations in Power BI
• Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
• Final Exam: Decision Analyst

Track 3: Systems Analyst

• Google Chart Tools: Basic Charts
• Google Chart Tools: Interacting with Charts
• Google Chart Tools: Advanced Visuals with Charts
• Plotly for Data Visualization: An Introduction to Plotly Chart Studio
• Plotly for Data Visualization: Exploring Chart Studio Visualizations
• Plotly for Data Visualization: Advanced Charts & Features in Chart Studio
• SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis
• SQL Programming with MariaDB: Analyzing Relational Data
• SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
• Final Exam: Systems Analyst

Track 4: Data Analyst

• VBA: Getting Started with VBA in Excel
• VBA: Building User Interfaces with Forms in VBA & Excel
• VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access
• Using BigML: An Introduction to Machine Learning & BigML
• Using BigML: Getting Hands-on with BigML
• Using BigML: Building Supervised Learning Models
• Using BigML: Unsupervised Learning
• Analyzing Data Using Python: Data Analytics Using Pandas
• Analyzing Data Using Python: Importing, Exporting, & Analyzing Data With Pandas
• Analyzing Data Using Python: Filtering Data in Pandas
• Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas
• Final Exam: Business Analyst to Data Analyst

Admission requirements

Academic grade: No minimum school pass requirements but we recommend that students have the following prerequisite skills:

• Knowledge of data visualization tools
• Knowledge of programming
• Knowledge of databases.

Language: Proficiency in English (course material and support only available in English).

Expertise level: Beginner

Equipment: Access to a PC or laptop with a reliable internet connection.

Effort: Self-paced learning online.

Accreditation status

Course type: Short course

Industry partner: Skillsoft

Certification: Certificate confirming course completion.

Certification issued by: College SA

Assessment information:

Each track concludes with a final internal assessment that will test your knowledge and application of the topics presented throughout that specific track.

There are no external certification exams for this course.

What to expect

Dedicated support team

We understand that students may require guidance and support to navigate the learning journey, and our Client Services team is always ready to assist them in every possible way. Our team is readily available during office hours and can be contacted via email, phone, WhatsApp and social media.

Skillsoft Learner Management System (LMS) access

Skillsoft is an online learning management system that offers all students enrolled for any of our IT Academy courses compelling content, interactive videos, quizzes, mentoring and practical simulations/virtual labs. The platform allows students to learn at their own pace.