Sr.
No Topic
Basic Concepts of SQL Server:
0) Introduction to basic terminologies
1) Querying data
2) Sorting data
3) Limiting rows
4) Filtering data
5) Joining tables
1
6) Grouping data
7) Subquery
8) Set Operators
9) Common Table Expression (CTE)
10) Pivot
11) Modifying data
12) Data definition
2 Introduction to Power BI
3 Power BI Architecture
4 Building Blocks of Power BI
Query Modes and their differences over each
5
other
Data Sources
6 On-Premise v/s Cloud based sources
On-Premise Data Gateway
Power Query:
1. All Possible Transformations
2. Basic Understanding of M Language
3. Query Parameters
4. M Functions
4.1. Text functions
4.2. Number functions
4.3. Table functions
7
4.4. DateTime functions
4.5. List functions
4.6. Combiner functions
4.7. Splitter functions
5. Miscellaneous options for queries:
5.1. Enable Load
5.2. Grouping
5.3. Duplicate, Reference and their difference
Data Modeling:
8 1. Checklist for query editor
2. Relationships & Filter Directions
9 Tabular Style Guide
DAX:
1. Introduction
2. Measure and Calculated Columns, and their
10
difference
3. Dax Formatter
4. Dax Best Practices
DAX
11 1 Use of Variables
2 Table Variables
DAX Functions:
1 Aggregation
2 Count
12
3 Logical Functions
4 Operators
5 Mathematical Functions
DAX:
13 1. Date & Time Intelligence Functions
2. Building a Date Table
DAX:
1 Evaluation Context
14
2 Understanding functionality of iterative
functions
DAX:
15 1 Table and Filter Functions
2 Calculate and Calculate Table
DAX:
1. Hierarchies and Parent Child Functions
16
2. Expanded Tables
3. Segmentation: Static & Dynamic
17 Calculation Groups
Custom Navigation: Buttons & Bookmarks &
18
Selection Pane
19 What-If Parameters
20 RLS & how it works on Power BI Service
Share Reports & Dashboards:
1. Publish to web
21 2. Sharing on service
3. Embedding in custom website, microsoft
teams, sharepoint, etc
22 Real Time Streaming Dataset
23 Publish report changes using ALM toolkit
24 Best practice analyzer in Tabular Editor
Miscellaneous topics :
Q&A
25 Mobile Layout
Performance Analyzer
DAX Studio
26 Incremental Refresh
27 mahe
28 Metrics/Scorecard
29 Microsoft Fabric Overview
30 PowerBI Git Integration
31 XMLA endpoint
32 Deployment pipelines
Hours
Hours Learning Day
Practical
35 5
4 0
4 0
3 2
2 2
2 3
10 6
2 2
1.5
2 1
3
10 10
4 4
4 4
10 6
4 4
2 1
3 4
2 4
4 6
4 6
4 4
2 4
2 4
1 2
1 2
2
4
2
2
Expectations
Developer should be able to write TSQL statements and should be able to
understand the TSQL written by others
Get basic understanding of power bi, its various components and
applications
Understand basic components of power bi architecture:
1. Power BI Desktop
2. Data Sources
3. Power BI Service
4. Gateway
5. Power BI Paginated Reports
1. Understand building blocks of Power BI (Concept of Report, Dashboard,
visualization, dataset, app, etc)
2. Get familiar with Power BI Desktop and Service Interface
3. Data View, Relationship View & Visualization View
1. Understand all dataset modes along with Live connection and their
differences
1. Get familiar with various supported sources
2. Difference between on-prem and cloud data sources
3. How gateway is used, when its requried
At the end of this set, trainee should be:
1. Able to fetch data from various sources in Power BI
2. Should be familar with all possible transformations in power query
3. Basic understaing of generally used M query functions for custom
columns
4. Be able to use query parameters
1. Understnad best practices to follow while transforming and modeling
data in powerbi
2. Understand relationship view in Power BI Desktop
3. Understand relationship filter directions
1. All the rules to be kept in mind while creating Data Model
1. Understand basic syntax of DAX
2. How calculated columns and measures are created using DAX
3. Create basic measures and calculated columns
4. Understand difference in column and measure
5. Get familiar with DAX Formatter
6. Following DAX best practices
1. Understand how variables are declared and re-used in DAX
2. Understand how table variables can be customize
3. Challenges when using table variables
1. Understand the functionality and applications of all DAX functions that
fall under the mentioned categories
2. Practice all the functions to get better understanding
1. How to build a calendar table in dax
2. All important column to be included in calendar table
3. Cover all date-time related dax functions
4. Manipulate date-time context using calculate
1. Understand the ROW Context
2. Understand FILTER Contetxt
3. Use of iterative functions e.g. SUMX(), COUNTX(), RANKX(), etc.
4. How context can be manipulated in DAX measures
1. Understand the functionality and applications of all DAX functions that
fall under the mentioned categories
2. Understand how calculate and calculate table works
3. Create calculated tables ussing summarize / calculate
4. Create conditional measures using CALCULATE()
1. Use and Application of Hierarchy and Parent Child DAX Functions
2. Expanded Tables
3. Understand static and dynamic segmentation
1. Understand use of selection pane to show / hide visuals and document
outlining
2. Creation of page specific and visual specific bookmarks
3. Use of buttons
4. Create custom navigation using button + bookmark + selection pane
1. Use and application of what-if parameters
1. Basic concept of RLS
2. How relationships are involved
3. Defining the role in power bi desktop
4. Understand how defined roles work in Power BI Service
5. Understanding USERNAME() function, USERPRINCIPAL() function,
CUSTOMDATA() function in RLS
1. Understand various ways of collaborating with other users in power bi
service
2. Difference between embedding and publish to web
1. what is real time streaming dataset and how data is pushed in it
2. Application of real time streaming dataset
1. Complete features of Q&A
2. Creating mobile layout in Power BI
3. Use and features of Performance Analyzer & DAX Studio
4. Step to test the visuals/Calculations
1. Basic Overview
1. What is a field parameter?
2. What is the use of a field parameter?
1. What is a Metrics/Scorecard?
2. What is the use of a Metrics/ScoreCard
1. What is a deployment pipeline?
2. What is the use of deployment pipeline
Practical description
Try each topics practically and solve the
assignments given to you.
> Get Familiar with Power BI Desktop and
Power BI service interface
> Workspaces
> Apps (make different audiences for different
users)
> Publish Apps
Practical assignment involving relevant topics
Try importing from various data sources in
Power BI Desktop
Try publishing reports to Power BI service
Discover how on premise dataset behaves on
Power BI service without gateway
Practice all transformation features, m-query
fuctions as going through them theoractically.
Practical assignments will be provided
involving Power query, m language,
parameters.
Implement relationships. Get understanding of
filter directions
Create basic measures and calculated columns
in power bi reports.
Incorporate variables in dax measures and
calculated colums.
Practice all functions as going through them.
Practical assignments will be provided
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practice all functions as going through them.
Practical assignments will be provided
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Practical assignment involving relevant topics
Recommended Resource
https://www.sqlservertutorial.net/sql-server-basics/
(Refer to section: Explore what Power BI can do for you)
https://docs.microsoft.com/en-us/power-bi/guided-learning/
https://www.tutorialspoint.com/power_bi/power_bi_introduction.htm
https://mindmajix.com/power-bi-architecturehttps://www.tutorialspoint.com/power_bi/power_bi_architecture
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-basic-conceptshttps://docs.microsoft.com/en-u
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-datahttps://docs.microsoft.com/en-us/po
https://docs.microsoft.com/en-us/power-query/power-query-quickstart-using-power-bihttps://docs.microsoft.c
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understandhttps://docs.mi
https://www.elegantbi.com/post/tabularstyleguide
https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodaxhttps://docs.microsoft.com/en-u
https://www.sqlbi.com/articles/variables-in-dax/https://docs.microsoft.com/en-us/power-bi/guidance/dax-vari
https://www.tutorialspoint.com/dax_functions/dax_functions_aggregation.html
https://www.tutorialgateway.org/power-bi-dax-aggregate-functions/
https://dash-intel.com/powerbi/statistical_functions_count.php
https://docs.microsoft.com/en-us/dax/logical-functions-dax
https://docs.microsoft.com/en-us/dax/dax-operator-reference
https://docs.microsoft.com/en-us/dax/math-and-trig-functions-dax
https://docs.microsoft.com/en-us/dax/date-and-time-functions-daxhttps://docs.microsoft.com/en-us/dax/time-
https://www.statslab-bi.co.nz/project/row-filter-context-dax/
http://sqlml.azurewebsites.net/2017/04/16/evaluation-contexts-in-dax/
https://blog.enterprisedna.co/advanced-logic-within-dax-iterating-functions-detailed-example/
https://docs.microsoft.com/en-us/dax/filter-functions-daxhttps://docs.microsoft.com/en-us/dax/calculate-functi
https://docs.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-daxhttps://www
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactivehttps://simplesqlb
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
https://www.absentdata.com/power-bi/parameter-power-bi/
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
How to Use - ALM Toolkit (alm-toolkit.com)
Best practice rules to improve your model’s performance | Microsoft Power BI Blog | Microsoft Power B
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
https://learn.microsoft.com/en-us/power-bi/create-reports/service-goals-introduction
What is Microsoft Fabric - Microsoft Fabric | Microsoft Learn
What Is the XMLA Endpoint for Power BI and Why Should I Care? - RADACAD
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tab
