Microsoft Power Business Intelligence (BI) Training

Secure enrollment now

Syllabus

Introduction to Power BI

 

  • Business Intelligence
  • Self Service Business Intelligence
  • SSBI Tools
  • What is Power BI
  • Why Power BI?
  • Key Benefits of Power BI
  • Flow of Power BI
  • Components of Power BI
  • Architecture of Power BI
  • Building Blocks of Power BI

Overview of Power BI Desktop

 

  • Data Sources in Power BI Desktop
  • Connecting to a data Sources
  • Query Editor in Power BI
  • Clean and Transform your data with Query Editor
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
  • Views in Power BI Desktop
  • Modelling Data
  • Manage Data Relationship
  • Cross Filter Direction
  • Create calculated tables and measures
  • Optimizing Data Models

Data Analysis Expressions (DAX)

  • Essential concepts in DAX
  • Why is DAX important?
  • DAX Syntax
  • Data Types in DAX
  • Calculation Types
  • DAX Functions
  • Measures in DAX
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • DAX Parameter Naming

Data Visualization

  • Introduction to visuals in Power BI
  • Charts in Power BI
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • What Are Custom Visuals?
  • Page layout and formatting
  • KPI Visuals
  • Z-Order

Introduction to Power BI Q&A and Data Insights

  • Introduction to Power BI Service
  • Dashboard vs. Reports
  • Quick Insights in Power BI
  • Creating Dashboards
  • Configuring a Dashboard
  • Power BI Q&A
  • Ask questions of your data with natural language
  • Power BI embedded

Direct Connectivity

  • Introduction to using Excel data in Power BI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
  • Introduction to Power BI Development API
  • Import Power View and Power Pivot to Power BI
  • Power BI Publisher for Excel
  • Content packs
  • Introducing Power BI Mobile

Power BI Report Servers

  • Report Server Basics
  • Web Portal
  • Paginated Reports
  • Row level Security
  • Data Gateways
  • Scheduled Refresh
  • Resources (Rest API/ SOAP API’s/ URL Access)
  • Advanced Analytics in Power BI using R & Python

Advanced Analytics in Power BI using R & Python

  • R Integration in Power BI Desktop
  • R visuals in Power BI
  • R Powered Custom Visuals
  • Creating R visuals in Power BI
  • R Visuals in Power BI Service
  • R Scripts Security
  • Creating visual using Python

Complimentary sessions on communication presentation and leadership skills.

Benefits from the course

Mode of Teaching

Live Interactive

  • Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator.

 

  • Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modelling capabilities including data preparation, data discovery and interactive dashboards.

 

Prerequisite:

 

  • Fundamental understanding of Microsoft Excel and formulas

Prerequisites

  • Fundamental understanding of Microsoft Excel and formulas.

Course Duration:

27 Hours

Class Hours:

2 Hours Day time slots or 3 Hours week end Slots (May change)

Video Clip

Address

 

Kerala State Rutronix

C-11, Padmasree,

Elankom Gardens
Vellayambalam,

Sasthamangalam P.O 
Thiruvananthapuram - 695010

Kerala, India

e-mail: md@keralastaterutronix.com

        

                         @2020 |  All Rights Reserved  | Designed and developed by ToySmiths - 🅜🅐 | Bizleaf