Data Analytics Mastery

This is a full-stack comprehensive course designed to equip individuals with relevant skills and knowledge in Data Analytics, providing a thorough grounding in the fundamentals while also introducing participants to intermediate concepts.

Enroll Now
View Course Brochure
1 %

Instructor Led

1 %

Certified

Course Tools:

pngwing.com
pngwing.com (1)
pngwing.com (3)
pngwing.com (2)
pngwing.com (4)

What you’ll learn

  • Introduction to Data Analytics
  • Data Cleaning with Microsoft Excel
  • Pivot Tables and Pivot Charts with Excel
  • Building dashboards with Microsoft Excel
  • Data Validation in Excel
  • What If Analysis - Goal Seek & Scenario Manager
  • Index and Match
  • Power Query with Excel
  • Data Presentation with PowerPoint
  • Data Visualization with Power BI
  • Data Modelling with Power BI
  • Power Query with Power BI
  • Advanced Power BI Dashboard Interfacing
  • Introduction to SQL
  • Writing Basic SQL Commands
  • Categories of SQL
  • Advanced SQL - Stored Procedures and Triggers
  • SQL Joins

What you stand to gain

  • Access to datasets and resources to aid practice
  • Certificate of completion
  • Job Referrals and Recommendation Letter
  • Participation in data hackathons which will improve your skills
  • 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 months
  • A maximum class of 40 participants for effective learning
  • Learning Mode: Virtual or Hybrid
  • Skill Level: Beginner
  • Assessment: Assignment, Presentation, Exam