All Trainings are completely PRACTICAL, REAL-TIME and project oriented
 040-66638869
  09573168449
  info@vinaytechouse.com
Power BI Classroom Training / Power BI Online Training:

(Basic to Extreme Advanced Level with REAL TIME Projects) Brochure Download: PDF / WORD

PBI Real Time Training Designed for Aspiring:
  • a) BI Developers
  • b) BI Leads
  • c) BI Testers
  • d) BI Consultants
  • e) BI Designer / Modeler / Architects
Batch Schedules:
Schedule Mode Duration Fee Link
Register
Register
Register
If Schedule doesn’t suit you, for:
  • SEPARATE ONLINE /
  • WEEK-END /
  • ONE ON ONE /
  • CUSTOMIZED TRAINING
TeraData Training : New Batch starts every 15 Days. MSBI Training : New Batch starts every 10 Days POWER BI Training : New Batch starts every 15 Days

POWER BI DEMO, DATA WAREHOUSE AND DATA MODEL FUNDAMENTALS

IT Data Fundamentals & Power BI Existence
  • Data, Data Availability in IT
  • IT data storage areas
  • Datawarehouse, BI definitions and layers
  • Power BI existence in IT, Product services>
  • Power BI Features
  • Power BI Tools and Components
  • Pwer BI Opportunities
Creative visualization through screen shots
Power BI and Competitiveness
  • What are BI, OLAP, and OLTP? Importance in the current Enterprise? Competitive advantages
  • Power BI vs Other BI tools
  • SQL History, SQL Extensions and Power BI detailed history
  • Hardware & Software requirements
  • Installation methods
Power BI components and explanation
  • Power BI Client
  • Power BI Server
  • Power BI Desktop
Creative visualization through software
Data warehousing fundamentals
  • Data definitions(Data, Information, BI, Mining, ODS, DSS, Analysis, OLTP, OLAP, OLCP)
  • Dwh Characteristics, Principles
  • Dwh approaches(Top down / Bottom up)
  • Dwh Life Cycle steps
  • Data Mart & Types
  • Data Processing Types (OLAP)
  • Granularity and various granularities
  • Diff between OLTP and OLAP
Creative visualization through screen shots
Huge discussion on DWH projects
Dimensional Modeling Fundamentals
  • Dimension, Dimension Table & types
  • Fact, Fact Table & measures types
  • Fact less fact table
  • Various schemas (Star, Snow Flake, Galaxy & Hybrid )
  • Surrogate key and usages in real time
  • Model, Business, Conceptual, Logical, Physical Data Models
Real time project tables, models and design
Huge discussion on Project Data Designs

POWER BI (BASIC TO ADVANCED COURSE CONTENT)

  • Installation of Power BI
  • Introduction to Power BI
  • Monthly updates of Power BI
  • Need of Power BI
  • Latest new features in Power BI
  • Working with Power BI Desktop
  • Working with Power BI Services
  • Power BI availability
  • Building blocks of Power BI
  • Differences between Power BI and SSRS(MSBI)
  • Connecting to Database
  • Fetching data from different files
  • Working with different visualizations
  • Importing custom visualizations
  • Working with import and direct query options
  • Getting data from different external data source
  • Working with Query Editor
  • Creating custom table in the Power BI
  • Merge Queries and Append Queries
  • Remove columns and split columns
  • Choosing required columns in the data
  • Working with different transformations
  • Working with Applied steps in query editor
  • Working with Power BI Views:
  • » Report View
  • » Data View
  • » Relationship View
  • Working with hierarchies and measures
  • Working with table and matrix visuals
  • Working with different level of filters
  • » Visualization level
  • » Page level
  • » Report level
  • Visualizations:
  • » Column charts and bar charts
  • » Line charts and area charts
  • » Waterfall charts and tunnel charts
  • » Pie charts and tree map charts
  • » And remaining all visualizations
  • Working with single row cards and multi row cards
  • Working with slicers
  • Publishing a report to Power BI Services
  • Managing report in Power BI services
  • Creating groups in Power BI Services
  • Different ways to share dashboards to Client and colleagues
  • Working with multiple pages
  • Creating Power BI dashboards
  • Using social websites to create Dashboards
  • Differences between old Power BI and new Power BI
  • Working with Pivot and Unpivot columns
  • Adding index column and custom column
  • Merging and appending queries
  • Working with Group By in Query Editor
  • Working with Replace Values and Replace Nulls
  • Managing data types in Query editor
  • Managing Relationships in Power BI Desktop
  • Adding image, text box and different shapes to reports in Desktop
  • Working with all query properties
  • Working with interactive drilldowns in the report visualizations
  • Working with Excel BI add Ins:
  • » Power view
  • » Power query
  • » Power map
  • » Power pivot
  • Creating calculated columns / fields and usage
  • Working with Power pivot data model
  • Working with data modeling
  • Developing KPIs and measures
  • Defining relationships between tables
  • Power BI gateways and types
  • Working with DAX functions
  • » Text functions
  • » Filter functions
  • » Date functions
  • » Logical functions
  • » Information functions
  • » Other functions
  • Creating and working with calculated measures by using DAX
  • Creating and working with calculated columns by using DAX
  • Implementing dynamic titles in the report
  • Creating a custom table with range of dates
  • Working with dynamic parameters
  • Using dynamic parameters to filter the entire report
  • Creating and publishing with Content packs
  • Scheduling the Dashboards
  • Different ways to share dashboards
  • Creating groups and managing groups
  • Adding videos and pictures in the dashboards