Power BI Classroom Training
 

Power BI - LIVE Online Training

Complete Real-time and Practical Power BI Training with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corproate business data needs!

 
Schedules for Power BI (LIVE) Online Training

Schedules Timings (IST) Start Date Register
   
REGULAR SCHEDULE (MON - FRI)  
5:30 PM to 6:30 PM July 10th Register
   
WEEKEND SCHEDULE (SAT, SUN)  
8 AM to 10:30 AM July 15th Register

 
None of the above schedules work for you? opt for On-demand Video Course
Trainer: Mr Sai Phanindra T (11+ Yrs Exp)
 
Duration: 3 Weeks (Mon - Fri)

Course Fee: INR 7000 (USD 150)

 
HIGHLIGHTS
✔ Basic to Advanced DAX ✔ Managed Gateways
✔ R Language ✔ Daily Tasks
✔ Weekly Interviews ✔ Resume Guidance
 

** This new curriculum applicable for registrations from July 6th, 2017
Power BI Training - Module I
Power BI Training - Module II

CHAPTER 1: INTRODUCTION TO POWER BI

  • Introduction to Power BI - Need, Imprtance
  • Power BI - Advantages and Scalable Options
  • History - Power View, Power Query, Power Pivot
  • Power BI Data Source Library and DW Files
  • Cloud Colloboration and Usage Scope
  • Business Analyst Tools, MS Cloud Tools
  • Power BI Installation and Cloud Account
  • Power BI Cloud and Power BI Service
  • Power BI Architecture - Overview
  • OnPremise Data Acces and Microsoft On Drive
  • Power BI Desktop - Instalation, Usage
  • Sample Reports and Visualization Controls
  • Power BI Cloud Account Configuration
  • Understanding Desktop & Mobile Editions
  • Report Rendering Options and End User Access
  • Power View and Power Map. Power BI Licenses
  • Course Plan - Power BI Online Training

CHAPTER 8: REPORT DASHBOADS, DATA REFRESH

  • Data Refresh Architecture
  • Publishing Reports to Power BI Account
  • Dashboards and Pinning Options
  • Dynamic Data Sources and Encryptions
  • Dashboards from multiple reports
  • Creating high-density reports
  • Data refresh & Power BI refresh architecture
  • Installing the Power BI Personal Gateway
  • Configuring Automatic Refresh
  • Working with MY WORK SPACE group
  • Workbooks and Alerts with Power BI
  • Applied Steps, Single row & Multi Row Cards
  • Using natural language Q&A to data
  • Adding tiles & YouTube videos to dashboards
  • Adding images to the dashboards
  • Parameters : Static and Dynamic Paramters
  • Dependant Parameters and Visibility Options

CHAPTER 2: CREATING POWER BI REPORTS, AUTO FILTERS

  • Report Design with Legacy & .DAT Files
  • Report Design with Databse Tables
  • Understanding Power BI Report Designer
  • Report Canvas, Report Pages: Creation, Renames
  • Report Visuals, Fields and UI Options
  • Experimenting Visual Interactions, Advantages
  • Reports with Multiple Pages and Advantages
  • Pages with Multiple Visualizations. Data Access
  • PUBLISH Options and Report Verification in Cloud
  • "GET DATA" Options and Report Fields, Filters
  • Report View Options: Full, Fit Page, Width Scale
  • Report Design using Databases & Queries
  • Query Settings and Data Preloads
  • Navigation Options and Report Refresh
  • Stacked bar chart, Stacked column chart
  • Clustered bar chart, Clustered column chart
  • Adding Report Titles. Report Format Options
  • Focus Mode, Explore, Export Settings

CHAPTER 9: POWER BI GATEWAYS & CONTENT PACKS

  • Consuming a service content pack
  • Creating a custom data set from a service
  • Creating a content pack for your organization
  • Consuming an organizational content pack
  • Updating an organizational content pack
  • Working with Pivot & Un Pivot columns
  • Creating index and custom columns, Group By in Query Editor
  • Applied Steps in Query Editor, M Language
  • M Language Sematics and Usage Options
  • Managing Gateways & Content Packs
  • Installing Personal, Enterprise Gateways
  • TraceVerbosity and Additional Logging Options
  • Confuguring Cloud Connections and OnPremise
  • Azure Bus Connections and Gateway Logs
  • Defining relationships between tables
  • Creating a custom DataSet From Service
  • Publishing a report to Power BI Services
  • Creating custom visualizations for Power BI

