Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm 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.