Here is a Dashboard for a pharmacy chain. Main concepts used are – Power Pivot, Power Query, DAX, Charts, Slicers. Power Pivots can handle multiple Excel files with large amounts of data. Using these concepts excellent reports and dashboards can be created easily and additional data can be added with ease.
Categories: Uncategorized