BI Data Engineer | Analyst: Power BI, SQL, Data Excel ,DAX

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: What is a Data Engineer

Lecture 3: What is a Data Analyst

Lecture 4: What is SQL

Lecture 5: What is Power BI

Lecture 6: What is Power BI Desktop

Lecture 7: What is DAX

Chapter 2: Power BI Setup and Overview

Lecture 1: Setting Up Office365

Lecture 2: Installing Power BI Desktop

Lecture 3: Power BI Desktop tour

Lecture 4: Power BI Overview: Part 1

Lecture 5: Power BI Overview: Part 2

Lecture 6: Power BI Overview: Part 3

Lecture 7: Components of Power BI

Lecture 8: Building blocks of Power BI

Lecture 9: Exploring Power BI Desktop Interface

Lecture 10: Exploring Power BI Service

Lecture 11: Power BI Apps

Chapter 3: Connecting Power BI To Web Data

Lecture 1: Connect to web data

Lecture 2: Clean and transform data : Part 1

Lecture 3: Clean and transform data : Part 2

Lecture 4: Combining Data Sources

Lecture 5: Creating Visualization : Part 1

Lecture 6: Creating Visualization : Part 2

Lecture 7: Publishing Reports to Power BI Service

Chapter 4: Connecting Power BI To Databases

Lecture 1: What is SQL Server

Lecture 2: SQL Server Download

Lecture 3: SQL Server Installation

Lecture 4: Install SSMS

Lecture 5: Connect to SQL Server with SSMS

Lecture 6: Download Sample Database

Lecture 7: SQL Server Minimum Hardware & Software Installation Requirements

Lecture 8: Connect Power BI To SQL Server Database

Lecture 9: What is PostgreSQL

Lecture 10: Minimum Installation Requirements for PostgreSQL

Lecture 11: Install PostgreSQL on Windows

Lecture 12: Install PostgreSQL on Macs

Lecture 13: Install PgAdmin4 on Macs

Lecture 14: Install PostgreSQL on Linux

Lecture 15: Install PgAdmin4 on Linux

Lecture 16: Connect to PostgreSQL

Lecture 17: Install Sample Database

Lecture 18: Connect Power BI To PostgreSQL database: Part 1

Lecture 19: Connect Power BI To PostgreSQL database: Part 2

Lecture 20: Connect Power BI To Access Database File

Chapter 5: Data Analysis & Transformation with Power BI

Lecture 1: Changing locale

Lecture 2: Connect to access database file

Lecture 3: Power query editor and queries

Lecture 4: Creating and managing query groups

Lecture 5: Renaming Queries

Lecture 6: Splitting Columns

Lecture 7: Changing Data Types

Lecture 8: Removing and reordering columns

Lecture 9: Duplicating and adding columns

Lecture 10: Creating conditional columns

Lecture 11: Connecting to files in folder

Lecture 12: Appending queries

Lecture 13: Merge queries

Lecture 14: Query dependency view

Lecture 15: Transform less structured data: Part 1

Lecture 16: Transform less structured data: Part 2

Lecture 17: Creating tables

Lecture 18: Query Parameters

Chapter 6: Data Modelling and Analysis with Power BI

Lecture 1: What is Data Modelling

Lecture 2: Creating and managing data relationships

Lecture 3: Creating Calculated columns

Lecture 4: Optimizing Models for reporting

Lecture 5: Time Intelligence

Lecture 6: Applying Filters on Visuals

Chapter 7: Excel Setup ( Optional )

Lecture 1: Office 365 setup ( Optional)

Lecture 2: Activating office 365 ( Optional)

Lecture 3: Logging into office 365 (Optional)

Lecture 4: What is Power Pivot

Lecture 5: Office versions of power pivot

Lecture 6: How to enable power pivot in excel

Lecture 7: What is Power Query

Chapter 8: Data Analysis & Visualization with Excel

Lecture 1: Connecting to a data source

Lecture 2: Preparing query

Lecture 3: Cleansing data

Lecture 4: Enhancing query

Lecture 5: Creating a data model

Lecture 6: Build Relationships with data

Lecture 7: Create lookups with DAX

Lecture 8: Analyse Data with Pivot Tables

Lecture 9: Analyse data with Pivot Charts

Lecture 10: Refresh Source Data

Lecture 11: Update Queries

Lecture 12: Create new reports

Chapter 9: MySQL Database Server Setup

Lecture 1: What is MySQL

Lecture 2: MySQL Download Link

Lecture 3: MySQL Windows Installation