4320 Assignmnets

Excel
Tableau
AI Applications to be used this semester for data analysis
- Microsoft CoPilot
  - Demo Video
- Google Gemini
  - Demo Video
- ChatGpt free version for data analysis not recommended
  - Free version has a data analysis limit
Comments on output
- Copy each step to a word document
- Copy the results for each step to the word document
- If the results are in a table format. make sure the table is in a user freindly format.
  - Table result
Assignment one ( Chapter 1-AI assignment that replaces Lab 1-3)
- Instructions File

Assignment two (Lab 2-1 Excel)
- Instructions File
- Excel File needed for assignment
- Videos
  - Pivot Table Basics
  - Excel date breakdown
Assignment Three (Lab 2-1 Tableau)
- Instructions File
- Excel File needed for assignment
- Tableau Comments
  - Video 1 (Tableau Overview)
  - Video 2 (convert measure to dimension)
  - Video 3 (Tableau packaged workbook)
  - Video 4 (Tableau Cross Tab)
  - Video 5 (Tableau data interpreter)
  - Calculated field creation
  - Tableau Filtering
Assignment Four (Lab 2-1 AI)
- Instructions
- Excel Data file
Assignment five (Lab 3-1 Excel)
- Instructions
- Excel Data file
  - Video
    - Pivot table count
    - Pivot table subtotal demo
Assignment Six (Lab 3-1 Tableau)
- Instructions
- Data file
  - Video
    - Tableau date breakdown
    - Filled geographic map
Assignment Seven (Lab 3-1 AI)
- Instructions
- Excel data file
Assignment Eight Excel (lab 4-4)
- Instructions
- Excel File
- Excel Linking demo version 1
- Excel Linking demo version 2
Assignment Nine ( Lab 4-4 Tableau)
- Instructions
- Excel File
- Tableau linking demo
Assignment Ten AI (Lab 4-4)
- Instructions
- Excel Data file

Assignment Eleven (Excel Lab 5-1))
- Instructions
- Excel Data file
- Percentage breakdown demo
- Short Slicer demo

Assignment Twelve (Tableau Lab 5-1))
- Instructions
- Excel Data file
- Note: Converting measure to dimension if necessary - see video demo from assignment three

Assignment Sixteen (Lab 7-1, AI separation-of-duty )
- Instructions
- Excel Data file

Assignment Seventeen (Lab 7-7 AI duplicate payments)
- Instructions
- Data file

Assignment Eighteen (Lab 7- 5 Fuzzy Matching)
- Instructions
- Data File
Assignment nineteen (Lab 7-8 Poetntail vendor paymant fraud)
- Instructions
- Data File
Assignment twenty (Lab 8-6 Excel Forecast)
- Instructions
- Excel Data file
- Video

Assignment Twenty one (Lab 8-7 Tableau Forecast)
- Instructions
- Excel Data file
- Video

Assignment Twenty Two (What-if analysis using data tables)
- Instructions
- Data File
- Zoom Demo of goal seek and data tables

Assignment Twenty three (What-if analysis using AI, one way)
- Instructions
- Data File

Assignment Twenty four (What-if analysis using AI two way)
- Instructions
- Data File

Dr. Gary G. Berg