Our Data masterclass training for those seeking a rewarding career in the digital economy equips candidates with enviable digital skills to thrive in today’s business world. The program is taught in an application-oriented manner with case studies and examples from a variety of industries, while also building the foundation for the most widely-used, easily accessible analytics tools and techniques (Microsoft Excel, Power BI and SQL from basic to advanced).
Candidates will design, deploy and manage social experiments that will enable work experience in data gathering, business intelligence development, using forms, google analytics, Meta business manager, and Trello.
Basic to Advanced
Schedule Breakdown
Every Candidate gets 90 days subscription. This includes:
5 weeks of Tuesday and Thursday intensive tutor-led sessions,
November:
22nd and 24th 10 am – 5 pm
29th 10 am – 5 pm
December:
1st 10 am – 5 pm
6th and 8th 10 am – 5 pm
13th and 15th 10 am – 5 pm
20th and 22nd 10am – 5 pm
Virtual Projects commence midweek for 55 days and those that meet the required level of expectation in tackling industry-related problems will be given a certificate.
Data Masterclass
You get:
Immersive online and physical Bootcamp
Concise self help videos with work materials
Recorded sessions
Certificate of Achievement
Weekend live sessions
Assessment and feedback
Interview prep
Get your Certificate
Course Highlights
Introduction to Data Analytics using excel
Formulas and Functions
Pivot Tables
Power Query and Pivot
What-if analysis
Visualization and reporting
Power BI cloud for Decision support development
ETL (Extraction, Transformation, and Loading process of Data)
Data Prep challenges
Reporting
Data visualization
DAX functions
Introduction:
Database, Tables & Keys, Creating Tables & CRUD
Constraints, Basic Queries, Company Database example and Creating Company Database
Functions and Wildcards
Union and Joins
Nested Queries and Triggers
ER Diagrams Intro and Designing an ER Diagram
Converting ER Diagrams to Schemas
Project work will include the use of the following tools:
Google Analytics
Meta business manager
Email Marketing
Web-development
Trello