Home - Archive by category: SSAS

The DAX Guide

Wanneer je al langer met DAX werkt in bijvoorbeeld SSAS Tabular of Power BI, dan weet je dat de offici√ęle documentatie prima is voor naslag. Wanneer je echter tegen hele praktische problemen aanloopt, kom je over het algemeen uit bij SQLBI (Marco Russo en Alberto Ferrari) of Chris Webb. Medio 2018 heeft SQLBI een nieuw[...]
Read More

Hernoemen van velden in SSAS

Zul je altijd zien: Je kubus is net in gebruik genomen. De eerste rapporten zijn er tegenaan gebouwd. Op dat moment blijkt de naamgeving toch niet 100% te kloppen. Hoe voorkom je dat alle bestaande rapportages nu breken, maar je wel flexibel bent in het wijzigen van namen van measures en kolommen / attributen?
Read More

Setting up DWH Test Automation: Design & Arch

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?
Read More

3 Important Lessons about Test Automation in Business Intelligence

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[...]
Read More

VSTS Continuous MSBuild for DWH / BI

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 Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly[ref]There’s also some mentions about SSDT 2015 projects not being supported,[...]
Read More

VSTS Continuous Build for DWH / BI

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[...]
Read More

Automated Deployments using Visual Studio

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[...]
Read More

Automated Testing for the Data Warehouse

Case: we’ve integrated two sources of customers. We want to add a third source. Q: How do we¬†at the same time¬†know that our¬†current integration and solutions will continue to work while at the same time¬†integrating the new sources? A:¬†Test it. Q: How do we get faster deployments and more stability? A: Automate the tests, so[...]
Read More

Moving BI to the cloud: Consider this…

While looking into the possibilities of moving my customer’s BI infrastructure into the cloud, my primary question was how to handle the lack of cloud SSAS. But there’s a lot more to keep in mind. Here’s a few things that I think should be thought of from an architectural point of view: not only in[...]
Read More

Moving BI to the Cloud: Ditch SSAS?

Some time ago I read Chris Webb blogged “Thoughts On The Power BI Announcements At The MS Data Insights Summit“, where between the lines was this rather interesting point: For the last few years my customers have asked me when MS was going to release SSAS in the cloud and I‚Äôve always replied that Power[...]
Read More

Latest Posts