BI348

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 1:
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 2:
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 3:
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 4:
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 5:
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 6:
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 1 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 2:

Video/Class Project 7:
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 8:
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 8.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 11 and 11.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 2 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 3:

Video/Class Project 9:
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 10:
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 12:
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 3 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 4:

Video/Class Project 13:
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 14:
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 15:
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 4 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 5:

Video/Class Project 16 & 17 (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 5 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 6:

Video/Class Project 18:
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 (This file is connected to files in "018Files" Folder. If this Excel File and the "018Files" folder are saved to same location, the data connections works).
        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 19:
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 6 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 7:

Video/Class Project 20:
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 21:
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 22:
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 7 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 8:

Video/Class Project 23:
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 24:
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 25 & 26:
Video to watch:   MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH    ( 06:17 min)
Video to watch:   MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop    ( 10:51 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

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

Week 9:

Video/Class Project 27 & 28:
Video to watch:   MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships    ( 13:38 min)
Video to watch:   MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship    ( 17:27 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 29 & 30:
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 36:
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 9 Assignments for Points in Class Toward Your Grade:

PointsProject 11 is an Excel File with Project Description tables inside Workbook: BI348-Project11.xlsm (When you have completed the Project, upload the File/Files to Canvas)

Video/Class Project 31:
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 32-35:

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

Assigned Homework: NONE

Old Class #1: Microsoft Big Data with MS Tools Version: BI 348 - 1 ...

Old Clss #2: Statistics Based Version: BI 348 - 2