Keep up with the excellent material. 👏👏👏 As a recent career changer, from web development to data analytics, these kinds of study materials are priceless. Thank you.
I am a big fan of you and would like show big appreciation towards your excel works.You make everything so easy to follow along for such a beginner with little experience.Always keep up the good work.
Most useful video I've seen so far from my point of view. I'm a beginner and it is really killing my drive and motivation to follow along hours of theoretical videos without knowing were this is going and how the knowledge will be applied. Here I can follow along and see the actual skills in action and learn by doing myself. Great stuff. I would add some teaser visuals at the beginning to see what we will achieve, not just explainations and text. Quick question. Why add headers and not a table ? Cheers from France. A
I think making the completed excel workbooks, power bi pbix files, tableau twbx files and eventually Jupyter notebooks available for these guided projects, as they evolve and incorporate more of the instructors and their expertise, would be incredibly useful.
This is great! Great because the project is very straightforward and beginner oriented. Great because the dataset is useful for going beyond the guided project, like analyzing for cross sell opportunities, etc. Thanks!
Thank you so much for this amazing video! It was really insightful and well-made. I learned a lot and truly appreciate the effort you put into creating this content. Keep up the great work!👏👏
Excellent Guided tutorial from you guys, Keep up the good job❤. It was observed that in the dataset we have 6:00 am and 6:00pm but it was incorporated into 6:00 on the Pivot table, How do we go about it pls. Thank you. ❤❤❤
Hi Chris, excellent starter tutorial. If I'm only interested in Excel projects at this stage, do you have Excel/PQ only projects that range from basic to advanced?
We have a few Excel projects live now (Coffee Shop, HR Survey Analysis, Traffic Safety) and one that combines Excel + SQL (Motor Vehicle Thefts). The HR project is intermediate and involves some good visualization techniques, but we haven't built a Power Query project quite yet. That said, we're producing new projects monthly and will certainly plan to include PQ!
We've created one! The Toy Store KPI Report PowerBI Dashboard can be found on our website and is free to access: www.mavenanalytics.io/guided-projects#projects-list
You are just too good sir. On another video this could have been hours.
Keep up with the excellent material. 👏👏👏
As a recent career changer, from web development to data analytics, these kinds of study materials are priceless.
Thank you.
Glad to hear it Charles, thanks for the note!
Thank you Chris, nice, short and to the point like a good cup of coffee
Thank you! ☕
I am a big fan of you and would like show big appreciation towards your excel works.You make everything so easy to follow along for such a beginner with little experience.Always keep up the good work.
Thank you very much!
Most useful video I've seen so far from my point of view. I'm a beginner and it is really killing my drive and motivation to follow along hours of theoretical videos without knowing were this is going and how the knowledge will be applied. Here I can follow along and see the actual skills in action and learn by doing myself. Great stuff. I would add some teaser visuals at the beginning to see what we will achieve, not just explainations and text. Quick question. Why add headers and not a table ? Cheers from France. A
I think making the completed excel workbooks, power bi pbix files, tableau twbx files and eventually Jupyter notebooks available for these guided projects, as they evolve and incorporate more of the instructors and their expertise, would be incredibly useful.
Great suggestion, it's actually in the works!
Chris you are the best teacher ever. Anything you teach becomes so easy to understand and follow. May Allah bless you.
This is great! Great because the project is very straightforward and beginner oriented. Great because the dataset is useful for going beyond the guided project, like analyzing for cross sell opportunities, etc. Thanks!
Glad you found it helpful!
Thank you so much for this amazing video! It was really insightful and well-made. I learned a lot and truly appreciate the effort you put into creating this content. Keep up the great work!👏👏
Hi Chris! I got to learn so much through this guided project. Thank you!
Glad it was helpful!
Thank you so much sir 😊😊😊 it am learning a lot as a housewifr want to become a dataanalyst lots of love from india
Hi Chris. I hope that you make a video or a course that focuses on data cleaning. Thanks!
We'll definitely add some guided projects with a heavy focus on data prep and cleaning - stay tuned!
Excellent Guided tutorial from you guys, Keep up the good job❤.
It was observed that in the dataset we have 6:00 am and 6:00pm but it was incorporated into 6:00 on the Pivot table, How do we go about it pls.
Thank you.
❤❤❤
Hi Chris, excellent starter tutorial. If I'm only interested in Excel projects at this stage, do you have Excel/PQ only projects that range from basic to advanced?
We have a few Excel projects live now (Coffee Shop, HR Survey Analysis, Traffic Safety) and one that combines Excel + SQL (Motor Vehicle Thefts). The HR project is intermediate and involves some good visualization techniques, but we haven't built a Power Query project quite yet. That said, we're producing new projects monthly and will certainly plan to include PQ!
Thanks guys. I'll be sure to check out your website projects.
I hope you create a video for power bi dashboard
We've created one! The Toy Store KPI Report PowerBI Dashboard can be found on our website and is free to access: www.mavenanalytics.io/guided-projects#projects-list
Very helpful, thanks !
Interesting.What happened to total sales and total sales volume .you only worked on transaction id
Thank you so much
Hello,may I ask how many projects do free users have access to?
At the moment, there are four free guided projects.
How can I add leading zeros to day and. Month?
="0"&DAY(serial_number) for the day or you can use ="0"&MONTH(serial_number) for the month
Thank you for the class but i cant download the csv file to this project
You can find all guided project data sets on our data playground: mavenanalytics.io/data-playground?search=coffee%20shop%20sales
is it power bi dashboard?
Excel dashboard