Power Query– tag –
-
[Vol.7] How to Add Slicers, Cards and Charts in Power BI: Dashboard Layout
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 6, we created DAX measures to display year-over-year (YoY) changes and target achievement status. Now it's time to start building the dash... -
[Vol. 6] How to Calculate YoY and Target Achievement in Power BI: DAX Measures
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol.5, we created four basic KPI measures: Operating Margin, Utilization Rate, Inventory Turnover, and Defect Rate. In this article, we will cr... -
[Vol. 5] How to Create Power BI KPI Measures: DAX SUM, AVERAGE and DIVIDE
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 4, we created a Calendar table and connected the four fact tables to both the Calendar master table and the line master table to build the... -
[Vol. 4] How to Create a Calendar Table in Power BI: DAX & Relationships
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 3, we imported five CSV files using Power Query and prepared the column names and data types. In this article, we will build the foundatio... -
[Vol.3] How to Import CSV Files into Power BI: Power Query Basics
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 2, we covered how to install Power BI Desktop and explored its main interface. You should now have a basic understanding of key areas such... -
[Vol.2] How to Install Power BI Desktop: The First Step in Building a Dashboard
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol.1, we introduced the overall concept of a Power BI dashboard and showed what the completed dashboard would look like. Power BI can streamli... -
[Vol.1] How to Build a KPI Dashboard in Power BI: Manufacturing KPI Example
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In finance and management reporting, a significant amount of time is often spent preparing monthly reports. Data collection, Excel-based calculati...
1