SSRS – Report Execution Analysis

A little while ago, I made a report to analyze the usage of SSRS report (users and rendering times).

Here’s how it works:
The vertical axis displays the total number of report executions, while the size (and (x) number) displays the total number of unique users.
And not to forget, color of the balloons is based on the average rendering time of that specific report.


Report Execution Analyses explanation

It is pretty straight forward on how to implement it.

Download
Download the SQL Stored Procedures and SSRS report RDL-file here:
ReportExecutionAnalysis.zip





Other reports
Have a look at other reports I’ve published for my readers:

SQL Agent Job Schedule Timeline report

sql-agent-job-schedule-timeline-report



SQL Agent Job Status report

sql-agent-jobs-report








Advertisements

Gartner’s Magic Quadrant for Advanced Analytics Platforms 2014

Gartner’s Magic Quadrant for Advanced Analytics Platforms 2014

Predictive analytics and other categories of advanced analytics are becoming a major factor in the analytics market. We evaluate the leading providers of advanced analytics platforms that are used to build solutions from scratch.

It’s such a pivotal moment for data scientists and the growing open-source R community that Gartner has embarked on its first ever Magic Quadrant for Advanced Analytics Platforms. Gartner estimates advanced analytics to be a $2 billion market that spans a broad array of industries globally, and ‘Gartner predicts business intelligence and analytics will remain top focus for CIOs Through 2017.’ We believe that this new Magic Quadrant puts a spotlight on big data as the great analytics disruptor which we feel highlights the need for solutions like Revolution Analytics’ that are built upon a flexible, open platform, and designed for today’s Big Data Big Analytics challenges.” — Dave Rich


Magic Quadrant for Advanced Analytics Platforms 2014








Gartner’s Magic Quadrant for Business Intelligence and Analytics Platforms 2014

Gartner’s Magic Quadrant for Business Intelligence and Analytics Platforms 2014

Microsoft offers a competitive and expanding set of BI and analytics capabilities, packaging and pricing that appeal to Microsoft developers, independent distributors and now to business users. It does so through a combination of enhanced BI and data discovery capabilities in Office (Excel) 2013, data management capabilities in SQL Server, and collaboration, content, and user and usage management capabilities in SharePoint.



Magic Quadrant for Business Intelligence and Analytics Platforms 2014


More info:
Gartner’s Magic Quadrant for Business Intelligence and Analytics Platforms 2014

Gartner’s Magic Quadrant for BI Platforms 2013







Yahoo! 24TB SSAS Cube – Big Data Case Study + Slides

Thanks Denny Glee for sharing this.

It’s old news, but still it’s very cool 🙂
I always thought that Yahoo! had a 7TB SSAS Cube, but it has been growing of course.
As of dec 2012, it reached 24TB!!

Microsoft Case Study:
Yahoo! Improves Campaign Effectiveness, Boosts Ad Revenue with Big Data Solution

Some key numbers from this case study include:

24TB Analysis Services MOLAP cube
2PB source data of a 14PB Hadoop cluster
700M unique users, 47% of the global online population
3.5B ad impressions/day

Yahoo-24TB-Cube-Platform-Architecture

Yahoo-24TB-Cube-Querying-the-Platform-Architecture

More slides can be found here.

Source:
http://dennyglee.com/2012/12/08/yahoo-24tb-ssas-big-data-case-study-slides/








Power Map is released (Office 2013 SP1)!

As of yesterday, Power Map was released as part of Office 2013 SP1.

Power Map for Excel - Office 2013 SP1



More info about the announcement:
Power Map for Excel Now Generally Available, Automatically Updated for Office 365

Announcing the release of Service Pack 1 for Office 2013 and SharePoint 2013





Important:
(thanks Chris Webb for the headsup!)

One important point to note here is that Power Map will only be available to Office 365 customers. If you have a standalone version of Excel, or have a regular (ie not Office 365) Professional Plus license, you will no longer be able to use Power Map. See:

http://office.microsoft.com/en-us/excel-help/power-map-for-excel-HA104204034.aspx?redir=0

Power Map for Excel New!

If you have a subscription for Microsoft Office 365 ProPlus, Office 365 Midsize Business, or for the Office 365 Enterprise E3 or E4 plans, you’ll have access to Power Map as part of the self-service business intelligence tools. To determine which subscription you have, see Office 365 ProPlus and Compare All Office 365 for Business Plans.

If you have Office 2013 Professional Plus or a standalone version of Excel 2013, you’ll be able to download and use the Power Map Preview for Excel 2013 until May 30, 2014. After that date, the preview will no longer work in any non-Office 365 subscription version of Excel.

To learn more about Power Map, see Get started with Power Map.



Join us at LinkedIn!
Don’t forget to join the ‘Microsoft Power BI‘ group on LinkedIn and stay updated!:
linkedin-microsoft-power-bi-group








Power BI (Office 365) pricing has been announced

Many thanks to SQL Chick (Melissa Coates) for the news!

The features you have end up being the same (more on that below). The differences shown below are only related to what prerequisites you already have in order to determine pricing.

Power-BI-Pricing-without-E3-E4

Pricing for the E3/E4 plans is shown in the next screen shot. The importance of E3/E4 is that they come with Office 2013 Professional Plus and SharePoint Online (SPO) Plan 2 – both of which are important prerequisites for Power BI features and functionality.

Office-365-E3-E4-Pricing

Let’s say you are an E3 subscriber at $20/month. Add the $20/month special offer price for Power BI and it’s a total of $40/month per user. That’s much better pricing than the $52 shown in the far right hand column of the pricing chart. Hmmm…sounds like a price break to entice more customers to the Enterprise Office 365 plans.

Good tip! 🙂



Join us at LinkedIn!
Don’t forget to join the ‘Microsoft Power BI‘ group on LinkedIn and stay updated!:
linkedin-microsoft-power-bi-group








SQL Server Data Tools (SSDT) Project Templates – Visual Studio 2012 (BI)

Thanks to the Dutch Data Dude

If you installed SQL 2012 you have probably noticed that you development environment for Integration Services, Analysis Services and Reporting Services is still hosted in a Visual Studio 2010 shell (SQL Server Data Tools). However, with a free download you can get the Microsoft Business Intelligence Project Templates for SSIS, SSAS and SSRS in your Visual Studio 2012 installation. All you need to do is to download and install it.

Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012