Preview Power BI Specialization with DAX

Back

Overview Of Data Analytics

Introduction to Power BI Course 2023

Introduction to Data Analytics

Unpacking and Importing Zip Files into Power BI

Instructional_Video

Course Materials

PBI Power Query, Report View & Services Datasets

Explore the Dynamic User Interface of Power BI

Download and Install Power BI Desktop Application

User Interface of Microsoft Power BI Desktop

Power Query

Introduction to Power Query

What is Power Query

Quiz (MCQ)

Introduction to Power Query

Getting Started with Basic of Functions

Introduction to Basic Functions

Text Functions in Power BI Power Query

Date Functions in Power BI Power Query

Number Functions in Power BI Power Query

Quiz (MCQ)

Text Functions

Quiz (MCQ)

Date Functions

Quiz (MCQ)

Number Functions

Conditional Column & Column From Examples

Introduction to Conditional Column & Column From Examples

Conditional Column in Power BI Power Query

Column From Examples in Power BI Power Query

Quiz (MCQ)

CFE & Conditional Columns

Appending or Combining Files

Introduction to Appending or Combining Files

Combine 49 CSV Files in 3 Button Clicks

Consolidated Files with Different Structures

Quiz (MCQ)

Append Queries

Replacing VLOOKUP with Merge Queries

Introduction to Replacing VLOOKUP

Introduction to Merge Queries

Advanced Merge Queries

Challenge with Merge Queries

Quiz (MCQ)

Merge Queries

Powerful Cleaning Features in Power Query

Introduction to Powerful Cleaning Features in Power BI Power Query

Data Cleaning in Power BI Power Query

Changing Structure of Data in Power BI Power Query (Unpivot)

Quiz (MCQ)

Data Cleaning

Working with Rows & Columns in Power Query

Introduction to Working with Columns & Rows

Working with Rows & Columns in Power BI Power Query

Quiz (MCQ)

Working with Rows and Columns

Various Data Sources in Power BI

Get SQL Data in Power BI

Get Live Website Data in Power BI

Get Email Data in Power BI

Get Google Forms (Google Sheets) Data in Power BI

Get Power BI Datasets

Share Point Data in Power BI

Get JSON Files in Power BI

Material

Working with Filters & Parameters

Introduction to working with Filters, Sorting and Parameters

Working with Filter, Parameters and Sorting in Power BI Power Query

Quiz (MCQ)

Sort & Filter

Custom Function Feature to Clean & Combine Files

Introduction to Custom Function to Clean & Combine Files

Clean & Combine CSV Files In Power BI Power Query

Clean & Combine Excel Files In Power BI Power Query

Quiz (MCQ)

Clean and Combine Files

Finding Out Postal Codes from States & UTs

Material

States and UT in India

Case Studies

Introduction to Case Studies

Get File Names From a Folder In Power BI Power Query

Cleaning Payroll Data In Power BI Power Query

Clean Data & Get Discounts In Power BI Power Query

Split Data in Rows & Columns In Power BI Power Query

Changing Stacked Address Table In Power BI Power Query - {Pivot}

Cleaning Bank Financial Data In Power BI Power Query

TechnoEdge Case Study In Power BI Power Query

Pick up the latest file from the folder in Power BI Power Query

Matching Records in Two Tables In Power BI Power Query

Create Fiscal Year Calendar In Power BI Power Query

Clean Bank Statement Available In PDF In Power BI Power Query

Quiz (MCQ)

Case Studies

Extra Case Studies

Assigning Scores to Students - Approximate VLOOKUP

Structuring Invoice Data

Author Book Challenge

Case Studies Material

M Functions

Introduction to M Language

M Functions Date - IsIn

M Functions Date_ Add and Subtract

M Functions - Date - Basic

M Functions - Text

Write a Simple M Code

Trick to get help for 800+ M Functions

M Function Material

Free Bonus Assignments

Date Function

Text Function

Number Function

Conditional Column & CFE

Appending & Combining Files

Replacing VLOOKUP with Merge Queries

Powerful Cleaning Feature in PBI Power Query

Working with Rows & Columns

Working with Filters & Parameters

Custom Function Feature to Clean & Combine Files

Power Query Project

EPQ Project Output

POWER BI (Report View)

Introduction to Report View

What is Report View