CHAPTER 3: REPORT VISUALIZATIONS and PROPERTIES

  • Power BI Design: Canvas, Visualizations and Fileds
  • Import Data Options with Power BI Model, Advantages
  • Direct Query Options and Real-time (LIVE) Data Access
  • Data Fields and Filters with Visualizations
  • Visualization Filters, Page Filters, Report Filters
  • Conditional Filters and Clearing. Testing Sets
  • Creating Customised Tables with Power BI Editor
  • General Properties, Sizing, Dimensions, and Positions
  • Alternate Text and Tiles. Header (Column, Row) Properties
  • Grid Properties (Vertical, Horizontal) and Styles
  • Table Styles & Alternate Row Colors - Static, Dynamic
  • Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
  • Totals Computations, Background. Boders Properties
  • Column Headers, Column Formatting, Value Properties
  • Conditional Formatting Options - Color Scale
  • Page Level Filters and Report Level Filters
  • Visual-Level Filters and Format Options
  • Report Fields, Formats and Analytics
  • Page-Level Filters and Cortana - Q & A Options
  • Column Formatting Options, Titles
  • Background Properties, Borders, Lock Aspect

CHAPTER 10: BUILDING A DATA MODEL

  • Building Power BI Report Model
  • Modelling Roles and Techniques
  • Building columns for specific charts
  • Using DAX for Slicing Operations in Power BI
  • Slicing and Dicing Options with Columns, Measures
  • IF..ELSEIF.. Conditions with DAX
  • Loading individual tables, Default Values
  • Implementing Measures, Hierarchies
  • Creating Calculated Columns
  • Invoke Function and Freezing Columns
  • Query Dependancies and Transformations
  • Improving the report by using measures
  • Working with Power BI Views - Performance
  • KPIs and Actions with Power BI
  • Building blocks of Power BI
  • Creating high-density reports
  • Using Images and Videos with Power Reports
  • Inddexing Connections and Column Duplciations
  • Conditional Splits, Merge and Pivot/Unpivot
  • POWER APPS, LOGIC APPS, MICROSOFT FLOW
  • Introducing the Power BI REST API

CHAPTER 4: DAX - SYNTAX and FUNCTIONS

  • DAX - Data Analysis Expressions
  • Purpose of DAX, Syntax Rules
  • Possible Operations and Usage
  • DAX Data Types and Operators
  • DAX Values and Usage Options
  • DAX Functions - Scalar, Statistical
  • Mathematical & Time Functions in DAX
  • Aggregate & Logical Functions in DAX
  • Conversion & Relational Functions in DAX
  • Working with Columns and Measures in DAX
  • Row Context and Filter Context
  • Using DAX for Calcualted Columns
  • Using DAX for Report Measures
  • Using Logical Operators and Conditions
  • DAX Filters and Expressions with Columns
  • DAX Errors and Handling Options
  • DAX Expressions: Excel Versus Power BI
  • Pivot Tables and Chart Slicer Functions
  • Funnel Reports and Data Cards.
  • Fetching data from different files
  • Computed Columns & Column Splits
  • Data Navigation Paths and Data Splits
  • Adding new Columns and Measures

CHAPTER 11: IMPROVING POWER BI REPORTS

  • Choosing the right visualizations
  • Custom Visualizations and Conditions
  • Working with MY WORK SPACE group
  • Using DAX in Report Models
  • Working with external data sources
  • Creating and Using Hierarchies
  • Column Refresh and Report Refresh Options
  • Chart Reports and Properties - Values, Filters
  • Merge Queries and Append Queries
  • Remove columns and split columns
  • Hiding & Moving Tables in Power BI
  • Legends, Values, Labels and Data Fields
  • Adding tiles to the Dash Boards
  • Adding YouTube videos to dashboards
  • Google Analytics with Power BI, Content Packs
  • Adding Reports to Microsoft One Drive
  • Adding images to the dashboards
  • Working with all visualizations
  • Using natural language Q & A to data
  • Reading & Editing Power BI Views
  • Power BI Templates (pbit)- Creation, Usage
  • Exporting Templates and Publish Options
  • Managing report in Power BI Services

CHAPTER 5: DAX - FUNCTIONS and CONTEXT

  • Row Context and Filter Context in DAX
  • ROW, CONTAINS, LOOKUPVALUE
  • ADDCOLUMNS,  MAXX, MAXA, DISTICTCOUNT
  • CALCULATETABLE, FILTER, SUMMARIZE
  • CROSSJOIN, GENERATE, GENERATEALL
  • DISTINCT, ALL, ALLEXCEPT, FILTERS, FILTER
  • HASONEFLTER, HASONEVALUE, ISCROSSFILTERED
  • RELATED, RELATEDTABLE, VALUES, ALL
  • Context Evaluation & ALLSELECTED
  • SUM, SUMX Functions in DAX
  • TOPCOUNT, TOPCOUNTX Variants in DAX
  • Using DAX in data models
  • Working with DAX Functions
  • Calculated Measures & Parameters with DAX
  • DAX Local Measures and Considerations
  • Excel Add-Ins for Power BI. Usage Options

