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

Great Retail companies to be associated with – Windows 8 and PUSHBI #mobilebi #analytics #mobile

image

A friend at Microsoft sent me a link about the Windows Retail group promoting our PUSHBI solution for Windows 8.  I went to the Windows site and sure enough we’re listed right next to Amazon and eBay! Actually ours is before theirs……just saying.

Source: http://www.microsoft.com/en-us/windows/enterprise/industry/retail.aspx

PUSHBI on Windows 8 is a must have solution –  it is like having your company’s own CNBC available on your Phone/Tablet/Desktop.

If you haven’t yet – check it out by visiting the Windows Store.

image

Thanks for making PUSHBI one of the TOP business applications in the Windows 8 marketplace.

Happy Analytics, Patrick

40 Retail CEOs at the Extended Results Booth at NRF

Well isn’t this an interesting picture?  This week we are assisting Microsoft at the National Retail Federation (NRF) conference in New York.  We have a pod within the Microsoft booth – telling stories and revealing our analytical solutions to visiting retailers from around the world.

image

Out of all of the companies at the conference, we were privileged to have been selected to demonstrate our Retail innovations and insights for these CEOs. Their only stops were at SAP, Intel, Oracle and Extended Results!   That’s it!  That is pretty cool.

We had the opportunity to showcase our Personal Business Intelligence solution, PUSHBI, and our dashboard solution, INSIGHTS365, working in conjunction with Microsoft Office365 in the Cloud.  I believe they walked away pretty impressed and I look forward to the follow up calls.

image

Great job, Bryan

Managers: Get Out of Your Office and onto the Floor… @retailbigshow @nrfnews

We are at the National Retail Federation (NRF) conference in New York this week in the Microsoft booth showcasing the coolest analytics solutions you’ll find on the Microsoft platform.  We’re honored to be working in conjunction with the Microsoft Retail team for our 5th year at this venue.

image

Our theme this year is, “get out of your office and onto the floor.” It’s about empowering managers to get away from the confines of the office, taking their business metrics along with them. Utilizing the best in technologies, managers now have decision-making metrics at their fingertips.

image

Off to a great start with lots of people coming to see PUSHBI.   I believe over the course of 2 hours, Bryan did demos to about 100 people.

image

We even got some TV time because they thought our solution looked like CNBC, but for your business.

Enjoy, Patrick

Setup day at the National Retail Federation conference–Microsoft and Extended Results

image

Another year, another visit to New York for the annual National Retail Federation (NRF) conference.  Above is Bryan Colyer getting our pod setup.

image

The size of the Microsoft booth is huge this year.  We are in the booth for our 5th year.  If you look closely, our pod to the middle left.

image

Here is a sky shot into the Microsoft booth.  Still a lot of setup going on and it should all get done on time for a start on Monday morning.

image

There are a lot of very cool technologies being setup.  Check out that 85 inch touch screen.  Windows device bar, touch tables, mobile devices, smartphones.  This really is GEEK central.

Enjoy, Patrick