Major characteristic of a dss and many bi tools

Assignment Help Other Subject
Reference no: EM133147756 , Length: word count:800

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 Tasks 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 Task 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 Tasks and Utilities and then click small triangle on the left side of Tasks to expand the Tasks 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 on
plus 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 Tasks 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 Options
2. Click on Preferences, then Results
3. 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

Reference no: EM133147756

Questions Cloud

Compute the direct materials variances for september : A certain apple pie requires the following: Direct materials standard 1.5 pounds at $7.25 per pound - Compute the direct materials variances for September
How many ports are there in the us : 1. The most widely known case of drugs and/or alcohol resulting in a transportation disaster is?
Finding errors in medicare billing process : Janice keeps finding errors in her Medicare billing process. Which root cause tool would not be useful in helping her reach her goal of improving the system?
Alcohol resulting in a transportation disaster : The most widely known case of drugs and/or alcohol resulting in a transportation disaster is? (Explain)
Major characteristic of a dss and many bi tools : 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
How does neuroticism affects individual behavior : How does neuroticism affects individual behavior.
Does this allocation scheme bias your breakeven analysis : Suppose you just found out that the $3,215 monthly malpractice insurance charge - Does this allocation scheme bias your breakeven analysis
Potential for intercultural misunderstanding : Directions: Describe how do you express the following emotions nonverbally:
Increase the number of applications from low-income : If you were the director of admissions at a university, what steps would you take to increase the number of applications from low-income and racial minority stu

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd