Microsoft Power BI Data Analyst

Microsoft Power BI Data Analyst
Course Outline	Outline
Reading Material	Download
Microsoft Material Access	Instruction
PowerPoint Slides	intro.pptx Slides.zip
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 Microsoft Official Exam link Tutorial Exam Skills Outline Exam Guide
Official URLs	Official GitHub material PowerBI Cloud PowerBI Documentation Power BI Pricing Power BI report server
Useful References	Data refresh in Power BI Get started with the Power BI Gateway Running Python Scripts in Power BI REAL TIME Reports in Power BI Sentiment Analysis using Microsoft Power BI Power BI Pro vs. Power BI Free vs. Power BI Premium Cohort Analysis Use buttons in Power BI
Day	Module		Sharing
1	1	Get Started with Microsoft Data Analytics Getting Started with Power BI
	2	Data Analytics and Microsoft Optimize Performance Resolve Data Errors
	3	Shaping the Data Profiling the Data Enhance the data structure
	4	Introduction to data modeling Working with tables Dimensions and Hierarchies
2	5	Introduction to DAX Real-time dashboards Advanced DAX
	6	Optimize the data model for performance Optimize DirectQuery Models
	7	Design a report Enhance the report
	8	Create a Dashboard Real-time Dashboards Enhance a Dashboard
3	9	Advanced Analytics Data Insights through AI visuals
	10	Creating Workspaces Sharing and Managing Assets
	11	Parameters Datasets
	12	Security in Power BI

Recommanded Books
	Title	Teach Yourself Visually Power BI
	ISBN	978-1-119-89465-0
	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	Pro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting
	ISBN	978-1-484-29632-5
	Author	Adam Aspin
	Year	2023
	Publisher	Apress
	Title	Beginning Power BI for Business Users: Learning to Turn Data into Insights
	ISBN	978-1-394-19029-4
	Author	Paul D. Fuller
	Year	2023
	Publisher	Wiley
	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 the Excel Analyst: Your Essential Guide to Power BI
	ISBN	978-1-615-47076-1
	Author	Wyn Hopkins
	Year	2022
	Publisher	Holy Macro! Books
	Title	Microsoft Power BI Data Analyst Certification Guide
	ISBN	978-1-803-23856-2
	Author	Orrin Edenfield
	Year	2022
	Publisher	Packt Publishing
	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	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
	ISBN	978-1-800-56157-1
	Author	Devin Knight, Bradley Schacht, Mitchell Pearson, Erin Ostrowsky
	Year	2020
	Publisher	Packt
	Title	Learn Power BI: A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI
	ISBN	978-1-838-64448-2
	Author	Deckler, Greg
	Year	2019
	Publisher	Packt Publishing, Limited
	Title	The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
	ISBN	978-1-509-30697-8
	Author	Marco Russo, Alberto Ferrari
	Year	2019
	Publisher	Microsoft Press
	Title	Supercharge Power BI: Power BI Is Better When You Learn to Write DAX
	ISBN	978-1-615-47069-3
	Author	Matt Allington
	Year	2018
	Publisher	Holy Macro! Books
	Title	Power BI: Moving Beyond the Basics of Power BI and Learning about DAX Language
	ISBN	B089XYQCVR
	Author	Mike Morris, Nick Gallagher, et al.
	Year	2020
	Publisher	Albano Publishing LLC
	Title	DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence
	ISBN	978-1-839-21707-4
	Author	Greg Deckler
	Year	2020
	Publisher	Packt Publishing
	Title	Hands-On Business Intelligence with DAX
	ISBN	978-1-838-82863-9
	Author	Ian Horne
	Year	2020
	Publisher	Packt
	Title	Applied DAX with Power BI: From zero to hero with 15-minute lessons
	ISBN	978-1-733-04610-7
	Author	Lachev, Teo
	Year	2019
	Publisher	Prologika Press
	Title	DAX Patterns
	ISBN	978-1-735-36520-6
	Author	Russo, Marco; Ferrari, Alberto
	Year	2020
	Publisher	SQLBI Corp.
	Title	Supercharge Excel: When you learn to Write DAX for Power Pivot
	ISBN	978-1-615-47053-2
	Author	Matt Allington
	Year	2018
	Publisher	Holy Macro! Books
	Title	Pro DAX with Power BI: Business Intelligence with Powerpivot and SQL Server Analysis Services Tabular
	ISBN	978-1-484-24896-6
	Author	Philip Seamark; Tom Martens
	Year	2019
	Publisher	Apress
	Title	Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
	ISBN	978-1-484-23476-1
	Author	Philip Seamark
	Year	2018
	Publisher	Apress
	Title	Analyzing Data with Power BI and Power Pivot for Excel
	ISBN	978-1-509-30276-5
	Author	Alberto Ferrari, Marco Russo
	Year	2017
	Publisher	Microsoft Press

Exam Code:PL-300

Exam Name:Microsoft Power BI Data Analyst