Major characteristic of a DSS and many BI tools (notably

Assignment Detail:- ITECH3101 Business Analytics and Decision Support - Federation University Exercise - Manipulating your data and creating a report Project 1: Importing data from Excel file The purpose of this project is to import your own data from Excel workbooks for creating SAS data set- 1- Download data Grades-xls from Week 2 in Moodle and save it under the folder SASUniversityEdition/myfolders- 2- Open up Parts tab in the navigation pane in SAS Studio- The following screen will appear-3- Click small triangle on the left of Utilities Import Data task is used to import data from many of common data formats such as Excel, CSV and other files- 4- Double-click Import Data task, you can see that two ways to import data are displayed on work area: -1- Click on the Select File button, -2- Click on Server Files and Folders tab in navigation pane on the left of screen, find the file, and drag it to the drag and drop area- 5- Click on Select File to open a window where you can see that Grades-xls is under the My Folders, and then select Grades-xls and click on Open- 6- Create your own data set- You may create your SAS data set by importing original data set-Grades-xls- and name your data set- Click Change button- After clicking Change button, it will show a list of SAS libraries- Now name your data set as myGrades- Your data set myGrades will be saved in WORK library that is a temporary SAS data set- After click Save button, data set has been named as myGrades- 7- Click Run icon, and data set has been imported to work area- 8- Look at your data set- Select My Libraries tab on the navigation pane and open up WORK library- 9- Double click on myGrades, and you will see the grade data set 10- Create a data report- Click on Part tab of navigation pane, select Data and then select List Data- Double click on List data and select myGrades data set in Work library- Finally click on Run icon- Project 2: Creating a data listing In this project, you will learn how to produce a data listing from a given data set- 1- Open SAS Studio as following- On the left of screen, you can see the navigation pane and the work area is on the right of screen- 2- Using List Data task to create a simple listing- Click Parts and Utilities and then click small triangle on the left side of Parts to expand the Parts tab- 3- Double-click on List Data to open a window- In this window, you would find a data set called Fish stored in SASHELP library- 4- Click on the icon at the top-right part of above screen to select data set Fish- Then click Ok button- 5- Select variables in data set Fish and include the variables in your listing- Click onplus sign-+- to select variables- 6- Hold the Ctrl key down and select variables Species, Weight, Height, and Width-Then click Ok- 7- Using OPTIONS tab to customize the listing- For example, in this example, you may want to just display the first seven rows in data set Fish- Click on OPTIONS tab to customize the listing- 8- Click on Run icon to create the following listing- Project 3: Creating reports In this project, you will learn how to produce a report such as PDF file or RTF -rich text format- file- Basically you can complete this task by using two methods: using built-in Parts provided by SAS Studio and writing a SAS program- In this project, you would use built-in tasks to create a report- You will implement this project based on the results of the Project 2- 1- Click on More Application Options2- Click on Preferences, then Results3- Download results as a PDF file Project 4- Answering questions -Please do this at your home by using your own computer- 1- Download data set employee-xls from Week2 in Moodle and import the data set to SAS Studio and create a report-2- A major characteristic of a DSS and many BI tools -notably those of business analytics- is the inclusion of at least one model- How does the text describe a model???? Project 5- Creating a Professional Report Summarize the above experiments procedure, results, answering for questions and screenshots -project 1, 2, 3, 4- into one report- Your report is the assignment that is required to be submitted for evaluation on week 9- Create a report by following the steps- You can add a chapter called Chapter 2 in your previous report- 1- Open your last week's report and find the end of last week's report- 2- Copy this week's related experimental results, your findings and Screenshots, and paste them at the end of last week's report- 3- Delete original Table of Content you created- 4- Select all content , align all text to both left and right margin 5- Use shortcut key approach, generate Chapter 2: Manipulating your data and creating a report 6- Then use shortcut key approach to generate proper sub-chapters for this week's lab work- 7- Insert Table of Contents to your report- Attachment:- Manipulating your data and creating a report-rar

Most Recent Questions


Helping Students for Excellence in Academics, GET Help with Assignment? Order Now