Much like the pieces on a chess board – to the novice, they represent individual units with different capabilities. Over time (or so I’m told) as experience is gained through tournaments and deliberate practice, the view of the novice expands to the point where the student stops seeing “individual pieces” and starts seeing “setups & […]
Tag: Power BI
Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user groups… Baltimore SQL Server Users Group April 20, 2020 | Details Atlanta BI SQL Server Users Group May 4, 2020 | Details …if you […]
Free Tableau to Power BI Conversion

Earlier this week, Gartner released the 2020 Magic Quadrant for Analytics and BI Platforms and (unsurprisingly) Microsoft dominated the competition. This also marks the 13th year, Microsoft has been positioned in the leaders quadrant (upper-right). To celebrate the win and continued dominance in this space, I’m giving away a some free consulting dollars (up to […]
New Features Coming to Power BI in 2020
In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosystem currently includes several different products that work reasonably well together and enable “users and organizations to analyze, act, and automate on […]
This is a question that has come up a few times over the past few months from several clients and so I figured it’d make a good quick blog post that can easily be pointed at to save time. I encourage you to make it to the end of this short post to find out […]
This blog has been very silent over the past few months as all of my attention and free time was spent working with a small startup focused on delivering a commercial solution based on Power BI. I’ll probably share more details down the road, but suffice it to say, it was an amazing experience and […]
Quick post today showing how to programmatically deploy a Power BI report to an PBI On-Premise Report Server. Over the past few years, I’ve had the pleasure of helping a client build a business-user-driven fully automated analytics solution involving SQL Server, Tabular, and now Power BI. The solution starts with a business analyst logging into […]
Ever looked at a Power BI report visual and wondered what the logic was behind a calculation? In most cases, your options are limited to… asking the report author checking the report documentation checking the data dictionary …all of which… assuming they even exist! …severely disrupt the analytical workflow. In this post, we’ll see a […]
When I’m managing an Analysis Services environment, I’m not just interested in the performance of the workload… yeah that’s important, but I’m also interested in the users who are generating that workload… especially the top users… and here’s why: These top users are your biggest customers. They’ve already bought-in to the product/solution and you should […]
Perhaps one of the most important lessons I’ve learned over the years is that there’s no right-way / one-size-fits-all approach to implementing an Analysis Services solution. All have their pros and cons and being successful is more about leveraging the approach that best fits the client organization. That said, one approach that has proven successful […]