Back To Home Page

BI 348: Business Analytics: Data Analysis and Decision Making using Excel

 

Syllabus

Introductory Video

 

Files From Textbook (Download to get files for homework problems):
TextbookExcelFiles.zip

 


Chapter 01:

Files to download:
BI348Chapter01.pptx

Videos to watch:
Basic Excel Business Analytics #01: Basic Business Analytics using Excel (05:04 min)

 

 

Chapter 07:

Files to download:
BI348Chapter07.pptx
Excel'sGoldenRule.docx
Text For FC VC Problem.docx
BI348Chapter07Start.xlsm
BI348Chapter07Finished.xlsm
BI348Chapter07-SecondFile.xlsx

Videos to watch:
Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example (37:24 min)
Basic Excel Business Analytics #03: Goal Seek For What-If Analysis (05:28 min)
Basic Excel Business Analytics #04: Excel Formula for Units Break Even Point and a Unit Defect Rate (04:46 min)
Basic Excel Business Analytics #05: 1 Variable Data Table For What-If Analysis (11:31 min)
Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis (09:46 min)
Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model (14:26 min)
Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? (19:51 min)
Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions  (10:57 min)
Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models  (17:16 min)
Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP  (09:49 min)




Chapter 02:

Files to download:                                                                                                 
BI348Chapter02.pptx
BI348Chapter02Start.xlsx
BI348Chapter02Finished.xlsx
NormalDistributionExcelFunctionsEmpirical RuleNotes.pdf

Videos to watch:
Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology (15:48 min)
Basic Excel Business Analytics #13: Excel Data Analysis Features: Sort, Filter, Pivot Tables (21:38 min)
Basic Excel Business Analytics #14: Logical Formulas & Conditional Formatting to Visualizing Data (13:29)
Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart (11:51 min)
Basic Excel Business Analytics #16: Count Transactions by Hour Report & Chart (07:29 min)
Basic Excel Business Analytics #17: FREQUENCY Array Function for Frequency Distribution & Histogram (23:01 min)
Basic Excel Business Analytics #18: Data Analysis Add-in for Frequency Distribution & Histogram (09:33 min)
Basic Excel Business Analytics #19: Why PivotTables Rule for Frequency Distributions & Histograms (16:29 min)
Basic Excel Business Analytics #20: Skew: Shape of Histogram, Shape of Quantitative Data (03:18 min)
Basic Excel Business Analytics #21: AVERAGE, MEDIAN, MODE.MULT functions & PivotTable Mode (09:03 min)
Basic Excel Business Analytics 22 Geometric Mean Average Compounding Rate GEOMEAN RRI Function (11:32 min)
Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more (18:20 min)
Basic Excel Business Analytics #24: Empirical Rule, Calculating Probability NORM.DIST & NORM.S.DIST (13:58 min)
Basic Excel Business Analytics #25: Percentiles, Quartiles, 5 Number Summary using Excel Functions (13:16 min)




 

Chapter 03:

Files to download:
BI348-Chapter03.pptx
Chapter03/BI348Chapter03.xlsx

Videos to watch:
Basic Excel Business Analytics #43: Visualizing Data: Table & Chart Guidelines  (41:38 min)


Chapter 04:

Files to download:
BI348-Chapter04.xlsm
BI348-Chapter04.pptx
YourNameBI348Chapter04HW-Part01.xlsx Homework File for HW problems #2,3,4,6
Linear Regression Slope Deductive Proof.pdf (If you want)
Linear Regression Slope Deductive Proof-Second.pdf (shorter, If you want)

Videos to watch:
Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart (15:45 min)
Basic Excel Business Analytics #45: Covariance and Correlation to Measure Linear Relationship (15:57 min)
Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation  (18:28 min)
Basic Excel Business Analytics #47: SST = SSR + SSE & R Squared & Standard Error of Estimate  (30:23 min)
Basic Excel Business Analytics #48: Data Analysis Regression feature (06:36 min)
Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression (04:44 min)
Basic Excel Business Analytics #50: Introduction to Multiple Regression, Data Analysis Regression (13:33 min)
Basic Excel Business Analytics #51: Testing Significance of Regression Relationship with p-value (20:44 min)
Basic Excel Business Analytics #52: LINEST, F.DIST.RT, T.DIST.2T & ABS Functions Test of Significance (08:30 min)



Chapter 05:

Files to download:
BI348-Chapter05.xlsx
BI348-Chapter05.pptx

Videos to watch:
Basic Excel Business Analytics #53: Line Charts for Time Series Data  (12:26 min)
Basic Excel Business Analytics #54: Basic Forecasting Methods and Measures of Forecast Error (32:12 min)
Basic Excel Business Analytics #55: Summary of 4 Basic Forecasting Methods & Mean Square Error  (08:13 min)
Basic Excel Business Analytics #56: Forecasting with Linear Regression: Trend & Seasonal Pattern   (25:21 min)

 

 

Chapter 08 and 09:

Files to download:
BI348-Chapter08.xlsx (chapter 08 & 09)
BI348-Chapter08.pptx (chapter 08 & 09)

 Manufacturing Max Example.docx

Videos to watch:
Basic Excel Business Analytics #57: Intro To Linear Programming using Algebra, Pencil & Paper  (27:42 min)
Basic Excel Business Analytics #58 Excel Solver to Maximize Contribution Margin  (16:36 min)
Basic Excel Business Analytics #59: Linear Program Special Cases: Infeasible, Unbound, Alternative  (5:02 min)
Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable  (12:54 min)
Basic Excel Business Analytics #61: Find Alternative Solution For Transportation Problem  (5:32 min)
Basic Excel Business Analytics #62: Excel Solver: Maximize Portfolio Returns  (11:33 min)
Basic Excel Business Analytics #63: Excel Solver Binary Variable Choose Projects Limited Resources (07:25 Min)

 

 

Chapter 11:

PowerPoint File to download:
BI348-Chapter11.pptx
 

Videos to watch and Excel files to dowload: 

Video Link:  Basic Excel Business Analytics #64: Introduction To Monti Carlo Simulation In Excel   (23:44 min)
Download files for videos #64:
BI348-Chapter11-Video64-IntroToSimulation.xlsx

Video Link:   Basic Excel Business Analytics #65: Create Random Variables: Custom, Binomial, Uniform, Normal   (22:41 min)
Download files for videos #65:
 BI348-Chapter11-Video65-CreatingRandomVariables.xlsx

Video Link: Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain Variables  (18:32 min)
Download files for videos #66:
BI348-Chapter11-Video66-NewProduct.xlsx

Video Link: Basic Excel Business Analytics #67: Monte Carlo Simulation for Marketing Analysis Binomial Variable  (11:45 min)
Download files for videos #67:
BI348-Chapter11-Video67-MarketingAnalysis.xlsx

Video Link:  Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length  (15:55 min)
Download files for videos #68:
BI348-Chapter11-Video68-ConstructionSequentialProject.xlsx

Video Link (Last Video): Basic Excel Business Analytics #69: Monte Carlo Simulation for Baseball World Series   (09:41 Min)
Download files for videos #69:
BI348-Chapter11-Video69-Baseball.xlsx

 

End of Class

 

 

 

 

 

 

Old Class Chapters 2.5 & 2.75