<< Back To M Girvin Home Page

Highline College BI 348: Big Data Business Analytics with Microsoft Power Tools 

Syllabus (click to view pdf, right-click to download file)
Introductory Video (click to view video)

Videos & Files & Handouts & Assignments by Week:

Week 1:

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.   

Week 1 Assignments for Points in Class Toward Your Grade:

PointsProject 01 Zipped Folder with Project  Description and Files (download and then unzip):   Project01-BI348.zip       (When you have completed the Project, upload to Canvas)
Take Quiz 01 at Canvas

Week 2:

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 
    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  

Week 2 Assignments for Points in Class Toward Your Grade:

PointsProject 02 Zipped Folder with Project  Description and Files (download and then unzip):   Project02-BI348.zip       (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 02 at Canvas

Week 3:

Video/Class Project 11:
Video to watch:   Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01   ( 12:12 min)
Start file for Video/Class Project to download:  001-MSPTDA-IntroToClass.xlsx   
Handout to download:  001-MSPTDA-IntroToClass.pdf 
Assigned Homework:  HW:  No Homework for this video

Video/Class Project 12:
Video to watch:   MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class   ( 31:25 min)
Start file for Video/Class Project to download:  002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.xlsx
Handout to download:   002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.pdf    
Assigned Homework:  HW:  No Homework for this video

Video/Class Project 13:
Video to watch:   MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop   ( 57:12 min)
Start files for Video/Class Project to download:     
    003-MSPTDA-IntroToPowerQueryStartFile.xlsx
    MSPTDA-003-AccessData.accdb
    MSPTDA-003-TextFiles.zip
Finished files (completed after video done):
    003-MSPTDA-IntroToPowerQueryFinishedFile.xlsx
MSPTDA-003-PowerBITextImportFinished.pbix
pdf Notes Handout to download: 003-MSPTDA-IntroToPowerQuery.pdf  
Assigned Homework: 
    Download Word Document and read: MSPTDA-003-HomeworkDescription.docx
    Then download the rest of the files and complete the homework:
        MSPTDA-003-ImportTextFilesForHomework.zip
    Examples of Finished Homework:
        MSPTDA-003-FinishedHomework.xlsx
        MSPTDA-003-FinishedHomework.pbix

Video/Class Project 14:
Video to watch:   MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set   ( 32:02 min)
Start files for Video/Class Project to download:     
    004-MSPTDA-StartFile-PowerQueryImportExcelFilesAppend.xlsx
    004-MSPTDA-ExcelFiles.zip
    SanJose.xlsx
Finished files (completed after video done):  004-MSPTDA-FinishedFile-PowerQueryImportExcelFilesAppend.xlsx
pdf Notes Handout to download:  004-MSPTDA-PowerQueryImportMultipleExcelFilesAppend.pdf  
Assigned Homework: 
    Download Word Document and read: 004-MSPTDA-HomeworkDescription.docx
    Then download the rest of the files and complete the homework:
        004-MSPTDA-Homework-ExcelFiles.zip
    Examples of Finished Homework:
        004-MSPTDA-Homework-PowerPivot-Answer.xlsx
        004-MSPTDA-Homework-PowerBI-Desktop-Answer.pbix

Video/Class Project 15:
Video to watch:   MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook   ( 27:44 min)
Start files for Video/Class Project to download:     
    005-01-MSPTDA-StartFile-PQAppendAllTablesCurrentWorkbook.xlsx
    005-02-MSPTDA-StartFile-PQAppendAllTablesCurrentWorkbook.xlsx
Finished files (completed after video done): 
    005-01-MSPTDA-FinishedFile-PQAppendAllTablesCurrentWorkbook.xlsx
    005-02-MSPTDA-FinishedFile-PQAppendAllTablesCurrentWorkbook.xlsx
pdf Notes Handout to download:  005-MSPTDA-PQAppendAllTablesCurrentWorkbook.pdf  
Assigned Homework: 
    Download Excel File with Homework: 005-MSPTDA-Homework-Start.xlsx
    Example of Finished Homework: 005-MSPTDA-Homework-Finished.xlsx
       

Video/Class Project 16:
Video to watch:    MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations   ( 23:38 min)
Start files for Video/Class Project to download:     
    006-MSPTDA-StartFilePowerQueryMergeAppendUnPivot.xlsx
    006-MSPTDA-dSalesRepTable.xlsx
    006-MSPTDA-dTerritoryTable.txt
   
Finished files (completed after video done): 
    006-MSPTDA-FinishedFilePowerQueryMergeAppendUnPivot.xlsx
   
pdf Notes Handout to download:  006-MSPTDA-PowerQueryImportCurrentWorkbook.pdf  
Assigned Homework: 
    Download Excel File with Homework: 006-MSPTDA-Homework-Start.xlsx
    Download Files to import for Merge Homework:
            006-MSPTDA-HomeworkExcelSalesTable.xlsx
            006-MSPTDA-HomeworkTextdProductTable.txt
    Example of Finished Homework:
        006-MSPTDA-Homework-Finished.xlsx

Week 3 Assignments for Points in Class Toward Your Grade:

PointsProject 03 Zipped Folder with Project  Description and Files (download and then unzip):   Project03-BI348.zip       (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 03 at Canvas

Week 4:

Video/Class Project 17:
Video to watch:    MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples   ( 37:38 min)
Start files for Video/Class Project to download:   007-MSPTDA-PowerQueryJoinsMergesStart.xlsx
Finished files (completed after video done):   007-MSPTDA-PowerQueryJoinsMergesFinished.xlsx
pdf Notes Handout to download:  007-MSPTDA-PowerQueryJoinsMerges.pdf 
Assigned Homework: 
    Download Excel File with Homework: 007-MSPTDA-Homework-Start.xlsx
    Example of Finished Homework: 007-MSPTDA-Homework-Finished.xlsx
       

Video/Class Project 18:
Video to watch:    MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)   ( 30:42 min)
Start files for Video/Class Project to download:   008-MSPTDA-GroupBy-Start.xlsx
Finished files (completed after video done):   008-MSPTDA-GroupBy-Finished.xlsx
pdf Notes Handout to download:  008-MSPTDA-GroupBy.pdf 
Assigned Homework: 
    Download Excel File with Homework:  008-MSPTDA-Homework-Start.xlsx
    Example of Finished Homework:  008-MSPTDA-Homework-Finished.xlsx

Video/Class Project 18.5:
Video to watch:   MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences     ( 07:18 min)
Start files for Video/Class Project to download: 00805-MSPTDA-GroupByConsecutiveOccurances-Start.xlsx 
Finished files (completed after video done): 00805-MSPTDA-GroupByConsecutiveOccurances-Finished.xlsx 
pdf Notes Handout to download:  Sames notes as above for video #8. Just use notes from previous video.
Assigned Homework: 
    Download Excel File with Homework: 008-05-MSPTDA-Homework-Start.xlsx 
    Example of Finished Homework: 008-05-MSPTDA-Homework-Finished.xlsx 

Video/Class Project 19 and 19.5(two videos, but only one pdf file):
Video to watch:   First:       MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop     ( 19 min)
                                  Second:  MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!  (3 min) 
Start files for Video/Class Project to download: 011-MSPTDA-ImportSQLIntoPowerQuery-Start.xlsx 
Finished files (completed after video done): 
    011-MSPTDA-ImportSQLIntoPowerQuery-Finished.xlsx 
    011-MPSTDA-PowerBIDesktop-GetSQL-Data.pbix
pdf Notes Handout to download: 011-MSPTDA-PowerQueryImportSQLData.pdf  
Assigned Homework: 
    Download Homework File: 011-MSPTDA-Homework-Start.xlsx 
    Example of Finished Homework: 011-MSPTDA-Homework-Finished.xlsx 

Week 4 Assignments for Points in Class Toward Your Grade:

PointsProject 04 Zipped Folder with Project  Description and Files (download and then unzip):     Project04-BI348.zip     (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 04 at Canvas

Week 5:

Video/Class Project 20 & 20.5(two videos, but only one pdf file):
Videos to watch:   First:       MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More    ( 01:07:26  min - 1 hour 7 minutes)
                                    Second:  Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)  (05:21 min)
Start files for Video/Class Project to download:
    009-MSPTDA-ValuesExpressionsFunctions-Start.xlsx 
    009-ParameterQueryTables.zip
Finished files (completed after video done): 009-MSPTDA-ValuesExpressionsFunctions-Finished.xlsx 
pdf Notes Handout to download:  009-MSPTDA-ValuesExpressionsFunctions.pdf 
Assigned Homework: 
    Download Excel File with Homework: 009-MSPTDA-Homework-Start.xlsx 
    Example of Finished Homework: 009-MSPTDA-Homework-Finished.xlsx 

Video/Class Project 21:
Video to watch:   MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column      ( 29:39 min)
Start files for Video/Class Project to download:  010-MSPTDA-CustomFunction-MovingAnnualTotals-Start.pbix
Finished files (completed after video done):  010-MSPTDA-CustomFunction-MovingAnnualTotals-Finished.pbix
Excel example: 010-MSPTDA-CustomFunction-MovingAnnualTotals-Excel.xlsx
zipped folder: 010-TextFiles.zip
pdf Notes Handout to download:  010-MSPTDA-CustomFunction-MovingAnnualTotals.pdf 
Assigned Homework: 
    Download pdf file with homework description: 010-MSPTDA-Homework-Start.pdf 
    Example of Finished Homework in Power BI Desktop: 010-MSPTDA-Homework-Finished.pbix 

Video/Class Project 22:
Video to watch:    MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries    ( 20 min)
Start files for Video/Class Project to download: 
    012-MSPTDA-LocaleStart.xlsx 
    zipped folder: TextFiles012.zip
Finished files (completed after video done):
    012-MSPTDA-LocaleFinished.xlsx
    012-MSPTDA-LocaleFinished.pbix  

pdf Notes Handout to download: 012-MSPTDA-Locale.pdf  
Assigned Homework: 
    Download pdf file with homework description: 012-MSPTDA-Homework-Start.docx
    Zipped Text Files: 012-TextFilesForHomework.zip 
    Example of Finished Homework in Excel: 012-HomeworkFinishedExample.xlsx

Week 5 Assignments for Points in Class Toward Your Grade:

PointsProject 05 Zipped Folder with Project  Description and Files (download and then unzip):    Project05-BI348.zip    (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 05 at Canvas

Week 6:

Video/Class Project 23:
Video to watch:    MSPTDA 13: Power Pivot Intro 1: Relationships rather than VLOOKUP for PivotTable Report   ( 15:23 min)
Start files for Video/Class Project to download:     
    013-MSPTDA-RelationshipsRatherThanVLOOKUPStart.xlsx
    Example of file using VLOOKUP Formulas: 013-PivotTablesVLOOKUPFinished.xlsm   
Finished files (completed after video done):
    013-MSPTDA-RelationshipsRatherThanVLOOKUPFinished.xlsx
pdf Notes Handout to download:  013-MSPTDA-RelationshipsRatherThanVLOOKUP.pdf 
Assigned Homework: 
    Download Excel file and complete the homework:   013-HomeworkStart.xlsx
    Examples of Finished Homework:     013-HomeworkFinished.xlsx

Video/Class Project 24:
Video to watch:    MSPTDA 14: Power Pivot Into #2: Amazing Columnar Database for Importing Millions of Rows of Data   ( 19 min)
Start files for Video/Class Project to download:     
    014-MSPTDA-PowerPivotToImportMillionsStart.xlsx
    014MSPTDATextData.zip
Finished files (completed after video done):
    014-MSPTDA-PowerPivotToImportMillionsFinished.xlsx
    014-ImportOneText.xlsx
pdf Notes Handout to download:  014-MSPTDA-ColumnarDatabaseNotes-PowerPivotToImportMillions.pdf 
Assigned Homework: 
    Download Excel file and complete the homework: 014-HomeworkStart.xlsx
    Zipped Folder with Text Files: 014-MSPTDA-HomeworkTextFiles.zip
    Examples of Finished Homework: 014-HomeworkFinished.xlsx  
       
Video/Class Project 25:
Video to watch:    MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions   ( 2 Hours 5 min)
Start files for Video/Class Project to download:     
    Start Excel File: 15Video/015-MSPTDA-ComprehensiveIntroPowerPivot.xlsx
    Zipped Folder with Data: 15Video/015-TextFiles.zip
    Example of DAX that Can't be Done in Standard PivotTable:  015-WhyDAXandNotStandardPivotTable.xlsx
Finished file (completed after video done):     015-FinishedDashboard-Finished.xlsx
pdf Notes Handout to download: 015-MSPTDA-PowerPivotComprehensiveIntroduction.pdf
Assigned Homework: 
    Download Excel File with Instructions for Homework:
    Start Excel File: 015-MSPTDA-Homework-Start.xlsx
    Zipped Data Folder: 015-MSPTDA-HomeworkExcelDataFiles.zip
    Examples of Finished Homework:  015-MSPTDA-Homework-Finished.xlsx      

Week 6 Assignments for Points in Class Toward Your Grade:

PointsProject 06 Zipped Folder with Project  Description and Files (download and then unzip):    Project06-BI348.zip  (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 06 at Canvas

Week 7:

Video/Class Project 26 & 27 (two videos, but only one pdf file):
Video to watch:     MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing  ( 1 hour 19 mins)   
Video to watch:   MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets.     (8.5  minutes)
Start files for Video/Class Project to download:  016-TextFiles.zip
Finished files (completed after video done): 
    016-MSPTDA-IntroToPowerBIFinished.pbix (File used in video 16 & 17)
    1366PowerBI-ReportFinished.pbix (File used in video 17)
    017-DashBoardAndPublishExcel.xlsx (File used in video 17)
pdf Notes Handout to download:  016and017-MSPTDA-IntoductionPowerBIDesktop.pdf   
Assigned Homework for video #16: 
    Word document with homework problem description :  HomeworkVideo016.docx
    Zipped Files for homework: CityTextFiles.zip
    Examples of Finished Homework:  016-MSPTDA-HomeworkFinished.pbix  

Published Report for Public Consumption (as seen in video #16):

Week 7 Assignments for Points in Class Toward Your Grade:

PointsProject 07 Zipped Folder with Project  Description and Files (download and then unzip):    Project07-BI348.zip    (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 07 at Canvas

Week 8:

Video/Class Project 28:
Video to watch:    MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI   ( 1 hour 7 mins)

Download all 14 files used in video, including homework files as zipped folder: FilesUsedInVideo18.zip

Start files for Video/Class Project to download:     
    018-MSPTDA-DAX-IteratorsTables-Start.xlsx
        Zipped Folder with data that was already loaded into previous file (018-MSPTDA-DAX-IteratorsTables-Start.xlsx ): 018Files.zip
    018-MSPTDA-DoubleCountStart.pbix
    018-MSPTDA-ALLVALUES-Start.xlsx
    018-MSPTDA-BigData.pbix
        Zipped Folder with data that was already loaded into Two previous "BigData" files: 018BigDataTextFiles.zip
Finished files (completed after video done):
    018-MSPTDA-DAX-IteratorsTables-Finished.xlsx
    018-MSPTDA-DoubleCountFinished.pbix
    018-MSPTDA-ALLVALUES-Finished.xlsx

pdf Notes Handout to download:  018-MSPTDA-DAX-IteratorsTables.pdf   
Assigned Homework: 
    Download Word Document and read: HomeworkVideo018.docx
    Then download the rest of the files and complete the homework:
        018-MSPTDA-HomeworkFile01Start.pbix
    Examples of Finished Homework:
        018-MSPTDA-HomeworkFile01Finished.pbix
        018-MSPTDA-HomeworkFile02Finished.pbix
       

Video/Class Project 29:
Video to watch:    MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS   ( 1 hour 48 minutes)

Download all 20 files used in video as zipped folder: FilesUsedInVideo19.zip

13 individual files available here:
Start files for Video/Class Project to download:     
    019-MSPTDA-CALCULATE-FilterContext-01-Start.xlsx (Excel File)
    019-MSPTDA-CALCULATE-FilterContext-01-Start.pbix (Power BI File)
    019-MSPTDA-CALCULATE-FilterContext-02-Start.pbix (Power BI File)
    019-MSPTDA-CALCULATE-FilterContext-03-Start.xlsx (Excel File)
    019-TableFilterExamplesStart.xlsx (Excel File)
    019-StarSchemaDataModel.xlsx (Excel File) This file just has picture of Star Schema Data Model
    019-SnowFlakeDataModel.xlsx (Excel File) This file just has picture of Snow Flake Data Model
Finished files (completed after video done):
    019-MSPTDA-CALCULATE-FilterContext-01-Finished.xlsx (Excel File)
    019-MSPTDA-CALCULATE-FilterContext-01-Finished.pbix (Power BI File)
    019-MSPTDA-CALCULATE-FilterContext-02-Finished.xlsx (Excel File) ... There is no start file for this. This is used for an example in the pdf notes.
    019-MSPTDA-CALCULATE-FilterContext-02-Finished.pbix (Power BI File)
    019-MSPTDA-CALCULATE-FilterContext-03-Finished.xlsx (Excel File)
    019-TableFilterExamplesFinished.xlsx (Excel File)

pdf Notes Handout to download:  019-MSPTDA-CALCULATE-FilterContext.pdf   

Assigned Homework: 
    Download Word Document and read: HomeworkVideo019.docx
    Then download the rest of the files and complete the homework:
        019-MSPTDA-HomeworkStart.xlsx
        019-MSPTDA-HomeworkStart.pbix
    Examples of Finished Homework:
        019-MSPTDA-HomeworkFinished.xlsx
       

Week 8 Assignments for Points in Class Toward Your Grade:

PointsProject 08 Zipped Folder with Project  Description and Files (download and then unzip):    Project08-BI348.zip   (When you have completed the Project, upload the Excel File to Canvas)
Take Quiz 08 at Canvas

Week 9:

Video/Class Project 30:
Video to watch:   MSPTDA 20: Data Source Folder Path Query Parameter, Power Query & Power BI, Dynamic Folder Location    ( 11 min)

Download all 6 files and folders with text files used in video as zipped folder: MSPTDA-20-DownloadAllFiles.zip

13 individual files available here:
Start files for Video/Class Project to download:     
    MSPTDA-20-TextFiles.zip (Folder with Text Files)
    NewLocationsFoprMSPTDA-20_TextFiles.zip
    020-MSPTDA-PQParameterDataSource-Start.xlsx (Excel File)
    020-MSPTDA-PQParameterDataSource-Start.pbix (Power BI File)

Finished files (completed after video done):
    020-MSPTDA-PQParameterDataSource-Finished.xlsx (Excel File)
    020-MSPTDA-PQParameterDataSource-Finished.pbix (Power BI File)

pdf Notes Handout to download:  020-MSPTDA-PQParameterDataSource.pdf   

Assigned Homework:  NONE

Video/Class Project 31:
Video to watch:    MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size   ( 25 min)

Download all 4 files and folders with text files used in video as zipped folder: MSPTDA-21-DownloadAllFiles.zip  

3 individual files available here:
Start files for Video/Class Project to download:  021-MSPTDA-ReduceDataModelSize-Start.xlsx   
Finished files (completed after video done):  021-MSPTDA-ReduceDataModelSize-Finished.xlsx  
pdf Notes Handout to download:  021-MSPTDA-ReduceDataModelSize.pdf 

Assigned Homework:  
Download pdf file and read:   HomeworkVideo021.pdf
No solution given for this one.

Video/Class Project 32:
Video to watch:    MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations    ( 20 min)

Download all 7 files and folders with text files used in video as zipped folder:   MSPTDA-22-DownloadAllFiles.zip

4 individual files available here:
Start files for Video/Class Project to download:   
    021-MSPTDA-downtime.csv (CSV File for data import - it says #21, but it is the correct data import file for this video #22)
    022-MSPTDA-DateTimeDimTable-Start.pbix (Start Power BI File)
Finished files (completed after video done):    
    022-MSPTDA-DateTimeDimTable-Finished.pbix (Finished Power BI File)
pdf Notes Handout to download:   022-MSPTDA-DateTimeDimTable.pdf

Assigned Homework:       
Download pdf file and read:  HomeworkVideo022.pdf
Homework Source Data File: HomeworkSourceData022.xlsx
Solution: Homework-022-Finished.pbix

Week 9 Assignments for Points in Class Toward Your Grade:

PointsProject 09  Description:  BI348-Project09-Description.pdf    (When you have completed the Project, upload the File/Files to Canvas)
Take Quiz 09 at Canvas

Week 10:

Video/Class Project 33:
Video to watch:   MSPTDA 23: Two Fact Tables? Converted into One? DAX, Power Query or Excel Worksheet Formulas?     ( 1 hour 9  min)

Download all 10 files and folders with text files used in video as zipped folder: MSPTDA-23-DownloadAllFiles.zip  

Individual files available here for each section of the video:
Excel Section of Video:   
     EMT1493Start.xlsx
    EMT1493Finished.xlsx
DAX Section of Video:   
     EMT1494Start.xlsx
    EMT1494Finished.xlsx
Power Query Section of Video:   
     EMT1498-SourceModel.xlsx (Model in Excel File must be imported into new Power BI Desktop file)
    EMT-1498-PowerBIDesktopPowerQuery.pbix (Finished)
pdf Notes Handout to download:  023-MSPTDA-TwoFactTables.pdf 

Assigned Homework:       
Download pdf file and read:  HomeworkVideo023.pdf
Homework Source Data File: HomeworkVideo023-SourceTables.xlsx

Video/Class Project 34:
Video to watch:   MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!      ( 6.5 min)

Individual files available here for each section of the video:
    Start:  024-MSPTDA-NumberDataTypesMath-Start.xlsx
    Finished: 024-MSPTDA-NumberDataTypesMath-Finished.xlsx
pdf Notes Handout to download:  024-MSPTDA-MultiplyDivideAndDataTypes.pdf 

Assigned Homework:  NONE

Video/Class Project 35 & 36:
Video to watch:   MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH      ( 13:37  min)
Video to watch:   MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop      ( 17:27  min)

Download all 4 files and folders with text files used in video as zipped folder:  MSPTDA-25-26-DownloadAllFiles.zip 

Individual files available here for each section of the video:
Excel Example (#25):   
     MSPTDA-25-ActualVsBudget-Excel.xlsx
Data Model & DAX Example (#26):   
     Start: MSPTDA-26-ActualVsBudget-DAXAndDataModel-Start.xlsx
    Finished:MSPTDA-26-ActualVsBudget-DAXAndDataModel-Finished.xlsx

pdf Notes Handout to download: 025-26-MSPTDA-BudgetVsActual.pdf  

Assigned Homework:   NONE

Video/Class Project 37 & 38:
Video to watch:   MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships       ( 13:37  min)
Video to watch:   MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship      ( 10:50   min)

Download all 6 files and folders with text files used in video as zipped folder:  MSPTDA-27-28-DownloadAllFiles.zip 

Individual files available here for each section of the video:
Excel Example (#27):  MSPTDA-27-ManyToManyRelationship.xlsx
Power Query & Data Model & DAX Example (#28):   
     Start:
        Excel: MSPTDA-28-Start-PQBridgeManyToManyRelationship.xlsx
        Power BI Desktop: MSPTDA-28-Start-PQBridgeManyToManyRelationship.pbix
    Finished:
        Excel: MSPTDA-28-Finished-PQBridgeManyToManyRelationship.xlsx
        Power BI Desktop: MSPTDA-28-Finished-PQBridgeManyToManyRelationship.pbix
pdf Notes Handout to download: 027-28-MSPTDA-ManyToMany.pdf  

Assigned Homework:   NONE

Video/Class Project 39 & 40:
Video to watch:    MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas      ( 10:19  min)
Video to watch:   MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports      ( 10:18   min)

Download all 6 files and folders with text files used in video as zipped folder:  MSPTDA-29-30-DownloadAllFiles.zip 

Individual files available here for each section of the video:
Worksheet Formula Example (#29): MSPTDA-29-Worksheet-OrderShipDates.xlsx 
Data Model & DAX Example (#30):   
     Start:
        Excel Power Pivot: MSPTDA-30-1-DAX-Start-SideBySideReport-OneDateTable.xlsx
        Power BI Desktop: MSPTDA-30-2-DAX-Start-CrossTabReport-TwoDateTables.pbix
    Finished:
        Excel Power Pivot: MSPTDA-30-1-DAX-Finished-SideBySideReport-OneDateTable.xlsx
        Power BI Desktop: MSPTDA-30-2-DAX-Finished-CrossTabReport-TwoDateTables.pbix
pdf Notes Handout to download: 029-30-MSPTDA-OrderShipDates.pdf  

Assigned Homework:   NONE

Video/Class Project 41:
Video to watch:   MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT?  ( 15 min)

Download all 6 files used in video as zipped folder: FilesUsedInVideo31.zip

pdf Notes Handout to download:  031-MSPTDA-FasterAverages.pdf 

Assigned Homework:  NONE

Video/Class Project 42-45:

Video to watch:     MSPTDA 32: Data Modeling for Slowly Changing Dimensions with Worksheet Formulas  (8:33 mins)
Video to watch:     MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable  (12:45) mins
Video to watch:     MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not  (7.09 mins)
Video to watch:     MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot  (11:29 mins)
Video to watch:     MSPTDA 35: Data Modeling for Slowly Changing Dimensions with Power BI & DAX  (10:30 mins)

Download All Files In Zipped Folder: MSPTDA32-35Files.zip

Download Invidual files:
MSPTDA32: MSPTDA-032-ChangingDimensions-PQAndWorksheetFormula.xlsx
MSPTDA33:  MSPTDA-033-ChangingDimensions-PQAndStandardPivotTableStart.xlsx and  MSPTDA-033-ChangingDimensions-PQAndStandardPivotTableFinished.xlsx
MSPTDA 33 Part 2:  MSPTDA-033-Part02-ChangingDimensions-PQAndStandardPivotTableStart.xlsx  and   MSPTDA-033-Part02-ChangingDimensions-PQAndStandardPivotTableFinished.xlsx
MSPTDA 34:  MSPTDA-034-ChangingDimensions-PQAndPowerPivotStart.xlsx  and  MSPTDA-034-ChangingDimensions-PQAndPowerPivotFinished.xlsx 
MSPTDA 35:  MSPTDA-035-ChangingDimensions-PowerBIAndDAXStart.pbix  MSPTDA-035-ChangingDimensions-PowerBIAndDAXFinished.pbix 
pdf notes: 032-35-MSPTDA-ChangingDimensions.pdf

Assigned Homework:   NONE

Video/Class Project 46:
Video to watch:     MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables    ( 13 min)
Start files for Video/Class Project to download:   036-MSPTDA-SampleFileParameterForCustomFunction-Start.xlsx
Finished files (completed after video done):   036-MSPTDA-SampleFileParameterForCustomFunction-Finished.xlsx
pdf Notes Handout to download: none
Assigned Homework:  none

Week 10 Assignments for Points in Class Toward Your Grade:

PointsProject 10 Zipped Folder with Project  Description and Files (download and then unzip):    Project10-BI348.zip    (When you have completed the Project, upload the File/Files to Canvas)
Take Quiz 10 at Canvas

Old BI 348 Class: BI 348