5320 Assignments

Assignment one (Database from scratch)

• Instructions
• Excel State File
• Videos
  • Table Creation video
  • Primary Key Comment video
  • Creating Relationship video
  • Comment on lookup and form creation(Video)
  • Additional comment on look-up feature (Video)

Assignment two (SQL query practice)

• Instructions
• Database File
• Database file zipped (Use this if your computer will not allow you to download database file)
  • SQL demo Video

Assignment three (Lending Club)

• Instructions
• Access Database file
• Access database file in zipped  (Use this if your computer will not allow you to download database file)
  • Cleaning the data
  • Power Query Connection to Access and Bucket Creation
  • Enable Power Pivot
  • Stat Analyis (t-test)
• Power Query – If Statements for Conditional Logic links
  • Add a conditional column (Power Query) (microsoft.com)
  • Power Query - If Statements for Conditional Logic - Excel Off The Grid
  • Power Query IF ELSE and IF AND statements | Excel Quick Help  this site has two pages
    • Demo video

• Assignment four (Lending Club Aproved Stats Modified)
  • Instructions
  • Data file (Large file about 121 MB)
  • Data Dictionary

• Assignment Five (Diilards Lab 4-4)
  • Instructions
  • UARK Access demo
  • UARK data Extraction Demo
  • Short Power BI Demo

• Assignment six (Oklahoma Pcard)
  • Instructions
  • Excel file
• Assignment Seven (Benfords law using Dilards data)
  • Instructions
  • Creating Leading Digit Field demo

• Assignment eight (Dillarsds Time series)
  • Instructions
• Assignmnet Nine
  • Instrctions
  • Tax rate file needed for assignment
  • Short video comment

• Chapter 10  project
  • Instructions
  • Power BI  Shell
  • Note:
    • Power BI Shell zip file (If there is a problem downloading the Power BI shell above, download this file.  This is a zip file containing the Power BI shell.  You you will need to unzip to access the Power BI shell

Ignore Items below (under revision)

• Assignment nine (State of Delaware open checkbook)
  • Instructions

Assignment five

• Instructions
• Data file
• Opening the data file video
• Setting up  your UARK account

Assignment six

• Instructions
• Part 1 file
• Part 2 file

Assignment Seven

• Instructions
• Data file
• Dashboard Demo
• Tableau packaged workbook demo

Assignment Eight

• Instructions
• Data File
• Title in Tableau Demo

Assignment Nine

• Instructions
• Data File
• Excel Text box demo

Assignment  Ten

• Instructions
• Data file

Assignment Eleven

• Instructions
• Excel File
• Changing Slicer Columns demo

Assignment  Twelve 

• Instructions
• Excel file

Assignment Thirteen

• Instructions
• CSV file
• Excel Power Query Data Transformation
• Launching Power Query Editor