Resources
Microsoft Power BI
Example: Baylor's COVID-19 Dashboard
Our favorite places and our favorite foods!
Fill out the following Excel file
We will build from scratch a data-driven dashboard using this structured data. We will use Microsoft Power BI to design the dashboard.
Power Query M (Preprocess Data):
- Add Index column
- For Foods and Locations:
- Split by semicolon
- Unpivot
- Remove attribute column
- Rename value column
- Trim
Power BI Visuals:
- Map
- Column chart of foods by frequency
- Wordcloud of foods
- Slicer of number of times ate out
- Sankey Chart of foods to locations
URL: https://baylor0-my.sharepoint.com/personal/joshua_been_baylor_edu/Documents/Videos/Book.xlsx
