Відео

Hi there. I have used this data set: fromzero2bihero.ck.page/26d7ecedbf

Thak you very much. I'm glad you enjoyed it

Hello. You should consider the one in the second video. I have realised that I've not considered the leap years a little bit too late, but if you use the one in YoY video it should work perfectly.

Thanks 😊 it's clear now

Hi and thank you for you patience. I have finally had a chance to look at that now and the measure shown in the video will concatenate all Companies into one line. The downside is that it will calculate the sales for all of those companies. Having said that, chances are very slim that in the top 3 to top 5 you would have a tie (at least is did not happened to me in a real life scenario yet). But yes, if you decide to use this visual, you need to take in consideration this aspect as well.

Hello, what do you mean by that?

Thank you. I believe it was because I was dragging the ID from the dimSearch to the ID from dimCompany. But it makes no difference if you do it the other way. Many-to-One would be the same as One-to-Many if you change the tables order in the relationship.

Thank you very much!

Thank You. The background is something was created in Power Point and then exported as SVG. This is how I create my background for the minute.

Hello. My last job hunting was a while ago (more than 8 years to be precise) so I won't say that I know 100% what you need to do. Having said that, here is what I would do if I would hunt for a job: 1. I would create myself a portfolio of reports (2-3 reports) on various themes. Maybe one sales, one hr and one financial. 2. I would find recruiters and/or companies that are active on the BI market and contact them. 3. Instead of sending them a CV or a cover letter, I would actually send them these report, as they would (in my opinion) have a greater impact. They would showcase my skills better than a CV. 4. I would not give up :) I hope this helps, and again, I would not consider this the absolute truth and the only way to "attack" this situation.

Hello. What's up?

I appreciate that, and I do believe as well that the biggest advantage of Power BI is that it can be consumed on the go. That's why I believe this option should be used in conjunction with the "regular" slicers. For example, in all of my reports now I have the regular slicer panel and I have added this option as well. And now it's up to the user to choose which option suits best for the situation. Let me give you an example: if one of our sales manager would like to use a drop down and filter through 4k customers, then that is a task in itself. On the other hand if they can type the name of the customer, then it is a lot easier. On the same type of scenario, if they want to filter by areas, then it's a lot easier to use the slicer as there are less options to go through.

Thank you. In the company table I don't have a single column containing all the information I want to search for. Only individual columns for various dimensions. That is why I had to create a separate table.

I have installed it on 13th of November. If you need to, please download and reinstall the latest version and, in the preview section in the options and settings, enable the text slicer preview.

Thank you very much!

You're welcome 😊 I'm glad you enjoyed it!

I'm glad you enjoyed it! There's a new video coming in about 2 hours on the new text slicer that I have a feeling you might like aswell 😀

You're welcome!

You are correct, and I've changed the calculation for the YoY calculation video, using the DATE function and adding or subtracting one year.

@MMS-PowerBI could you please share the code?

@@souravkarmakar7601 Yes,, Please provide the code.

Thank you, and I hope these visuals will help you. I will put together a video with the measures that I used and post it out soon.

The weekend schedule changed for me, so, instead of a video I've made a post with the measures I've used. Please follow this link to see the measures: ua-cam.com/users/postUgkxGIj1mP0znXM9PZgvqO5G1_CmiGL4qR36

You're welcome! I'm glad you liked them and I hope they will be usefull to you!

I am glad this is helpful. Here is the data set: fromzero2bihero.kit.com/accessfreefile. You can play around with the dates and so on. In theory, whereever I publish a video about sales I will use this data set (with small changes here and there)

If you are not using any slicers, then you can use the offsets for year, month and quarter. If you calendar table ends with the last date where you have sales, then here is an idea for the year: YoY = VAR _MIN_DATE = CALCULATE(MIN('DATE TABLE'[DATE]), 'DATE TABLE'[CurrYearOffset] = -1) VAR _MAX_DATE = CALCULATE(MAX('DATE TABLE'[Date]), 'DATE TABLE'[CurrYearOffset] = 0) VAR _SALES_CY = CALCULATE(SUM(SALES[LINE VALUE]), 'DATE TABLE'[Date] >= DATE(YEAR(_MIN_DATE)+1, MONTH(_MIN_DATE), DAY(_MIN_DATE)), 'DATE TABLE'[Date] <= _MAX_DATE) VAR _SALES_LY = CALCULATE(SUM(SALES[LINE VALUE]), 'DATE TABLE'[Date] >= _MIN_DATE, 'DATE TABLE'[Date] <= DATE(YEAR(_MAX_DATE)-1, MONTH(_MAX_DATE), DAY(_MAX_DATE))) RETURN DIVIDE(_SALES_CY - _SALES_LY, _SALES_LY) This will only work for current year as in 2024. The min dates look like this: for the month to date VAR _MIN_DATE = CALCULATE(MIN('DATE TABLE'[DATE]), 'DATE TABLE'[CurrYearOffset] = -1, 'DATE TABLE'[Month] = MONTH(today())) for the quarter to date CALCULATE(MIN('DATE TABLE'[DATE]), 'DATE TABLE'[CurrYearOffset] = -1, 'DATE TABLE'[Quarter Number] = QUARTER(TODAY()))

