Power BI Training Classes
 

Power BI - Video 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!

 
Power BI Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study Material and Lab Work for every video. Trainers available for doubts clarifications. COMPLETELY PRACTICAL & REAL-TIME. Versions: Power BI Desktop, Power BI Mobile

Type: 100% Practical & Example Based, Real-time
No. of Videos: 12 Videos (Duration: 60 mins per video)
Total Course Fee: INR 9000/- (USD 150)

This Video Course includes one Real-time Project. Download Brochure
Program Highlights & Trainer Profile

  • Completely Real-time and Practical
  • Video wise Lab Work and Tasks
  • One Real-time Case Studies
  • One Real-time Project
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MCT)

 
Power BI Training - Module I
Power BI Training - Module II

VIDEO 1: INTRODUCING POWER BI

  • Introduction to Power BI
  • Getting started with Power BI
  • Power BI Installation and Cloud Account
  • Power BI Cloud and Power BI Service
  • Introducing Natural-Language queries
  • Introducing Quick Insights
  • Introduction to Report and Report Design
  • Introducing Visual Interactions
  • Power BI Desktop & Power BI Services
  • Building blocks of Power BI
  • Understanding Desktop & Mobile Editions
  • Report Rendering Options and End User Access
  • SMDL Technique for Data Visualizations
  • Data Flow and Work Flow Architecture
  • Power View and Power Map. Power BI Licenses

VIDEO 2: CREATING POWER BI REPORTS

  • Report Design using HTML, TXT, CSV, DAT, xls
  • Report Design using Databases & Queries
  • Query Settings and Data Preloads
  • Navigation Options and Report Refresh
  • Computed Columns & Column Splits
  • Working with external data sources
  • Fetching data from different files
  • Data Navigation Paths and Data Splits
  • Working with import and direct query
  • Creating custom table in the Power BI
  • Merge Queries and Append Queries
  • Remove columns and split columns
  • Hiding & Moving Tables in Power BI
  • Stacked bar chart, Stacked column chart
  • Clustered bar chart, Clustered column chart

VIDEO 3: REPORT VISUALIZATIONS and FILTERS

  • Report Fields, Formats and Analytics
  • Creating and Using Hierarchies
  • Column Refresh and Report Refresh Options
  • Visual-Level Filters and Importance
  • Page-Level Filters and Cortana - Q & A Options
  • Report-Level Filters - Visualizations
  • Format Options and Table Styles
  • GRID, Column Headers, Values, Totals
  • Column Formatting Options, Titles
  • Background Properties, Borders, Lock Aspect
  • Chart Reports and Properties - Values, Filters
  • Page Level Filters and Data Fields
  • Report Level Filters and Data Fields
  • Legends, Values, Labels and Data Fields
  • Working with Report Pages and Options
  • Adding new Columns and Measures

VIDEO 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

VIDEO 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

VIDEO 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 with DAX
  • 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

VIDEO 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

VIDEO 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 in query editor
  • Single row & Multi Row Cards
  • Using natural language Q&A to data
  • Adding tiles to the dash boards
  • Adding YouTube videos to dashboards
  • Adding images to the dashboards

VIDEO 9: DATA FROM SERIVICES & 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 functionality in Query Editor
  • Applied steps in query editor
  • Managing Gateways & Content Packs
  • Defining relationships between tables
  • Creating a custom DataSet From Service
  • Publishing a report to Power BI Services
  • Creating custom visualizations for Power BI
  • Introducing the Power BI REST API

VIDEO 10: BUILDING A DATA MODEL

  • Building a model
  • Building columns for specific charts
  • Using DAX for Slicing Operations in Power BI
  • Slicing and Dicing Options with Columns, Measures
  • Loading individual tables
  • Implementing measures
  • Creating calculated columns
  • Improving the report by using measures
  • Integrating budget information
  • Reallocating the budget
  • Working with Power BI Views
  • KPIs and Actions with Power BI
  • Building blocks of Power BI
  • Creating high-density reports
  • Using Images and Videos with Power Reports

VIDEO 11: IMPROVING POWER BI REPORTS

  • Choosing the right visualizations
  • Custom Visualizations and Conditions
  • Working with MY WORK SPACE group
  • Using DAX in Report Models
  • Adding tiles to the Dash Boards
  • Adding YouTube videos to dashboards
  • Google Analytics with Power BI
  • Google Analytics Server and 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
  • Managing report in Power BI Services

VIDEO 12: POWER BI ACCESS & CLOUD INTEGRATION

  • Getting data from existing systems
  • Data Refresh and LIVE Connections
  • 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
  • Power BI Integration with Microsoft Azure

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

 
 
 
 

Who can benefit from this Power BI 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