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 |
| 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 |