Power BI → Power BI Installation - Home

Curriculum

32 Sections
119 Lessons
20 Weeks

Expand all sectionsCollapse all sections

Overview of Data Analytics
1
- 1.1
  Overview of Data Analytics
Power BI Installation
1
- 2.1
  Power BI Installation
Basic Visual Analytics
9
- 3.1
  Visual AnalyticsCopy
- 3.2
  Basic Charts: Bar Chart, Line Chart, and Pie ChartCopy
- 3.3
  HierarchiesCopy
- 3.4
  Data GranularityCopy
- 3.5
  HighlightingCopy
- 3.6
  SortingCopy
- 3.7
  FilteringCopy
- 3.8
  GroupingCopy
- 3.9
  SetsCopy
Explore the Dynamic User Interface of PowerBI
1
- 4.1
  Explore the Dynamic User Interface of PowerBI
Power Query
1
- 5.1
  Power Query
Functions
4
- 6.1
  Introduction to Basic Functions
- 6.2
  Text Functions
- 6.3
  Date Functions
- 6.4
  Number Functions
Conditional Column and Column From Examples
3
- 7.1
  Introduction to Conditional Columns and Column from Examples
- 7.2
  Conditional Column in Power BI Power Query
- 7.3
  Column from Examples in Power BI Power Query
Appending or Combining Files
2
- 8.1
  Combining CSV Files
- 8.2
  Consolidate Files with Different Structures
Replacing VLOOKUP with Merge Queries
4
- 9.1
  Introduction to Replacing VLOOKUP
- 9.2
  Introduction to Merge Queries
- 9.3
  Advanced Merge Queries
- 9.4
  Challenge with Merge Queries
Powerful Cleaning Features in Power Query
3
- 10.1
  Introduction to Powerful Cleaning Features in Power BI Power Query
- 10.2
  Data Cleaning in Power BI Power Query
- 10.3
  Changing Structure of Data in Power BI Power Query (Unpivot)
Working with Rows and Columns in Power Query
2
- 11.1
  Introduction to Working with Columns & Rows
- 11.2
  Working with Rows & Columns in Power BI Power Query
Various Data Sources in Power BI
7
- 12.1
  Get SQL Data in Power BI
- 12.2
  Get Live Website Data in Power BI
- 12.3
  Get Email Data in Power BI
- 12.4
  Get Google Forms (Google Sheets) Data in Power BI
- 12.5
  Get Power BI Datasets
- 12.6
  Share Point Data in Power BI
- 12.7
  Get JSON Files in Power BI
Working with Filters and Parameters
2
- 13.1
  Introduction to working with Filters Sorting and Parameters
- 13.2
  Working with Filter, Parameters and Sorting in Power BI Power Query
Custom Function Feature to Clean and Combine Files
3
- 14.1
  Introduction to Custom Function to Clean & Combine Files
- 14.2
  Clean & Combine CSV Files In Power BI Power Query
- 14.3
  Clean & Combine Excel Files In Power BI Power Query
Finding Out Postal Codes from States and Uts
1
- 15.1
  Finding Out Postal Codes from States and Uts
M Functions
7
- 16.1
  Introduction to M Language
- 16.2
  M Functions Date – IsIn
- 16.3
  M Functions Date_ Add and Subtract
- 16.4
  M Functions – Date – Basic
- 16.5
  M Functions – Text
- 16.6
  Write a Simple M Code
- 16.7
  Trick to get help for 800+ M Functions
Power BI Report View
1
- 17.1
  Introduction to PowerBI Report View
Working with Basic Visualization in PowerBI
3
- 18.1
  Introduction to Basic Visualization in Power BI
- 18.2
  Basic Charts in Power BI
- 18.3
  Formatting of Visuals in Power BI
Visualize Spatial Data by Maps
3
- 19.1
  Introduction to Visualize Spatial Data by Maps
- 19.2
  Working With Maps In Power BI
- 19.3
  Geo Styling
Formatting of Pages and Report
3
- 20.1
  Introduction to Formatting of Pages & Reports
- 20.2
  Page Perfection
- 20.3
  Working With Themes
Textualize Your Data in Power BI
4
- 21.1
  Introduction to Textualize Your Data in Power BI
- 21.2
  Matrix Mastery
- 21.3
  Conditional Formatting In Textual Data
- 21.4
  Hierarchies In Matrix
Filters and Slicers in Power BI
5
- 22.1
  Introduction to Filters & Slicers in Power BI
- 22.2
  Filters On Different Data Types
- 22.3
  Introduction To Filters
- 22.4
  Slicers In Power BI
- 22.5
  Formatting of Slicers
Cards and KPIs
3
- 23.1
  Introduction to Cards & KPIs in Power BI
- 23.2
  Numeric Cards
- 23.3
  Textual Cards In Power BI
Using Actions to Enhance Data Visualization in Power BI
4
- 24.1
  Introduction to Using Actions to Enhance Data Visualization
- 24.2
  Elements in Power BI
- 24.3
  Actions in Power BI
- 24.4
  Bonus in Power BI
Artificial Intelligence in Business Intelligence
5
- 25.1
  Q & A in Power BI
- 25.2
  Decomposition Tree in Power BI
- 25.3
  Smart Narrative in Power BI
- 25.4
  Explain the increase & decrease feature in Power BI
- 25.5
  Get Quick Insights in Power BI
Misc Features
4
- 26.1
  Clear all Slicers & Apply all Slicers
- 26.2
  On Object Interaction
- 26.3
  Customize Pane Switcher Option
- 26.4
  New Card in Power BI
Power BI Services
4
- 27.1
  Introduction to PowerBI Services
- 27.2
  Introduction to Publishing The Report To Power BI Service
- 27.3
  Publishing Report To Power BI Online
- 27.4
  Sharing & Collaboration of Power BI Reports
Exporting the Report
1
- 28.1
  Introduction to Exporting the report
Creating a Dashboard in Power BI
3
- 29.1
  Introduction to Creating a Dashboard in Power BI Service
- 29.2
  Creating a Dashboard In Power BI Service
- 29.3
  Dashboard Options
Capstone Projects
4
- 30.1
  FMCG Sales Report
- 30.2
  Banking Report
- 30.3
  Healthcare Report
- 30.4
  HR Report
Introduction to Power Pivot
1
- 31.1
  Introduction to Power Pivot
Power BI DAX
20
- 32.1
  Introduction
- 32.2
  Text Function
- 32.3
  Data Function
- 32.4
  Logical Functions
- 32.5
  Calculated Column Vs. Measures
- 32.6
  Implicit Measures Vs. Explicit Measures
- 32.7
  Calculate Function
- 32.8
  PREVIOUSDAY – Calculate Time Intelligence Functions
- 32.9
  NEXTDAY – Calculate Time Intelligence Functions
- 32.10
  Percentage Difference
- 32.11
  SAMEPERIODLASTYEAR
- 32.12
  DATEADD
- 32.13
  MTD, QTD and YTD using Quick Measures
- 32.14
  Concatenated List of Values
- 32.15
  Star Rating using Quick Measures
- 32.16
  Filter Function
- 32.17
  All Function
- 32.18
  SUMMARIZE
- 32.19
  Top N
- 32.20
  CALENDARAUTO

Call Us Chat With Us Live Consultation