Categories
DAX Power BI

The Ultimate Time-Intelligence Pattern

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 & […]

Categories
Uncategorized

Power BI Time-Intelligence: Beyond the Basics

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 […]

Categories
Power BI

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 […]

Categories
Power BI

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 […]

Categories
Speaking

SQL Saturday Baton Rouge

As mentioned a few weeks back, I’m hitting the SQL PASS speaking circuit hard this year and the next stop is the inaugural SQL Saturday Baton Rouge on March 7, 2020 where I’ll be delivering a new session on Power BI Time-Intelligence that’s certain to make you exercise those DAX muscles! Power BI Time Intelligence […]

Categories
Uncategorized

DAX Variables and IF/SWITCH Statements

Earlier this week, a client came to me with a DAX error that I’d not seen before… Query (12, 4) Calculation error in measure <insert measure name>: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column. After reviewing their code and […]

Categories
Uncategorized

Do all visuals on a Power BI report generate queries?

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 […]

Categories
Uncategorized

IDERA ACE – Class of 2020!

Just a few weeks ago, I was accepted into the IDERA ACE program class of 2020! Oh, never heard of it? Well, let me clue you in… IDERA ACEs are active community members who have shown a passion for helping the community and sharing their knowledge. Members are selected annually and are up-and-coming data professionals […]

Categories
Uncategorized

A Few Thoughts on Power BI and the Future

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 […]

Categories
Uncategorized

Programmatically Deploy Power BI Reports to Power BI Report Server

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 […]