Learn how to create a calendar or date reference for your data and organize it by building a DAX date table in Power BI.
Since this post primarily concerns a Dutch data source, the rest of this post will be in Dutch. English summary below.
De open data die het Centraal Bureau voor de Statistiek (CBS) via Statline (http://statline.cbs.nl) aanlevert is van onschatbare waarde voor analisten. Over diverse thema’s wordt informatie gepubliceerd, zoals woning, demografie, inkomen en arbeid
I’ve blogged a few times about the tracing functionality that is built into Power Query/Get&Transform and Power BI (see here and here). The trace files themselves clearly contain a lot of interesting information, but there’s no official documentation about what they contain and the format seems to have changed several times.
Do you want to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis, produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Well, then you can use the Power BI suite of business analytics tools that deliver insights throughout your organization.
Microsoft Power BI is a powerful tool that allows users to pull real time data directly from Microsoft Dynamics NAV and other sources for analysis and reporting. Included in the analyzation options are two map visualizations that show data by location. These maps are an impactful and creative way to display data. However, sometimes it can be frustrating trying to navigate the map visualizations recognizing your data.
Microsoft Power BI is an amazing tool. It allows me to build reports that update with real-time information from our ERP system, Microsoft Dynamics NAV, so that all of our team members can access information about financials, projects, cash flow, and various statistics in one click. However, Power BI is anything but perfect, especially when it comes to formatting.