- Using Worksheet
- Using Names
- Using Table Objects
- The ETL Process
- The Power Query Windows
- The Power BI Desktop Main Interface
- The Report,Data and Model Views
Analyzing Data with Power BI | |||
|---|---|---|---|
| Course Outline | |||
| Reading Material | |||
| Useful URLs |
Download latest Microsoft Official Course Exercises Official GitHub material PowerBI Cloud PowerBI Documentation Cohort Analysis Use buttons in Power BI AdventureWorks sample databases Share Power BI reports and dashboards with coworkers and others |
||
| 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 Power BI Pricing Power BI report server |
||
| Day | Lab | Sharing | |
| 1 | 1 |
|
Ex01.pdf Ex01.zip XL1001 Notes |
| 2 |
|
||
| 3 |
|
Ex03.pdf Ex03.zip | |
| 4 |
|
Ex04.pdf Ex04.zip | |
| 2 | 5 |
|
Ex05.pdf Ex05.zip |
| 6 |
|
https://xviz.com/ Sample external visual project files Bing Map Documentation Map-Streetview (Using Bing Map) |
|
| 3 | 7 |
|
Ex07.pdf Ex07.zip |
| 8 |
|
Ex08.pdf
Ex08.zip
Smart Narrative Decomposition Tree |
|
| 4 | 9 |
|
|
| 10 |
|
||
| 11 | Themes | Instruction | |
| 12 | Tooltip | Instruction Data | |
| 13 | Heat Map | Instruction Data | |
| 14 | Conditional Formatting | Instruction Data | |
| 15 | Timeline | Instruction Data | |
| 16 | Gantt Chart | Instruction Data | |
| 17 | KPI | Instruction Data | |
| 18 | Running Total | Instruction Data | |
| 19 | Calendar | Instruction Data | |
| 20 | Switch Function | Instruction Data | |
| 21 | Calculate Function | Instruction Data | |
| 22 | Related Function | Instruction Data | |
| 23 | Replicate VLookup | Instruction Data | |
| 24 | SumX Function | Instruction Data | |
| 25 | GroupBy Function | Instruction Data | |
| 26 | Security | Instruction Data | |
| 27 | Share Reports | Instruction | |
| 28 | Drill-Through | Instruction | |
| 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 |
| ISBN | 978-1-615-47076-1 | |
| Author | Wyn Hopkins | |
| Year | 2022 | |
| Publisher | Holy Macro! Books | |
 | Title | Exam Ref DA-100 Analyzing Data with Microsoft Power BI |
| ISBN | 978-0-136-81968-4 | |
| Author | Daniil Maslyuk | |
| Year | 2021 | |
| Publisher | Microsoft | |
 | 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 | |
.jpg) | 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 | |
.jpg){kind=spacer} | 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 | |
 | 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 | |