PowerPivot

What does the #Layoff picture look like through Social lenses? w/@plusonesocial

Patrick HustingLeave a comment

image

Just last week our company downsized a lot of people including me!  Smile  I’m cool with it as it allows me a lot more free time to get back to doing what I love to do the most.  Analyze and report data trends.

Well, I thought I would use PlusOneSocial and search on the hashtag #layoff and see what people are saying!  Most people are tweeting about their layoffs early in the morning or afternoon.  Why?  Because that is when they get the notice!

image

Interesting to see what the other hashtags are which include #unemployment, #jobs, #oil, #target and #texas being the most active.

image

If you want to do your own analysis like this for FREE, just visit http://www.plusonesocial.com and download the app.  You’ll be a social media analytics expert in minutes.

Enjoy, Patrick

If I was DELL, CISCO, INTEL, APPLE, GOOGLE and many others, this is what I would use for BI. #excel #sharepoint #powerview

Patrick HustingLeave a comment

image

Well, these guys should be using PUSHBI.  BUT, they all own basically every Microsoft license that you can purchase –  are they actually using the software to their fullest potential?  I can bet you BIG DOLLARS they are not.  They are just producing report after report that nobody is looking at.  I guarantee it.

image

We’ll help these tech-titians maximize their business intelligence investments to their fullest.  We are not just creating another report, but creating dashboard solutions that actually mean something.

image

We are creating dashboards that provide an INSTANT KNOW of what is going on within the organization.  Not just another bar chart, but an interactive story that tells you what is going on with every click.

image

And especially since these tech-behemoths are global corporations, we can easily provide geo-spatial analysis into their product moving across the United States and the Globe.  Where are the sales and the delays in product reaching the distributors?

image

If you’re selling high-technology products, even flight delays in getting product and people to the right destinations can cause a ripple effect to your bottom line.

So if DELL, CISCO, INTEL, APPLE or GOOGLE are listening, it is time to give us a call so we can get out of the “just another report will do” mode.

Enjoy, Patrick

More Microsoft Power View Examples by Extended Results

Patrick Husting1 Comment

The advanced analytics team at Extended Results has really taken off using Microsoft SQL Server 2012 Power View (that was a mouth full).  Just look at some of the great looking reports that they have already developed.  I really like the design feature where the reports look like a piece of paper and the color pallet is soft but allows your eyes to adjust to the report quickly and find outliers.   If you look at the middle report, all the bar charts on one report is quickly mastered from development because a lot of companies like that kind of style of report

Enjoy, Patrick

image

image

image

SQL SQL 2012 Launch and Power View Samples–U.S. Government Budget vs. Spend

Patrick Husting1 Comment

The report below is from a data set we pulled from the U.S. Government for the 1976-2016 time frame. We pulled budget vs. actual spend data which we found to be absolutely amazing! WHY? Because we had no idea what and where our government spends money until now!  Power View really enables some interesting analytics capabilities.  In the report below, across the top you have the different departments you can slice against which then shows you the budget vs. spend for that department.  Also, shows the children of that department on the left hand side of the report.  Truly amazing the type of analytical Power View can enable.   We’ll have some other views coming out soon showcasing other great scenarios of government spend animated over time using Power View.  Should be a lot of fun.

pv03_thumb[1]

 

Should you have any questions in regards to using, upgrading and deploying Microsoft SQL Server 2012, please visit our SQL SQL 2012 Readiness page on our web site.

Enjoy

Patrick

SQL SQL 2012 Launch and Power View Samples–Corporate Dashboards

Patrick HustingLeave a comment

At Extended Results, we have always been at the forefront of Microsoft Business Intelligence products.  We have be a part of the many TAP and Beta programs around the business intelligence stacks within Microsoft.   We are excited about the launch of SQL 2012 and all the amazing new features that we can take advantage of for our customers.  One feature we would like to highlight is Power View and some of the amazing report writing capabilities you have in such a simple interface.

We recently completed a project for a customer who wanted to try some examples of their corporate reporting within Power View.  They we interested in the time to create a report “On-Demand” so that they could meet business reporting needs quickly.   We created several views for them in a few days.  The two examples below show a corporate dashboard and a second report that is interactive and using the PLAY functionality found in Power View.  Great layout and very interactive.  Very cool.

pv02   pv01

Should you have any questions in regards to using, upgrading and deploying Microsoft SQL Server 2012, please visit our SQL SQL 2012 Readiness page on our web site.

Enjoy

Patrick

WINNER! PowerPivot Data Mash-up Contest

Patrick Husting1 Comment

Aaron Meyers, BI Consultant here at Extended Results has placed 2nd in the PowerPivot Data Mash-up, earning him a total of $2,000. Not bad for only a couple hours of work!  We would like to congratulate him on his big win.  We are truly fortunate to have the best BI consultants on our team, and it sure feels good to be rewarded for all of that hard work at the end of the day.

Below is an example of Aaron’s dashboard.  As you can see, it combines crime, unemployment rates and education stats; and lets you effortlessly compare data by year, region and type.  You can even drill-down into one or more specific categories for a visual histogram analysis.  Very cool tool!  Great job, Aaron!

clip_image001[4]

Source:

http://apps.facebook.com/datamashup/default.aspx

Extended Results work in the #Microsoft BI Labs #powerpivot #excel

Patrick HustingLeave a comment

We built this Calendar Analytics solution for Microsoft several months ago.  Nice to see Microsoft marketing it as it has had thousands of downloads.  Works with Microsoft Exchange, Excel 2010 and PowerPivot.  If you haven’t tried it, click on over, download it and take it for a spin.   Amazing what you can do in Excel and you’ll become the hero in your company.

Source: http://www.microsoft.com/BI

image