Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!)

Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!)

943.573 Lượt nghe
Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!)
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://files.chandoo.org/pbix/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/2023/05/Resources-to-Learn-Power-BI-2023.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/2023/05/Resources-to-Learn-Power-BI-2023.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