Data Analytics Specialist

R3 000.00

Companies are looking for Data Scientists who can manage data, get results, and drive decision-making. Analytics is all about using data to answer questions, and this Aspire Journey will teach you just that. You’ll learn how to analyze data, build dashboards, and deliver impactful reports. Along the way, you’ll build skills in SQL, Tableau, and Excel that will prepare you to fulfill a Data Analytics role.

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

Course fee: R3 000.00

DepositR750.00

Monthly instalments: R750.00 x 3

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

      • 17 courses (12h 59m) / 10 labs (10h) / 7 others (8h 30m)
      • Optional additional resources are available to enhance your learning in your own time.

Course code: C01352

 

Course overview:

    • Track 1: Exploring and Visualizing Data in Excel
    • Track 2: Databases with SQL
    • Track 3: Tableau

 

Modules and topics covered:

Track 1: Exploring and Visualizing Data in Excel

Exploring Data In Excel

Pivot Tables In Excel

Formatting cells and ranges in Excel 365

Visualizing Data In Excel

Handling Data In Excel

 

Track 2: Databases with SQL

SQL Overview

SQL Manipulation

Queries

Aggregate Functions

Query Multiple Tables with SQL

SQL Window Functions

SQL Math and Date Functions

 

Track 3: Tableau

Opening & Connecting Data Sources in Tableau Desktop

Preparing & Cleaning Data in Tableau Desktop

Blending & Managing Data Files in Tableau Desktop

Working with Data & Fields in Tableau Desktop

Creating Data Visualizations in Tableau Desktop

Analyzing Data in Tableau Desktop

Performing Calculations in Tableau Desktop

Going Deeper with Maps in Tableau Desktop

Enhancing Data Visualizations in Tableau Desktop

Presenting & Delivering Vizzes in Tableau Desktop

Tableau: Storytelling Tools

Tableau Desktop: Real Time Dashboards

Academic grade: No minimum school pass requirements or formal prerequisites.

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 exam 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
*Selected IT classes at the Bellville campus (Cape Town) only
This field is for validation purposes and should be left unchanged.