Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

MGT 4337: HR Staff/Employee Relations (Perry): Project

This guide contains resources to help students locate information on factors related to their company project

Microsoft Power BI

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

University Libraries

One Bear Place #97148
Waco, TX 76798-7148

(254) 710-6702