Quiz (MCQ)

Introduction to Power BI

Introduction To Report view

Working with Basic Visualization in Power BI

Introduction to Basic Visualization in Power BI

Basic Charts in Power BI

Formatting of Visuals in Power BI

Quiz (MCQ)

Working with Basic Visualization in Power BI

Visualize Spatial Data by Maps

Introduction to Visualize Spatial Data by Maps

Working With Maps In Power BI

Geo Styling

Quiz (MCQ)

Working With Maps In Power BI

Formatting of Pages & Report

Introduction to Formatting of Pages & Reports

Page Perfection

Working With Themes

Quiz (MCQ)

Formatting pages

Analytic Artistry in Power BI

Introduction to Analytic Artistry In Power BI

Graphical Glory

Smart Graphs

Bonus Video: Technoedge Learning Services Sales Analysis Report

Quiz (MCQ)

Analytical glory

Textualize Your Data in Power BI

Introduction to Textualize Your Data in Power BI

Matrix Mastery

Conditional Formatting In Textual Data

Hierarchies In Matrix

Quiz (MCQ)

TABLE AND MATRIX

Filters & Slicers in Power BI

Introduction to Filters & Slicers in Power BI

Filters On Different Data Types

Introduction To Filters

Slicers In Power BI

Formatting of Slicers

Quiz (MCQ)

Slicers

Cards and KPIs

Introduction to Cards & KPIs in Power BI

Numeric Cards

Textual Cards In Power BI

Quiz (MCQ)

Card and KPI

Using Actions to Enhance Data Visualization in Power BI

Introduction to Using Actions to Enhance Data Visualization

Elements in Power BI

Actions in Power BI

Bonus in Power BI

Quiz (MCQ)

Object and action

Artificial Intelligence in Business Intelligence

Q & A in Power BI

Decomposition Tree in Power BI

Smart Narrative in Power BI

Explain the increase & decrease feature in Power BI

Get Quick Insights in Power BI

AI in BI Material

New Features 2023

Clear all Slicers & Apply all Slicers

On Object Interaction

Customize Pane Switcher Option

New Card in Power BI

New Features Material

Sparklines (2022 feature)

FREE BONUS ASSIGNMENTS

Basic Visuals in Power BI

Maps

Advanced Charts

Tables & Matrix

Slicer

Card and KPI

Enhance Data Visualization in PBI

Introduction to Power BI

Power BI Services

Introduction to Power BI Service

What is Power BI Service

Quiz (MCQ)

Power BI Services

Publishing The Report To Power BI Service

Introduction to Publishing The Report To Power BI Service

Publishing Report To Power BI Online

Sharing & Collaboration of Power BI Reports

Quiz (MCQ)

Publishing report

Exporting The Report

Introduction to Exporting The Report

Exporting The Report

Quiz (MCQ)

Exporting The Report

Power BI Service Settings

Introduction to Power BI Service Settings

Automatically Refresh Power BI Reports

Creating an Account in Power BI Service

Quiz (MCQ)

Services setting

Creating a Dashboard in Power BI

Introduction to Creating a Dashboard in Power BI Service

Creating a Dashboard In Power BI Service

Dashboard Options

Quiz (MCQ)

Create a Dashboard

Power BI Mobile Application

Introduction to Power BI Mobile Application

Power BI Mobile Application

Quiz (MCQ)

Power BI Mobile Application

FREE BONUS ASSIGNMENTS

Power BI Services

" Power BI Capstones Project -1 " FMCG Sales Report

Project Material

Video Solution

Sales & Retail

" Power BI Capstones Project -2 " Banking Domain

Banking_Domain

Video Solution

Bank Domain

" Power BI Capstones Project -3 "Finance Domain

Finance_Domain

Video Solution

Finance Domain

" Power BI Capstones Project -4 "Healthcare Domain

Healthcare_Domain

Video Solution

Healthcare

" Power BI Capstones Project -5 " HR Domain 1

Project 1

Video Solution

HR1

" Power BI Capstones Project-5 " HR Domain 2

Project 2

Video Solution

HR2

Power BI-Bonus Projects

Practice File -1

Practice File 2

"Power BI Interview Questions "

Interview Question & Answers

Introduction to Power Pivot

Power BI DAX (Data Analysis Expressions)

Power BI DAX Material

