Lab April 30 - May 4

• In this lab you will perform Descriptive and Predictive Analysis of the Toyota Used Cars Dataset.
• Final Files for Submission will include:
  • QlikView files with Test and Train analysis (predictive analytics)
  • QlikView file with BOTH datasets that analyze all data (descriptive analytics)
  • Word File with Predictive Analysis Summary
• Team Work
• Short Presentations will be on Friday, May 4. Each presentation 3-4 min. For presentations you will use the QlikView file Dashboard sheet.
• Download ToyotaTest.xlsx and ToyotaTrain.xlsx files from Shared Files
• Open QlikView and load BOTH datasets. Call this file ToyotaTotal_YourName
• Perform Descriptive Analysis of the Data and Create a Dashboard Sheet that describes the data. Your dashboard must include:
  • At least 2 different charts
  • Statistics Box
  • At least ONE text box with dynamic calculations
• Predictive Analysis Requirements:
  • QlikView file with Train Dataset, Scatter Charts, Correlations, Linear Regression Models. Goal: To find a linear regression model and the best predictor based on the training dataset
  • QlikView file with Test Dataset. Testing your models. Making decision which model is working the best on the test data.
  • SAP: build at least one multiple linear regression model and test it on the test dataset