How to Model and Analyze Data in EXCEL using POWER PIVOT
Vložit
- čas přidán 11. 09. 2024
- mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle
/ mo_chen ⬅ Support me on Patreon
/ discord ⬅ Join our Discord Data Community
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
• Data Analysis Portfoli... ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python
┋Professional Certificates┋
DataCamp Certifications ➡ datacamp.pxf.i...
Google Data Analytics Professional Certificate ➡ www.coursera.o...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.o...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.ne...
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.o...
IBM Data Science Professional Certificate ➡ imp.i384100.ne...
Google Project Management Professional Certificate ➡ imp.i384100.ne...
PROJECT FILES ➡ github.com/moc...
Thanks so much for taking a little time out of your day to watch this!
I swear the algorithm hears me. I finally have gotten to a place where I feel incredibly confident in PQ as it applies to what I do. I talked about learning Power Pivot to the same level with a friend last night.
So used to seeing people trashing Excel while being completely ignorant of its actual capabilities. Refreshing video!
I'm glad you liked it!
Exactly
To Zoom in you can use window's magnifier, which can be activated by pressing window key and Plus (+) key and to zoom out window key and minus (-) key, And by the way videos are fun and informative.
Greetings from US ,MO Chen I appreciate your help
Thank YOU Sir! I am learning so much just by watching/listening to you.
I'm glad you find the content educational!
Greetings from Brazil, Mo Chen! I appreciate your videos very much, nowadays I work as a report developer in a Industry IT team. I am used to work with PBI, didnt know how powerful excel could be too! I want to find new jobs around here related to data analysis and reports development, and your content have been extremely useful.
Let me ask you something. Could you bring in your next videos, examples of how a possible data analysis report finished project would look like? Using these tools you had shown? What does the client usually wants to see? And how is the appearence of the final version that you deliver?
Thanks!
thats so informative thanks!
That was really good Mo! Loved it 👍
Glad you liked it!!
Hey Mo Chen… thank you so much for this lesson. I have a question though. Instead of doing this in power pivot, is there a way we can create a calculated field (by adding new measure) using pivot tables?
Great video! Do you know if SSAS uses the same DAX just as Power Pivot or Power BI? or something might change between these tools? Thank you!
Thank you so much, Mo! I love this video.
I'm so glad!
LETS GO MO! 😀
Question : i am not able to create a new data table the option is there but it doesn't work any suggestions?
Excellent 👍
Glad you liked it!
2:45 the first query is loaded in PQ.
My question is, what’s the tool running between the headers and the first row? I’m assuming it’s running some analysis?
Options in the View tab (Column quality and Column distribution).
What an amazing video. Whoever stumbles upon your channel has literally found gold information
I'm glad you stumbled here then!
Hello Mo Chen, In the power pivot of Excel where in design I can't create the new date table like u created in this. Can u please tell me that?
I wish my data was always so clean 🥴 Rarely you have the data perfectly transformed to create one to many relationships
does college degree matter to get into tech as a fresher ?
Is a an indebt and simplified tutorial. The only issues here is that the video is not clear enough. The recording is faint.
What happened to the Data Roadmap for 300? I went to go purchase it today but i can't seem to find it just the Data Portfolio now? Please let me know how i can purchase. Thanks.
I believe you sent me an email on this as well. I replied to you, please check your inbox.
In the design tab, the date table is not giving me the option to choose new. It is only letting me choose default. what could be wrong? Or what am I doing wrong?
You need to convert the data type for the 'Order Date' column in PowerQuery to Date type.