BI 348 - Data Analysis with Microsoft Power Tools
Excel, Power Query, Spilled Arrays, PivotTables, Power Pivot, Power BI, Data Models, M Code, DAX and more!
BI 348 - Data Analysis with Microsoft Power Tools
Excel, Power Query, Spilled Arrays, PivotTables, Power Pivot, Power BI, Data Models, M Code, DAX and more!
Class Content (Videos, Excel Files, PDF Note Files, Test Files):
Week 1:
Video to watch:
MS
365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting,
Data Analysis Tips! (36
mins)
Excel File Download: ExcelBasics08.xlsx (1 practice problem at end of worksheets)
pdf notes: ExcelBasics08.pdf
Download Excel workbook project for Excel Basics 08 video: BI348Project01.xlsx . When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Week 2:
Video to watch:
PivotTables
Can't, But PIVOTBY & GROUPBY Can ! 10 Mind-Blowing Examples! MS 365 Excel
Basics #9 (51
mins)
Excel File Download: ExcelBasics09.xlsx (5 practice problem at end of worksheets)
pdf notes: ExcelBasics09.pdf
Download Excel workbook project for Excel Basics 09: BI348Project02.xlsx . When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Week 3 (4 videos):
Video to watch:
MS 365 Excel Basics
10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA
Examples. (1 hour 22 mins)
Video to watch:
MS 365 Excel Basics #10 Part 02: SORT
Array Function (5 mins)
Video to watch:
MS 365 Excel Basics #10 Part 03: FILTER Array
Function (4 mins)
Video to watch:
MS 365 Excel Basics #10 Part 04: GROUPBY Array
Function to Calculate the Percent of Count Total (3
mins)
Download zipped folder with all files: MECS04DownloadFiles.zip (after you download, unzip to get access to files)
pdf notes: inside zipped folder
Download Excel workbook project and the data files for the Excel Basics 10 videos:
BI348Project03.xlsx
Project03Problem03HourlyWageTextFiles.zip
Projetc03-Problem02-TreeData.csv (right-click to download)
When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Week 4 (2 videos):
Video to watch:
MS 365 Excel Basics
11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context
Too! (40
mins)
Video to watch:
MS 365 Excel Basics
12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data
Model 25
mins)
Download zipped folder with all files: MECS04DownloadFiles.zip (after you download, unzip to get access to files)
pdf notes: inside zipped folder
Download the pdf project instructions and the zipped folder with project files for the Excel Basics 11 & 12 videos:
BI348Project04Instructions.pdf (right-click to download)
When you complete project 4, you can upload your results (two files) in the Home area of our Canvas course.
More coming throughout quarter...
Week 5:
Video to watch:
MS 365 Excel Basics
#13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas
(45
mins)
Download zipped folder with all files: MECS04DownloadFiles.zip (after you download, unzip to get access to files)
pdf notes: inside zipped folder
Download .Project 5 Excel file for this Excel Basics 13 video: BI348Project05.xlsx
When you complete project 5, you will upload your results in the Home area of our Canvas course.
Link to Old BI 348 Class 2024
Link to Old BI 348 Class 2023
Link to Old BI 348 Class 2022:
Link to Old BI 348 Class 2020
Link to Old BI 348 Class 2019
Link to Old BI 348 Class 2015-2018
