Blog

I needed a place to express myself, share my discoveries and reach more people. Here you are!

Power BI – Your model matters

Power BI – Your model matters

I'm trying to address a crucial topic (to me), but more complex to communicate than a technical feature. DATA MODELING This article gives you some tips and may give you the urge to look differently at your data. If so, my bet will be won, and you may significantly...

read more
PIT Point In Time

PIT Point In Time

Introduction We often have descriptive data in our Power BI models. Data may vary over time and have validity dates. It can become a real headache when creating a data model. What kind of data? A car could change his production plant through time. A car can have...

read more
Pie Chart is bad!

Pie Chart is bad!

      During my presentation at Power Saturday in Paris, I wanted to demonstrate to an already very optimistic public that Power BI is a great tool and that modeling is a must-have for their reports. (Data Modelling is not the subject here) Power BI a super tool? Yes,...

read more
SSIS – Log Execution time

SSIS – Log Execution time

This query helps you to have a better view of your SSIS Packages executions. When you run a "master job / package", you don't clearly see the execution time for your child packages in SSISDB Reports. With this query, now it's possible 🙂 USE SSISDB GO SELECT...

read more
PowerBI – Bookmarks

PowerBI – Bookmarks

Bookmarks are not perfect, I can easily confirm you. But with them, you can build beautiful and rich reports. In this example, I will show you how your users can switch from one visual to another one.

read more
Power BI Desktop: Print in the A4 size

Power BI Desktop: Print in the A4 size

As you know, the August 2018 update of Power BI Desktop grants us the possibility to export in PDF directly from the Desktop. Two clicks and it's done. Great news right? I remember all the steps I had to go through to make it before, it still give me headache... But...

read more
SP_WHO3 – Running Queries (Toolbox)

SP_WHO3 – Running Queries (Toolbox)

Display all running queries Source:http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3 Code: SELECT SPID = er.session_id ,BlkBy = CASE WHEN lb.lead_blocker = 1 THEN -1 ELSE er.blocking_session_id END ,ElapsedMS = er.total_elapsed_time ,CPU = er.cpu_time...

read more
Learn DAX from examples: Lazy DAX

Learn DAX from examples: Lazy DAX

Concrete cases in DAX Working with Power BI (or SSAS Tabular) does not require much effort. It's quite intuitive and easy to set up. However, to fully enjoy it, it is recommended to take the time to learn DAX. Create a measure, in the formula bar, is done through an...

read more
Connect Excel To Power BI Desktop

Connect Excel To Power BI Desktop

You created your model with Power BI Desktop and you want to build and export some report with a classic Pivot Table in Excel. This video is for you. Bonus: Export the content of your Power BI File

read more

Pin It on Pinterest

Shares
Share This