Excel
1. Introduction to Excel
○ Exploring the Excel interface
○ Basic Excel functions and formulas (SUM, AVERAGE, MIN, MAX)
2. Data Manipulation and Cleaning
○ Using data validation, conditional formatting, and functions like
CONCATENATE, TRIM, UPPER, and LOWER
3. Data Transformation
○ Power Query: importing and transforming data
○ Power Pivot: creating data models and using DAX functions
4. Data Visualization
○ Creating Pivot charts and visualizations
MySQL
1. Introduction to SQL
○ Basics of database management systems
○ Creating databases and tables
2. SQL Commands
○ Using SQL statements: SELECT, INSERT, UPDATE, DELETE
○ Applying logic with WHERE, GROUP BY, and ORDER BY clauses
3. Joins and Aggregates
○ Working with different JOINs (LEFT, RIGHT, INNER, FULL)
○ Aggregate functions (SUM, AVG, COUNT, etc.)
PowerBI
1. Introduction to PowerBI
○ Getting started with data importation
○ Data cleaning and transformation techniques
2. Data Modeling and Visualizations
○ Using DAX and creating relationships between
Course Benefits
● Practical Skills: Your child will learn how to analyze and interpret real data.
● Develops Logical Thinking: The course builds critical thinking and problem-solving
skills.
● Industry Tools: They will gain hands-on experience with Excel, MySQL, and
PowerBI.
● OngoingGuidance: Mentorship is available for continued support after the course.
For Add Course Review. You need to login first Login Here
UpdatedNovember 2020
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
UpdatedNovember 2020
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
UpdatedNovember 2020
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
UpdatedNovember 2020
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
UpdatedNovember 2020
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included