Course Outlines

•  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

 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.