🏡


Analyzing Data with Power BI

Course Outline Download
Reading Material Download
PPNS
Useful URLs
Useful References Sharing Power BI Report with Free Users:
DayLabSharing
1 1
  • Using Worksheet
  • Using Names
  • Using Table Objects
  • The ETL Process
  • The Power Query Windows
  • The Power BI Desktop Main Interface
  • The Report,Data and Model Views
2
  • What is relationship?
  • Why you need to know?
  • Primary Key
  • Foreign Key
  • Referential integrity
  • Cardinality/Multiplicity
  • Active Relationship
  • Alias Table Technique
3
  • Custom/Virtual Column: What it is about?
  • Create ETL level Custom Columns
  • Create ETL level Conditional Columns
  • Create Report level Custom Columns
  • Comparing ETL and Report level Custom Columns
4
  • The Data Warehousing Concept
  • Create Internal Tables
  • Load Data from CSV files
  • Load Data from XML files
  • Load Data from JSON files
  • Load Data from PDF files
  • Load Data from Web Sites
  • Load Data from Rest API
  • Load Data from Microsoft SQL Server
  • Load Data from Azure Cloud
2 5
  • Promote/Demote Header
  • Pivot
  • Unpivot
  • Add Index column
  • Reposition column
  • Convert to List
  • Reduce Rows
  • Transpose
  • Group By
  • Append Columns
  • Merge Columns
6
  • Fill Down
  • Single and Both Direction
  • How to using Map Visuals to present geographical related information?
  • How to add more external Visuals?
  • Filtering Scopes?
  • How to Drill Down the Hierarchical data?
  • How to Drill Through from one report page to other page?
  • What is Matrix?
  • How to create and use Measures?
3 7
  • The uses of Bookmarks
  • Advanced filtering with Slicers
  • Dealing with Hierarchies Data
  • The power of DAX
  • Using SQL Statements
  • Direct Query
  • ETL Level Parameters
  • Reporting Level Parameters
  • Define and use Roles
8
  • Analytics
  • Q & A Visual
  • Key Influencer
  • Decomposition Tree
  • Smart Narrative
4 9
  • Publish Report
  • Create Dashboards
  • Using Q&A under Dashboard to create new Visuals
  • Sharing Reports and Dashboards
  • Cross Report Drill-through
  • Data Gateway
  • Refresh Data
  • Download PowerPoint Slide and PDF files
10
  • Install Power BI Mobile App
  • Phone Views
11 Themes Instruction
12 Tooltip Instruction    Data
13 Heat Map Instruction    Data
14 Conditional Formatting Instruction    Data
15 Timeline Instruction    Data
16 Gantt Chart Instruction    Data
17 KPI Instruction    Data
18 Running Total Instruction    Data
19 Calendar Instruction    Data
20 Switch Function Instruction    Data
21 Calculate Function Instruction    Data
22 Related Function Instruction    Data
23 Replicate VLookup Instruction    Data
24 SumX Function Instruction    Data
25 GroupBy Function Instruction    Data
26 Security Instruction    Data
27 Share Reports Instruction
28 Drill-Through Instruction

