Главная
Study mode:
on
1
) Download Files
2
) Video Introduction and review of Topics covered in video
3
) Introduction to Power BI Desktop
4
) Overview of process of using Power BI Desktop to build our specific Reports and Dashboards
5
) Open and Save Power BI File
6
) Import Excel dProduct Lookup Tables
7
) Import and Append Multiple Text Files with Sales Data
8
) Clean Data
9
) Discussion of Relationships and why they are important
10
) Create Calendar Table using DAX CALENDAR Table Function
11
) Create Calculated Columns with DAX Functions: MONTH, FORMAT and YEAR
12
) Create Relationships and discuss more about Relationships
13
) Save As to save Power BI File
14
) Create Cross Tabulated Power BI Report
15
) Show Values As % of Column Total
16
) Create Gross Profit Dash Board
17
) DAX Measure for Gross Profit %
18
) Column and Bar Chart as Slicer for Gross Profit Dashboard
19
) Dashboard Interactivity
20
) Add New Data And Watch Dashboard Update
21
) Conclusion & Summary
Description:
Learn to harness the power of Power BI Desktop for accounting in this comprehensive video tutorial. Master the process of cleaning and transforming data to create dynamic sales dashboards. Import and consolidate multiple text files into a single, easily updatable table for efficient reporting. Explore essential topics including data importation, cleaning techniques, relationship building, DAX functions for calendar tables and calculated columns, cross-tabulated reporting, and interactive dashboard creation. Gain practical skills in visualizing data with column and bar charts, implementing slicers, and updating dashboards with new data. Perfect for accountants looking to enhance their data analysis and visualization capabilities using Power BI Desktop.

Power BI for Accountants - Complete Introduction to Power BI Desktop to Build Reports & Dashboards

ExcelIsFun
Add to list
#Business #Business Intelligence #Microsoft Power BI #Data Science #Data Analysis #Data Cleaning #Data Processing #Data Transformation #Power BI Desktop
1 of 21

) Download Files