Week 7 - 8:

Story behind this section: There will be a total of 5 videos with a total length of about 4 hours for weeks 7-8 and weeks 9-10. These 5 videos will be a complete set of lessons about all the Microsoft Power Data Analysis tools. Some of the content will be review for you, but some of it will be new. The intent is to give you a full overview of all of  Microsoft Power Data Analysis tools for performing data analysis in this last class in the series of classes: Busn 216, Busn 218, Busn 210 and BI 348. It will be a good 5 video over view of all the data skills you will need after you graduate and get jobs with your Global Trade and Logistics degree.

Videos to watch:

00: Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data (05:29 min)

01: Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts (36:03 min)

Files to download so that you can follow along with videos and practice what you see:

Download Start Excel File: https://excelisfun.net/files/EDA01-Start.xlsx

Download Excel File with Finished examples: https://excelisfun.net/files/EDA01-FinishedAfterVideoFilmed.xlsx

Download Text Files: https://excelisfun.net/files/fSales.txt

Download Text Files: https://excelisfun.net/files/fSales-WithExtraYearData.txt

Video to watch: 

02: Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! (01 hours and 16:24 min)

Files to download so that you can follow along with videos and practice what you see:

Download Start Excel File: https://excelisfun.net/files/EDA02-Start.xlsx

Download Excel File with Finished examples: https://excelisfun.net/files/EDA02-FinishedAfterVideoFilmed.xlsx

Download Text Files: https://excelisfun.net/files/EDA-02-CSVFiles.zip

Download Power BI Desktop File with Finished example: https://excelisfun.net/files/EDA02-PowerPivotImport.pbix

Project to complete and upload to Project 5 upload link in Home Area, Week 7-8 section in Canvas:

Excel File and Instructions: Project5.xlsm

Text File (1 file with 1 million rows of data) Need for Project: fSalesProject5.csv

Project 5 due before midnight on Sunday, May 30

 

 

Week 9 - 10

Story behind this section: this is a continaution from weeks 7-8 section : )

You will have to download and install the free Microsoft Power BI Desktop app. The video shows links. You can start watching video and download after you watch the introduction, if you want. The link to download is also here: Download free Power BI Desktop:https://powerbi.microsoft.com/en-us/desktop/

Video to watch:

03: Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals  ( 01 hours and 16:12 min)

Files to download so that you can follow along with videos and practice what you see:

Download Text Files: https://excelisfun.net/files/EDA-03-ExcelFiles.zip

Download Power BI Desktop File with Finished examples:https://excelisfun.net/files/EDA03-Reports-FinishedAfterVideoFilmed.pbix

Video to watch: 

04: Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas  ( 58 min)

Files to download so that you can follow along with videos and practice what you see:

Download Power BI Desktop Chapter 3 Finished File with DAX Date Table Code: https://excelisfun.net/files/EDA03-Reports-FinishedAfterVideoFilmed.pbix

Download Power BI Desktop File with Finished examples: https://excelisfun.net/files/EDA04-ReportsFinished.pbix

Download Start Excel File: https://excelisfun.net/files/EDA04-Start.xlsx

Download Excel File with Finished examples: https://excelisfun.net/files/EDA04-Finished.xlsx

Project to complete and upload to Project 6 upload link in Home Area, Week 9-10 section in Canvas:

EPDF Project Instructions: BI 348 Project 6.pdf  (right-click to download)

Project 6 due before midnight on Sunday, June 13