🏡


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
Sample Exam Questions
Version0.8Questions Only
Version0.8Questions & Answers
Version2.0CertGod