POWER BI - Vinay Tech House

Home / Business Intelligence Courses / Power BI

Power BI Training

Quickly find meaningful insights within your data that help make better business decisions or easily build rich, visual analytic reports. Share, interact, and collaborate on reports based on your data to find the insights, trends, and critical business intelligence you need.

Classroom | Online | Fast Track | Self Paced

Course Highlights

Live Projects

Placement Assistance

Expert Trainers

Premium Training

Live Video Share

Real-Time Case Studies

Frequently Asked Questions

What is Power BI and What are it's uses?

"Powering BI", added more features to the existing BI. It is a Self Sevice Business Intelligence (SSBI) Software Service which generates Reports and Dashboards for better Decision Making and quick Insights.

Is Microsoft Power BI easy to learn?

It is easy to learn since it is a Low-Code application ( full support to graphical)

Does Power BI have a market?

Yes, Microsoft is the leader in Analytics and Business Intelligence since 16 years. It is providing its wonderful support to the current cutting edge processes and technologies by its monthly updates. And also On-Premise MSBI and Cloud Azure BI providing other BI supportive services beside Power BI. Kindly visit the following links to know more about the Power BI Market & Leadership

- https://powerbi.microsoft.com/en-us/blog/microsoft-named-a-leader-in-the-2022-gartner-magic-quadrant-for-analytics-and-bi-platforms/

- https://powerbi.microsoft.com/en-my/blog/microsoft-named-a-leader-in-the-forrester-wave-augmented-bi-platforms-q3-2021/

What if I miss a training session?

No need to worry, daily videos are in the class room folder and materials in the materials folder. You can watch and practice and also reach out to the trainer for queries.

What type of Study materials and Videos we will get and How long they are available?

You will get all materials after a week of your joining which you can download and use. Daily live class recordings will be placed in a folder and you will have access for maximum 12 months. Lab practice documents and required Power BI credentials provided for practice till one year.

Quick Enquiry

Why Join Vinay Tech

In-Depth Curriculum

Our educational program aims to comprehensively cover all & important points & aspects of the subject

Course Specialized Trainers

Our Trainers are high experienced industry experts with their teaching methods designed for their particular course

10+ Years of Experience

We’ve come a long way teaching from hundreds to thousands, so we use our experience in guiding students in the right path

Students Favourite

Vinay Tech House is prefered by many students as their favourite, rating as the best in teaching

Curriculum

Mandatory Topic 1: Power BI Demo and Data Warehouse Fundamentals

Power BI Demo content

Data, Data Availability types in IT
IT data storage areas [File stream, Database]
Data warehouse, BI definitions and layers
Power BI existence in IT, Product services
Power BI Features, Self Service BI
Power BI Tools and Components
On-Premises vs. Cloud computing [Azure]
Power BI Opportunities and Support
Legacy vs. Modern BI tools
OLAP vs. OLTP vs. Insights and Analytics
Power BI challenging Data Science
Power BI History, releases and blogs
Installation process and challenges

Data warehouse Fundamentals

Data warehouse, Data Mart and differences
Types of data marts and real-time usage
ODS, Stage, EDW, and DW definitions
Data Lake and Blob Storages
DWH Life Cycles
DWH Approaches (INMON and KIMBALL)
Data Granularity, Data movement stages

Mandatory Topic 2: Data Model Fundamentals [ E-R Model and Dimensional Model ] [ Theory and Complete Practical ]

Data Model Fundamentals

Dimension, Dimension Table & types
Fact, Fact Table & measures types
Fact less fact table
Schemas (Star, Snow Flake, Galaxy & Hybrid )
Surrogate key and usages in real time
Business, Conceptual, Logical, Physical Data Models
1:1, 1: Many, Many: Many relationships
Active, Inactive relationships
Single and Bidirectional relationships
Cross filtering relationship
Role Playing real-time usage

Topic 1: Installation [ Desktop, Gateway, Server & Studio ]

Installation

Various windows versions
Software components
Release impact on installation
Power BI Cloud Desktop installation
Power BI Report Server Desktop installation
DAX Studio installation
Report Server Installation
Gateway Installation

