Data Analytics Intermediate

The Data Analytics Intermediate Course is designed to equip individuals with advanced skills and knowledge in Data Analytics using tools like Microsoft Excel, Power BI, and SQL.

 

Participants will learn more about concepts in Excel such as “Data Validation” and “What If Analysis” while gaining practical experience in the use of Power Query for Excel and Power BI. Advanced concepts in SQL such as Joins, Stored Procedures, and Triggers will also be covered.

Enroll Now
View Course Brochure
1 %

Instructor Led

1 %

Certified

Course Tools:

Microsoft_Excel-Logo.wine
Microsoft-Power-BI-Symbol (1)
pngwing.com

What you’ll learn

  • Introduction to Power Query
  • Data Cleaning and Manipulation
  • Advanced Power BI dashboard interfacing
  • Data Modelling and Advanced DAX Functions
  • Automation of interactive Power BI dashboards
  • Data Validation in Excel
  • What If Analysis in Excel
  • Index and Match Functions
  • Recap of Basic SQL
  • Merging Subqueries
  • Aggregate Functions
  • SQL Joins

What you stand to gain

  • Access to datasets and resources to aid practice
  • Certificate of completion
  • Job Referrals and Recommendation Letter
  • Access to class recordings
  • Mentorship
  • Participation in data hackathons, seminars and other events hosted by Dataleum

Course Features

  • Lectures: Active engagement with enriched course content
  • 4-5 hours per day || 3 weeks
  • A maximum class of 40 participants for effective learning
  • Learning Mode: E-Live, Facilitator-led learning.
  • Pass Mark: 75%
  • Skill level: Intermediate