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 four (Lending Club)

• Instructions
• Access Database file (large file)
• Access database file in zipped  (Use this if your computer will not allow you to download database file)
  • Unblolcking Database file
  • Cleaning the data
  • Loading data and transforming
  • 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 and shows custom column creation

Assignment five (Lending Club)

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

Assignment six (Dillards Lab 3-5)

• Instructions
  • UARK Access demo

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

• Assignment seven (Oklahoma Pcard)
  • Instructions
  • Excel file

• Assignment Eight (Benfords law using Dilards data)
  • Instructions
  • Creating Leading Digit Field demo

• Assignment  (Dillarsds Time series)
  • Instructions

• Assignmnet Ten
  • Instrctions
  • Tax rate file needed for assignment
  • Short video comment
  • Additional Vidoe

• Chapter 10  project
  • Instructions (included formuls=as for the P2P calculatuons)
  • Power BI O2C shell
  • Power BI P2P shell
  • Chapter 10 Power Bi instructions for most of the calcullations
    • Data has been imported
    • Data type for all ID fields has been chnaged to text
    • Power BI measure and card creatiuon

Ignore Items below (under revision)

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