Topic 2: Working with Power BI Desktop and Connection to Many Data Sources

Working with Power BI Desktop

Desktop over view and Building blocks of PBI Desktop
Differences between Power BI and SSRS(MSBI)
Connecting to various sources and retrieving data
1. Flat files
2. CSV files
3.JSON files
4. Databases (Sql Server & Oracle)
5. Excel files
6. Web
7. Analysis Services [Tabular & Multi-dimensional model]
8. Azure SQL database and DWH
SQL Data Mover Practice
9. Python Script
10. M- Retrieval

Topic 3: Working with Excel BI Addons

Working with Excel BI Addons

Working on data modes [very detailed] Import Direct Query Connect Live
Genera reports using SQL, SQL Procedures and Views.
Generate reports using MDX and DAX Queries
Control retrieval rows and time.
Differences between Load and Edit options.

Topic 4: Working on Power BI Modes [ Import, Direct Query and Connect Live ]

Power BI Modes

Power view
Power query
Power map
Power pivot

Topic 5: Working with Various with Various Ribbon Options and Important Real-Time Topics Covered

File Menu [All options-Detailed Practical]

New Report Creation and Opening Existing Report
Save report with PBIX extension
Export Power BI Template (PBIT)
Import Power BI Template, Power Query, View, Model, and others
Working on Options and Settings for additional

Home Menu [All options- Detailed Practical]

External Data: Get Data, Recent Sources, Enter Data Edit Queries and Refresh
Insert New Page, New Visual, Ask a question And Buttons [Back, Q &A, Book Mark, URL] Text Box, ImageShapes[ Oval, Rectangle, Line, etc…]
Custom Visuals : From Market Place, From File
Themes: Switch themes [using corporate theme]
Calculations creation using New Measure / Column / Quick Measure
Publishing to cloud service

View Menu [All options -Detailed Practical]

Report Phone Layout / Desktop View Show Gridlines, Snap Objects to Grid Locking Objects on the surface
Bookmarks creation, viewing, & using in Dashboard Selection Pane [Hiding and showing objects]
Slicer and Sync Slicers explanation with practical Performance analyzer test run

Modeling Menu [All options-Detailed Practical]

Changing Data types, formats, and sort order
Create roles and implement row-level security and dynamic row-level security
Working on Linguistic schemas

Help Menu [All options-Detailed Practical]

Guided learning, documentation, training videos
Blogs, Communities, Power BI for developers
Support and Consulting Services

Format Menu [All options-Detailed Practical]

Edit interactions for the visual for cross highlighting, cross filtering, and none options.
Bring forward, send backward etc…visual options

Data / Drill Menu [All options-Detailed Practical]

Drill down report creation
Drill one level down, multiple levels, and data drill

Topic 6: Power BI Dataset Properties

Power BI dataset

Create Hierarchies and analyzing data.
Create Groups (List, Bin)
Hide / Unhide columns usage in real-time
Consider table as Date Table
Expand and collapse columns

Topic 7: Power Query Properties [ 5 Types of Properties and M-language ]

Queries Properties [All options –Detailed Practical]

Real-time practical on duplicates and references
Create groups to classify tables
Refreshing table data and enabling data to tables
Creating reusable functions

Query Properties

Perform data transformations by adding, removing and retaining columns, duplicates, errors.
Working on reusable functions
Merging multiple queries
Joining multiple queries to get matched, unmatched and both matched and unmatched rows.

Column Properties

Numeric columns.
String columns (split strings)
Date columns
Full real-time examples on the data transformations

Filter Properties

Working on Number, String, and Date
Various filter options

Parameters Properties

Working on Any, List, and Query Parameters
Working on multiple parameters
Working on cascading parameters

Mash up (M) language

Syntax, protocols, variables and conventions
Let, In, semicolon, and other functions

Miscellaneous Transformations

Transpose rows, reverse rows, Pivot and Unpivot View options [monospaced font, column profiling, Column distribution, and performance monitoring]

Topic 8: Power BI Views, Filters, Visuals and Visual Formatting Options

Types of views in PBI Desktop

Report View
Data View
Relationship View

Working with Different Level of Filters

