How to Model and Analyze Data in EXCEL using POWER PIVOT

I'M HERE TO HELP YOU LAND YOUR NEXT TECH & DATA JOB

LET'S COLLABORATE

ABOUT ME
I'm Mo and I work as a data analytics manager / content creator. I make videos about how best to get your next job in the tech & data space; whether you're a beginner, career switcher, or someone looking to take their tech & data career to the next level.

COURSES & CERTIFICATES

INDUSTRY RECOGNIZED CERTIFICATIONS

TOP DATA ANALYST COURSES

TOP DATA SCIENTIST COURSES

TOP DATA ENGINEER COURSES

TOP BUSINESS INTELLIGENCE COURSES

TOP PROGRAMMING LANGUAGE COURSES

TOP AI COURSES

[michaelt]

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.

[tmb]

So used to seeing people trashing Excel while being completely ignorant of its actual capabilities. Refreshing video!

[PowerBiWithVivek]

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.

[djakperetheophile]

Greetings from US, MO Chen I appreciate your help

[joaomarcoseliasmatias]

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!

[DingDongGrahamBell]

Thank YOU Sir! I am learning so much just by watching/listening to you.

[behzod]

Hello from Uzbekistan
You are doing a great job
I really appreciate that you are teaching with real life cases which are more useful in my job than other fancy youtube tutorials

[lakshmanperera]

Great video, a real eye opener for me personally, did not know excel has that much of capabilities

[Sameer-dpfe]

Another basic and best tutorial. Thanks Data With Mo😋

[arnab]

Whoever facing Date format problem (Order date ) : to convert Text to Date format use can use Power Query selecting the 'Order Date' column > select left side of Date column "aBc" > Right click > Using Locale > select data type - Date + select Locale - English(US) > OK

[richardenriquezjr.]

Thank you so much, Mo! I love this video.

[travediary]

Great video! Appreciated a lot for this! It would be even better if you could do the same analysis in jupiter notebook using pandas.❤

[jackhao]

Great work. I can't create a new Date Table for some reason. Any ideas?

[mosespremium]

Thanks for the video. Is it possible to access the dataset used here for the analysis? Once again, thanks for this tutorial.

[alanhernandez]

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!

[mrbartuss]

I wish my data was always so clean 🥴 Rarely you have the data perfectly transformed to create one to many relationships

[rumeeburu]

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?

[assaulterak]

Question : i am not able to create a new data table the option is there but it doesn't work any suggestions?

[TheJords]

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?

[CikYlang]

hai mo chen, i have two data model and both have duplicate value which cannot to create relationship. i create distinct table and make relationship with both data. but that relationship don't worked.. can you advise how to solve that