Data Analytics Mastery
The Data Analytics Mastery Course is a comprehensive program designed to equip individuals with in-depth skills and expertise in data analytics.
Over a three-month period, participants will gain hands-on experience with industry-standard tools, including Microsoft Excel, Power BI, SQL, and PowerPoint.
The training incorporates a structured series of assessments, assignments, and tests, ensuring practical application of acquired knowledge and reinforcing key analytical concepts.
1
%
Instructor Led
1
%
Certified
Course Tools:
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