arrow_back
Overview Of Data Analytics
Introduction to Power BI Course 2024
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
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
Interview Question & Answers
Introduction to Power Pivot
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