@@MMS-PowerBI Thank you, very helpful

Not yet. This is something that I think about filming, but I could not find the neccessary time. I will make one, but I can't promise exactly when :).

When I have that measure name, I always use SUM([column to be added]), with no added filters. Otherwise, I change the measure name to describe what it does, just in case somebody else will work on the report in the future.

@ thank you

I can't even begin to tell you how happy I am that you want to use some of these "tips". You have made my week. (maybe even my year :) ) Thank you very much.

@@MMS-PowerBI You are welcome sir! I’ll be adopting the incredible solution you outlined in your three KPIs and one visual video (supercharged line chart). I’ll need to rewatch your videos a few times to adapt it fully to my situation. You’re an excellent presenter-methodical, logical, and thorough in your explanations. Thank you!

You're very welcome!

Stelian, would you be able to transition the total sales line to a forecasted sales line?

Thank you very much! I'm glad you liked it!

@@MMS-PowerBI Would you consider creating a video on designing dashboards that effectively communicate sales performance to upper management? The focus would be on maximizing storytelling through data visualization.

Thank you. It's just another way that information can be added, and sometimes a few words are better than a graph.

Other than Flat Schema, Star Schema and Snowflake Schema, the two most common are: Relational schema. In a relational database schema, each object is assigned its table, and these tables all connect to each other. Hierarchical schema. In this schema, one root table connects to multiple child tables where each child has exactly one parent. Now, bear in mind that I don't think you will ever need these two in Power BI.

Happy to hear that!

Hi there and thank you for watching the video. Here is a link from where you can download the excel file: fromzero2bihero.ck.page/dc4ab94aa6 It will require a subscription to the newsletter and I promise I won't bombard you with emails :) (as a matter a fact so far I have not sent a single email)

Hi there. I usually consider YoY growth only on the same period of both years. So, let's consider this scenario: 1. The previous year records start on 1st of July and the current year ends today, 23rd of October. 2. Total sales PY = 1.11M (01/07/23 to 31/12/2023) (calculated using SAMEPERIODLASYEAR), Total sales CY = 3.21M (01/01/24 to 23/10/24). Your 188.49% YoY growth in this case is incorrect, because the two periods are not the same. There is the period between 1/01 to 01/07 where there is no data in '23 but there is in '24, and there is the period between 24/10 and 31/12 where there is data in '23 but not in '24. And that's why I calculate the minimum date of 01/07 for both years and the maximum date of 23/10 for both years. In this case the total sales would look like Total sales PY = 1.05M Total sales CY = 1.16M (01/01/24 to 23/10/24), returning the 10.24% YoY growth. I hope this answers your question. Anyway, please let me know if you think there is something wrong with my logic, because at the end of the day I might be wrong myself :)

@@MMS-PowerBI ah, I understand! Thanks for the explanation

​@@MMS-PowerBI Hi, how can we account for years with 366 days in the measure? I’d really appreciate your feedback.

I have realised this whilst recording the next weeks video, because I was looking at 29th of February 2024 in my date table :). So I will change my calculation by using the date function. Anyway, I hope that on this Thursday I'll be able to publish a video that explains why I calculate my YoY% like that.

You're very welcome! I'm glad you enjoyed it.

I'm so glad I could help you!

Glad it was helpful!

First of all thank you for watching the tutorial. The dataset is something I created a while ago and it did not have a target table, but I believed that is a very good way of using the "Enter data" feature. As for the date table, if you need a comprehensive one, you can find out how to get the code for the one I use here: ua-cam.com/video/7qaIavKCaoI/v-deo.html

@@MMS-PowerBII already discovered some of your fantastic tutorials also the one how to create a date table. Many thanks for sharing them ❤.

I am glad you think so and I hope it will give you a starting point to create your own KPI cards.

Thank you for the kind words! I'm glad you liked it!

Thank you very much! I'm very happy that I could help you 😀

Glad you think so!

In this video you can find the M code that I used: ua-cam.com/video/7qaIavKCaoI/v-deo.htmlsi=25EG71sHgiYBK43Y It should be the final chapter.

Thank you very much 😊. I'm very happy that you enjoyed it.

Thank you very much! I'm glad you enjoyed this tutorial, and I know this is the beginning of a very beautiful journey for you!

Of course, you could consider that a 3NF is a denormalized version of 4NF. But, when aiming for the best performance, then a fully denormalized data is the goal. Having said that, I always use 1NF and 2NF, depending on the situation, because of the way data is stored in our company.

Thank You very much 😊

I have a video on the channel where you can see how to get the exact same date table. This is the link: ua-cam.com/video/7qaIavKCaoI/v-deo.html