Recommanded Books
TitleTeach Yourself Visually Power BI
ISBN978-1-119-90377-2
AuthorAlexander Loth
Year2023
Publisher Visual
TitleData Cleaning with Power BI: The definitive guide to transforming dirty data into actionable insights
ISBN978-1-805-12640-9
AuthorGus Frazer
Year2024
Publisher Packt Publishing
TitleThe Complete Power BI Interview Guide: A modern approach to acing the data analyst interview and landing your dream job
ISBN978-1-805-12067-4
AuthorSandielly Ortega Polanco, Gogula Aryalingam and Abu Bakar Nisar Alvi
Year2024
Publisher Packt Publishing Pvt Ltd
TitleEffective Strategy Execution: Business Intelligence Using Microsoft Power BI (Management for Professionals)
ISBN978-3-662-68806-9
AuthorBernd Heesen
Year2024
Publisher Springer
TitlePro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions
ISBN978-1-484-29537-3
AuthorReza Rad
Year2023
Publisher Apress
TitlePro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting
ISBN978-1-484-29632-5
AuthorAdam Aspin
Year2023
Publisher Apress
TitleBeginning Power BI for Business Users: Learning to Turn Data into Insights
ISBN978-1-394-19029-4
AuthorPaul D. Fuller
Year2023
Publisher Wiley
TitleMastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
ISBN978-1-801-81148-4
AuthorGreg Deckler, Brett Powell
Year2022
Publisher Packt Publishing
TitleUp and Running with DAX for Power BI: A Concise Guide for Non-Technical Users
ISBN978-1-484-28187-1
AuthorAlison Box
Year2022
Publisher Apress
TitlePro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics
ISBN978-1-484-28226-7
AuthorAdam Aspin
Year2022
Publisher Apress
TitlePro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
ISBN978-1-484-28577-0
AuthorAdam Aspin
Year2022
Publisher Apress
TitlePower BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
ISBN978-9-389-32883-7
AuthorNisal Mihiranga
Year2022
Publisher BPB Publications
TitlePower BI for the Excel Analyst: Your Essential Guide to Power BI
ISBN978-1-615-47076-1
AuthorWyn Hopkins
Year2022
Publisher Holy Macro! Books
TitleExam Ref DA-100 Analyzing Data with Microsoft Power BI
ISBN978-0-136-81968-4
AuthorDaniil Maslyuk
Year2021
Publisher Microsoft
TitlePower BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data
ISBN978-9-355-51814-9
AuthorAlan Murray
Year2023
Publisher BPB Publications
TitleLearning Microsoft Power BI: Transforming Data into Insights
ISBN978-1-098-11284-4
AuthorJeremey Arnold
Year2023
Publisher O'Reilly Media
TitleApplied Microsoft Power BI: Bring your data to life!
ISBN978-1-733-04613-8
AuthorTeo Lachev,Edward Price,Maya Lachev,Martin Lachev
Year2022
Publisher Prologika
TitleMicrosoft Power BI For Dummies
ISBN978-1-119-82487-9
AuthorJack A. Hyman
Year2022
Publisher For Dummies
TitleExpert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
ISBN978-1-800-20569-7
AuthorSoheil Bakhshi
Year2021
Publisher Packt Publishing
TitleMicrosoft Power BI Performance Best Practices: A comprehensive guide to building consistently fast Power BI solutions
ISBN978-1-801-07644-9
AuthorB. Merchant, C. Webb
Year2022
Publisher Packt Publishing
TitleLearn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition
ISBN978-1-801-81195-8
AuthorGreg Deckler
Year2022
Publisher Packt Publishing
TitleExtreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
ISBN978-1-801-07851-1
AuthorMichiel Rozema, Henk Vlootman
Year2022
Publisher Packt Publishing
TitleMastering Power BI: Build Business Intelligence Applications Powered with DAX Calculations, Insightful Visualizations, Advanced BI Techniques, and Loads of Data Sources
ISBN978-9-391-03072-8
AuthorChandraish Sinha
Year2021
Publisher BPB Publications
TitlePro Power BI Desktop: Self-service Analytics and Data Visualization for the Power User
ISBN978-1-48425-762-3
AuthorAdam Aspin
Year2020
Publisher Apress
TitleData Analysis with Microsoft Power BI
ISBN978-1-260-45862-6
AuthorBrian Larson
Year2020
Publisher McGraw-Hill Education
TitleMicrosoft Power BI Quick Start Guide - Second Edition: Bring your data to life through data modeling, visualization, digital storytelling, and more
ISBN978-1-800-56157-1
AuthorDevin Knight, Bradley Schacht, Mitchell Pearson, Erin Ostrowsky
Year2020
Publisher Packt
TitleLearn Power BI: A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI
ISBN978-1-838-64448-2
AuthorDeckler, Greg
Year2019
Publisher Packt Publishing, Limited
TitleThe Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
ISBN978-1-509-30697-8
AuthorMarco Russo, Alberto Ferrari
Year2019
Publisher Microsoft Press
TitleSupercharge Power BI: Power BI Is Better When You Learn to Write DAX
ISBN978-1-615-47069-3
AuthorMatt Allington
Year2018
Publisher Holy Macro! Books
TitlePower BI: Moving Beyond the Basics of Power BI and Learning about DAX Language
ISBNB089XYQCVR
AuthorMike Morris, Nick Gallagher, et al.
Year2020
Publisher Albano Publishing LLC
TitleCollect, Transform and Combine Data using Power BI and Power Query in Excel (Business Skills)
ISBN978-1-509-30795-1
AuthorGil Raviv
Year2018
Publisher Microsoft Press
TitleAnalyzing Data with Power BI and Power Pivot for Excel
ISBN978-1-509-30276-5
AuthorAlberto Ferrari, Marco Russo
Year2017
Publisher Microsoft Press