Business Analyst to Data Analyst

R4 320.00

Data Analysts interpret data and turn it into information that drives business decisions. This journey will guide you in the transition from Business Analyst to a Data Analyst by teaching the required skills.

Online books Digital learning
Clock Start anytime
Calendar Months course access
Computer Skillsoft LMS access
Teacher and student Dedicated Skillsoft mentor
Certificate Certified by Optimi College

Course fee: 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.

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

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.

Course type: Short course

Industry partner: Skillsoft

Certification: Certificate confirming course completion.

Certification issued by: Optimi College

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.

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.

"*" indicates required fields

Are you still in school?*
When do you want to start?*
Do you require financial assistance?
Optimi College is in partnership with Student Hero. By selecting “yes” you consent to share your name and contact information with Student Hero so that they can assist you with seeking financial aid.
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
*Selected IT classes at the Bellville campus (Cape Town) only
This field is for validation purposes and should be left unchanged.