Power BI specialist in Rotterdam

Mostly on what sits beneath the report: which tables to connect from an ERP system, rostering system or patient record, where a measure such as occupancy or delivery reliability is calculated, and who can see what. That way, the same figure means the same thing everywhere. Whether you call them a Power BI specialist, Power BI consultant or Power BI expert makes no difference.

You can find our full approach, from the first model through to management, on the Power BI consultant page. If you want one of our colleagues to join your team temporarily, see Hire a BI consultant.

Yes. We carried out a data maturity assessment for Albert Schweitzer Ziekenhuis, which has a site in Dordwijk, Dordrecht. Our only office is in Amsterdam; we can come to you or meet online.

For organisations in the capital dealing with seasons, venues and ticket sales, we have a dedicated page: Power BI specialist Amsterdam.

A fresh perspective on what is already in place, and time to tackle work that has been left undone. Albert Schweitzer Ziekenhuis already had a Business Intelligence Center and a digital strategy, but lacked a clear picture of where it stood and what steps it needed to take. We mapped this out with a maturity assessment.

In Power BI, the work often involves a shared semantic model that supports multiple reports, and an established route from development through testing to production.

That depends on the capacity and storage mode. According to Microsoft, a model in Import mode on shared capacity can refresh on a schedule up to eight times a day; on Premium, Premium Per User or Fabric capacity, up to 48 times. A manual refresh using "Refresh now" does not count towards those eight.

If a warehouse planner needs to see what is happening now, you can use DirectQuery and automatic page refresh. On shared capacity, the shortest interval is 30 minutes. Change detection, which refreshes when a measure changes, works only on dedicated capacity.

With Microsoft Dynamics 365 Business Central, you make the data available through API pages or OData web services and load it into Power BI Desktop. For the online version, Microsoft also provides ready-made Power BI apps for areas such as finance, inventory and production.

If your ERP system runs on your own server, you need an on-premises data gateway for refreshes. Most of the time goes into determining which ERP table contains which information. Read more about data in manufacturing.

Every tenant has a home region: the Azure data centre selected when the tenant was created. You can find it in Power BI under Help, then "About", next to "Your data is stored in". Workspaces can also run on capacity in another region. According to Microsoft, the West Europe Azure region is in the Netherlands.

Decide which patient or employee data may be included in the model with your data protection officer beforehand. For management purposes, a count per department is usually enough.

Yes. You define a role with a DAX filter on the location, then assign the right people or Entra groups to that role in the Power BI service. Note that the filter applies only to people with the Viewer role. Workspace admins, members and contributors can see all rows.

For branch reports, use an app or a separate workspace where managers have read-only access.

When management has all it needs from what the ERP system or patient record already shows, and no department needs to compare figures from two systems. If you need a single standalone report, custom-built Power BI dashboards are a better fit: we start with the decision the report needs to support.

If your question is about forecasting, such as how busy tomorrow will be, a report is not enough. Read about the AI consultant in Rotterdam or our data science consultancy in Rotterdam.