01 Oct In this assignment, you will plan and design a BI solution framework for a large farming company to streamline its farming products ordering and deliveries to the market (wholesale markets and large grocery stores).
In this assignment, you will plan and design a BI solution framework for a large farming company to streamline its farming products ordering and deliveries to the market (wholesale markets and large grocery stores).
Instructions:
Your BI solution must include:
Data accessed from different sources and historical data
Real-time data capable of predicting products ordering
Price adjustment ability based on market and environment change
Records of past delivery methods, and ability to modify delivery methods for customers
Online ordering and delivery system
One single system for ordering and tracking
Submission Requirements:
Your framework should meet the following requirements:
Three to five pages (750-1,205 words) in length
Formatted according to APA guidelines as explained in the CSU-Global Guide to Writing & APA (Links to an external site.) (subheadings, one-inch margins, and double spacing)
Supported by three credible, academic outside sources in addition to course materials
Write clearly and logically, as you will be graded on content, analysis, and your adherence to the tenets of good academic writing, which should be succinct where possible while also exploring the topics appropriately. Integrate and cite scholarly sources to support your work, and supplement your ideas.
Part B: Cleaning Messy Data Set
For the Part B of this assignment, you will clean up messy data. Messy data means those data sets that are not quite ready for analysis, such as blank or multiple answers in columns that should have one answer, non-number values for a cell in a table, and missing data.
You can correct these issues by using SAS code.
Instructions:
Download the messydata.sas7bdat needed. Make sure that you download the data files to your folder in this location:
SASUniversityEditionmyfolderssasuser.###
(where the ### is the version number for SAS)
You will be able to link to your SAS data table file via the SAS software if you store it there. This directory is the SASUSER Library in the University Edition of SAS Studio.
Copy and paste the following code into SAS Studio. Included in the code is a procedure to attach labels to the variable to make the output more readable.
* (C) 2016 Elliott, Alan C. and Woodward, Wayne A. *
*******************************************************;
* This example illustrates Cleaning a MESSY data file;
******************************************************************;
STEP 1;
* THIS CODE MAKES A COPY OF THE ORIGINAL FILE;
* SO ALL CHANGES ARE MADE IN A COPY OF THE DATA SET;
DATA WORK.CLEANED;SET SASUSER.MESSYDATA;
LABEL
EDUCATION=’Years of Schooling’
HOW_ARRIVED=’How Arrived at Clinic’
TOP_REASON=’Top Reason for Coming’
SATISFACTION=’Satisfaction Score’
Subject=”Subject ID”
DateArrived=”Date Arrived”
TimeArrive=”Time Arrived”
DateLeft=”Date Left”
TimeLeft=”Time Left”
Married=”Married?”
Single=”Single?”
Age=”Age Jan 1, 2014″
Gender=”Gender”
Race=”Race”
Satisfaction=”Satisfaction Score”;
* You don’t really need the ARRIVAL Label;
TEMP=ARRIVAL;
DROP ARRIVAL;
LABEL TEMP=’Arrival Temperature’;
RUN;
* the code that shows the first 10 records:
PROC PRINT LABEL
DATA=WORK.CLEANED
(firstobs=1 obs=10);
VAR SUBJECT EDUCATION TEMP
TOP_REASON SATISFACTION;
RUN;
TITLE;FOOTNOTE;
Run the code.
In the WORK library, save the changes in a file named “CLEANED.”
Submission Requirements:
For the Part B of this assignment, you will submit the following:
your SAS code,
a screenshot of the output from the run, and
a screenshot of the Output Data.
Also, state other steps necessary for cleaning a data set beyond these steps in this assignment.
