How to Model and Analyze Data in EXCEL using POWER PIVOT
HTML-код
- Опубликовано: 22 окт 2024
- mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen ⬅ Support me on Patreon
• 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 ➡ imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate ➡ imp.i384100.ne...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.ne...
Microsoft Power BI Data Analyst Professional Certificate ➡ imp.i384100.ne...
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
Thank YOU Sir! I am learning so much just by watching/listening to you.
I'm glad you find the content educational!
Greetings from US ,MO Chen I appreciate your help
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.
Lovely video. Clear and informative.
Glad it was helpful!
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!
That was really good Mo! Loved it 👍
Glad you liked it!!
thats so informative thanks!
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!
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?
Hi I have created the relationships as required, I am getting a error running the Related function
=RELATED(products[Profit]*orders[Quantity])
error: Function RELATED expects a fully qualified column reference as its argument.
Please advice
Excellent 👍
Glad you liked it!
I need help - obviously my Excel is 2016 and most of the things I don't have access to even if I use office 365 online. Do you have any advice on how to have the options you have?
do you use windows or Mac ? I have Mac and unfortunately it's not supported in Mac version
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!
does college degree matter to get into tech as a fresher ?
Question : i am not able to create a new data table the option is there but it doesn't work any suggestions?
LETS GO MO! 😀
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.
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 couldn't either
I wish my data was always so clean 🥴 Rarely you have the data perfectly transformed to create one to many relationships
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.
I can't do "add data to data model"
I have excel 2019 on windows
Is a an indebt and simplified tutorial. The only issues here is that the video is not clear enough. The recording is faint.