Course curriculum

    1. What is Data Analytics

    2. Business Analyst vs Data Analyst

    3. Types of Data Analysis

    4. Road map to become a Data Analyst

    5. Quiz_Introduction

    1. Basic Formulas: Sum, Average, Product, Mean, IF, Sumif

    2. Advanced Formula: Vlookup, Xlookup, Hlookup

    3. Pivot Tables

    4. Business math and Statistics using Excel for Data Analyst

    5. Power Query

    6. Data Cleaning Using Excel

    7. Quiz_Microsoft Excel

    1. Introduction to Power BI

    2. Data Transformation in Power Query

    3. Creating Metrics using DAX

    4. Data Modelling in Power BI

    5. Dashboarding

    6. Publishing to Power BI Service

    7. QUIZ

    1. Introduction to Database and SQL

    2. Basic SQL Syntax

    3. Retrieving data with SQL

    4. Advanced SQL Queries

    5. SQL Project for Data Analyst

    6. QUIZ

    1. How to Present and Interpret your results as a data analyst

    1. Evaluation Project

About this course

  • Free
  • 28 lessons
  • 10 hours of video content