You asked for it. Here is a complete and in-depth course on how to use Power BI for data analysis. We are going to cover powerful & practical concepts like,
✅ How to load and clean-up data with Power BI
✅ How to build a data model in Power BI
✅ Using DAX & Power Pivot to build measures and calculations
✅ Creating and changing visuals
✅ Answering business questions with Power BI
✅ Understanding trends & creating forecast in Power BI
✅ Customizing visuals & interaction effects
✅ Creating a comprehensive sales performance report
✅ Saving and publishing the Power BI files
✅ Updating and data refresh process
✅ Additional resources to learn and master Power BI
~
DOWNLOAD THE FILES:
====================
👉 If you want to follow-along:
✅ Blank data file (for following along): https://chandoo.org/wp/wp-content/uploads/2022/02/pb-sales-data-blank.xlsx
✅ Extra data file (for testing the refresh process): https://chandoo.org/wp/wp-content/uploads/2022/02/extra-data.xlsx
👋If you want completed files:
✅ Completed file pack (unzip for all the files): https://chandoo.org/wp/wp-content/uploads/2022/02/data-analysis-with-powerbi-files.zip
POWER BI LEARNING RESOURCES:
=============================
1 Page PDF on Power BI learning resources - https://chandoo.org/wp/wp-content/uploads/2022/02/Resources-to-Learn-Power-BI.pdf
Download Power BI Desktop software - https://powerbi.microsoft.com/en-us/desktop/
~
VIDEO TIMESTAMPS ⏱👉
======================
Use these timestamps to access individual chapters of the video. For best results, watch the video from start to finish.
0:00 - Welcome to Data Analysis with Power BI Course
1:50 - Power BI Desktop (how to get it)
2:50 - Power BI Desktop Screen Explained
4:42 - Sample Data file explained
5:58 - Loading data into Power BI
7:24 - Setting up the data model in Power BI (star schema)
9:30 - Creating our first charts in Power BI
10:38 - Fixing data problems (data clean-up with Power Query)
13:16 - Adding "amount by sales persons / team" chart
13:53 - Interactive nature of Power BI
15:21 - Fixing "blank" team problem
16:33 - Saving Power BI workbooks
16:48 - Analyzing Sales Peron Performance in Power BI
17:52 - Adding "Measures" with DAX in Power BI
20:06 - Using Slicers to filter visual / page level data
20:41 - Formatting the visuals
22:22 - Adding more "measures"
25:00 - How to setup conditional formatting on the visuals
26:32 - Adding "WOW" factor to the report
28:11 - More visuals & controlling the interactions
31:04 - Adding "titles & logos" on the report
33:01 - How to do "trend analysis" in Power BI
36:02 - Forecasting Power BI
37:44 - How to save & publish Power BI reports
39:45 - Refreshing with new data
41:10 - How to learn more about Power BI?
1 Page PDF on Learning Power BI 📃💻👇
==================================
Download the 1 pager from here - https://chandoo.org/wp/wp-content/uploads/2022/02/Resources-to-Learn-Power-BI.pdf
More Power BI related Videos for you 👉
=================================
1️⃣ Power BI vs Power Query & Power Pivot - Awesome example - https://youtu.be/6lzdovy1uCw
2️⃣ Power BI Analyst Job - what is it like? - https://youtu.be/tScP7oRZey8
3️⃣ Example Power BI report & how it compares with Excel - https://youtu.be/OKSIVfMF0QI
4️⃣ Create a variance chart in Power BI - https://youtu.be/ePQBg93EEWE
⏩ Power BI videos on the channel - Full Playlist - https://www.youtube.com/watch?v=CJW-Yb4PfZ8&list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
~
Thank you and happy learning. 😀🌞🌻
#PowerBI #Data
0 Comments