Data Analysis & Business Intelligence Made Easy with Excel Power Tools
Excel Data Analysis Basics = E-DAB
10 Videos about the Basics of Data Analysis:
Video/Class
Project 01:
Video to watch:
E-DAB 01: Excel Data Analysis & BI Basics Class 01: What is Data
Analysis & Business Intelligence? ( 12:41 min)
PowerPoint Video Notes:
E-DAB-01-IntroductionToClass.pptx
Assigned Homework: No Homework for this video
Video/Class
Project 02:
Video to watch:
E-DAB 02: Excel Data Analysis & BI Basics:
Data, Proper Data Sets, Excel Tables, Logical Tests, More ( 35:26 min)
Start file for Video/Class Project to download: E-DAB-02-Start-DataTablesFilterLogicTest.xlsx
Finished file for Video/Class Project to download: E-DAB-02-Finished-DataTablesFilterLogicTest.xlsx
pdf notes: E-DAB-02-DataTablesFilterLogicTest.pdf
Assigned Homework: In the above Excel Download file named
"E-DAB-02-Start-DataTablesFilterLogicTest.xlsx", at the end of the worksheets
are 3 problmes for you to complete. The problems are on the blue sheets and the
answers are on the red sheets.
Video/Class
Project 03:
Video to watch:
E-DAB 03: Excel Data Analysis & BI Basics: Excel Spreadsheet Formulas Old
School? Or Dynamic Arrays?
( 29:52 min)
Start file for Video/Class Project to download: E-DAB-03-FormulasStart.xlsx
Finished file for Video/Class Project to download: E-DAB-03-FormulasFinished.xlsx
pdf notes: E-DAB-03-Formulas.pdf
Assigned Homework: In the above Excel Download file named
"E-DAB-03-FormulasStart.xlsx ", at the end of the worksheets
are 2 problmes for you to complete. The problems are on the blue sheets and the
answers are on the red sheets.
Video/Class
Project 04:
Video to watch:
E-DAB 04: Excel Data Analysis & BI Basics:
PivotTables & Slicers to Create Dashboards & Summary Reports ( 29 min)
Start file for Video/Class Project to download: E-DAB-04-PivotTablesStart.xlsx
Finished file for Video/Class Project to download: E-DAB-04-PivotTablesFinished.xlsx
pdf notes:
E-DAB-04-PivotTables.pdf
Assigned Homework: In the above Excel
Download file named "E-DAB-04-PivotTablesStart.xlsx ", at the end of the worksheets
are 4 problmes for you to complete. The problems are on the blue sheets and the
answers are on the red sheets.
Video/Class
Project 05:
Video to watch:
E-DAB
05: Excel Data Analysis & BI Basic: Visualizing Data w Tables, Charts,
Formatting & Dashboards ( 54:40 min)
Start file for Video/Class Project to download: E-DAB-05-Visualizations-Start.xlsx
Finished file for Video/Class Project to download: E-DAB-05-Visualizations-Finished.xlsx
pdf notes:
E-DAB-05-Visualizations.pdf
Assigned Homework: In the above Excel
Download file named "E-DAB-05-Visualizations-Start.xlsx ", at the end of the worksheets
are 5 problmes for you to complete. The problems are on the blue sheets and the
answers are on the red sheets.
Video/Class
Project 06:
Video to watch:
E-DAB
06: Excel Data Analysis & BI Basics: The Magic of Power Query to Import,
Transform & Load Data ( 26:39 min)
All files needed to follow along with video and do homework are in this zipped
folder you can download:
DownloadFilesForEDAB06.zip
If you want, you can donwload files individually:
Excel Start File:
E-DAB-06-PowerQuery-Start.xlsx
Excel Finished File:
E-DAB-06-PowerQuery-Finished.xlsx
Text files for video example #1:
Ex01March2019.txt , Ex01April2019.txt
Text
Files for Example #2: EB25FileDownloads.zip
pdf notes: E-DAB-06-PowerQuery.pdf
Homework #2 Text File HW02CarDealerSurveyData.txt
Assigned Homework: In the above Excel
Download file named "E-DAB-06-PowerQuery-Start.xlsx " at the end of the worksheets
are 2 problmes for you to complete. The problems are on the blue sheets and the
answers are on the red sheets. Text file for Homewprk #2 is above and is
named "HW02CarDealerSurveyData.txt ".
Video/Class
Project 07:
Video to watch:
E-DAB 07: Excel Data Analysis & BI Basics:
Data Modeling: Excel Formulas, Power Query, Power Pivot?
( 45:20 min)
All files needed to follow along with video and do homework are in this zipped
folder you can download:
DownloadFilesForEDAB07.zip
If you want, you can donwload files individually:
Excel Start File:
E-DAB-07-DataModeling-Start.xlsx
Access Data Source File:
E-DAB07-AccessData.accdb
Excel Finished File:
E-DAB-07-DataModeling-Finished.xlsx
pdf notes: E-DAB-07-DataModeling.pdf
Assigned Homework:
Homework instructions and problem are in this Excel Workbook
file: E-DAB-07-HomeworkStart.xlsx solution
to homework is here:
E-DAB-07-HomeworkFinished.xlsx
Video/Class
Project 08:
Video to watch:
E-DAB
08: Excel Data Analysis & BI Basics: Power Pivot: Big Data, Data Modeling, DAX &
Dashboard ( 44:41 min)
All files needed to follow along with video and do homework are in this zipped
folder you can download:
DownloadFilesForEDAB08.zip
If you want, you can donwload files individually:
Excel Start File: E-DAB-08-SQLBigDataDAXFormualsStart.xlsx
Excel Finished File:
E-DAB-08-SQLBigDataDAXFormualsFinished.xlsx
pdf notes: E-DAB-08-SQLBigDataDAXFormuals.pdf
Assigned Homework:
Homework instructions and problem are in this Excel Workbook
file: E-DAB-08-HomeworkStart.xlsx solution
to homework is here:
E-DAB-08-HomeworkFinished.xlsx
Video/Class
Project 09:
Video to watch: E-DAB
09: Power BI Desktop: Data Modeling & Interactive Visualizations (Data Analysis
& BI Basics)
( 37:36 min)
All files needed to follow along with video and do homework are in this zipped
folder you can download:
DownloadFilesForEDAB09.zip
If you want, you can donwload files individually:
Excel Start File:
E-DAB-09-PowerBISourceTables.xlsm
Zipped Folder with Files:
E-DAB-09-PowerBISourceZippedExcelTables.zip
Power BI Desktop Finished File:
E-DAB-09-PowerBIReportFinished.pbix
pdf notes: E-DAB-09-PowerBIDesktop.pdf
Assigned Homework:
Homework instructions and problem are in this
Word
file:
E-DAB-09-HomeworkProblem-PowerBI.docx solution
to homework is here:
E-DAB-09-HomeworkFinished.pbix
Video/Class
Project 10:
Video to watch: E-DAB-10:
Excel & Power BI Together! Import, Publish and Share (Excel Data Analysis & BI
Basics)
( 14:36 min)
All files needed to follow along with video and do homework are in this zipped
folder you can download:
DownloadFilesForEDAB10.zip
If you want, you can donwload files individually:
Excel Start Source Table File:
E-DAB-10-ExcelFileSourceTables.xlsx
Excel Start Source Data Model File:
E-DAB-10-ExcelFileWithDataAndReports.xlsx
Power BI Desktop Start File:
E-DAB-10-PowerBIDesktop-Start.pbix
Important Notes:
Hints about Importing Excel Data Model into Power BI Desktop File.docx
(Steps for Importing Excel Data Model into Power BI File with the new
User Interface in 2020 Power BI Desktop).
Power BI Desktop Finished File:
E-DAB-10-PowerBIDesktop-Finished.pbix
pdf notes: E-DAB-10-ExcelAndPowerBIShare.pdf
Assigned Homework:
Homework instructions and problem are in this
zipped fodler: E-DAB-10-HomeworkFiles.zip