malt beverages

1 BUSB333-DashboardUsingPowerPoint

Create a Dashboard

I’m using PowerPoint with embedded charts and Excel spreadsheets to create my dashboard but

there are many options to create a simple dashboard for your industry. I used one of the available

dashboards under PowerPoint templates by selecting NEW – TEMPLATES - DASHBOARD.

Pick one that best suits your research and presentation material. MS Excel also has many

dashboards that are interactive with PowerPoint.

I’m using data from multiple sources:

- L.A. Times article “Southern California’s grocery battle heats up with the spread of discounter Aldi” (Peltz & Spacek, 2017)

- L.A. Times article “A tough region for grocers (Peltz, 2015) - Statista “Market share of Southern California's leading grocery retailers as of June 2017”

(Blazquez, 2017)

I’ve been collecting data on the grocery business since the

great “Strike of 2003” that greatly impacted the

competitive landscape of this industry in Southern

California.

Here are samples of the sources I used for 2015 and 2017.

Based on these sources, I created the dashboard following the prompts within the PowerPoint

slide. Your dashboard may not contain as many visual guides as this one. Just one is sufficient.

I added the actual 2017 sales amounts to the bar graph at the top and changed the Excel

embedded sheet to represent my research with titles and percentage amounts. I calculated the

total amount of sales ($45 billion - 2017) and ensured the correct percentage of sales for each

company. Based on Few’s Best Practices (2013), I changed my calculated percentage figures to

one decimal place as some of the numbers are too close to round up. You’ll also notice that the

bar graph I’m using shows lighter blue bars behind the numbers for a visual reference as well as

the numeric numbers.

2015

2017

2 BUSB333-DashboardUsingPowerPoint

I updated the line graph below. I changed the background color to a darker shade to highlight the

lines. I also changed the embedded Excel sheet to only represent the top two businesses as

adding all six grocery retailers created confusion on the chart without adding more information.

I updated the speedometer to reflect the top 2 grocery stores for 2015 and 2017. This was part of

the PowerPoint template. I could have deleted it as it seems to duplicate the line graph but I kept

it as another visual reference to what’s most important on the dashboard.

I added a graphic of a stop light to reflect a “red-yellow-green” idea that some of the charts use.