CHAPTER 12: POWER BI ACCESS & CLOUD INTEGRATION

  • Getting data from existing systems
  • Data Refresh and LIVE Connections
  • pbit and pbix : differences. Usage Options
  • Using relational databases on-premises
  • Using relational databases in the cloud
  • Using live connections to Analysis Services
  • Integrating Power BI with Office
  • Publish Excel data models in Power BI
  • Consume Power BI content from Excel
  • Managing Security to Access Data
  • Using Row-Level Security & User Access
  • Extending and customizing Power BI
  • Power BI embedded in applications
  • Power BI Mobile and Report Access
  • pbit Limitations and MultiCard Reports
  • Power BI Integration with Microsoft Azure

CHAPTER 6: DAX - TIME INTELLIGENCE, & EXPRESSIONS

  • YTD, QTD, MTD Calculations with DAX
  • DAX Expressions with Power View
  • DAX Calculations and Measures
  • Using TOPN, RANKX, RANK.EQ
  • Computations using STDEV & VAR
  • SAMPLE Function, COUNTALL, ISERROR
  • ISTEXT, DATEFORMAT, TIMEFORMAT
  • Time Intelligence Functions with DAX
  • Data Analysis Expressions and Functions
  • DATESYTD, DATESQTD, DATESMTD
  • ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN
  • CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
  • SAMEPERIOD and PREVIOUSMONTH,QUARTER
  • KPIs with DAX. Vertipaq Queries in DAX

CHAPTER 13: INTEGRATION ELEMENTS IN POWER BI

  • SSRS Integration with Power BI
  • SSRS Scaleout Deployments & Power BI
  • SSRS Report Portal URL to Power BI Cloud
  • Power BI KPI Reports Vs SSRS KPI Reports
  • Convering and Working with Mobile Reports
  • Report Buidler Reports to Powert BI
  • Rpeort Migration Options, Settings
  • KPI Reports and Mobile Reports
  • Generating QR Codes and Report Security
  • SSAS Integration with Power BI
  • Reporting JSON Files, Bulk Data Loads
  • SQL Azure and Azure Market Place
  • SCALA and PYTHON Data Access
  • Creating high-density Reports inPower BI
  • Email Subscriptions and Automated Refresh

CHAPTER 7: MDX QUERIES, EXRESSIONS IN POWER BI

  • OLAP DataSources in Power BI
  • Using MDX Queries with PowerBI Queries
  • MDX SELECT and Perspective Access
  • KPIs and MDX Expressions with Power BI
  • MDX with Goal, Value, Trend, Status
  • Using MDX Controls and Dynamic Parameters
  • Cube Reports with OLAP Databases
  • MDX Queries and Filters with Power BI
  • Working with Pivot & Unpivot columns
  • YTD, PARALLELPERIOD,SCOPE, ALLMEMBERS
  • WHERE, EXCEPT, RANGE, NONEMPTY
  • CURRENT & EMPTY, AND / OR, LEFT / RIGHT
  • SCOPE, THIS, THIS, FREEZE Functions  
  • ADOMD Client: MDX Query Processing
  • MDX in Cube Browser - Null, Empty Axis
  • Hierarchies and Levels with MDX
  • Choosing between DAX and MDX
  • WOrkspace Limitations with MDX Queries
  • Import and Direct Query Options with OLAP

CHAPTER 14: POWER BI with Microsoft R

  • Install / Configure MRAN
  • R Language Usage and R Analytics
  • Enabling R Visuals in Power BI
  • Using R For Big Data Analytics
  • Using R Packages with Power BI
  • R Data Analysis in Power BI - Advantages
  • Working with R Script Editor
  • Working with Plotting Commands, Modifications
  • Manual/Schedule Refresh of R Scripts
  • Machine Learning Techniques - Power BI
  • SCALA and PYTHON Data Access
  • Machine Learning Techniques - Power BI
  • Creating high-density reports
  • Working with ArcGIS Maps, ESRI Files
  • Genrating QR Codes for Reports
  • Dashboards - Security Options in AD
  • Visuals and Pins - Security Options in AD
  • Using R for Power BI Reports and Dashboards
  • Streaming DataSets with Microsoft R

EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today

 
 
 
 
 
 
 

Who can benefit from this Power BI Online Training course?

Complete Real-time and Practical Power BI Training with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corproate business data needs!

 

Job-Oriented Real-time Training @ SQL School Training Institute


 

Register Today

 

 

Register Today

 

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google: 4.7/5

Facebook: 4.8/5

Sulekha: 4.8/5

JustDial: 4.7/5

MouthShut: 5/5

UrbanPro: 5/5

Yet5: 5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social