Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model

Learn about how to use Power Query to import multiple Large .csv files (text files) from a single folder into the Data Modle so we can create reports in a file with dramatically smaller file size:
1) (00:04) Notes about downloading files
2) (00:27) Look at large .csv files we need to import
3) (00:55) Talk about file size reduction when importing data into Data Model rather than importing into Excel Sheet.
4) (01:37) Power Query to import .csv files From Folder
5) (04:50) Load to “Only Create Connection” and “Add this to the Data Model”
6) (05:35) What is Data Model.
7) (07:35) Excel data Model to reduce files size
8) (07:50) Build PivotTable report with slicers and a column chart. In Create PivotTable dialog box, click “Use an external data source”, Choose Connection, Table Tab.
9) (05:12) Note: When you use Data Model, Dates cannot be grouped in the PivotTable (how to get around this in an upcoming video)
19) (09:57) Drop new CSV Files in original folder and see that the entire system: 1) Power Query Import and Data Transformation, 2) PivotTables and 3) Charts updates when we refresh with the keyboard Ctrl + Alt + F5.
10) (10:50) Summary and Conclusion

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[wittepinda]

I watched this #29 on its own and it was wonderful. Everything I wanted to know at this point to import a whole folder and making it work. Very clear and almost intrusive (in a good way) method of speaking to make me understand it fully. Thanks a million!

[Luciano_mp]

Uma série excelente Basic Excel Business Analytics, juntou o Power Query, ficou espetacular. Obrigado Mike.

[aussteeladmin]

I'm looking at the Power Query abilities and I have at this stage 2.CSV files that have multiple "table arrays" in them. what I would like to do is based on a selector like a table array and drop down, to select the corresponding .csv table within the file, duplicate it depending on qty, and then have that being exported out as a new CSV file.

[rkdexceltips]

one question : when ALT+N+V power pivot window comes there are two option comes (connection and table) and under both option query name is showing as (importcsvsalesdata) and (powe query -importcsvsalesdata). why you picked query name (importcsvsalesdata) from table option and not from connection option? plz reply
Can we also selection query name from (powe query -importcsvsalesdata) under connection option

[jimconley]

Is there an Excel book you would suggest?

[AlexSmith-trhc]

Nice video. However, at 10:30, CTRL+ALT+F5 does not appear to Refresh my data.

[eddisonbuenano]

I've taken this step, but my dates wont separate them selves out to the hour. Where can I find this out?

[Ychhenghak]

When we close xlsx workbook, will the connection still connect?

[donpeps]

I have not been able to get POwer QUERY because it says it is associated with Excel 2010 and Excel 2013 and I have Excel 2016. How can i get access to it then please?

[kasturi]

Thank you so much for this this video...You explain so beautifully & make it seem simple....