Power BI DAX_Section 01

1.1 Introduction

1.2 Introduction To Data Modelling

1.3 First DAX Function in Power BI

Quiz

Section 1

Power BI DAX_Section 02

2.0 Introduction

2.1 DAX - Basic Date Functions - Part 1

2.2 DAX - Basic Date Functions - Part 2

2.3 DAX - Basic Date Functions - Part 3

2.4 DAX - Basic Date Functions - Part 4

2.5 DAX - Basic Date Functions - Part 5

2.6 DAX - Basic Text Functions Part 1

2.7 DAX - Basic Text Functions Part 2

2.8 DAX - Basic Text Functions Part 3

2.9 DAX - Logical Functions Part 1

2.10 DAX - Logical Functions Part 2

Quiz

Section 2

Power BI DAX_Section 03

3.0 Introduction

3.1 Calculated Column Vs Measures

3.2 Implicit Measures vs Explicit Measures

3.3 Introduction to CALCULATE Function

3.4 Calculate Function in Power BI DAX - Part 2

3.5 PREVIOUSDAY - Calculate Time Intelligence Functions

3.6 NEXTDAY - Calculate Time Intelligence Functions

3.7 Calculate Percentage Difference in Power BI DAX

3.8 SAMEPERIODLASTYEAR Function in Power BI DAX

3.9 Calculate Previous Data Using DATEADD Function

Quiz

Section 3

Power BI DAX_Section 04

4.0 Introduction

4.1 MTD, QTD & YTD Using Quick Measures In Power BI DAX

4.2 Concatenated List of Values (Quick Measures)

4.3 Star Rating Using Quick Measures

Quiz

Section 4

Star Rating File

Star Rating

Power BI DAX_Section 05

5.0 Introduction

5.1 Filter Function in Power BI DAX

5.2 All Function in Power BI DAX

5.3 SUMMARIZE Function in Power BI DAX

5.4 TOP N Function

5.5 CALENDARAUTO Function In Power BI DAX

5.6 Calendar Table

Quiz

Section 5

FREE BONUS ASSIGNMENTS

DAX Section 1

DAX Section 2

DAX Section 3

DAX Section 4

DAX Section 5

DAX Capstones Projects

Project 1 _ Sales & Retail Domain

Resources

Project 1_ Video Solution

Project 2_ Banking Domain

Bank Data

Project 2_Video Solution

Project 3 _ Finance Domain

Finance Data

Finance Project Video Solution

Wrap Up

Course Completion (PBI 2023)

CHAT GPT - BONUS COURSE

OneDrive_2023-11-10

Chat GPT for Data Analyst Introduction

ChatGPT + Excel Basic Users

Generate Excel Formulas from ChatGPT

GPT: Explain Excel Fundamental Concepts

Power Query with ChatGPT

Data Modelling with ChatGPT

VBA Automation with ChatGPT

Generate Sample Data from ChatGPT

GPT for Excel users

GPT - GPT for Excel Teachers and Mentors - Part 1

GPT-GPT for Excel Teachers and Mentors - Part 2

Excel Conditional Formatting with ChatGPT

GPT - Excel Shortcuts with ChatGPT

Introduction to SheetGPT for Googlesheets

Install SheetGPT Addin in Google Sheets

Plan for Social Media Post in Google Sheets by SheetGPT

Shedule for Social Media Users by SheetGPT

SheetGPT Language Translation in Google Sheets

Data Cleaning in Google Sheets by SheetGPT

Getting Country Information in Google Sheets by SheetGPT

Marketing TagLine in Google Sheets by SheetGPT

Introduction to GPT for SQL

GPT- Create SQL Query From Scratch

Explain SQL Query using ChatGPT

Explain SQL Fundamental Concepts by ChatGPT

Add Comments to SQL Query by ChatGPT

Debug and TroubleShoot SQL Code by ChatGPT

GPT-SQL for Instructors, Teachers & Mentors

GPT for Power BI

GPT Connect Power BI with Datasource

Concept Clarification and Learning Support with GPT

DAX in Power BI by ChatGPT

Create a Theme for Power BI Report by ChatGpt

GPT Test my Knowledge for Power BI

Power BI Shortcut and Tricks by ChatGPT

Internship with ChatGPT

Preview - Power BI Specialization with DAX