Summary
Keywords
Full Transcript
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
