Articles

LazyDAX V2: Learn DAX from examples

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

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

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

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

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!

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

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.