Power BI Training

Topics:

• Introduction to Business Intelligence
• Self-Service Business Intelligence (SSBI)
• Introduction to Power BI
• Traditional BI vs. Power BI
• Power BI vs. Tableau vs. QlikView
• Uses of Power BI
• The Flow of Work in Power BI
• Working with Power BI
• Basic Components of Power BI
• Comparison of Power BI Version
• Introduction to Building Blocks of Power BI
• Data model and importance of Data Modeling

Hands-on:

• Installation of Power BI

Skills You will Learn:

• Concepts of Business Intelligence
• Power BI installation

Topics:

• Data Sources in Power BI Desktop
• Loading Data in Power BI Desktop
• Views in Power BI Desktop
• Query Editor In Power BI
• Transform, Clean, Shape, and Model Data
• Manage Data Relationship
• Editing a Relationship
• Cross Filter Direction
• Saving Workfile
• Measures

Hands-on:

• Data Cleaning using Power BI query editor
• Creating Measures
• Transform, Clean, Shape, and Model Data for further analysis

Skills You will Learn:

• Data transformation using the query editor
• Shaping data with measures
• Managing Data Relationships

Topics:

• Introduction to DAX
• Importance of DAX
• Data Types in DAX
• DAX Calculation Types
• Steps to Create Calculated Columns
• Measures in DAX
• DAX Syntax
• DAX Functions
• DAX Operators
• DAX Tables and Filtering

Hands-on:

• Creating Calculated Columns and Measures
• Performing Data Analysis using DAX

Skills You will Learn:

• Data Analysis using DAX
• Creating Calculated Measures and Columns

Topics:

• Introduction to Visuals In Power BI
• Visualization Charts in Power BI
• Matrixes and Tables
• Slicers and Map Visualizations
• Gauges and Single Number Cards
• Modifying Colors in Charts And Visuals
• Shapes, Text Boxes, and Images
• Custom Visuals
• Page Layout and Formatting
• Bookmarks and Selection Pane
• KPI Visuals
• Z-order
• Grouping and Bining

Hands-on:

• Creating different visuals
• Creating cards, measures, KPI, reference line, and slicers

Skills You will Learn:

• Visuals in Power BI
• Report creation
• Visuals modification
• Z-order and KPI in visuals

Topics:

• Introduction to Power BI Service
• Creating a Dashboard
• Quick Insights in Power BI
• Configuring a Dashboard
• Power BI Q&A
• Ask Questions about your Data
• Power BI Embedded
• Bookmarks and buttons

Hands-on:

• Creating reports and dashboard
• Publishing reports on Power BI Service
• Using Power BI Service for operations on reports

Skills You will Learn:

• Report and dashboard creation
• Designing stories with dashboards

Topics:

• Data Sources Supported in Power BI
• Exploring Live Connections to Data Sources
• Connecting Directly to SQL Azure
• Connecting Directly to SQL Server Analysis Services/My SQL
• Import Power View and Power Pivot
• Data Gateways
• Direct Query vs. Import Connectivity modes
• Connecting Power BI in Excel

Hands-on:

• Setting Up On-Premise Data Gateway
• Connecting Power BI with SQL Server Database
• Connecting Reports on Power BI Service with Local Data Files

Skills You will Learn:

• On-Premise Data Gateway
• Connecting Power BI with Databases
• Connecting Power BI Service with Local Data Sources

Topics:

• What is Power BI Report Server?
• Key Features of Report Server
• The architecture of the Report Server
• Limitations of Report Server
• Power BI Report Server vs. Power BI Service
• Acquiring and Installing Power BI Report Server
• What is a Web Portal?
• Paginated Reports
• Row Level Security

Hands-on:

• Setting Up Power BI Report Server
• Using Power BI Report Server for Publishing Reports
• Implementing Row Level Security

Skills You will Learn:

• Power BI Report Server
• Publishing reports on Report Server

Topics:

• Brief concepts about R
• R Programming Concepts
• Create R Scripts for BI
• Python Programming
• Python Scripts in BI
• Python integration with Power BI

Hands-on:

• Demonstrate connecting R and Python in Power BI
• Using R and Python for data analysis

Skills You will Learn:

• Data cleaning and transformation
• Python and R scripts
• Power BI integration

Topics:

• Use Parameters
• Create a data flow
• Introduction to Anomaly Detection
• Introduction to Smart Narrative
• Introduction to Sensitivity labels in Power BI
• Deployment Pipeline

Hands-on:

• Connecting with Power BI service
• Creating dataflow
• Creating scorecard

Skills You will Learn:

• Data flow creation
• Anomalies detection
• Smart Narrative implementation

Topics:

• Power BI Service
• Row Level Security
• Visuals and Charts
• Power BI Desktop
• Handling Workspaces

Hands-on:

• Analyze store data
• Draw conclusions from visuals created

Skills You will Learn:

• Sales Reports creation
• Interactive Dashboards creation