Photo by Markus Winkler on Unsplash

(The article can also be found at my webpage eliasnordlinder.com)

The importance of Sharing

I think that one of the best way to learn something is by sharing. There are a lot of great free online content, and I really like when I find someone really knowledgeable about a tool practically.

If it is a practical aspect, like what I learned in this episode in Tableau, I like to redo the lecture by myself, go through what I have learned and then write about it myself to teach other from my point of view.

This article is regarding VizConnects video “VizConnect Tableau Design Tips”…


Photo by Josh Riemer on Unsplash

(The story can also be found at eliasnordlinder.com)

What are Pre-attentive Attributes?

Pre-attentive attributes are attributes that our brain, or more exactly our Spatial Memory, subconsciously processes when looking at a visual. It is the very first thing that you pay attention to. The process is done in milliseconds, before you are even aware of it.

If you have you read any of Daniel Kahnemans books, he splits up the brain in two systems.

  • System 1 (Reptilian brain): This system is quick, automatic, impulsive, unconscious, emotional and stereotypical.
  • System 2: This system is slower, conscious, reflective, analytical and makes complex decisions


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…


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…


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.

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…


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

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…


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…


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…

Elias Nordlinder

Data Analyst at Visma. Previous BI Consult with 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