SalesDemo

Purpose

Showcase Power Bi mastery including DAX functions for Month to Date calculations, DAX tables for top 3 values, visuals with drill down and slicing functionality, bookmarks for navigation, a glossary and accompanying documentation.

I typically avoid as many DAX tables as possible by performing all transformations in a pipeline / SSIS package / miscellaneous data transformation on the server side, but I wanted to include one Power Bi in my portfolio that uses Import instead of Direct Query so that it would load faster.

Data Architecture

Instead of using real data, I created sample spreadsheets for Import.

Power Bi

This Power Bi uses Imported Data so that it is rendered quicker and cannot be refreshed.

Power Bi - Tabs

1. Index - Pages listing Bookmarks to all pages.
2. Flash Report – Snapshot of Sales by Prsnl and Products for a selected period of time. Includes a leaderboard for Prsnl and Products sold.
3. Sales Prnsl Profile – Snapshot of Prsnl acheivements for a specified time period.
4. Product Profile - Snapshot of Products sold for a specified time period.
5. Glossary – Definitions of fields displayed within reports.

Power Bi - Measures

Power Bi - Calculated Columns