3 ай бұрын
4 ай бұрын
4 ай бұрын
Пікірлер
@BoterH 4 күн бұрын
Thanks ! snowflake is like several star scheme together.
@MMS-PowerBI 4 күн бұрын
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.
@BoterH 4 күн бұрын
Thank you very much for the tutotrial. One of the first i don't have to accelerate X2 to follow :-). There's step I don't understand well is about value replacement. If you replace departement ID (so secondary key) how the ID HRFM, HRFH ... will link with the DimEmployee table, as the primary keys have not changed...
@MMS-PowerBI 4 күн бұрын
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.
@xyclos 4 күн бұрын
Excellent. Thanks.
@MMS-PowerBI 4 күн бұрын
You are welcome! I'm glad you liked it 😊!
@cvdung06 6 күн бұрын
Excellent instructions. Thanks🎉
@MMS-PowerBI 6 күн бұрын
I'm glad it was helpful! Thank you for watching, and I hope you'll enjoy more tutorials from me.
@kebincui 14 күн бұрын
👍👍
@MMS-PowerBI 14 күн бұрын
Thank you!
@kebincui 14 күн бұрын
Super 👍👍,thanks
@MMS-PowerBI 14 күн бұрын
Thank You! I am very happy that you enjoed it!
@kingsfordsconspiracytheori9066 14 күн бұрын
I love the tutorial, can you provide the datasets?
@MMS-PowerBI 13 күн бұрын
Thank you for watching. The data set download link was added to the description of the video.
@billgillaspey9036 15 күн бұрын
Ye: thank you for this video. And I, too, would like to receive the data set. Thanks in advance.
@MMS-PowerBI 13 күн бұрын
Hello and Thank you for watching the video. The download link was added to the description of the video.
@MojtabaFazeli-hl8dh 16 күн бұрын
Hi and Thank you, But can ytou share data sample for use according your tutorial?
@MMS-PowerBI 13 күн бұрын
Hello and Thank you for watching the video. The download link was added to the description of the video.
@getsetgoo3334 17 күн бұрын
great tutorial, keep up the good work
@MMS-PowerBI 17 күн бұрын
Thank you. This is much appreciated 👏
@kennethstephani692 17 күн бұрын
Great video!
@MMS-PowerBI 17 күн бұрын
Thank you very much! I'm glad you enjoyed it 😊
@eddycha8009 19 күн бұрын
Your introduction is awesome!
@MMS-PowerBI 19 күн бұрын
Thank you very much! I'm glad you like it!
@fabiuskumgne3659 21 күн бұрын
cool
@MMS-PowerBI 20 күн бұрын
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 Ай бұрын
Very nice explanations. I notice that when you filter for dates only in 2023, you used "is after 01/01/2023", which is distinct from the usual "is on or after 01/01/2023" that you might use in Powerbi to include the first date of the year. Does the method you used here accidentally exclude the date 01/01/2023? If so, then "is after 12/31/2022" would have to be used, or perhaps an adjustment in M to "[PROCDATE] >= #datetime(...". Thanks for any clarification. I look forward to watching more from you.
@MMS-PowerBI Ай бұрын
@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 👏
@ubaidillahmuhammad20 2 ай бұрын
AMAZING JOB. BUT PLEASE GIVE THE FILES
@MMS-PowerBI 14 күн бұрын
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.
@AnilKumar-vi8oe 3 ай бұрын
Valuable content, waiting to see more from you.... Thanks for sharing
@MMS-PowerBI 3 ай бұрын
Thank you your very much. The next video should be live in a bit over an hour now! I hope you will like it 😀
@nathalyvilela5015 3 ай бұрын
😅😊😊
@MMS-PowerBI 3 ай бұрын
Hi there, I hope it wasn't that bad 😀
@theberg1e 4 ай бұрын
Nice Video! Do you have a video where you load this dataset into PowerBI, transform it and build the measures? That would be very helpful! Keep up the good work 👍
@MMS-PowerBI 4 ай бұрын
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.
@theberg1e 4 ай бұрын
@@MMS-PowerBI Good to hear. I can not wait for it (:
@MMS-PowerBI 3 ай бұрын
@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
@qasimali-gu3oz 4 ай бұрын
I have recently solved many FAANG SQL interview questions from stratascratch through Power Query and it was such a fun. I love Power BI.
@MMS-PowerBI 4 ай бұрын
It's good to hear that! 😊 Power Query might seem complicated, but it's not that bad.
@qasimali-gu3oz 4 ай бұрын
Congratulation on starting this amazing Power BI journey.
@MMS-PowerBI 4 ай бұрын
Thank you so much!