Retail #SocialMedia dashboard utilizing Microsoft #Excel and #PowerPivot. #bigdata

image

I’ve been helping out a buddy create a social media dashboard for a bunch of retailers he visits.  Since the Twitter Analytics for Excel ran out of support, he needed another option and asked for some help.

I utilized Plus One Social to pull the data.  This program allows you to search on keywords and then places the data into a desktop database.

image

Then using PowerPivot, I created a self-serve BI model for the end-user to create their own dashboards.

image

Then I just easily created some pretty cool looking dashboards.  I think the hardest part of doing it in Excel is just getting everything to line up and look appropriate.  But I think I nailed it.  Comments?

image

Email should you have any questions.

 

Enjoy, Patrick

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s