When you start a new Power BI report, you may run into some options that might confuse you. Maybe you already know what they are, but you don't really know when to use what? This is the blog post for you 🙂 Import This option loads all the data into the Power BI report. This
Continue reading...
SSAS
Organizations that start with Power BI often ask me "Jesse, how do you go about development, test and production environments when using Power BI?". I have decided to write about my experiences - I have been implementing Power BI since the beginning of the product - and share you my ideas. The reason why this
Continue reading...
In Microsoft BI, a tabular model is often the way to go. OLAP gets more and more often replaced by Tabular cubes and Power BI models. However, it's really hard to create a model that covers the whole enterprise. In this post I propose a solution for doing just that in a simple way. In
Continue reading...
Tonight I presented a 1-hour session about applying Continuous Integration at the Microsoft Advanced Analytics User Group Belgium. The session was an "espresso version" from the 2-day course, skipping things like Git, setting up VSTS build environments etc. Great fun to be here, thanks for the invite! The slides can be found at https://bit.ly/2LMlQ6v. Want
Continue reading...
If you want to set up Continuous Integration using Visual Studio Team Services (VSTS) in order to build your BI projects, you'll run into the fact that some project types can be built and released out-of-the-box by MSBuild, while others need specific logic to create or deploy artifacts. In this post, I share my current
Continue reading...
With Continuous Integration working for my Data Warehousing solution (SQL Server, SSAS Tabular, SSIS), it's time to step forward. Before moving to Continuous Deployment, I want to have a rigorous and automated testing on my EDW. But how to get there?
Continue reading...
As you might know, I'm keeping an eye on how I can automate my Data Warehousing testing. In "Automated Testing for the Data Warehouse" my observation was In essence, testing a Data Warehouse isn't that complex It turns out I'm not the only one thinking about this (really? 😉 ). Some time ago I listened to
Continue reading...
Wait, didn't I post this already several weeks ago? Well, almost. A few weeks ago, I showed how to set up a build agent using devenv.com. Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly. However, it turns out to be pretty easy to build
Continue reading...
In my earlier post "Automated Deployments using Visual Studio" I metioned that the method described was a workaround because I hadn't figured out how to do a continuous build in VSTS (Visual Studio Team Services) yet. With hindsight, that workaround was not really needed: VSTS build turns out to be só easy, that it's ridiculous
Continue reading...
In my earlier post "Automated Testing for the Data Warehouse", I sketched the outlines of what would be needed in order to achieve automated testing for your Data Warehouse solutions. Today, I want to look at the first step: build & deploy. Between the previous post and the current one, some useful content about this has been written already
Continue reading...