Power BI specialist Amsterdam

They build the layer between your data sources and the report everyone opens: how the tables relate, where revenue and occupancy rates are calculated, and who can see what. Whether you call them a Power BI specialist, Power BI consultant or Power BI expert, the work is the same.

For a cultural organisation, performances, venues, sales channels and seasons are the building blocks of that model. To see how we set up Power BI across sectors, from data model to management, read about our Power BI consultancy.

Organisations receiving a four-year grant under Amsterdam’s Kunstenplan 2025-2028 must, under the rules of the Amsterdams Fonds voor de Kunst, report each year on the previous calendar year. This includes annual accounts and a board report. Many organisations, however, plan their programmes and ticket sales by season.

Microsoft states that a date table must cover complete years, but those years do not have to be calendar years. Add a season column alongside the calendar year and you can report on both from the same model. For more on data in the sector, read about data and AI for the cultural sector.

By giving the date two roles. Microsoft calls this a role-playing dimension: a dimension that filters the same facts in different ways, such as by order date, shipping date or delivery date. Only one relationship between two tables can be active in Power BI. That is why you often create a separate date table for each role, using Power Query or a calculated table in DAX.

For a venue, those roles are the sale date and the performance date. You can then see how sales for a concert built up in the preceding period and compare them with the same performance in a previous season.

Yes. According to the Azure Databricks documentation, you can connect Power BI Desktop to clusters and Databricks SQL warehouses, and publish data from Azure Databricks to the Power BI service.

If you want to refresh the semantic model when processing on the platform is complete, you can use a Power BI task in a Databricks job. First, you create a Power BI connection in Unity Catalog. The platform we built for the Koninklijk Concertgebouworkest runs on Databricks and Azure, with Delta Lake, Unity Catalog and dbt.

You can use an on-premises data gateway: Windows software installed locally that connects the Power BI service to sources on your own network. The gateway uses outbound connections, so you do not need to open inbound ports.

You do not need to reload ticket sales from previous seasons with every refresh. With incremental refresh, Power BI divides the table into partitions and refreshes only the recent period; the historical data stays in place. This also works with a Pro licence.

Yes, using row-level security in the semantic model. A role is given a DAX filter, for example to show only performances in its own venue, and you assign people or groups from Microsoft Entra ID to that role in the Power BI service. The filter only applies to the Viewer role; a workspace admin, member or contributor can see everything.

You decide which data about individual ticket buyers belongs in a report with your privacy officer. A count per performance is often enough.

Yes. Data Science Lab has its office on Westerdoksdijk in Amsterdam. We can have an initial conversation at your office, at ours or online.

If you are looking for someone to work alongside your team on reports and models for a period, read about hiring a BI consultant. If you want a completed report delivered as a project, we can discuss that in the initial conversation.

When the standard report from your ticketing system already provides what the management team needs, and nobody combines those figures with other sources. If the problem lies with definitions or ownership, a new report will do little to help: start with data governance instead.

If you want a single, clearly defined report delivered, read how we build Power BI dashboards around the decision they need to support.