Microsoft Power BI – Get Yourself a Measures Table

As a manager of an infrastructure mainly based in Power BI, there are a few improvements that I would like to see in the tool in the future. This is my first post about it and I’ll start with the one that I think is the easiest to implement and would have a major impact […]

Check your Power BI Data

One of the biggest challenges there is while handling with a Power BI dataset is to monitor the quality of the data published for analysis. This post aims to teach a way to understand which data is available in the service and its quality. Monitoring it’s one of my golden rules to have an amazing […]

Data Warehouse Design

Recently I’ve been thinking about my concepts of data warehouse design and if they still make sense for the market. A few months ago, I wrote some rules about what I think constitutes a good data warehouse, check them below. DATA WAREHOUSE GOAL In my opinion, all data warehouses are built to address a simple […]

Will SSIS die?

Well, this is a hard question and, in my opinion, SSIS seems that is going that way. At least the current experience it provides will definitely die and let me explain why.

One more data layer please

During my career, there is one thing that always kept my attention. I saw so many very different data environments.

Goodbye SSAS Multidimensional

With the release of the SSAS Tabular version, Microsoft started the retirement process of the good old SSAS Multidimensional.

Power Tools for Power Work

As a BI professional, I have a set of tools that I require to have installed on my computer in order to do my work properly. It can be mandatory tools because I work with Microsoft BI stack or others because I feel they are really useful for some specific task while developing, debugging or visualizing data.

6 Rules for an amazing Data Warehouse

During my career, for several times I had the chance to either build a new Data Warehouse for a company or to work with their existing one. Because of that, I understand what should be taken into consideration when people take care of their Data Warehouse and I wrote my 6 golden rules for a great environment.

Power journey

This is a recognition post to Microsoft and a thank you because finally provided Microsoft Business Intelligence Professionals with the right tools to actually do our work.

Flávio Fernandes