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)

SQL & Data

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

Operations-Management-Science-for-your-Company

Operations Management Science For Your Company

Your company could take quantum leaps toward its growth targets if some of the latest operations management science tools were brought in and applied. This does not mean a replacement of any current operations processes or personnel, but only the… (READ MORE)

Operations

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

Framework-for-Self-Service-Business-Intelligence

A Framework for Self-Service Business Intelligence

In the information age, competitive advantage comes from making business sense of vast amounts of data. Departments demand Business Intelligence for specific local needs that may not be offered by a central enterprise BI team. How do we begin to… (READ MORE)

Business Intelligence

, , , , , , ,

Query-On-Prem-Datasets-from-Power-BI-Cloud

Query On-Prem Datasets from the Power BI Cloud

Here are some notes for connecting Power BI to Analysis Services. Thanks to Microsoft for the helpful presentation on 3/4/2015. Cloud-based BI allows businesses to start doing BI quicker with little to no overhead. One obstacle has been negotiating the… (READ MORE)

Business Intelligence

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

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

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

Innovation-in-Healthcare-Increasing-Access

Innovation in Healthcare – Increasing Access

In Innovator’s Prescription, Clayton Christensen demonstrates how products and services evolve in a way that makes technology available to people. Granting access to technology to people who previously did not have access to it constitutes a disruption to traditional providers… (READ MORE)

Health Care

, , , , , , , , , ,

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)

Operations

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

Data-Analysis-Reduces-No-Shows

Making use of Data to Reduce No-shows in Healthcare

No where is a no-show as costly as it is in healthcare. Expensive resources sit idle. Most providers come up with innovative ways to fill the empty spots (calling people on a waiting list, overbooking in the first-place). Overbooking does… (READ MORE)

Health Care

, , , , , , , , , , ,

Technical and Business Acumen

Successful Projects Benefit from both Technical and Business Acumen

Often times, these skills belong respectively to software engineers or to project managers. You may have someone on a project that is able to negotiate both domains, or you may have teams of people working together which collectively provide skills… (READ MORE)

Operations

, , , , , , , , , ,

cabin2

One way to simplify code – “IsAppropriateFor”

I personally like to avoid unnecessary complexity. I love solving problems with simple, easy to read, code. Dr. Chris Dansie at the University of Utah’s department of Information Science likes to say that, “…when it comes to real-world software application… (READ MORE)

Software Dev

, , , , , , , ,