Image for post
Image for post
Photo by Chang Duong on Unsplash

This is the fourth article of the series: DAX Series — Learn the core of Power BI
4. Iterators and Aggregators

In the end of this article I have a link to my GitHub where you can find one empty Power BI Model and one full model with the measures and similar I have used in this article.

In this article I will describe what Iterators and Aggregators are in DAX. When should you use each and what is the theory behind these?

You can also find the story here:
https://eliasnordlinder.com/certifications/f/dax-series-4-iterators-and-aggregators

What are Iterators and Aggregators?

Aggregators are functions that aggregate values of a column…


Image for post
Image for post
Photo by Aaron Burden on Unsplash

Last summer I wrote an article with tips about passing the Tableau Certification exams, which was well received in the medium sphere. The article was regarding resources, study plans and how to think about the exam on both the exam day and the day before.

As I took the DA-100 exam for Microsoft Power BI a couple of months later I will write a similar article here, but aimed towards the DA-100 certification and Power BI.

(You can find both of these articles on my website eliasnordlinder.com)

My aim with this article is to help the people pass the DA-100…


Image for post
Image for post

This is the third article of the series: DAX Series — Learn the core of Power BI
3. Measures vs Calculated Columns

In the end of this article I have a link to my GitHub where you can find one empty Power BI Model and one full model with the calculation that I have done in this article.

In this article I will describe in detail the difference between Measures and Calculated Columns in DAX. I will describe in which use cases each of these can be used and common pitfalls.

You can also find the story here:
https://eliasnordlinder.com/power-bi/f/dax-series-3-measures-vs-calculated-columns-in-dax

What are Calculated Columns?

I…


This is the second article of the series: DAX Series — Learn the core of Power BI. 2. Resources/Learning Techniques while learning DAX.

Image for post
Image for post

In this article I will give out different resources and learning techniques while learning the DAX language. This will be a list of resources I would like to have when I began to learn DAX and describe the language in a good way.
It is a mix of blogs, Youtube-channels and books.

You can also find the story here:
https://eliasnordlinder.com/power-bi/f/dax-series-2-resourceslearning-techniques-while-learning-dax

Learning Techniques for learning DAX

It is important to acknowledge that people approach new things in different ways.

Some people like to…


Image for post
Image for post

This is the first article of the series: DAX Series — Learn the core of Power BI
1. What is the DAX Language?

As I promised I will post two articles every week about different aspects of the DAX language. One article in the middle of the week and one in the end of the week.

In the end of this article I have a link to my GitHub where you can find one empty Power BI Model and one full model with the measures and similar I have used in this article.

In this article I will describe what…


20-part blog series about figuring out the DAX language

Image for post
Image for post
Photo by Karla Hernandez on Unsplash

(As I am switching towards more focus on Tableau and Alteryx in my job life at the moment, I will put this series on halt for a while. I will take it up later when Power BI will be more of my daily work again.)

What is this series about and who is it for?

During the next-coming months I will post at least two articles every week for a new DAX-series that I will make. One article will come out around the middle of the week and the second one by the end of the week

The purpose of this…


Image for post
Image for post
Photo by GEORGE DESIPRIS on Unsplash

In this article I will give an introduction to what Common Table Expressions (CTE) are in the SQL Language. I will give some examples on how to use them, and thy they will help you in your SQL journey.

(You can also find this story at my web page eliasnordlinder.com, where I also post many other blog posts about Business Intelligence)

I have a previous Python Background before moving into SQL, and one Best Practice in Python is to conduct Modular Programming. I think that most people that have done some kind of programming know what Modular Programming is.

Modular…


Image for post
Image for post
Photo by Sebastian Staines on Unsplash

In this article I will explain what Window functions are.
I will first write a short introduction of Window Function, when they were introduced into SQL Server and their overall use cases. After this I will go into a sample of real life scenarios when they are really helpful.

(You can also find this story at my web page eliasnordlinder.com, where I also post many other articles about Business Intelligence)

Window Functions, Background and Timeline

Windows functions were introduced in in SQL Server in 2005. In the beginning they could be aggregated, but no Window frame could be specified.

In 2012 a big step were…


Image for post
Image for post

In this article I will first give a short introduction of what Tabular Editor is and why I think that it is a very important tool in Power BI. After that I will go through five use cases where Tabular editor will help you achieve things quicker and more effective than if you were only using Power BI.

(You can also find this story at my web page eliasnordlinder.com, where I also post many other articles about Business Intelligence)

What is Tabular Editor?


Image for post
Image for post
Photo by Green Chameleon on Unsplash

Last week I passed my Tableau Desktop Certified Associate Specialist Exams. I hope that I can give some tips back to the community. I got a lot of help from free online resources for my exams which I would like to give the same.

(You can also find this story at my web page eliasnordlinder.com, where I also post many other blog posts about Business Intelligence)

First and foremost, I think everyone have to set their own phase for how long they need to prepare, especially in times like this. I think this blog post by Eva Murray sums it…

Elias Nordlinder

Business Intelligence Consultant. Previous MSc in Economics and Finance. Love problem solving/analytics and to teach data to other people.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store