Power BI: US Coffee Shop Power BI: US Coffee Shop


Us Coffee Chain


  1. Download the dataset and load it into power bi desktop


  1. Create calender table 



  1. Create relationships


  1. Create DAX Measures 



  1. Add refresh date 

  1. Add logo and title
  1. Add date slicer 
  1. Add cards for sales per month, YOY%, GPM%, GPM YOY%, and refreshed date 



  1. Add arrow indicator 


  1. Create the map
  1. Create map legend 
  1. Create line and stacked column visual 

  1. Another line and stacked column visual 
  1. Create last visual 

  1. Final 

Click here for the interactive dashboard!