lecture2 - Case#1 LAB Building Applichem's Information...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 of 19 Case #1 LAB: Building Applichem’s Information System Infrastructure IMPORTANT: The information contained in this lab handout is based on Excel 2007 for Windows. Instructions for other versions of Excel and for Mac are similar. Scenario: Applichem has four plants and each planting is operating independently due to lack of Information System Infrastructure. The lack of Information system infrastructure has hampered growth and has resulted in loss of opportunity. Goals Create a star schema based Information System Infrastructure Show how to import data from text files Integrate and Format data Perform analysis on the imported data Create KPIs (Key Performance Indicators), Charts and Dash Board Issues Date has to be reformatted to obtain meaningful KPIs Raw data is available, need to convert into meaningful KPIs Requirements DS - Format dates & times. Summarize Information: find the Median, Mode, Average, Minimum, and Maximum values for each variable PART 1 - How to import text data into Excel Theory: A text file is a kind of computer file that is structured as a sequence of lines. Because of their simplicity, text files are commonly used for storage of information. They avoid some of the problems encountered with other file formats. .txt is a file format for files consisting of text usually containing very little formatting (ex: no bolding or italics). Files with the .txt extension can easily be read or opened by any program that reads text and, for that reason, are considered universal (or platform independent). 1. Rename the Sheet1 Tab 1. Open a new workbook in Excel. 2. Double click the tab for “ Sheet1 ”. 3. Type: Plant_Data and press enter (you can choose other names that you think are appropriate). Tip Don’t use spaces or dashes when you are naming a sheet. Spaces and dashes are acceptable but make calculations between sheets a little more cumbersome because you must place ‘ ‘ around the sheet name. For example: No Spaces: =Plant_Data!B4-6 With Spaces: =’Plant Data’!B4-6
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Inserting the Case1Data_Spring2012.txt File Into the Template 1. In the “ Plant_Data ” sheet, click in cell A1 . (The upper left corner of our data will start here). 2. From the menu, click: Data Tab – Click From Text 3. Select the “ Case1Data_Spring2012.txt ” file and click “ Open ”. 4. Step 1 of 3 The Text Import Wizard starts: a. Set the File Type to: Delimited . You select “Delimited” when your columns of data are separated by tabs, spaces, comas, or some other character. Our data is separated by tabs. b. Set Start Import at Row to: 1 Setting this one tells Excel to import the first row. c.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 19

lecture2 - Case#1 LAB Building Applichem's Information...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online