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.

How to set deadlines for report finishing, if you have never done anything like it? 🤯

In the pictures, you'll find my 5 tips 👆🤘

Let me know if you have smth to add in the comments 👇

Is learning an essential part of data analyst work? I would say hell, yes!

Read my thoughts in the slides.🤘

Last few days I got questions about how to be more noticeable for employers if I don't have experience in data analysis? This is why today I wrote about the experience. 🤘

Usually, you think that you'll be more "attractive" to employers if you get more courses. ‼It's not true‼ W/o the experience, you'll have only basic knowledge of various tools but not deep knowledge.

It's better to have experience on one tool than basics on several. So, how to get this experience, read the slides. 😉

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.

One more important part in making Power BI reports is a GATEWAY. 🤘

Read the description in the slides and let me know your questions below 👇

If you have been looking at some videos about Power BI, you could hear people talking about implicit & explicit measures. And you could think, what the hell is it? 🤔

🤘IMPLICIT measures are those columns, loaded from the data source, that have a sigma sign next to their name.

🤘EXPLICIT measures are those that you create with the DAX.

👆As always, examples can be found in this post's pictures.

Are you confused with concepts of DASHBOARD and REPORT in Power BI? 🤯🙈 No, worries! In these slides, I'm describing the biggest differences between them. 🤘

As always, let me know your questions or comments below. 👇

Do you know that Power BI Desktop has 3 different views? Do you know their differences? If not, keep on reading. If yes, are you using all of them? Comment 👇😉

There are 3 different views in Power BI desktop
🤘Report view
🤘Data view
🤘Model view

All of them are described in the picture of this post. 👆

Save this, if it was useful 😉

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 👇

What the hell snowflake ❄️ schema is? 🤯

The previous post was about STAR schema, so if you don't know what the hell that one is, read that post 😉 because is related to today's post too 🙂

🤘So, SNOWFLAKE schema is the same Star schema, but with an additional dimension table connected with another dimension table.

🤘You can see the example in the picture. There is Cust_typ_catgry table (dimension table) connected with another dimension table, D_cust.

I would say that this schema is the second most popular schema. And you can also use it in the Power BI model.