Most Popular

The most viewed posts

Elephant-Carpaccio-for-Business-IntelligenceElephant-Carpaccio-for-Business-Intelligence

Elephant Carpaccio for Business Intelligence

Nope. This post is not about Hadoop. It’s about agile – about how I learned some of agile’s key principles and about how to apply agile to the work of Business Intelligence. In 2009 I attended an agile hands-on workshop… (READ MORE)

Business Intelligence, Most Popular

, , , , , , , , , , ,

SSRS-Review

SSRS Review

Microsoft SQL Server Reporting Services, the time-tested heavyweight is a low-cost solution but its mobile capabilities are lacking. I built a career around this tool, so here’s my long over-due honest review. The product has gone unchanged in the last… (READ MORE)

Business Intelligence, Most Popular

, , , , , , , , , ,

How-to-Solve-the-Wrong-Level-Of-Grain-Problem-in-SQL

How to Solve the “Wrong Level of Grain” Problem in SQL

In late 2007, two insurance industry collegues brought me into a problem they were having with an SSRS report which listed properties. They wanted to show a count of properties as well as note information for each property. Because each… (READ MORE)

Data Management, Most Popular

, , , , , , , , , , , , , , , , ,

Sql-Reporting-Services-To-Roambi

How to Refresh Roambi Reports With SSRS Subscriptions

SSRS is good with parameters, various data sources, subscriptions, and linked reports. But highly responsive and interactive reports (especially on a mobile device) is not what SQL Server Reporting Services is good at. The online BI tool, Roambi, however is… (READ MORE)

Business Intelligence, Most Popular

, , , , , , , , , , , , , ,

Creating-Value-in-Vendor-Negotiations

Creating Value in Vendor Negotiations

I traditionally considered negotiating as a somewhat selfish act with the simple goal of maximizing what I could get out of a deal while minimizing what the other party could get. This actually may be the best one can hope… (READ MORE)

Most Popular, Operations

, , , , , , , , , , , , ,

HIPAA -and-Amazon-AWS

HIPAA and Amazon AWS

What is HIPAA The Health Insurance Portability and Accountability Act of 1996 (HIPAA) is U.S. law which protects the privacy of individually identifiable health information. In particular, standards are set for the security of electronic protected health information (PHI). The… (READ MORE)

Cloud, Health Care, Most Popular

, , , , , , , , , , , , , ,

data-integration-sql-xml-cross-apply

Transformation Pattern with SQL, XML and CROSS APPLY

You don’t have to live with the repeated pain of transforming xml to rowset values when you need data from xml data stores. You also don’t need to transform and copy the data to relational database┬átables in MS SQL Server… (READ MORE)

Data Management, Most Popular

, , , , , , , , , , , , ,