Blog

Home - Page 3

Inzicht in je online Power BI omgeving

Prathy Kamasani heeft een bijzonder handige Power BI Template (=een rapport waarin je eigen data wordt weergegeven) gemaakt waarin allerlei zaken over je online Power BI-omgeving worden weergegeven. Denk aan zaken als de Power BI dashboards en rapporten die gebruikt worden binnen je organisatie, wie er administrator-rechten heeft, aantal verversingen (alleen interessant voor niet-SSAS-modellen), aantal mislukte verversingen […]

Read More

Een weekje Process Mining

Bij één van mijn klanten heb ik vorige week een succesvolle Proof-of-Value gedaan met Process Mining. Nu is Process Mining een aanpak en techniek waar je steeds vaker over hoort, dus wellicht tijd voor een klein overzicht – wat is het, wat kan het en waarom hebben we dat niet in de BI-stack zitten?

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 devenv.com. 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

A new role for the BI team?

This Christmas holiday, I read Alberto Cairo’s “the functional art” – a must-read if you’re interested in data visualization at any level. In the fourth part of the book he includes some interviews with leading people in the data visualization field. Especially in the interviews with Hannah Fairfield (at the time of the interview Graphics […]

Read More

Synchronizing SQL Server environments

When deploying changes through DTAP, you might need to sync your environments. For example, I sync my Acceptance environment before deploying a new increment, so I can easily see the effects of my new software on production data. To be honest, I’m not very good in these database management tasks[ref]I’ve worked once in an environment […]

Read More