Analyzing Data with Power BI |
| Course Outline |
Download
|
| Day | Modules | Sharing |
| 1 |
- Data Analytics and Microsoft
- Getting Started with Power BI
- Get data from various data sources
- Optimize performance
- Resolve data errors
- Data shaping
- Enhance the data structure
- Data Profiling
|
|
| 2 |
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
- Introduction to DAX
- DAX context
- Advanced DAX
- Optimze the model for performance
- Optimize DirectQuery Models
- Create and manage Aggregations
- Design a report
- Enhance the report
|
|
| 3 |
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
- Paginated report overview
- Create Paginated reports
- Advanced Analytics
- Data Insights through AI visuals
|
|
| 4 |
- Creating Workspaces
- Sharing and Managing Assets
|
|
| 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 | 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 | 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 | 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 | 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 | Hands-On Business Intelligence with DAX |
| ISBN | 978-1-838-82863-9 |
| Author | Ian Horne |
| Year | 2020 |
| Publisher | Packt |
.jpg) | Title | Collect, Transform and Combine Data using Power BI and Power Query in Excel (Business Skills) |
| ISBN | 978-1-509-30795-1 |
| Author | Gil Raviv |
| Year | 2018 |
| Publisher | Microsoft Press |