Author Archive: Daniel Acevedo

I have been in Information Technology for 20 years. I have done front-end, middle-tier, and database design and coding as well as project management. In recent years, I dedicated myself to customer, partner, and vendor integrations in service industries. I am currently focused on Business Intelligence for a great medical devices manufacturer. You'll see posts about OOD, coding design patterns, Cloud Implementations, Advanced SQL strategies, Business Intelligence (BI), Agile practices, and IT management strategies. Please know that, although the content on this site draws from my professional experience, none of the content in this site reveals any information about current or past clients or employers. Here is something I really care about in my profession: building communication channels and trust across functions and organizations to get things done. That is a theme that you'll see throughout my posts as well.


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

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)


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


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 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

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


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

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

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)


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


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)


, , , , , , , , , ,


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

, , , , , , , ,