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.
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