Download Excel File #1: Download Excel File #2:
Download Zipped Folder:
Entire page with all Excel Files for All Videos:

Buy excelisfun products:

Learn about how
Topics:
1. (00:16) Introduction
2. (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016
3. (03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!
4. (17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set
5. (21:50) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report.
6. (22:34) Diagram to understand Data Model and Power Pivot
7. (46:46) Unhanded Exception Error.
8. (48:02) Summary

Reference Video:
Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model

Nguồn: https://thedancingparent.com/

Xem thêm bài viết khác: https://thedancingparent.com/cong-nghe/

28 Comments

Elizabeth James

June 29, 2020

This is a great tutorial but I am wondering if anyone has recommendation for how to solve a problem I am running into. I have a power query that goes out and grabs Covid data. But the table it is grabbing from does not have a "date" on it (@t but I need to track by the date. How do I tell the advanced editor to insert the date it retrieved the data in the first column? The convert dates don't work because the site does not have a date. So I am wondering how to insert the date in the first column based on the date the power query was run.

Reply

Isam

June 29, 2020

Thank you.

Reply

Janmejaya Patnaik

June 29, 2020

Damn Good explanation. Each and every option explained in detail. Really thankful to you. Hope you are doing good. 👍. In lockdown I used to watch.

Reply

Alesya Blagova

June 29, 2020

Love that video. Super clear and detailed!!!

Reply

BezUmiaru

June 29, 2020

Simply Champion!

Reply

Dick

June 29, 2020

Simply Awesome Mike!

Reply

paul maksimovic

June 29, 2020

This is excellent – what a Brilliant instructor and very enthusiastic. This guy rocks

Reply

MV CF

June 29, 2020

soo useful. thank u!

Reply

Ruroshinzy Naruto

June 29, 2020

Thank you so much, all your videos are amazing, thank you for the time and efforts.

Reply

coni z.

June 29, 2020

Super detailed and clear tutorial. I should have watched it long time ago. What a shame. But Thank you for sharing and looking forward to more sharing🤗🤗

Reply

Ben Fan

June 29, 2020

Thank you the your useful viedo, i am just wondering if the error with Power Pivot matters if we ignore them? Thank again

Reply

fajne fajne

June 29, 2020

Hi All, I have a question and I will be very grateful for help.

QUESTION: How can I connect in Power BI to a query (transformed by Power Query) saved as Connection Only in the other Excel file? I have not extracted it to sheet because of the size.

I have a big data transformed in Power Query and saved in one Excel file and because of the big size of the content of the query I keep it as Connection only, and I have not extracted it to to table in the Excel file sheet.

Is there a possibility that I could use the content of this query, from the Excel file (saved as Connection only), as an input data in another Power BI model?

I know that I could build the same query from scratch in Power BI (or copy the M code), but I would like to limit the number of processes to be run by the Power BI model, and use the already prepared data from another file.

Thank you very much in advance for help.

Reply

Shane Janse Van Rensburg

June 29, 2020

Late starter to power query, this tutorial was mind blowing. Love it. Thanks Mike!

Reply

ShawnB

June 29, 2020

WOW!!! I have to learn and practice this because I’m MANUALLY managing data… THIS will give me back about 40hrs a week down to about 10 mins. AMAZING! Thank you!!!

Reply

Arief Fadilla De Mello

June 29, 2020

Dude. This. Is awesome

Reply

Aditya

June 29, 2020

how to disable power pivot add-in, in case of error occurs?

Reply

M. Q

June 29, 2020

Oh, that's a great video I was searching about
You can't imagine how much I pleased to see this training.

Thnks alot

Reply

Lalu Pasha

June 29, 2020

I really liked this vedio sir…Thanks for your services

Reply

Kayla Aworinde

June 29, 2020

Fantastic fantastic. teaching. Can you please create data analytic video's in a business context e.g spend analytics

Reply

Ovan Oakley

June 29, 2020

Absolutely amazing stuff! great job!

Reply

khoun tola

June 29, 2020

Thanks Man, English is my second language and I did not learn Excel from school. I am just trying to learning everything by myself around my small town. I have to say you nailed it with this video. Thanksssssss

Reply

Yalmar Ponce

June 29, 2020

amazing explanation! Thanks.

Reply

Krishantha Dharmasena

June 29, 2020

YOUR AMAZED ME, THANKS FOR EVERY EFFORT, WONDER YOU HAVE PDF FOR THIS TUTORIAL,PLEASE LET ME KNOW SIR,

Reply

FUBOL7

June 29, 2020

Amazing video. Thanks so much for sharing. I needed this. I have been doing everything manually.

Reply

Martina T

June 29, 2020

Another awesome awesome video!!! Thank you so much!!

Reply

Daniel Morales

June 29, 2020

Amazing video, thank you!!

Reply

AliuOFLagos

June 29, 2020

Loved this video but, I have really unstructured data with lots of lines to make changes, is there a way to use PP to clean data quicker?

Reply

Kamalesh Vasudeva

June 29, 2020

You ……. are…….. amazing. I wish I could give double thumbs up for this video. But don't mind, I could only manage one 😉

Reply

Leave a Reply