Value displayed in the original report.
Case 08 · GA · Power BI
PBI Dashboard for coffee retailer
The data sources: a CSV file with currency exchange rates and an XLS file located on SharePoint.
Starbuck coffee reportOriginal report screen
Volume displayed in the original report.
This year and year-ago calculations.
GA and Power BI case.
CSV and XLS.
The data sources: a CSV file with currency exchange rates and an XLS file located on SharePoint.
Currency exchange ratesCSV file
Report dataXLS file located on SharePoint
Two main pages.
First page is dedicated to main trend of product distribution.
PAGE 01
General tendency
Product distribution, countries, manufacturers, value sales and volume in cups.
PAGE 02
Time tendency
Change of the trend and activity of the customers through MAT, YTD and MTD calculations.
Report page 01
Main trend of product distribution.
First page is dedicated to main trend of product distribution and includes the following visuals.
General tendencyOriginal Power BI screen
Visuals
General tendency.
01
Matrix with data about Values Sales in EUR and CHF, volume of sales in cups (with distribution for Segments and Zones).
02
Chart with sales in EUR per country and volume in cups.
03
Treemap for top 10 Manufacturers by Sales in EUR.
04
Chart with volumes (monthly) in cups with Trend Line.
05
Cards with total sales in EUR and total volume cups sales.
Slicers: For Segments, active for all visualizations, inactive for cards with total sales in EUR and total volume cups sales.
Report page 02
Change of the trend and activity of the customers.
The second page is dedicated to change of the trend and activity of the customers.
Visuals
MAT, YTD and MTD.
01
Matrix with MAT TY, MAT YA, MAT TY vs MAT YA (Abs), MAT TY vs MAT YA (%), share MAT TY out of total calculations for every Segment (groups).
02
Matrix with YTD TY, YTD YA, YTD TY vs YTD YA (Abs), YTD TY vs YTD YA (%), share YTD TY out of total calculations for every Segment (groups).
03
Matrix with MTD TY, MTD YA, MTD TY vs MTD YA (Abs), MTD TY vs MTD YA (%), share MTD TY out of total calculations for every Segment (groups).
04
Matrix with Manufacturers and Sales MAT TY, Share MAT TY.
05
Matrix with Manufacturers and Sales YTD TY, Share YTD TY.
06
Matrix with Manufacturers and Sales MTD TY, Share MTD TY.
07
Cards with Sales Value, Sales MAT TY, Sales YTD TY, Sales MTD TY.
Note: (Abs) — Absolute change of Value Sales; (%) — relative change of Value Sales.
Coffee data reportOriginal MAT · YTD · MTD screen
Report screen 03
Users portrait.
The third report image shown on the original page is preserved here in full.
Users portrait
New users, returning users, device distribution, age and gender, preferable devices and users’ interests.
The report also shows the most popular days of the week and hours for visits.
The definitions
MAT, YTD and MTD.
Definitions and examples from the original case.
Moving Annual Total
Finds the total value over the last 12 months.
MAT TY (This Year)
Finds total value over the course of the previous 12 months, starting from the latest period available in current year (e.g., latest available period is Nov 2020, MAT TY calculates total of all values from Dec 1, 2019 to Nov 30, 2020).
MAT YA (Year Ago)
Total value over previous 12 months last year, starting from the same month as above of previous year (e.g., MAT YA calculates total of all values from Dec 1, 2018 to Nov 30, 2019).
Year to Date
Finds total value of period of time beginning the first day of the reporting calendar year to the latest available month or date etc.
YTD TY (This Year)
Calculates total value, based on period that starts with the first day of the current calendar year to the latest available month or date etc. (e.g., Jan 1, 2020 – Nov 30, 2020).
YTD YA (Year Ago)
Calculates total value for the same period as above of previous year (e.g., Jan 1, 2019 – Nov 30, 2019).
Month to Date
Finds total value of the period starting from the beginning of the current month up until now.
MTD TY
Total value for the latest available month (e.g., Nov 1 – Nov 30, 2020).
MTD YA
Finds total value of same period as above for previous year (e.g., Nov 1 – Nov 30, 2019).