🏡


Microsoft Power BI Data Analyst

Course Outline 🔗Outline
Reading Material 📝Download
Microsoft Material Access 📝Instruction
PowerPoint Slides
Extra Lab(DAX) 🔗Extra.zip
Lab Setup 🔗How to setup Labs for Host Computer.docx
Exam Preparation
Exam Code:PL-300
Exam Name:Microsoft Power BI Data Analyst
Official URLs
Useful References
DayModuleSharing
1 1
  • Data Analytics and Microsoft
  • Getting Started with Power BI
2
  • Get data from various data sources
3
  • Data shaping
  • Enhance the data structure
  • Data Profiling
4
  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies
2 5
  • Introduction to DAX
  • DAX context
  • Advanced DAX
  
6
  • Optimze the model for performance
  • Optimize DirectQuery Models
  • Create and manage Aggregations
7
  • Design a report
  • Enhance the report
8
  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Configure a Dashboard tile alert
  • Use Q&A to create a dashboard tile
3 9
  • Paginated report overview
  • Create Paginated reports
  
10
  • Advanced Analytics
  • Data Insights through AI visuals
11
  • Parameters
  • Datasets
  • Security in Power BI
12
  • Creating Workspaces
  • Sharing and Managing Assets

Recommanded Books
TitleExam Ref PL-300 Power BI Data Analyst
ISBN978-0-137-90123-4
AuthorDaniil Maslyuk
Year2022
Publisher Microsoft Press
TitleMicrosoft Power BI Data Analyst Certification Guide
ISBN978-1-803-23856-2
AuthorOrrin Edenfield
Year2022
Publisher Packt Publishing
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
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
TitleDAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence
ISBN978-1-839-21707-4
AuthorGreg Deckler
Year2020
Publisher Packt Publishing
TitleHands-On Business Intelligence with DAX
ISBN978-1-838-82863-9
Author Ian Horne
Year2020
Publisher Packt
TitleApplied DAX with Power BI: From zero to hero with 15-minute lessons
ISBN978-1-733-04610-7
AuthorLachev, Teo
Year2019
Publisher Prologika Press
TitleDAX Patterns
ISBN978-1-735-36520-6
AuthorRusso, Marco; Ferrari, Alberto
Year2020
Publisher SQLBI Corp.
TitleSupercharge Excel: When you learn to Write DAX for Power Pivot
ISBN978-1-615-47053-2
AuthorMatt Allington
Year2018
Publisher Holy Macro! Books
TitlePro DAX with Power BI: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular
ISBN978-1-484-24896-6
AuthorPhilip Seamark; Tom Martens
Year2019
Publisher Apress
TitleBeginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
ISBN978-1-484-23476-1
AuthorPhilip Seamark
Year2018
Publisher Apress
TitleAnalyzing Data with Power BI and Power Pivot for Excel
ISBN978-1-509-30276-5
AuthorAlberto Ferrari, Marco Russo
Year2017
Publisher Microsoft Press