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


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.


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


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?


Email should you have any questions.


Enjoy, Patrick

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s