-
Business Intelligence Basics
-
What is BI ?
-
Different BI Tools
-
Advantages of BI
-
Applications and Future of BI
-
Overview of BI and Data Integration Products
-
Opportunities/ Scope of BI
-
What is a Data Warehouse?
-
Data Warehousing Schemas
-
Dimensions and Fact Table types
-
Modeling Types
-
Star and Snow Flake Examples and differences
-
PBI Architecture Overview
-
What is BI ?
-
Microsoft Power BI Desktop
-
Overview of Power BI
-
Introduction to Tools and Terminology.
-
Different components of PBI
-
Downloading and installation of PBI Desktop
-
An overview of the interface
-
Introducing 3 views of PBI
-
Different connection options
-
Connecting to Microsoft Excel
-
Connecting to Oracle Database
-
Connecting to CSV files
-
Different method of extracting data
-
Overview of Power BI
-
Power Query Editor (ETL Tool)
-
Visualization and report
-
Overview: Visualizations
-
Using visualizations
-
Overview: Power BI data sources
-
Upload Power BI data sources
-
Basic charts in Power BI
-
Creating basic visuals
-
Formatting visuals and pages
-
Using Themes and Import Custom Themes from Gallery.
-
Inserting images to our report
-
How to set up your data model – Setup and Manage relationships.
-
Sort, copy, and paste visualizations
-
Creating hierarchy
-
Grouping data
-
Setting interactions between visuals
-
Using Various types of graphs
-
Using Slicers to filter the data.
-
Using Filters
-
Using Tool Tips at Page Level and Field Level
-
Conditional Formatting in Tables and Graphs.
-
Parameter settings
-
Using Buttons and Actions.
-
Creating Bookmarks with Various actions.
-
Selection option
-
Ask a Questions to create Custom visuals by Using Q&A
-
Familiarizing different AI visuals
-
Using Market Place to add Custom visuals to Visualizations
-
Use Scrollers and Hierarchy Slicers from Market Place.
-
Download and use different custom visuals from the gallery
-
Sample Reports using Database Tables
-
Overview: Visualizations
-
DAX
-
What is DAX?
-
Why we use DAX?
-
Basic DAX functions :- SUM, SUMX, CALCULATE…..
-
Time intelligence functions :-SAMEPERIODLASTYEAR,DATEADD…
-
Text functions :- CONTAINS, STARTSWITH, ENDSWITH..
-
Mathematical functions :- DIFF, DIVIDE…
-
Aggregate functions :- MIN, MAX, AVG…
-
Logical functions :- IF, OR, AND, NOT….
-
Count functions :- COUNT, DISTINCTCOUNT…
-
Information functions :-ODD, EVEN,RANKX…
-
Filter functions :-FILTER,ALL, ALLSELECTED ….
-
Inter and Intra column operation :-RELATED,SUMMARIZE,SUMMRIZECOULMN…
-
Data handling with tables
-
Variables
-
Conditional operation
-
Visualizing DAX Calculations.
-
Difference between Measures and Quick Measures
-
How to organize all the measures
-
What is DAX?
-
Reports and Dashboards
-
How to save a report
-
Modify and Print a Report
-
Rename, hide and delete report pages
-
Send a report to PowerPoint
-
Introducing Power BI Service
-
Publish reports to Power BI Service.
-
Creating Dashboards
-
Create and manage dashboards
-
Pina report tile to a dashboard
-
Pin a live report page to a dashboard
-
Pin a tile from another dashboard
-
Build a dashboard with Quick Insights
-
Interacting with your Dashboards
-
Sharing Dashboards and Reports.
-
Manage published reports
-
Updating report options
-
How to save a report
-
Advanced Topics
Data Warehousing Schemas
The lesson content is empty.