I replicated this project yesterday. It was nice learning but would have been better if you could explain why, you are doing what you are doing especially at the beginning of the project. It gives a clear overview and helps to clearly understand the concepts and flow as i am a beginner. I definitely learnt a lot from this project. Could you / your wife create more intermediate level use case PowerBi Projects? It will help people like me. Anyway, your content adds a lot of value. kudos to Nicole! Great Work!
@first0last0
23 күн бұрын
I felt the same. Like why are you removing the duplicates for instance, would be nice with the reasoning behind, etc
@OnePercentPerfectionist
2 ай бұрын
Can I just say that I love your wife? I think this was my best real PowerBI video on YT. Really enjoyed her thought process and the visuals were different, Loved that scatter plot/chat analysis. Please bring her back soon? 😊❤
@mo-chen
2 ай бұрын
She’s on a lot of podcasts on the channel and she has a complete home office video as well. Make sure to check those out!
@emily841113
2 ай бұрын
@@mo-chen Where can I find Nicole's other videos? Thank you:)
@mo-chen
2 ай бұрын
@@emily841113 just go to my podcast playlist :)
@prefectdays
3 ай бұрын
Hope you make more videos like this, I learn a lot from your content in the path of becoming data analysis. Knowledge from your videos help me build the confidence to apply for a job. Really appreciate your content
@mo-chen
2 ай бұрын
Thanks so much for the nice comment. I'm glad my content helps!
@shizuku7081
3 ай бұрын
Thank you so much! It was so interesting seeing a senior analyst in action while explaining the thought process!
@mo-chen
2 ай бұрын
Glad you enjoyed it!
@lifeviz28568
Ай бұрын
I find this PowerBI tutorial to be a little complicated and overwhelming for me. Everything was a bit haphazardly disorganized and I was having a hard time understanding her thought process - I think your wife was talking and going with the flow who knows what she's doing. A lot of the basic info like DAX functions weren't explained in detail.
@danielthuomuhia3206
27 күн бұрын
I mean you can't be spoon feed everything. Ask Google. There is ChatGPT also. Damn
@vancouverrrr
3 ай бұрын
thank you mo chen and mo chen wife for new video
@Dtdragpnd1
6 күн бұрын
This was a great project. I really wish she had gone into the insights she would have drawn and more explaining why she does things.
@pabeader1941
24 күн бұрын
| is called Vertical Bar or Pipe depending on your programming background.
@KaushikNath-rc7ev
4 күн бұрын
Mo, I think if the video was made by you, it would have been a lot easier for us to understand. No offense to your wife, she did a great job too, but the way you explained the Excel Portfolio Dashboard was just mind-blowing. I am kind of a newbie in this field, still creating that Excel dashboard with your guidance was super smooth. However I cannot say the same for this Power Bi Dashboard, as I'm getting quite a bit confused in just the first 15 minutes itself. Again, no offense to your wife, she did her best, but beginners like me needs someone who can explain and guide through projects like YOU do.
@mo-chen
Күн бұрын
Thanks for your honest feedback!
@yukwai6839
2 ай бұрын
Amazing, thank you very much Mo Chen & Nicole, I learnt alot!
@mo-chen
2 ай бұрын
Glad it was helpful!
@joelshah1665
2 ай бұрын
Where is the excel data set ? I want to practise along the video pls ?
@vintage_anime_vault
2 ай бұрын
download from the decription,pal
@AryanGlobalCollege
Күн бұрын
keep getting error "Cannot convert value '45396' of type Text to type Date." tried everything, any solution please..
@williamshelukindo7149
2 ай бұрын
what an amazing project, i have to say i have learnt alot in this guide
@mo-chen
2 ай бұрын
Great to hear!
@roopakn5556
Ай бұрын
May I know from where did you get the dataset. Just thought to put this project in my portfolio, so asking for the details of dataset! By the way, I learnt a lot from this video and am looking forward to seeing more quality content like this in the future!
@mrbartuss1
3 ай бұрын
7:20 Or use DAX Formatter instead
@ArunKumar-bp5lo
3 ай бұрын
where to publish the power BI projects . i know for tableau there is a tableau website
@jmBurton-Creations
2 ай бұрын
Maybe Kaggle, GitHub, or even Medium? Or if you have a portfolio website, there as well. I would even post it to LinkedIn for exposure to recruiters and others
@DilipSatam
3 ай бұрын
Hi Mo, Thanks you for creating such a valuable content. Could you please make a video on what would be the future of Data analyst role and how should we prepare for future in this era of AI. Thanks 😊
@mo-chen
2 ай бұрын
I already did. Please search something along the lines of "Mo Chen Will AI replace data analysts".
@sundayowolabi88
Ай бұрын
This is super good to watch and learn. Thank you Mrs. Chen. How can I download the dataset or drop the link to the Dataset. Thank you
@mo-chen
Ай бұрын
In the description
@elitekitano8804
3 ай бұрын
Hi Chen. Just wondering in the data cleaning, why did we do not remove the null column? I found that in accounts_id column in accounts table, there are null value. Just wondering what's the thought process of why we not eliminating it. Thank you
@Nicole_TC13
3 ай бұрын
You should take out null values, something I missed when doing this. This is what caused a many to many relationship later on in the project. Good spot
@Nehasgh2014
Ай бұрын
I did this project too and has similar concerns. Thanks!
@Pragnava984
3 ай бұрын
thank you
@mo-chen
2 ай бұрын
I'm glad you liked the video!
@memeduniya567
3 ай бұрын
can you please bring a project that include excel,sql,python,powerbi
@mo-chen
2 ай бұрын
I have a whole portfolio project playlist including all of these. Please check it out on my channel.
@Andrea-ev3by
3 ай бұрын
Thanks a lottt
@mo-chen
2 ай бұрын
I'm glad you liked it!
@kavyareddymarakala6541
Ай бұрын
Why are the PYTD sales and quantity values null even though we are considering them from the base fact set table which has values starting from Jan 2022 and for the PYTD sales we calculated from 2022 to 2023 April 14. If you could explain that would be great.
@life-rn6nr
15 сағат бұрын
When you have do many projects to manage
@SANDATA764
2 ай бұрын
Thank you very much for such amazing content. This is a really good and strong project that can be used as a portfolio project. I have tried to reach you through email but didn't get any reply. So please, if you get any chance to attend it,? will be really appreciated.
@mo-chen
2 ай бұрын
Join the Discord Server (invite link in video description) please. It's by far the best way to interact with the whole community, including me. Or feel free to book a 1:1 session here mochen.info/1-1-mentorship-lp/
@nahidehsan41
Ай бұрын
i cant open the excel file in powerbi
@novriandi8203
Ай бұрын
Why do i have a minus gross profit? i follow everything you do, i don't understand. When i see the data, all values in sales data is under value than COGs data.
@novriandi8203
Ай бұрын
solved, it's because my pc region isn't english(us)
@mo-chen
Ай бұрын
Nice, I'm glad you figured it out!
@tomaszkrauzy1962
3 ай бұрын
What might be the reason for me not being able to select multiple measures for one card to display, have to create multiple cards ... ?
@Nicole_TC13
2 ай бұрын
You should use the (new) cards, that way you can bring in multiple metrics in a single card visual - let me know if I misunderstood
@jaitiwari241
Ай бұрын
Hey bro !you are amazing I just want to give you one advice . So there are so many dashboard on KZitem but kindly create one detailed level advanced financial dashboard(FP&A[ financial planning and analysis]) covering tl financial metrics like total login , sanction value and count , disbursement count and value on pan country level and cover same in zone, state, branch level and employees performance and on different ticket size, covering bounce count ,bounce rate,total aum( assets under management),total gross income,roi%,LTv values and create from connecting data source like direct query or data lake or data bricks and from cleaning data , creating modelling ,dax and reports and then sharing , testing and deploying dashboard. If you cover all these aspects then surely it will be first dashboard on KZitem.
@shaunting335
3 ай бұрын
Instead of creating the inpast measure, could we just create the dim_date table to the last sales date?
@Nicole_TC13
3 ай бұрын
Good idea, and much more simple! Will keep this in mind for future work :)
@miragurumoorthy95
3 ай бұрын
Yes I second this.
@faacam
3 ай бұрын
hello hi, can u explain a bit aboutt this, wanna know more thank uu
@shaheerkamal9321
3 ай бұрын
Among the first 30 viewers yayyy.
@mo-chen
2 ай бұрын
Haha nice!
@pratyushrai6393
3 ай бұрын
nice
@mo-chen
2 ай бұрын
I'm glad you liked it!
@_Anshuman-zo1lj
2 ай бұрын
Where is the data set
@mo-chen
2 ай бұрын
in the description
@thejakumari7587
3 ай бұрын
Thank you so much for this valuable project ! Love from Sri Lanka
@mo-chen
2 ай бұрын
I'm so glad you liked it!
@hodan9521
13 күн бұрын
More explaining is defo needed in the talk through please for next time, why are you doing what you're doing?? i had to stop and ask Chatgpt questions in between :(
@mo-chen
11 күн бұрын
It's always good to apply what you learn and do some further research / study on your own. Good job.
@chif_01
2 ай бұрын
How can I get this data to follow along?
@mo-chen
2 ай бұрын
The link is in the description : )
@chif_01
2 ай бұрын
@@mo-chen is it free?
@M_le-n4r
2 ай бұрын
What do you mean by switch ?
@Nicole_TC13
2 ай бұрын
SWITCH functions allow us to switch between multiple values/fields/measures - here I’m using SWITCH functions to switch between the sales/gp/volume measures 😊
@M_le-n4r
2 ай бұрын
Ty for answering! A few more questions: 1. Is there a need to make another measure just for the dates? Doesn't powerbi automatically create a date hierarchy for the dates? 2. How do you know when to use the date from the created measure vs the date from fact_sales?
@yopiwijaya1905
3 ай бұрын
i need pandas project
@mo-chen
3 ай бұрын
Already have some in the portfolio project playlist. Have a look please.
Пікірлер: 76