Analytics - Simplified

Are you new to Power BI? Do you know that it uses 2 different coding/formula languages? 🤯 If not, read the slides of this post!

Question of the day: if you are working with Power BI, are you using both of these languages? If not, why? Let me know your answer in the comments.

Even during my holidays, I didn't want to leave you w/o a post. 😁😊

When doing analytical work or creating a report it's not hard to forget the first thing you must always do before starting. What is it? Understanding what problem should you solve or what question should answer? 🤘

Don't forget this essential part!

Read more in the slides.

Do you know when to use GROUP BY or DISTINCT in SQL queries? 🤔 If not, keep on reading or look at the pictures. 👆

GROUP BY is used with aggregations like SUM() or COUNT().

DISTINCT is used when there are no aggregations in the SELECT statement.

It's simple like that! SQL code examples can be found in the pictures.

‼ Of course, you can use DISTINCT in aggregations, e.g., if you want to calculate DISTINCT COUNT. HERE I simple compare it with GROUP BY because sometimes you don't know which one to use. 😉

Let me know your questions below and add some code examples, if you can. 👇

Do you know what exactly GROUP BY in SQL does? Today you will! 😜🤘

- you should use GROUP BY if you use aggregations like SUM(), COUNT(), AVG(), MIN(), MAX().
- it groups all rows with the same values. E.g., if I have a column with values: RUN, RUN, LIFT, PUSH, PUSH, PUSH, GROUP BY groups those and gives a result of unique values: RUN, LIFT, PUSH.

An example how it looks like in SQL can be found in the pictures above.

❗Note, that
⚠ if you use aggregations and don't use GROUP BY, not everywhere you'll get an error even though you should. So be careful.
⚠ if you don't use GROUP BY, you will get repeated values. For example, if I have the same column "Terms" with values RUN, RUN, LIFT, PUSH, PUSH, PUSH, and I will write

SELECT Terms
FROM table

♦The result will be a column with all values: RUN, RUN, LIFT, PUSH, PUSH, PUSH

But with GROUP BY

SELECT Terms
FROM table
GROUP BY Terms

♦I'll get only unique (grouped) values: RUN, LIFT, PUSH.

If you like posts like this, like & save this post! 🤘 And as always, let me know your thoughts and questions below 👇