I Made My Filters Disappear!
Did you know that you can make your Power BI filter pane disappear? With the PowerPoint add-in for PowerBI this is quite easy to do, just look in the demo below!
Power BI Multiple Audiences management through Azure Data Factory and Active Directory
Power BI Multiple Audiences were released a few months ago and gave the opportunity to have one Power BI app with content dependent on the user. Before this you had to create multiple app workspaces and apps if different user groups need different reports, but now you can one app/app workspace for a subject are […]
Data Driven Disease Damage Control – Speaking at Pass Data Community Summit
Next week I will return to Seattle and the Pass Data Community Summit, and return to the stage to present a session on how we at NHO, the Confederation of Norwegian Enterprises, worked with data during the Covid pandemic. This have been a lot of work and is why my blog have been inactive for […]
A scalable solution for Datawrapper vizualisations with Data Factory and Databricks
During the Covid pandemic we at NHO (The Confederation of Norwegian Enterprise) have performed surveys with our members, which are Norwegian enterprises. We have asked them how business is going, if they fear bankruptcy, how the income is, and how they look at the next months going forward. Media and others have wanted this data […]
Setting up Azure DevOps for your Data Factory – Part 3/3 – Create release pipeline
Now we have set up our environments and we have developed something that we want to release to test. This final post describes how to do that, and a few useful tips as well. Release processThe release process will have these steps;1. Stop any active triggers. We do not want any pipelines to start as […]
Setting up Azure DevOps for your Data Factory – Part 2/3 – Develop something
This is the second post in how to set up Azure DevOps for your and shows how you should do development. For this example we will do the simple task of copying some data from a public data source into Azure Data Lake Storage Gen2. If you have not done so, read my post on […]
Setting up Azure DevOps for your Data Factory – Part 1/3 – Create Environemnts
We recently set up Azure Devops for deploying Data Factory, and I though I’d share some practical tips for how to do this. There are some great other resources out there for this, but I’ll try to put it all together for you here, and add a few bits I have found myself. This post […]
Posting to Workplace from Azure Data Factory
We recently started using Workplace (by Facebook) at work, so I wanted to check if I can add some data from our data warehouse as posts in groups. This turned out to be very easy, but worth a post. To set it up you go into workplace and settings for the group you want to […]
Comparing Databricks, Mapping Data Flows and SSIS as data transformation in ADF
I presented a session on SQLSaturday Oslo last weekend and can share some of the key takeaways here. This is by no means a complete comparison of every feature of these techniques, but show some of the strengths and weaknesses and can be a start when considering what tech to use in your Azure Data […]
From Excel to real-time Power BI with PowerApps!
At work we have a weight loss competition that was in full progress when I started there in June. After the summer vacation it’s time to start thinking about beach body 2020 and start again, but we received some scrutiny in the BI department that this was shown on a TV screen as an Excel […]