Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
Need one suggestion. In the raw data/source datasheet, I have one column for Birthday information in Date number format. Furthermore, Some data are missing and some cells are mentioned with non-number values (i.e "N/A", "Not update" etc.). Now the problem is when I add this Table into power pivot, Dates are stored as text. That's why I could not add any function. Can you please how to solve this?
This is so satisfying. Please in a case where one will have to select 2000 customers out of 4 or 5 datasets with each rows upto 20,000 and column 10. Do I do the selection during the data cleaning stage or during the model selection? Thank you
Very useful power pivot we have facing problem filter wise sheet separated in Power Pivot data analyze tab in Pivot option Baton show report filter page not working in Power Pivot how to solve problem
Question, can you hold control and select each table, and then add them to the data module w/o having to select and add them individually? Thanks in advance!
Is there a way to do the same thing as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
THANK YOU SO MUCH. NOW I KNOW HOW TO MAKE PIVOT TABLE RELATIONSHIPS
You are one smooth criminal on damn excels. So satisfying to watch. Thanks
Thank you so very much! Your explaination is super clear and easy to follow along.
Very insightful, but I know it will be very instructive and inspirational if you share your data so we, your students may follow. Thank you boss.
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
The third of your video I watch I must subscribe this channel the now, best explanation ever!
This was so good!! Excellent explanations!!!
Loved it. Thanks.
Great video!!! Tons of useful information in just to 10 mins. Thanks
Thank you❤
So far, T H E B E S T video tutorial!
Awesome 👍😎😎😎😎👍👍👍 great job
I keep getting an error code when i try to make a relationship between my tables, says there duplicates. so annoying
do you need microsoft office subscription for adding data in powerpivot table
Need one suggestion. In the raw data/source datasheet, I have one column for Birthday information in Date number format. Furthermore, Some data are missing and some cells are mentioned with non-number values (i.e "N/A", "Not update" etc.). Now the problem is when I add this Table into power pivot, Dates are stored as text. That's why I could not add any function. Can you please how to solve this?
This is so satisfying. Please in a case where one will have to select 2000 customers out of 4 or 5 datasets with each rows upto 20,000 and column 10. Do I do the selection during the data cleaning stage or during the model selection? Thank you
Sounds like the cleaning stage - query only what you need, and append if necessary.
Very useful power pivot we have facing problem filter wise sheet separated in Power Pivot data analyze tab in Pivot option Baton show report filter page not working in Power Pivot how to solve problem
Question, can you hold control and select each table, and then add them to the data module w/o having to select and add them individually? Thanks in advance!
What do I do if there are duplicate values when trying to make relationships?
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
Is there a way to do the same thing as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
Why practice excel sheet is missing?🙄
Can you send me the file, please?