Відео

A quick video with all the measures should be live tomorrow morning. Here is a link: ua-cam.com/video/oYFJQJ1p4fo/v-deo.html

Hello, I can certainly do that and funny enough, I've just used that on my last project. Give me a couple of day and I'll get the video made.

A quick video with all the measures should be live tomorrow morning. Here is a link: ua-cam.com/video/oYFJQJ1p4fo/v-deo.html

@@MMS-PowerBI Hi thank you for your replyl just tried acccessing the link and it says private

Sorry about that. The video is public now.

Hi Syed. Let me first thank you for your kind words. It makes me really happy to hear that you found my videos useful. Now, I will end up doing a video like that, but I don't have a time line on that. I can though give you some information based on my experience and journey in the Power BI world, without pretending it will be the absolute truth :). Responsibies, or more like a system that I use: 1. Liase with the stakeholders to udnerstand the businisses requirements. (at this step I usually define the important KPIs and a rought structure of the report) 2. Data gathering and transformation (for me it mostly means writing SQL queries that I then import in Power BI). Since I write my custom queries the data transformation in Power BI is minimal for me. 3. Report development (writing DAX, creating visualisations, filters pages, etc.) 4. Data analysis (it is happening pretty much at the same time with the previous step as they are strongly related) 5. Report testing (this is the bit I give most of my time, because here is where I make sure that the reports are accurate, especially when I have to connect two different databases - SQL and Oracle in my case) 6. User training (I cannont expect that the final user will have my knowledge on Power BI and they do need all the help they can get. The whole point is for them to use the report, not just have it there for fun). 7. Support and Administration ( any suport reuqired from users and administration of the Power BI Wev service) Skills: 1. Data modelling (You need to understand very well a data model, how it works and how to use it. A good data model give you accurate information and excellent performance) 2. DAX and M language (This is another very important aspect. You need to understand the logic of DAX and how to build measure. The M language can be learned a bit later) 3. SQL (You don't need to be an expert. You could even get by without any knowledge, but I can guarantee it would help to be confident in SQL) 4. MS Office 365 (You will end up connecting your report in various way with all of the components of the MS Office and you need to have good knoledge of all) 5. Any other expierience in Azure, Power Pivot, Power Query, Data warehousing would be very beneficial. And of course you need the soft skills: communication, creativity, negotiation, critical and analytical thinking and so on. Bear in mind this list could go on, and on, but this it what I can think of based on my role and my experience.

​@@MMS-PowerBI Thanks a lot for answering my enquiries , I really appreciate the way you describe everything. Once again many many thanks mate , cheers up.

For the company that I work for, I mostly have to go with a snowflake design just because of the sheer volume of data. If I would recommend any of them, it would be in this order: 1. Star Schema 2. Snowflake Schema 3. Flat File (for 1 page dashboard style, small dataset, and it's needed very, very quick without emphasis on accuracy)

@@MMS-PowerBI Thanks!! You knowledge of Data Modelling is TIP TOP!!

Thank you for the feedback. I am trying to improve on my editing skill and hopefully on the more recent videos thigs are better :)

You have just made my day . Thank you very much!

@@MMS-PowerBIYou're welcome. You deserve more subscribers.

I will do my best :)

Thank you very much. It makes me really happy to know that you enjoyed it.

Yes, I was prepared for a different set of results, at least on the bigger file, but sometimes what we believe to be true might not be.

Hi Alana, Am I correct to assume that you want to concatenate multiple columns in one? Because in that case all you need to do is merge colums. (like I did in the video at 01:00) But I have the feeling that this is not you desired result. Please let me know what is the desired result and I'll be more than happy to help.

@@MMS-PowerBI thank you so much. i wish i could show you an image i have a table with several columns that contain the same type of information. I want to merge all columns in one but without merging rows, keeping them individual. When i merge columns, each row from all columns merges too, and i want to keep each row individual. Let's say stacked instead of merged all together. My final objective is to be able to do group by count and get how many records of each distinct type i have, but if i merge columns it doesn't leave the rows individual and it can not count properly.

I apologize for the late response. Unfortunately this option is not available in Power Query/Power BI. If you have a Linked In account please send me a message with a couple of pictures of a mock up table and the expected result and I might be able to give you another solution. www.linkedin.com/in/marin-stelian-manolescu

