Basic Excel Business Analytics #26: Box & Whisker Plot. Chart Example in Excel 2016 (05:21 min)

Chapter 02.5: Import, Clean, Transform Data:

This section of downloads and videos is setup slightly different that the previous sections. The difference is that the Excel downloadable files are listed below the links for each video link.

PowerPoint File to download:
BI348-Chapter02.5-ImportCleanTransformData.pptx  (PowerPoint has all notes for this section - there is no chapter in the textbook).

Homework Files:
ImportTextFilesForHomeworkPr-04.zip
BI348Chapter02.05-HW.xlsx

Videos to watch and files to download for Chapter 02.5 (Import, Clean, Transform Data):

Video Link: Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC  (29:48 imn)
Download files for video #27:
BI348-Chapter02.5-ExcelDataTransformMethods.xlsx
BI348-Chapter02.5-ExcelDataTransformMethodsFinished.xlsx

Video Link: Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard (21:53 min)
Video Link: Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model  (11:19 min)
Video Link: Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform  (05:13 min)
Download files for videos #28 & 29 & 30:
Import-01-TxtCvsFiles.zip
BI348-Chapter02.5-Import01-TextFiles.xlsx
BI348-Chapter02.5-Import01-TextFilesFinished.xlsx
BI348-Chapter02.5-Import01-TextFilesFinishedNoDataModel.xlsx

Video Link: Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each  (12:06 min)
Download files for videos #31:
Import-02-ExcelFilesOneSheetEach.zip 
BI348-Chapter02.5-Import02.xlsx
BI348-Chapter02.5-Import02Finished.xlsx 

Video Link: Basic Excel Business Analytics #32: Power Query Import Multiple Excel Files with Multiple Sheets (08:58 min)
Download files for videos #32:
Import-03-ExcelFilesMultipleSheetsEach.zip
BI348-Chapter02.5-Import03.xlsx
BI348-Chapter02.5-Import03Finished.xlsx

Video Link: Basic Excel Business Analytics #33: Power Query: Transform Many Bad Data Files into Proper Data Set  (11:21 min)
Download files for videos #33:
Import-04-ExcelNotProperDataSets.zip
BI348-Chapter02.5-Import04.xlsx
BI348-Chapter02.5-Import04Finished.xlsx

Video Link: Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources (Access, Text, Excel)  (05:00 min)
Download files for videos #34:
Import-05-SeparateFileTypes.zip
BI348-Chapter02.5-Import05.xlsx
BI348-Chapter02.5-Import05Finished.xlsx

Video Link:  Basic Excel Business Analytics #35: Power Query to Get Data From the Web and Import into Excel  (03:00 min)
Download files for videos #35:
BI348-Chapter02.5-Import06.xlsx
BI348-Chapter02.5-Import06Finished.xlsx

Video Link:  Basic Excel Business Analytics #36: Power Query to Unpivot Data (Multiple Columns to Single Column) (06:15 min)
Video Link: Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature   (06:51 min)
Download files for videos #36 & 37:
BI348-Chapter02.5-Import07.xlsx
BI348-Chapter02.5-Import07Finished.xlsx

Video Link:  Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model  (10:55 min)
Download files for videos #38:
Import-08-4MillionsRowsIntoDataModel.zip
BI348-Chapter02.5-Import08-TextFiles.xlsx
BI348-Chapter02.5-Import08-TextFilesFinished.xlsx
BI348-Chapter02.5-Import08-ExcelFiles.xlsx
BI348-Chapter02.5-Import08-ExcelFilesFinished.xlsx

Video Link:  Basic Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships?  (12:18 min)
Download files for videos #39:
Import-09-SalesTable.txt
Import-09-SR-RegionTable.xlsx
BI348-Chapter02.5-Import09.xlsx
BI348-Chapter02.5-Import09Finished.xlsx

Chapter 02.75: Introduction to Building Data Models with Power Pivot:

PowerPoint Files to download:
BI348-Chapter02.75-PowerPivot.pptx

Video Link:  Basic Excel Business Analytics #40: Introduction to PowerPivot & Data Modeling  (36:22 min)
Video Link:  Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model  (10:52 min)
Download files for videos #40 & 41:
BI348-Chapter02.75Example01Start.xlsx
BI348-Chapter02.75Example01Finished.xlsx

Download files for videos #42: Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example  (01:04:01 1 hour, 4 minutes, 1 second)
BI348-Chapter02.75Example02-SourceData.zip
BI348-Chapter02.75Example02Start.xlsx
BI348-Chapter02.75Example02Finished.xlsx