PowerBI Online Training
Chapter 1: Introducing Power BI
- Introduction to Power BI
- Getting started with Power BI
- Power BI Installation and Cloud Account
- Introducing natural-language queries
- Introducing Quick Insights
- Introduction to Report and Report Design
- Introducing Visual Interactions
- Power BI Desktop & Power BI Services
- Building blocks of Power BI
- Understanding Desktop & Mobile Editions
- Report Rendering Options and End User Access
- Data Flow and Work Flow Architecture
Chapter 2: Creating Power BI Reports
- Report Design using TXT, CSV, xls
- Report Design using Databases & Queries
- Repot Data Sources and Data Set Queries
- Query Settings and Data Preloads
- Dataset Properties and Report Fields
- Navigation Options and Report Refresh
- Computed Columns & Column Splits
- Working with external data sources
- Fetching data from different files
- Working with import and direct query
- Creating custom table in the Power BI
- Merge Queries and Append Queries
- Remove columns and split columns
- Choosing required columns in the data
Chapter 3: Report Customizations & Parameters
- Working with Data Visualizations & Cards
- Tables, Matrix, Charts, Bars, Sparkline, Pie, Maps
- Creating and Working with Parameters
- Dynamic and Dependant Parameters
- Static and Dynamic Filters - Usage Options
- Navigator Options and Parameter Mapping
- Creating and Working with groups
- Managing the null values and errors
- Managing data types in Query editor
- Column Delimiters and Relationships Management
Chapter 4: Report Dashboards & Data Refresh
- Publishing Reports to PowerBI Account
- Dashboards and Pinning Options
- Dynamic Data Sources and Encryptions
- Dashboards from multiple reports
- Installing the Power BI Personal Gateway
- Configuring automatic refresh
- Working with MY WORK SPACE group
- Workbooks and Alerts with PowerBI
- Applied steps in query editor
Chapter 5: Using Power BI Desktop
- Cube Reports with OLAP Databases
- DAX Expressions with Power View
- DAX Calculations and Measures
- Improving the report by using measures
- Integrating budget information
- Working with Power BI Views
- Working with Data Hierarchies
- In-built slicers and custom slicers
- Working with reference lines
- Working with Power pivot data model
- Working with data modeling
- Using DAX in data models
- Working with DAX Functions
- Calculated Measures & Parameters with DAX
- Creating high-density reports
- Working with Pivot & Unpivot columns
- Different external data source
Chapter 6: Data from Services & Content Packs
- Consuming a service content pack
- Creating a custom data set from a service
- Working with Pivot & Un Pivot columns
- Creating index and custom columns
- Group By functionality in Query Editor
- Applied steps in query editor
- Building blocks of Power BI
- Managing Gateways & Content Packs
- Defining relationships between tables
- Creating a custom table with range
- Publishing a report to Power BI Services
- Power BI as a Service
- Creating high-density reports
- Creating custom visualizations for Power BI
- Pushing Real-time data to Power BI
Chapter 7: Improving Power BI Reports
- Data from multiple Data Sources
- Reports from various data sets
- Dashboards from multiple reports
- Working with MY WORK SPACE group
- Creating Groups & Working
- Managing Gateways & Content Packs
- Adding tiles to the Dash Boards
- Adding YouTube videos to dashboards
- Adding images to the dashboards
- Working with all visualizations
- Using natural language Q & A to data
- Reading & Editing Power BI Views
- Managing report in Power BI Services
- Scheduling refresh to the Datasets
Chapter 8: Power BI Access & Cloud
- Getting data from existing systems
- Data refresh and live connections
- Using relational databases on-premises
- Using live connections to Analysis Services
- Integrating Power BI with Office
- Publish Excel data models in Power BI
- Using Power BI Tiles from Office Store
- Managing security to access data
- Extending and customizing Power BI
- Power BI embedded in applications