Power BI - LIVE Classroom 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 needs in Cloud & On-premise.

Regular Schedules (Mon - Fri: 3 Weeks)

Timings (IST) Free Demo Start Date Register
8 PM to 9 PM Aug 24th Aug 25th Register

Weekend Schedules (Sat & Sun: 4 Weekends)

Timings (IST) Free Demo Start Date Register
8 AM to 10 AM Sep 2nd Sep 3rd Register

Program Highlights & Trainer Profile


Basic to Advanced DAX Power Query
M Language Managed Gateways
R Language Resume Guidance
Trainer : Mr. Sai phanindra T (11+ Yrs EXP). Profile
 

Modes Of Training : LIVE Online Training, Inhouse Classroom Training, Video Training. Register Today

 

Power BI Training Course Contents:

Power BI Training - Module I

Power BI Training - Module II

SESSION 0: INTRODUCTION TO POWER BI (Free Demo)

  • 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 and Data Access
  • 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

SESSION 8: DAX EXPRESSIONS - Level 2

  • 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
  • Data Type Conversions with DAX Routines

SESSION 1: 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 and Export Settings

SESSION 9: DAX EXPRESSIONS - Level 3

  • Building Power BI Report Model with DAX
  • Modelling Roles and Techniques
  • Building columns for specific charts
  • Using DAX for Slicing Operations in Power BI
  • IF..ELSEIF.. Conditions with DAX
  • Slicing and Dicing Options with Columns, Measures
  • Loading individual tables, Default Values
  • Implementing Measures, Hierarchies
  • Creating Dynamic Columns and Measures in DAX
  • 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
  • Conditional Splits, Merge and Pivot/Unpivot
  • POWER APPS, LOGIC APPS, MICROSOFT FLOW
  • Introducing the Power BI REST API

SESSION 2: 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 and Lock Aspect

SESSION 10: 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
  • Email Subscriptions and Automated Refresh

SESSION 3: CHART AND MAP REPORT PROPERTIES

  • CHART Report Types and Properties
  • STACKED BAR CHART, STACKED COLUMN CHART
  • CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
  • 100% STACKED BAR CHART, 100% STACKED COLUMN CHART
  • LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
  • LINE AND STACKED ROW CHARTS
  • LINE AND STACKED COLUMN CHARTS
  • WATERFALL CHART, SCATTER CHART, PIE CHART
  • Field Properties: Axis, Legend, Value, Tooltip
  • Field Properties: Color Saturation, Filters Types
  • Formats: Legend, Axis, Data Labels, Plot Area
  • Data Labels: Visibility, Color and Display Units
  • Data Labels: Precision, Position, Text Options
  • Analytics: Constant Line, Position, Labels
  • Working with Waterfall Charts and Default Values
  • Modifying Legends and Visual Filters - Options
  • Map Reports: Working with Map Reports
  • Hierarchies: Grouping Multiple Report Fields
  • Hierarchy Levels and Usages in Visualizations
  • Preordered Attribute Collection - Advantages
  • Using Field Hierarchies with Chart Reports
  • Advanced Query Mode @ Connection Settings - Options
  • Direct Import and In-memory Loads, Advantages

SESSION 11: 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
  • MultiCard Reports, Templates Publish Options

SESSION 4: HIERARCHIES and DRILLDOWN REPORTS

  • Hierarchies and Drilldown Options
  • Hierarchy Levels and Drill Modes - Usage
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Options
  • Aggregates with Bottom/Up Navigations. Rules
  • Multi Field Aggregations and Hierarchies in Power BI
  • DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
  • SEE DATA and SEE RECORDS Options. Differences
  • Toggle Options with Tabular Data. Filters
  • Drilldown Buttons and Mouse Hover Options @ Visuals
  • Dependant Aggregations, Independant Aggregations
  • Automated Records Selection with Tabular Data
  • Report Parameters : Creation and Data Type
  • Available Values and Default values. Member Values
  • Parameters for Column Data and Table / Query Filters
  • Parameters Creation - Query Mode, UI Option
  • Linking Parameters to Query Columns - Options
  • Edit Query Options and Parameter Manage Entries
  • Connection Parameters and Dynamic Data Sources
  • Synonyms - Creation and Usage Options

SESSION 12: 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
  • Using natural language Q & A to data
  • Reading & Editing Power BI Views
  • Power BI Templates (pbit)- Creation, Usage
  • Managing report in Power BI Services

SESSION 5: POWER QUERY & M LANGUAGE - Part 1

  • Understanding Power Query Editor - Options
  • Power BI Interface and Query / Dataset Edits
  • Working with Empty Tables and Load / Edits
  • Empty Table Names and Header Row Promotions
  • Undo Headers Options. Blank Columns Detection
  • Data Imports and Query Marking in Query Editor
  • JSON Files & Binary Formats with Power Query
  • JavaScript Object Notation - Usage with M Lang.
  • Applied Steps and Usage Options. Revert Options
  • creating Query Groups and Query References. Usage
  • Query Rename, Load Enable and Data Refresh Options
  • Combine Queries - Merge Join and Anti-Join Options
  • Combine Queries - Union and Union All as New Dataset
  • M Language : NestedJoin and JoinKind Functions
  • REPLACE, REMOVE ROWS, REMOVE COL, BLANK - M Lang
  • Column Splits and FilledUp / FilledDown Options
  • Query Hide and Change Type Options. Code Generation

SESSION 13: POWER BI ACCESS & CLOUD INTEGRATION

  • Pivot Tables and Chart Slicer Functions
  • Fetching data from different files
  • Data Navigation Paths and Data Splits
  • 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 pbit Limitations
  • Power BI Integration with Microsoft Azure

SESSION 6: POWER QUERY & M LANGUAGE - Part 2

  • Invoke Function and Freezing Columns
  • Creating Reference Tables and Queries
  • Detection and Removal of Query Datasets
  • Custom Columns with Power Query
  • Power Query Expressions and Usage
  • Blank Queries and Enumuration Value Generation
  • M Language Sematics and Syntax. Tranform Types
  • IF..ELSE Conditions, TransformColumn() Types
  • RemoveColumns(), SplitColumns(),ReplaceValue()
  • Table.Distinct Options and GROUP BY Options
  • Table.Group(), Table.Sort() with Type Conversions
  • PIVOT Operation and Table.Pivot(). List Functions
  • Using Parameters with M Language (Power Query Editor)
  • Advanced Query Editor and Parameter Scripts
  • List Generation and Table Conversion Options
  • Aggregations using PowerQuery & Usage in Reports
  • Report Generation using Web Pages & HTML Tables
  • Reports from Page collection with Power Query
  • Aggregate and Evaluate Options with M Language

SESSION 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

SESSION 7: DAX EXPRESSIONS - Level 1

  • DAX - Data Analysis Expressions, Data Types and Operators
  • 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 & Filter Context,Calcualted Columns, Measures
  • DAX Filters and Expressions with Columns
  • 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
  • Calculated Measures & Parameters with DAX
  • DAX Local Measures and Considerations

SESSION 15: INTEGRATION ELEMENTS IN POWER BI

  • SSRS Integration with 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
  • Generating QR Codes and Report Security
  • Reporting JSON Files, Bulk Data Loads
  • SQL Azure and Azure Market Place
  • SCALA and PYTHON Data Access
  • Creating high-density Reports inPower 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 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  
  • Choosing between DAX and MDX
 
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 - Trainer : Mr. Sai Phanindra T