POWERBI NOTES BY
INTERVIEWSTORYSHELF
ALL RIGHTS RESERVED ©INTERVIEWSTORYSHELF
0|Page
, POWERBI NOTES BY INTERVIEWSTORYSHELF
Disclaimer
InterviewStoryShelf provides educational materials and
resources for informational purposes only. Created by
Experienced Employees. While we strive for accuracy and
reliability, we do not guarantee the completeness or correctness
of the content. Users should verify information independently
before relying on it. InterviewStoryShelf is not responsible for
any direct or indirect consequences resulting from the use of our
materials. All purchases made through our platform are final, and
we do not guarantee specific results or success.
Copyright Notice
© [2025] InterviewStoryShelf all rights reserved. All content,
including text, graphics, logos, images, and digital materials on
this website, are the exclusive property of InterviewStoryShelf
unless otherwise stated. No part of this material may be copied,
reproduced, distributed, or transmitted in any form without prior
written permission from InterviewStoryShelf. Unauthorized use
may result in legal action.
Page |1
, POWERBI NOTES BY INTERVIEWSTORYSHELF
Data is a precious commodity for businesses and there has never been a more
exciting time for those who like to work with data.
Businesses store huge volumes of data, which they use to make decisions to stay
competitive in their field. This means there is a large demand for people with the
skills to make sense of that data.
Having data is useless without meaning. The ability to create reports that result in
better understanding and therefore drive effective decision-making is in high
demand. Businesses want to maximize the value of their data.
Power BI Desktop is the best tool for self-service business intelligence and
analytics. This free tool makes it easy to acquire, shape, model, and present data
in an effective and interactive way.
The Power BI Service then provides a cost-effective way to share these reports
with other members of your team or with management.
Learning Power BI will give you the edge over others who still use over-priced,
rigid, and limited tools. The Microsoft data platform is the leader in the analytics
and BI market.
This book will demonstrate the demand for data analytics skills by businesses
today, where you can find work and what employers will expect from you.
It then takes you on a practical guide to Microsoft Power BI. No prior knowledge
is required. This is a comprehensive beginner’s guide to Power BI.
Page |2
, POWERBI NOTES BY INTERVIEWSTORYSHELF
1. Power BI - A Complete Introduction…………………………………………………………………………………….05
2. What is Data Wherehouse? ………………………………………………………………………………………………..10
3. Power BI Software’s / Tools / Products………………………………………………………………………………..12
4. Power BI Desktop Installation………………………………………………………………………………………………16
5. Data Transformation with Power Query / Query Editor………………………………………………………..20
6. Connect to various data sources………………………………………………………………………………………..23
7. The Power Query editor user experience……………………………………………………………………………..26
8. Data Modeling in Powerbi…………………………………………………………………………….……………………..29
9. Snowflake and Star Schema………………………………………………………………………….……………………..31
10. Relationships……………………………………………………………………………………………………………………….36
11. Change Data Type of a Column in Power BI………………………………………………………………………….48
12. Types of Joins / Join Kinds / Merge Type:……………………………………………………………………………..65
13. Introduction to DAX……………………………………………………………………………………………………………..71
14. DAX Syntax & Operators………………………………………………………………………………………………………75
15. DAX Functions. ……………………………………………………………………………………………………………………79
16. Time Intelligence ………………………………………………………………………………………………………………..114
17. Power Query Software Overview :……………………………………………………………………………………..119
18. Power BI Visual Interactions (Ad-hoc filtering and highlighting)……………………..……..…………...121
19. Drill through in Power BI Desktop…………………………………………………………………………………….….122
20. Filters in Power BI………………………………………………………………………………………………………………..124
21. Hierarchies and Drill-Down in Power BI………………………………………………………………………………..126
22. Data Visualization Basics……………………………………………………………………………………………………...133
23. Visualizing KPI Data………………………………………………………………………………………………………………149
24. Maps in Power BI………………………………………………………………………………………………………………….153
25. Grouping and Binning ………………………………………………………….………………………………..…………….157
26. Sorting Data in Visuals in Power BI Desktop.………………………………………………………………………..163
27. Create tooltips based on report pages in Power BI Desktop……….……………………………….……....169
28. Bookmarks.……………………………………………………………….……………………………...…………………………174
29. Selection Pane: ……………………………………………………………….……………………………………………….....180
30. What is Power BI Service …………………………………………………………………….….……………………….....188
31. Workspaces …………………………………………………………………………………………………………….……….....190
32. Access on-premises data from Power BI Service – Data Gateway..………………………….………………192
Page |3
INTERVIEWSTORYSHELF
ALL RIGHTS RESERVED ©INTERVIEWSTORYSHELF
0|Page
, POWERBI NOTES BY INTERVIEWSTORYSHELF
Disclaimer
InterviewStoryShelf provides educational materials and
resources for informational purposes only. Created by
Experienced Employees. While we strive for accuracy and
reliability, we do not guarantee the completeness or correctness
of the content. Users should verify information independently
before relying on it. InterviewStoryShelf is not responsible for
any direct or indirect consequences resulting from the use of our
materials. All purchases made through our platform are final, and
we do not guarantee specific results or success.
Copyright Notice
© [2025] InterviewStoryShelf all rights reserved. All content,
including text, graphics, logos, images, and digital materials on
this website, are the exclusive property of InterviewStoryShelf
unless otherwise stated. No part of this material may be copied,
reproduced, distributed, or transmitted in any form without prior
written permission from InterviewStoryShelf. Unauthorized use
may result in legal action.
Page |1
, POWERBI NOTES BY INTERVIEWSTORYSHELF
Data is a precious commodity for businesses and there has never been a more
exciting time for those who like to work with data.
Businesses store huge volumes of data, which they use to make decisions to stay
competitive in their field. This means there is a large demand for people with the
skills to make sense of that data.
Having data is useless without meaning. The ability to create reports that result in
better understanding and therefore drive effective decision-making is in high
demand. Businesses want to maximize the value of their data.
Power BI Desktop is the best tool for self-service business intelligence and
analytics. This free tool makes it easy to acquire, shape, model, and present data
in an effective and interactive way.
The Power BI Service then provides a cost-effective way to share these reports
with other members of your team or with management.
Learning Power BI will give you the edge over others who still use over-priced,
rigid, and limited tools. The Microsoft data platform is the leader in the analytics
and BI market.
This book will demonstrate the demand for data analytics skills by businesses
today, where you can find work and what employers will expect from you.
It then takes you on a practical guide to Microsoft Power BI. No prior knowledge
is required. This is a comprehensive beginner’s guide to Power BI.
Page |2
, POWERBI NOTES BY INTERVIEWSTORYSHELF
1. Power BI - A Complete Introduction…………………………………………………………………………………….05
2. What is Data Wherehouse? ………………………………………………………………………………………………..10
3. Power BI Software’s / Tools / Products………………………………………………………………………………..12
4. Power BI Desktop Installation………………………………………………………………………………………………16
5. Data Transformation with Power Query / Query Editor………………………………………………………..20
6. Connect to various data sources………………………………………………………………………………………..23
7. The Power Query editor user experience……………………………………………………………………………..26
8. Data Modeling in Powerbi…………………………………………………………………………….……………………..29
9. Snowflake and Star Schema………………………………………………………………………….……………………..31
10. Relationships……………………………………………………………………………………………………………………….36
11. Change Data Type of a Column in Power BI………………………………………………………………………….48
12. Types of Joins / Join Kinds / Merge Type:……………………………………………………………………………..65
13. Introduction to DAX……………………………………………………………………………………………………………..71
14. DAX Syntax & Operators………………………………………………………………………………………………………75
15. DAX Functions. ……………………………………………………………………………………………………………………79
16. Time Intelligence ………………………………………………………………………………………………………………..114
17. Power Query Software Overview :……………………………………………………………………………………..119
18. Power BI Visual Interactions (Ad-hoc filtering and highlighting)……………………..……..…………...121
19. Drill through in Power BI Desktop…………………………………………………………………………………….….122
20. Filters in Power BI………………………………………………………………………………………………………………..124
21. Hierarchies and Drill-Down in Power BI………………………………………………………………………………..126
22. Data Visualization Basics……………………………………………………………………………………………………...133
23. Visualizing KPI Data………………………………………………………………………………………………………………149
24. Maps in Power BI………………………………………………………………………………………………………………….153
25. Grouping and Binning ………………………………………………………….………………………………..…………….157
26. Sorting Data in Visuals in Power BI Desktop.………………………………………………………………………..163
27. Create tooltips based on report pages in Power BI Desktop……….……………………………….……....169
28. Bookmarks.……………………………………………………………….……………………………...…………………………174
29. Selection Pane: ……………………………………………………………….……………………………………………….....180
30. What is Power BI Service …………………………………………………………………….….……………………….....188
31. Workspaces …………………………………………………………………………………………………………….……….....190
32. Access on-premises data from Power BI Service – Data Gateway..………………………….………………192
Page |3
