Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360)

Course Overview

) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard.
) Import Multiple Excel Files From Folder.
) Name Query.
) Transform extension column to lowercase.
) Filter Files to only include ".xlsx" file extensions.
) Remove Columns.
) November 2016 Power Query Update Problem.
) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File..
) Delete Content Column.
) Filter to only include Excel Sheet Objects.
) Filter to exclude sheets that contain the word "Sheet".
) Remove Columns.
) Expand Data and Sheet Name Columns.
) Change Field Names.
) Change Data Types.
) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type..
) Remove columns for Amount and Revenue Discount.
) Close and Apply to add to Data Model.
) Import Excel Manager Table. Change Data Types to Text. Close and Apply.
) Create Relationship between Zip Code Columns.
) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type..
) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing..
) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing..
) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers).
) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers).
) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage.
) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage.
) Create Slicer for States..
) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage..
) Summary.

(Please note that we obtained the following content based on information that users may want to know, such as skills, applicable scenarios, future development, etc., combined with AI tools, and have been manually reviewed)
[Course Overview]: This course provides a comprehensive overview of Power BI Desktop, a powerful data visualization and analysis tool. It covers the entire process of creating a dynamic dashboard from Excel data, including importing multiple Excel files from a folder, transforming columns, filtering files, adding custom columns, creating relationships, and creating visualizations. It also covers the November 2016 Power Query update problem and how to work around it. By the end of the course, learners will have a complete understanding of Power BI Desktop and be able to create their own dynamic dashboards.

[Why to Learn]: Power BI Desktop is a powerful tool for data visualization and analysis. It allows users to quickly and easily create dynamic dashboards from Excel data, and provides a wide range of features for customizing visualizations. Learning Power BI Desktop can help learners gain valuable skills in data analysis and visualization, which can be applied to a variety of fields.

[Development Paths]: After completing this course, learners can continue to develop their Power BI Desktop skills by exploring more advanced features, such as creating custom visuals, using the R language, and creating custom measures. They can also explore other data visualization and analysis tools, such as Tableau and QlikView.

[Related Learning Suggestions]: Learners interested in further developing their data analysis and visualization skills can explore courses on Excel, Tableau, and QlikView. They can also explore courses on data science, machine learning, and artificial intelligence.