This course teaches learners how to use Power BI Desktop to clean and transform data, create dashboards, and monitor sales. The course covers importing and appending multiple text files, creating relationships, using DAX functions, and building interactive dashboards. The intended audience for this course is accountants looking to enhance their data analysis and reporting skills using Power BI Desktop.
Power BI for Accountants - Complete Introduction to Power BI Desktop to Build Reports & Dashboards
ExcelIsFun via YouTube
Overview
Syllabus
) Download Files.
) Video Introduction and review of Topics covered in video.
) Introduction to Power BI Desktop.
) Overview of process of using Power BI Desktop to build our specific Reports and Dashboards.
) Open and Save Power BI File.
) Import Excel dProduct Lookup Tables.
) Import and Append Multiple Text Files with Sales Data.
) Clean Data.
) Discussion of Relationships and why they are important.
) Create Calendar Table using DAX CALENDAR Table Function.
) Create Calculated Columns with DAX Functions: MONTH, FORMAT and YEAR.
) Create Relationships and discuss more about Relationships.
) Save As to save Power BI File.
) Create Cross Tabulated Power BI Report.
) Show Values As % of Column Total.
) Create Gross Profit Dash Board.
) DAX Measure for Gross Profit %.
) Column and Bar Chart as Slicer for Gross Profit Dashboard.
) Dashboard Interactivity.
) Add New Data And Watch Dashboard Update.
) Conclusion & Summary.
Taught by
ExcelIsFun
