Using Text / CSV file as a Data Source for Power BI
Using Folder as a Data Source for Power BI
Using Web as a Data Source for Power BI
The Power BI Data Model
Using Databases as a Data Source for Power BI
The Power BI Service
2
Introduction to Power Query Editor
Types of Power BI Data Connectors
Basic Table Transformations
Power BI Desktop Queries
Raw Data Housekeeping
Shaping Data
Combining Data
Text, Number, Date Tools
Index and Conditional Columns
Grouping and Aggregating Data
Connecting to Folders
Defining Hierarchies & Categories
Query Editing and Power BI Best Practices
Introduction to Database Normalization
Data (“Fact”) Tables Vs. Lookup (“Dimension”) Tables
Creating Power BI Table Relationships
Active vs. Inactive Relationships
Relationship Cardinality
Connecting Multiple Data Tables
Filtering & Cross Filtering
Data Modelling & Relationships
Basic Calculations and Measure
Intro to the Power BI Report View
Adding Basic Charts to Power Bi reports
Formatting and Filtering Options
Matrix Visuals
Slicers & Timelines
Cards & KPIs
Power BI Map Visuals
Tree maps, Lines Areas, Gauges
Editing Report Interactions
Adding Drill through Filter
Linking to Report Bookmarks
Managing & Viewing Roles
Power BI Data Visualization Best Practises
3
Cloud Data
Connecting to Analysis Services
The Power BI API
Custom Visuals
Publishing Power BI to PowerBI.Com
Intro to Power BI Mobile Apps
Recommanded Books
Title
Teach Yourself Visually Power BI
ISBN
978-1-119-90377-2
Author
Alexander Loth
Year
2023
Publisher
Visual
Title
Data Cleaning with Power BI: The definitive guide to transforming dirty data into actionable insights
ISBN
978-1-805-12640-9
Author
Gus Frazer
Year
2024
Publisher
Packt Publishing
Title
The Complete Power BI Interview Guide: A modern approach to acing the data analyst interview and landing your dream job
ISBN
978-1-805-12067-4
Author
Sandielly Ortega Polanco, Gogula Aryalingam and Abu Bakar Nisar Alvi
Year
2024
Publisher
Packt Publishing Pvt Ltd
Title
Effective Strategy Execution: Business Intelligence Using Microsoft Power BI (Management for Professionals)
ISBN
978-3-662-68806-9
Author
Bernd Heesen
Year
2024
Publisher
Springer
Title
Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions
ISBN
978-1-484-29537-3
Author
Reza Rad
Year
2023
Publisher
Apress
Title
Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
ISBN
978-1-801-81148-4
Author
Greg Deckler, Brett Powell
Year
2022
Publisher
Packt Publishing
Title
Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users
ISBN
978-1-484-28187-1
Author
Alison Box
Year
2022
Publisher
Apress
Title
Pro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics
ISBN
978-1-484-28226-7
Author
Adam Aspin
Year
2022
Publisher
Apress
Title
Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
ISBN
978-1-484-28577-0
Author
Adam Aspin
Year
2022
Publisher
Apress
Title
Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
ISBN
978-9-389-32883-7
Author
Nisal Mihiranga
Year
2022
Publisher
BPB Publications
Title
Power BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data
ISBN
978-9-355-51814-9
Author
Alan Murray
Year
2023
Publisher
BPB Publications
Title
Learning Microsoft Power BI: Transforming Data into Insights
ISBN
978-1-098-11284-4
Author
Jeremey Arnold
Year
2023
Publisher
O'Reilly Media
Title
Applied Microsoft Power BI: Bring your data to life!
ISBN
978-1-733-04613-8
Author
Teo Lachev,Edward Price,Maya Lachev,Martin Lachev
Year
2022
Publisher
Prologika
Title
Microsoft Power BI For Dummies
ISBN
978-1-119-82487-9
Author
Jack A. Hyman
Year
2022
Publisher
For Dummies
Title
Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
ISBN
978-1-800-20569-7
Author
Soheil Bakhshi
Year
2021
Publisher
Packt Publishing
Title
Microsoft Power BI Performance Best Practices: A comprehensive guide to building consistently fast Power BI solutions
ISBN
978-1-801-07644-9
Author
B. Merchant, C. Webb
Year
2022
Publisher
Packt Publishing
Title
Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition
ISBN
978-1-801-81195-8
Author
Greg Deckler
Year
2022
Publisher
Packt Publishing
Title
Introducing Charticulator for Power BI: Design Vibrant and Customized Visual Representations of Data
ISBN
978-1-484-28075-1
Author
A. Box
Year
2022
Publisher
Apress
Title
Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
ISBN
978-1-801-07851-1
Author
Michiel Rozema, Henk Vlootman
Year
2022
Publisher
Packt Publishing
Title
Mastering Power BI: Build Business Intelligence Applications Powered with DAX Calculations, Insightful Visualizations, Advanced BI Techniques, and Loads of Data Sources
ISBN
978-9-391-03072-8
Author
Chandraish Sinha
Year
2021
Publisher
BPB Publications
Title
Pro Power BI Desktop: Self-service Analytics and Data Visualization for the Power User
ISBN
978-1-48425-762-3
Author
Adam Aspin
Year
2020
Publisher
Apress
Title
Data Analysis with Microsoft Power BI
ISBN
978-1-260-45862-6
Author
Brian Larson
Year
2020
Publisher
McGraw-Hill Education
Title
Microsoft Power BI Quick Start Guide - Second Edition: Bring your data to life through data modeling, visualization, digital storytelling, and more
.jpg)
.jpg){kind=spacer}
