Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Images, charts, indicators and sparklines in a tablix stretch and degrade report performance

This fact is probably not documented very well but this is an important factor in SSRS visual report design… The use of rectangles is very much a core part of Reporting Services report design and a difference in behavior is expected.  Cells in a tablix will grow vertically to accommodate…

Read more

3 comments, 217 reads

Posted in SQL Server BI Blog on 26 September 2013

Showing a 100% Progress Gauge in Power View

What I’m going to show you is not rocket science.  This one gets filed under the category of “well, duh.  That was easy  …now that I see how to do it.” Power View sets the maximum value for a chart series based on the maximum unfiltered axis value; pretty simple…

Read more

0 comments, 237 reads

Posted in SQL Server BI Blog on 1 August 2013

DAX: Returning the Nth Selected Value in a Slicer

A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn’t solved before using a tabular model and DAX.  She had cost information for several hospitals in a PowerPivot model.  Using an Excel pivot table published to a SharePoint…

Read more

1 comments, 247 reads

Posted in SQL Server BI Blog on 13 July 2013

We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced

Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several new Business Intelligence tools available for preview; some only privately and some to the public.  The entire suite will soon be available for either public preview or release under the…

Read more

3 comments, 289 reads

Posted in SQL Server BI Blog on 9 July 2013

SQL Server Pro Article: Custom Programming to Enhance SSRS Reports

I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance SSRS Reports; How to write a custom assembly and use it to build a dynamic report dataset.  The article was posted online in April and featured in the July printed…

Read more

5 comments, 272 reads

Posted in SQL Server BI Blog on 2 July 2013

Book Review: Instant Creating Data Models with PowerPivot How-to

I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot How-to” by Leo Taehyung Lee, published by Packt Publishing. This is a short, concise book; only 46 pages long.  Quite honestly, if I had picked up this book for myself,…

Read more

0 comments, 232 reads

Posted in SQL Server BI Blog on 13 June 2013

Time to Complete the 2013 BI Survey

It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take the annual BI Survey!  The survey is an annual report conducted by Business Application Research Center (BARC), an independent software industry analyst, comparing the industry BI tools rated by thousands…

Read more

0 comments, 202 reads

Posted in SQL Server BI Blog on 10 June 2013

Taking the Tabular Journey

A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services. by Paul Turley This post will be unique in that it will be a living document that will be updated and expanded over time.  I will also post-as-I-go on the…

Read more

4 comments, 325 reads

Posted in SQL Server BI Blog on 2 June 2013

Mastering Reporting Services Expressions, March 26

As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using Expressions to enhance report capabilities.  The sessions are online with live chat from 11:00 to 4:30 Eastern Time. Register today to get in on the early-bird discount.  the cost for…

Read more

9 comments, 379 reads

Posted in SQL Server BI Blog on 15 March 2013

Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes

We can now use Visual Studio 2012 to create and edit SQL Server BI projects!  Woo Hoo. In the past, if you wanted to develop and maintain BI projects in the same development environment as other Visual Studio projects, you had to install multiple versions of Visual Studio.  This may…

Read more

1 comments, 387 reads

Posted in SQL Server BI Blog on 8 March 2013

SQL Server Community World Tour with GeoFlow

When I started playing with GeoFlow, I just had to find a way to do something interesting with it.  This is a short world tour with visits to a few SQL Server community members and leaders around the globe talking about their SQL Server communities.  GeoFlow is a new BI…

Read more

13 comments, 334 reads

Posted in SQL Server BI Blog on 6 March 2013

Speaking at the Business Analytics Conference, April 1-12 in Chicago

The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please do not share your schedule until that time.”  Well, what does that mean, exactly?  It means that it’s midnight right now and time to tell the world….  We are going…

Read more

0 comments, 328 reads

Posted in SQL Server BI Blog on 6 February 2013

Database Lifecycle Management for Azure SQL Database

DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created a few databases and then quickly left it behind but in the last few months I’ve found some really good uses for “Microsoft Windows Azure SQL Database”.  I just wish…

Read more

2 comments, 598 reads

Posted in SQL Server BI Blog on 1 February 2013

Reporting Services 2012 BI Training

Just wanted to get the word out that our SSRS 2012 training course is available.  Are you looking for expert training on SQL Server 2012 Reporting Services?  SolidQ now offers a SSRS training course with focus on designing report solutions for  Business Intelligence and SharePoint integration.  Not using SharePoint?  Private…

Read more

4 comments, 965 reads

Posted in SQL Server BI Blog on 10 December 2012

Is Self-service BI Threatening IT Professionals’ Livelihoods?

(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is little doubt that the movement toward self-service BI is going to change the climate for some IT professional who specialize in BI – but the question is “how?” and “how…

Read more

0 comments, 530 reads

Posted in SQL Server BI Blog on 9 December 2012

Debugging Parameter Dependencies in Reporting Services

Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value expression for the query parameter ‘DatesYear’ contains an error: The expression references the parameter ‘DatesYear’, which does not exist in the Parameters collection. Letters in the names of parameters must…

Read more

2 comments, 1,521 reads

Posted in SQL Server BI Blog on 7 December 2012

Power View and Reporting Services

There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting tools.  This is becoming a very popular topic and I thought I’d post my reply to that thread here.  I encourage you to  read the entire post on…

Read more

0 comments, 464 reads

Posted in SQL Server BI Blog on 3 December 2012

Is PowerPivot the Next Access?

I’m impressed with the current generation of semantic modeling technology from Microsoft.  I’ve had the opportunity to use both PowerPivot and SSAS Tabular Models on a handful of client projects and have had very good results so far.  The xVelocity in-memory aggregation and data compression engine seems to be everything…

Read more

2 comments, 2,945 reads

Posted in SQL Server BI Blog on 28 October 2012

Office 2013 BI and Mobility

I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about Power View and PowerPivot.  I’ve posted the presentation online and it’s ready for viewing here: Power View and PowerPivot – High-octane Self-service Reporting. (this presentation is the shell slide for…

Read more

1 comments, 444 reads

Posted in SQL Server BI Blog on 15 October 2012

The State of Microsoft Self-Service Reporting

(article published on the MVP Award Program Blog) I really enjoy this topic.  One of the reasons, I suppose, it’s such a hot topic is that a lot of people believe that there is a perfect ad hoc reporting solution out there, just barely beyond the current set of capabilities…

Read more

4 comments, 2,163 reads

Posted in SQL Server BI Blog on 25 September 2012

Older posts