Thank you very much!

Business intelligence (BI) is a technology-driven process for analyzing data and delivering actionable information that helps executives, managers, and workers make informed business decisions.

@@MMS-PowerBI thank you so much 🙏

You're welcome. I'm happy to help 😀

@@MMS-PowerBI and Im happy to be your first Moroccan subscriber 😊

Hello, Here is a link from where you can download the MS Access database: fromzero2bihero.ck.page/26d7ecedbf I hope you enjoyed the tutorial 😀

Hi Robert, The name of the game is performance. And here is how the type of data model might affect it: 1. The size of date model. The larger the size, the worse the performance becomes. It is a good practice for example that in the fact table to keep only events (dates, numbers) and NO descriptions. Just by splitting it into a fact table and dimensions table you could reduce the size of data model considerabely. 2. A flat file (normalized) might work if it has a low amount of rows. When you are talking about millions of rows, as soon as you DAX calculations will get a bit more complicated, the query response time will go through the roof. And we all know is nothing worse than waiting more than 2-3 seconds (and that's very generous) to have a report refreshed. I hope this helps you a little bit.

In theory both duplicate and reference will give you a copy of the initial query, but.... There is a but :) With duplicate when you change/modify the initial query, the copy will not be affected. Whatever steps you make in the fact table, they will not be reflected in the dimension table. With reference on the other hand, any changes you make to the initial query will be reflected in the copy. For example, if you use reference to create the parts dimension and then in the fact table you remove the part description column, then the description column will be removed in the dimension table as well. I hope this answer you question. If if you have any more question please give me a shout. I'll be more than happy to help.

Hi there, Thank you for you wondeful comment. I have in plan to get a project through all the steps, from file to upload on the Power BI service, but I can't promise a date just yet. It will be something that most likely will be a couple hours long, and will have some interesting DAX measures.

Youre welcome. In theory snowflake schema can be denormalized into a star schema. But sometimes, if you have loads of data, it's advisable to normalize the star schema into a snoflake schema, depending on what type of granularity you need to achieve.

I am happy you found the tutorial useful and that it has the right speed. I try to stay more to the point, than go around the bushes for nor reason :). Now, related to you question, first of all well spotted. I have tried to add that step more like a how to do it. In real life this would create a blank result and all sort of issues. The solution is to make the replacements in the original table or file, before duplicating, and then both the employees table and the department id table would have the same IDs.

You are welcome! I'm glad you liked it 😊!

I'm glad it was helpful! Thank you for watching, and I hope you'll enjoy more tutorials from me.

Thank you!

Thank You! I am very happy that you enjoed it!

Thank you for watching. The data set download link was added to the description of the video.

Hello and Thank you for watching the video. The download link was added to the description of the video.

@@MMS-PowerBI THANK YOU !!!

Hello and Thank you for watching the video. The download link was added to the description of the video.

Thank you. This is much appreciated 👏

Thank you very much! I'm glad you enjoyed it 😊

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

Thank you for your comment 😊. This example is just a tiny bit of what can be done. You can play with titles more and make them dynamic, use more reference labels, and so on. If there's something you'd like me to do, just let me know.

@kevinhung-liang Thank you for your kind comment. Regarding the date filtering you are correct in saying that on an "official" project the way to use filtering is "on and after". At the company I work for we use SQL and Oracle databases and I always export my data already cleaned and I always filter data as either "<=", either ">=". In Power BI, for both M language and DAX the syntax should be the same. On a separate note, if there is anything specific that you would want me to shoot a video of, just let me know. Thank you for sacrificing your time to watch the video. It is highly appreciated 👏

Thank you for you kind words. let me start by apologizing for the late response. Having said that I have a dded a link in the description box of the video were you can download the access files for the data set.

Thank you your very much. The next video should be live in a bit over an hour now! I hope you will like it 😀

Hi there, I hope it wasn't that bad 😀

Thank you for your reply. I hope next Monday I'll be able to upload a video with the process of cleaning the data and creating the data model. After that, we'll transform the report using measures.

@@MMS-PowerBI Good to hear. I can not wait for it (:

@theberg1e Hi there. The video with how i cleaned the data in Power Query. I would appreciate veru much any feedback from you. Thank you

It's good to hear that! 😊 Power Query might seem complicated, but it's not that bad.

Thank you so much!