Visualization level
Page level
Report level
Drill though page level
Drill through cross report level

Working with Various Display Panel

Visualization Pane
Fields Pane
Query Settings Pane

Working on Different Single and Multi-visuals

Table usage and properties
Matrix usage and properties
Column or bar charts [Stacked and Clustered and 100% stacked]
Line charts and area charts
Waterfall charts and funnel charts
Pie charts and tree map charts
Slicers, Cards [Single and Multi Row]
Bubble Chart, Table Sort Order
Maps [Area, Filled, Shape, and ArcGIS]
Custom visuals practice [Market place, Files]

Many Reports and Dashboards based on Visuals and DAX

PBI Cloud Introduction and Differences with Power BI Desktop

Topic 9: Power BI Cloud Service, On-Premise Report Server and Report Builder

Create New Workspace

Create new workspace &template workspace
Add users and provide roles ( four roles)
Add dashboards, reports, and work books

Get Data

Organizational content packs
Service content packs
Work books
Reports
OneDrive applications
Dataflows

App Workspaces

Create app workspace
Add collaborators
Add dashboards, reports, and work books
Publish workspace
Sharing app workspace
Access on app workspace
Install mobile app workspace
Browsing in mobile app
Commenting in app workspace
Modifying and deleting the app workspace
Republish app workspace

Reports & Management

Browsing in Mobile and Desktop view
Get Metrics and View related
Create Book Marks and Selections
Drill through cross reporting
Exporting data [Excel, CSV] ,Persistent filters
Visual options
Row-level &Dynamic Row Level Security

Power BI Gateways [ Personal & Data ]

Download and Install Power BI Gateway
Install & Configure Personal Gateway for PBI
Install & Configure Data Gateway
Gateway connections for On-Demand Refresh
Gateway configuration for Scheduled Refresh

Dashbaords

Create dash board
Add the below tiles
a) Image tile
b) Text box tile
c) Video tile
d) Streaming tile
e) Live page tile
f) Visual tile
g) Book mark tile
h) Workbook tile
i) Insight tile
j) Usage Metrics tile
Sharing dash board
Subscribing dash board & Alerts Creation
Comments on dash board
Replying for customer comments
Metrics, View Related
Mobile view of dash board
Real-Time dashboards practice with more DAX

Dashboard and Workbook Management

Explaining all available options

Dataflows

Create dataflow using entities
Implement Power Query Operations
Common Data Model [CDM] usage
Save Dataflow
Using Data Flow in Power BI Desktop

Content Packs

Create content pack and view content packs
Add dashboard, reports, and work books
Share content pack
Provide access on content packs
Working with Content from Others

Power BI Mobile & Report Publisher

Download mobile publisher
Create mobile report and customer support
Mobile view
Desktop, Service, and Mobile App
Measures, Calculations and Tables
Mobile app with SSRS and Power BI reports

Power BI Reort Builder, Report Server [ On-Premise ] & Paginated Reprots

Explain RDL (.rdl) Technology and SSDT
Install report builder and create paginated reports with .RDL
Install and configure report server
Place SSRS and Power BI reports in Server
Upload On-Premise reports to Cloud
Integrate RDL and PBIX reports
 Mobile app access for On-Premise reports

Power BI Enhanced [ Advanced ] Support

Microsoft Flow
Power Apps
Power BI Embedding
Power BI Developer
Power BI REST API
.NET API

TOPIC 10: DAX [DATA ANALYSIS EXPRESSIONS]

DAX Language General Topics

Syntax and usage
Naming conventions
Operators and Naming Parameters
Functions
DAX Queries
Tools --DAX Studio and SSMS

DAX Functions [ Very Detailed Practice] Good material provided for all the functions

a)Text b) Filter c)Date d) Logical e)Information f)Time g) Parent Child h)Statistical i)Math and Trig j)Other functions

Date Functions

CALENDAR, CALENDARAUTO, DAY, MONTH, YEAR YEARFRAC, DATE, TIME, DATEVALUE, TIMEVALUE EDATE, EOMONTH, WEEKDAY, WEEKOFMONTH TODAY, UTCTODAY, NOW, UTCNOW, DATEDIFF

Time Intelligence Functions

