0
34
Development of OLAP reporting in Excel based on PQ and Power Pivot
Databases & SQL
An ETL process for automatic loading, cleaning, and merging of data from multiple Excel files has been implemented using M language. A data model has been built using Power Pivot, measures and KPIs have been created in DAX, and interactive pivot…
