When asked what content our blog readers and video viewers would like to see more of, the most requested topic is: „Industry Best Practices“. With that in mind we will be starting a series of Blog posts and Webinars by our MVPs highlighting work they have done. The first in this series is by Ike […]
There are a lot of discussions these days around Power BI tools to create reports and for sure many of you may have already downloaded and worked with some of them if not all of them. You may also already thought that some of the tools’ names are confusingly similar. I recently had an interesting…
One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I’m sure everyone agrees to some point that they do, but you do know just how much they matter, and why? Over the weekend, I received an email from one of our loyal…
Sehr gut, mit diesen Scripts lassen sich DateDim und TimeDim Entities leicht erstellen.
Besonders gut gefällt mir der Ansatz, das durch einen Scheduled Refresh im Dataflow das CurrentDate automatisch aktualisiert wird.
„Setting up a daily refresh schedule for this DataFlow will keep the flag values current, too (i.e. [Current Day?] and [Completed Day])“
The purpose of this article is to outline a set of guidelines and recommended practices for managing Microsoft Power BI projects. This guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Again, this guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Topics included in this guide: Solution Architecture Managing Power BI Desktop Files Datasets and Reports Version Control & Lifecycle Management Workspace and App Management Data Model and Power Query Design Guidelines Dimensional Design Query Optimization Managing Dataset Size with Parameters Implicit and Explicit Measures If Users Need Excel, Give them Excel Certified & Shared Datasets Enterprise Scale Options
I have been asked to produce a simple construction report, we need to show the last 4 weeks of actual progress data and 6 weeks of forecast and to make thing a little bit complex the average installation since the start of the project, nothing special three measures, average to date, install per week and […]