5320 Assignments

Assignment One

• 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 wall not allow you to download database file)
  • Cleaning the data
  • Power Query Connection to Access
  • Enable Power Pivot
  • Bucket Creation and Power Pivot
• 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)
  • Instructions
  • Data file (Large file about 118 MB)
• Assignment Five (Diilards exploratory analysis)
  • Instructions
  • Walton URL  Waltonlab.uark.edu
  • UARK Access demo
  • UARK Power BI demo
• Assignment six (Oklahoma Pcard)
  • Instructions
  • Excel file
• Assignment Seven (Benfords law using Dilards data)
  • Instructions
• Assignment eight (Dillarsds Time series)
  • Instructions
• Assignment nine (State of Delaware open checkbook)
  • Instructions
• Chapter 11  project
  • Instructions

Ignore Items below (under revision)

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