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?
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
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
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Interested in a Free demo? Want to learn more?
Get Certified by Vinaytech House
Vinay Tech’s course completion certificate will be provided upon the completion of the
course successfully. It increases the value of your resume and you can attain leading
job posts with the help of this certification in leading MNCs. The certificate can be printed out
like a hard copy or handed digitally.
Need help with Microsoft ETL Certification?
Our Student Say!
Our Learners Work At
