Blog

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

Power BI Visuals List: Which Graphic to choose?

Click on the image to show an example for each graphics available in Power BI You can also download the Lazy DAX file Here (Where all examples are available) Why this list? Today, I had some time to learn!I think I'm not that bad for data...

Power BI: Duplicate of Duplicate – The best way to test your reports and measures

This article seems obvious, but that's something that I do a lot, and this is the first thing I do when somebody asks me a question. After many weeks, some clients tell me: "Now, I'm using your technique too" But I don't feel to own this! It's pretty simple, but in...

DAX is case insensitive

This week with my colleague Vincent Philipot, we learned something that many of you already know. (But maybe not!) DAX is case insensitive!!Yes!! And nobody told me before! What does it mean? Here is a short description available on Wikipedia But because an example is...

Power BI Interview questions: a different way to know your applicants

One day you will have to recruit or will be involved in a recruitment process for a Power BI position. Nobody knows everything about a tool or a subject, that's also why our job is fun, we never stop to learn. Asking very precise questions aren't always the best...

Your data model first!

At this end of the year, I thought it’s time for me to bring you a gift!!It’s a very important subject that I mention to my coworkers and it’s 80% of a success power bi story! All the focus is on the tech part. All developers (yes, you are!!), spend a huge amount of...

Power BI Create a Calendar table automatically

In our models, the best way to deals with dates and DAX intelligence functions is to use a Calendar Table (Dimension). Good news, this table can be created in 2 clicks with Power Query (Transform Data) in Power BI! Go transform data and right click on Queries to...

LazyDAX v3

Yes! I changed my LazyDAX file! my motivation: Less is more!
Curious to learn DAX or want to discover some DAX functions? Then, give it a try!

How to stay always “Available” in Microsoft Teams with Excel

You want to always stay available in teams! You are scare to appear away because you are answering the phone or working on paper!! Excel is all you need!

How I optimized my learning time with Instapaper

I discovered a great tool to improve my learning and reading time. I try in this article to share with you my reading routine and more information on this tool.

LazyDAX V2: Learn DAX from examples

Download LazyDAX v2, it will help you to learn DAX from examples. It’s also a simple datamodel reusable for your tests and presentations.

Power BI Visuals List: Which Graphic to choose?

Power BI: Duplicate of Duplicate – The best way to test your reports and measures

DAX is case insensitive

Power BI Interview questions: a different way to know your applicants

Your data model first!

Power BI Create a Calendar table automatically

LazyDAX v3

Yes! I changed my LazyDAX file! my motivation: Less is more!
Curious to learn DAX or want to discover some DAX functions? Then, give it a try!

How to stay always “Available” in Microsoft Teams with Excel

You want to always stay available in teams! You are scare to appear away because you are answering the phone or working on paper!! Excel is all you need!

How I optimized my learning time with Instapaper

I discovered a great tool to improve my learning and reading time. I try in this article to share with you my reading routine and more information on this tool.

LazyDAX V2: Learn DAX from examples

Download LazyDAX v2, it will help you to learn DAX from examples. It’s also a simple datamodel reusable for your tests and presentations.

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...

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...

Management Studio – Faster with multiple select

In SQL Server Management Studio (SSMS for close friends) but also in a multitude of text editors (such as Notepad++ for example), you can make multiple selections. I thought it was something everyone knew, but I realize that I often look like a magician every time I...

SSIS – Create Environment from Packages variables

I created this script to automate some "not funny" tasks with our SSIS Catalog. If you have several SSIS projects configured in project mode (with a project.params file), when deploy them on your servers you unfortunately have to manually create the different...

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,...

SSMS – Query Shortcuts : Feel like a superman developer

SSMS Query ShortcutDear BI Developer, I’m pretty sure you would be happy to improve your productivity. If not, you should at least read this article to look like a superman (superwoman) developer.When I start a new mission, the first thing I do is to set up SSMS (SQL...

My discoveries: Useful links and articles regarding Microsoft Data Plaform

My discoveriesI always wanted to start a blog post with my discoveries on the internet. It’s often the case, and I hope you use it a lot, we are searching for information on a search engine. 2 months later (sometime less), we face the same issue! Excepted if you are...

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...

How to create a database in Azure

Look how it's easy to create a database in Azure! 3 Clicks, 5 minutes and you get a database

Power BI – PowerApps – Microsoft Flow: Do more with your data

Example in this tutorial: Analyse and pick up one of your clients, send him by mail to your account manager and ask them to take contact. (Power BI can do the job!)

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.

Docker: SQL Server 2019 Container

Azure Storage Explorer: Manage your Blob files

Azure File Storage – Share Drive

Azure Blob Storage and Power BI – Quick Tips

SSIS – Export SSIS Catalog Environments

You need to: Export your SSIS Environments (Variables)Replicate it on your new serverAssign these variables to your new project SSIS Catalog is not complex, but we don’t really want to spend our time to copy manually our configuration from one server to another...

Update Power BI Desktop : More information with less visuals ? Let’s use the Tooltip !

*This post is an update to the video about the Tooltip* It can be sometimes very difficult to put all the information we need in only one report page. Maybe I could remove this visual to add this one instead? But then, I won't have the figures for this year. Maybe...

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...

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...

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...