Course content

  • Overview of BI concepts
  • Why we need BI?
  • Introduction to SSBI
  • SSBI Tools
  • Why Power BI?
  • What is Power BI?
  • Building Blocks of Power BI
  • Getting started with Power BI Desktop
  • Power BI Desktop
  • Extracting data from various sources
  • Workspaces in Power BI
  • Data Transformation
  • Measures and Calculated Columns
  • Query Editor
  • Modelling Data
  • Manage Data Relationship
  • Optimize Data Models
  • What is DAX?
  • Data Types in DAX
  • Calculation Types
  • DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text and Aggregate
  • Measures in DAX
  • How to use Visual in Power BI?
  • Charts in Power BI
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards
  • R Visuals in Power BI
  • What Are Custom Visuals?
  • KPI Visuals
  • Data Binding
  • Power BI report server
  • Why Dashboard?
  • Dashboard vs Reports
  • Creating Dashboards
  • Configuring a Dashboard: Dashboard Tiles, Pinning Tiles
  • Power BI Q&A
  • Quick Insights in Power BI
  • Power BI embedded
  • REST API
  • Custom Data Gateways
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL
  • Introduction to Power BI Development API
  • Excel with Power BI: Connect Excel to Power BI, Power BI Publisher for Excel
  • Content packs
  • Update content packs
  • Extracting data out of Azure SQL using R
  • Using R, call the Azure ML web service and send it the unscored data
  • Writing the output of the Azure ML model back into SQL
  • Read scored data into Power BI using R
  • Publishing the Power BI file to the Power BI service
  • Scheduling a refresh of the data using the Personal Gateway

Mode of Training

Online

Total duration of the course

5 to 7 weeks

Training duration per day

50 mins - 90 mins

Communication Mode

Go to meeting, WEB-EX

Software access:

Software will be installed/Server access will be provided, whichever is possible

Material

Soft copy of the material will be provided during the training.

Training

Both weekdays and weekends

Training Fee

 $300

I have Learned the POWER BI from PRO IT KEYS . To be very true it is best online training organization. Where the the trainer is not only professional they were the leaders.
Kiran Kumar