Course Content
- Introduction to Business Intelligence
- Stages of business intelligence
- Installing Power BI & Connecting to Data
- Refreshing Power BI Service Data
- Interacting with your Dashboards
- Sharing Dashboards and Reports
- Building blocks of Power BI
- Understanding the Power BI Tools
- Installing Power BI & Connecting to Data
- Working with the query Editor
- Working with the data model and creating a visualization
- Overview of workflow in power bi desktop
- Introduction to different views of the data model
- Taking a closer look at the query editor interface
- Required Poer BI Settings
- Overview of Ouery Editor
- About the attached data
- Connecting Power BI Desktop to the data
- Understanding Append Queries
- Pivoting & Unpivoting Columns
- Creating a new Group for the queries
- Duplicating & Referencing Queries
- Entering Data Manually
- Merging Queries
- Creating an Index Column
- Duplicating Column and extracting info
- Creating Conditional Columns
- Performing Basic Mathematical Operations
- Improving Performance and Loading Data into Data Model
- Query Editor & The Data Model
- Intro to Relationships and Editing Relationships
- Concepts are Cardinality
- Cross Filter Selection & Many to Many Relationship
- Active Properties
- Different Between M-Language & DAX
- DAX, Measures, Calculated Values
- DAX complex Functions Like Calculate, SUM, SUMX, RELATED, ALLEXCEPT, CONCATENATE, LOOKUP VALUE, IF, SEARCH, etc.
- Categorizing Data
- Report View Interface
- Creating Visuals
- Add Tooltips and Interactions/Markings
- Data Color
- Hierarchies & Drill-down
- Formatting Charts & Sorting
- Introduction to Slicers
- Treemaps & Tables
- Types of Filters
- Multi-row Cards
- Combined Visuals & Waterfalls
- Introduction and Installation
- Interface Overview
- Importing data from Desktop to Service
- Dataset Menu
- Working on Reports
- Dashboard Overview
- Workspace & Gateways
- Installing Gateways – Personal & On-premise
- Working Alone or Collaborating with Colleagues
- Collaborating in App Workspace
- Sharing the Results
- Publishing the App
- Content Packs from Online Services
- Power Bi Mobile Overview
- Excluding Dataset from Sharing
- Introduction
- JSON Data
- Importing Data From the Rest of the APIs
- Setting up a SQL Server
- Importing Data from SQL Server
- Overview of PowerApp
- Basic Power App Concept
- Canvas Apps, Navigation, Customisation
- Contents – Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes
- Introduction to embedded Power BI
- Create embedded code
- Manage embedded code
- Integration of Power BI in SharePoint
- Introduction of Power BI API
- Introduction to Power BI Mobile
- Creating mobile based reports & dashboards
- Optimizing report for Power BI mobile app
- Introduction of integrating Power BI & Excel
- Introduction of Power BI Premium
- Power BI Premium per user
- Power BI Premium features
- Introduction to Data Flow
- Create Data Flow
- Introduction to Power BI Deployment Pipelines
- Introduction of Sensitivity Labels
- Introduction of Power BI Goals feature
- Incremental data load in Power BI
- Understanding Data Refresh
- Personal Gateway
- Replacing a Dataset
- Troubleshooting Refreshing