Power BI Training

Power BI Training Curriculum

Introduction to Power BI

Introduction to Power BI: What is Power BI?
Power BI Desktop; The First Experience
Power BI Website; You’ll Need Just a Web Browser
Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

Getting Data

What is Power Query: Introduction to Data Mash-Up Engine of Power BI
Get Started with Power Query: Movies Data Mash-Up
Power BI Get Data From Excel: Everything You Need to Know
Definitive Guide to Power BI Personal Gateway
File Sources
Folder as a Source
Database Sources
Analysis Services Connection
Get Data From Azure SQL Database
Azure SQL Data Warehouse Source
Software as A Source
Web Source

Power Query for Data Transformation

Installation, Requirements, and Configuration
Different versions of Power Query
Power Query Introduction
Query Editor
Transformation GUI
Row Transformations
Column Transformations
Data Type
Adding Column
Text Transformations
Number Column Calculations
Date and Time Calculations
Data types, Lists, Records, and tables in M
M built-in functions
Generators in M
Writing Custom Functions
Error handling
Advanced Data Transformations with M

Power Pivot for Data Modelling

Power Pivot xVelocity engine basics and concepts
Different versions of Power Pivot
Relationships in Power Pivot
Best practices
Introduction to DAX
Calculated Members
Row Context vs Set Context
Advanced calculations using Calculate functions
Time Functions
DAX Advanced
Power Pivot embedded in Power BI Desktop

Data Visualization with Power BI Desktop, Power View and Power Map

Data Visualization Best Practices
Power BI Desktop Visualization
Custom Visuals in Power BI Desktop
Formatting Visuals in Power BI Desktop
Power View for SharePoint
Power View for Excel
Charts, Scorecards, and other visualization items in Power View
Sorting, Filtering, and categorization with Power View
Best Practices to work with Power View
3D geo-spatial visualization with Power Map
Different versions of Power Map
Best Practices to work with Power Map

Designing the best solution with Power Q&A

Power Q&A introduction
Design best practices for Power Q&A

Power BI Desktop; combination of three tools

Power BI Desktop Introduction
Getting data from different data sources
Differences of Power Query stand-alone with Power Query in Power BI Desktop
Modelling data, and relationships
Creating calculated measures
Power Pivot difference in Power BI Desktop
Visualizing data in Power BI Desktop
Power View difference in Power BI Desktop
Best practices of designing solutions with Power BI
Custom Visuals for Power BI Desktop

Administration

Power View for SharePoint Administration
Office 365 Administration
Deployment of files into Power BI website
Building dashboards in Power BI website
Mobile apps for Power BI on Apple, Android, and Windows Phone
Configuration and administration on Power BI website.

  • PRIVATE
  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query






© 2016, ALL RIGHTS RESERVED.
Create an Account