DATESBETWEEN, DATESINPERIOD, ClosingBalanceofmonth, ClosingBalanceOfQuarter, ClosingBalanceOfYear, OpeningBalanceOfMonth, OpeningBalanceOfQuarter, OpeningBalanceOfyear, DATESYTD, DATESQTD, DATESMTD TOTALQTD, TOTALMTD, TOTALYTD ,FIRSTDATE, FIRSTNONBLANKDATE, LASTDATE, LASTNONBLANKDATE, NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PARALLEL PERIOD, SAMEPERIODLASTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PEVIOUSQUARTER,PREVIOUSYEAR, STARTOFMONTH, STARTOFQUARTER,STARTOFYEAR

Logical Functions

AND, OR, NOT, IFERROR, IF, SWITCH, IN TRUE ,FALSE

Filter Functions

ADDMISSINGITEMS, FILTER, FILTERS,Distinct, VALUES COUNTROWS, ALL, ALLEXCEPT, Earlier, Earliest, HASONEFILTER, RELATED, RELATEDTABLE, KEEPFILTERS, CROSSFILTER, ISCROSSFILTERED, CALCULATE, CALCULATE TABLE, AllSelected, AllNoBlankRow, USERELATIONSHIP,

Information Functions

CONTAINS ROW, CONTAINS, ISEVEN, ISODD, ISTEXT, USERNAME, USERPRICIPALNAME, LOOKUPVALUE, ISERROR, ISNONTEXT, ISNUMBER, ISLOGICAL, ISINSCOPE,ISONORAFTER

Math & Trignometry Functions

SUM,SUMX,ROUND,MROUND,ROUNDUP, ROUNDDOWN,RAND,RANDBETWEEN , SQRT,TRUNC,PI,LOG,LOG10,LN,ISO.CEILING,CEILING,FLOOR,ISO.FLOOR,GCD,LCD,EXP,FACT, Even,ODD,PRODUCT,PRODUCTX

Other Functions

DATA TABLE,EXCEPT, INTERSECT, UNION, GROUP, SUMMARIZECOLUMN, GENERATE SERIES, NATURAL JOIN TREATAS, ISEMPTY, VAR

Math & Trig Functions

path, pathlength, pathcontains ,pathreverse, PathItem

Statistical Functions

ADDCOLUMNS, AVERAGE, AVERAGEX, AVERAGEA COUNT, COUNTA ,COUNTAX ,COUNTBLANK, COUNTROWS, COUNTX, CROSSJOIN, DISTINCTCOUNT GENERATE, GENERATEALL, GEOMEAN, MAX, MAXA ,MAXX,MEDIAN,MEDIANX, MIN, MINA, MINX, PERMUT,RANK.EQ, RANKX, ROW, SAMPLE, SELECTCOLUMNS, SUMMARIZE,TOPN

Textual Functions

BLANK, CODE,UNICHAR,CONCATINATE COMBINEVALUES , CACATINATEX, TRIM REPT, REPLACE, SUBSTITUTE, FIND, SEARCH FORMAT, MID, LEFT, RIGHT, VALUE

Good material with Real-time scenarios covered

A project with most of the DAX functions

TOPIC 11: ADDITIONAL SESSIONS [ANALYSIS SERVICES TABULAR MODEL AND AZURE SESSIONS]

Analysis Services - Tabular Model

Workspace Database , Workspace Server , Direct Query , Backup to disk
Installation steps , error mechanisms Creating a tabular model and setting model
Data to the model , renaming tables, filtering columns
Rename Columns
Monitoring relationships , Providing relationships
Create Hierarchies
Create partitions
Create perspectives
Create Roles
Create KPIs
Deployment

Azure Sessions

Azure cloud and introduction
Azure portal, resources, and resource groups
Azure account creation and pay-as-you-go
Azure Sql Database, Data warehouse, and Analysis Services Databases
Aure Blob and Data Lake Storages Introduction
Azure Data Factory [ADF] Introduction
ADF- Pipelines, Sources, Sync, and Transformations
ADF- Copy Activity practice
ADF Data Bricks Introduction

Projects Covered

Project - 01

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Project - 02