Course curriculum

  • 1

    SKILLS DIAGNOSIS SURVEY

    • Skills Survey
  • 2

    Introduction

    • What is Data Analytics?

    • Business Analyst vs Data Analyst

    • Types of Data Analysis

    • Road map to become a Data Analyst

    • Quiz_Introduction
  • 3

    Microsoft Excel

    • Basic Formulas: Sum, Average, Product, Mean, IF, Sumif

    • Advanced Formula: Vlookup, Xlookup, Hlookup

    • Pivot Tables

    • Business math and Statistics using Excel for Data Analyst

    • Power Query

    • Data Cleaning Using Excel

    • Quiz_Microsoft Excel
  • 4

    Business Intelligence Tools (Power BI or Looker)

    • Introduction to Power BI

    • Data Transformation in Power Query

    • Creating Metrics using DAX

    • Data Modelling in Power BI

    • Dashboarding

    • Publishing to Power BI Service

    • Quiz_BI Tools
  • 5

    SQL

    • Introduction to Database and SQL

    • Basic SQL Syntax

    • Retrieving data with SQL

    • Advanced SQL Queries

    • SQL Project for Data Analyst

    • Quiz_SQL
  • 6

    Presentation Style

    • How to Present and Interpret your results as a data analyst
  • 7

    Project

    • Evaluation Project
  • 8

    Feedback

    • Copy of Congratulations for completing your course, please rate this course on a scale of 1-5. Once you've submitted your rating, your certificate will be available for immediate download.