During SSAS development, there are often times when you need to process a subset of objects (ex. dimensions, measure groups, partitions, etc) in a SSAS database. This is especially true when you’re working with a … Continue reading Process Multiple SSAS Objects Simultaneously via SSMS
BISM Tabular – Proceed with Caution
This year I’ve given a few presentations on a topic near and dear to my heart. The presentation is titled 20 Minute Tabular Model and one of the major components of the presentation involves a … Continue reading BISM Tabular – Proceed with Caution
Creating a Pareto Chart in SSRS
Recently, I created an SSRS report which used pareto charts to help a client analyze the impact of unplanned events in their production facilities across multiple dimensions (ex. Location, Equipment, Reason Code etc). In this … Continue reading Creating a Pareto Chart in SSRS
Pareto Analysis
Pareto Analysis is a nice technique for exploring the distribution of a measure across its contributors. Regardless of whether the measure is positive (ex. sales amount) or negative (ex. production defects) the goal is the same. In … Continue reading Pareto Analysis
Come see me present!
Here’s a just a quick update on a few speaking engagements lined up for the near future: SQL Saturday – Charlotte BI Edition (10/19/2013) Right on the heels of PASS Summit 2013, this SQL Saturday … Continue reading Come see me present!
Great Demo of Power BI’s Q&A Feature
This is probably the best demo I’ve seen covering the new Q&A feature for Power BI: The guy asking questions, Mark Reguera, was a non-technical finance guy @ Microsoft who started using PowerPivot/PowerView within his … Continue reading Great Demo of Power BI’s Q&A Feature