Premium Essay

System Analyst

In: Computers and Technology

Submitted By tsuwat
Words 1220
Pages 5
Data Warehouse Design:
Dimensional Modeling II
Data Technology
Chularat Tanprasert, Ph.D.


Dimensional modeling

Popular, useful, and pragmatic approach
Based on Kimball

Fact table
Dimension tables
Design process in steps

Database Schema Design

Star Schema (With Attributes)

Example Designs

A useful way to learn about data warehouse design principles is by using examples – reuse.
Kimball – Data warehouse lifecycle toolkit
Adamson & Venerable – Data warehouse design solutions
Let’s take a look at inventory, shipments, and financial services.


An inventory system serves as a
“middleman” between the manufacturer and the retailer – value adding process.
There are threee types of inventory model

Inventory snapshot
Delivery status

Inventory Snapshot Model
For specific time periods, inventory levels are measured and recorded.

Delivery Status Model
Create one record for each complete shipment of a product to a warehouse.

Transaction Model
Record every transaction that affects the inventory.


The shipments process is where the product leaves a company and is delivered to a customer.
Typically, accompanying each shipment is a shipment invoice.
Each line item on the shipment invoice corresponds to an SKU.




Financial Services

Typically a large bank.
Services include

Cheque accounts, saving accounts, mortgage loans, investment loans, personal loans, credit cards, etc.

Goal – to market more effectively to households.
Build a household data warehouse to track accounts, account holders, and their household grouping. Financial Services

Five years of monthly data for each account.
For current month must...

Similar Documents

Free Essay

A Systems Analyst

...IT professional who specializes in analyzing, designing and implementing information systems. Systems analysts assess the suitability of information systems in terms of their intended outcomes and liaise with end users, software vendors and programmers in order to achieve these outcomes.[1] A systems analyst is a person who uses analysis and design techniques to solve business problems using information technology.[2] Systems analysts may serve as change agents who identify the organizational improvements needed, design systems to implement those changes, and train and motivate others to use the systems. Although they may be familiar with a variety of programming languages, operating systems, and computer hardware platforms, they do not normally involve themselves in the actual hardware or software development. They may be responsible for developing cost analysis, design considerations, staff impact amelioration, and implementation timelines. A systems analyst is typically confined to an assigned or given system and will often work in conjunction with a business analyst. These roles, although having some overlap, are not the same. A business analyst will evaluate the business need and identify the appropriate solution and, to some degree, design a solution without diving too deep into its technical components, relying instead on a systems analyst to do so. A systems analyst will often evaluate code, review scripting and, possibly, even modify such to some......

Words: 254 - Pages: 2

Premium Essay

Attributes and Skills of a Systems Analyst

...The role of a systems analyst is vital to the success of any organization. In this role, the systems analyst is responsible for being the “liaison” between the technology department and all other departments within the company (Laudon & Laudon, 2011, p. 68). There are several key skills and characteristics necessary to be an effective systems analyst. The person performing this role needs to have excellent communication skills, planning and organizational skills, and managerial skills. While the systems analyst must constantly continue his education as it pertains to new software and hardware systems, there are other roles an analyst is expected to fill. The analyst needs to establish a working relationship with other departments. This allows the analyst to obtain data to assist with the department’s information technology needs. A characteristic that would be demonstrated in this area is that of teamwork. The analyst has to put the needs of the company first and be able to interact with all types of people (U.S. Bureau of Labor Statistics, n.d., p. 5). The position relies on the ability to solve problems within the business. Therefore, the analyst needs to have a clear understanding of how the business operates. By meeting with the various departments, the analyst is able to understand what problem exists and what options are available to resolve the problem (Laudon & Laudon, 2011, p.381). The analyst needs to decide which option will work best for the department...

Words: 638 - Pages: 3

Premium Essay

Role of a System Analyst

...The Role of a Systems Analyst John Willis IT510-01 June 17th, 2013 Prof: Michael H. McGivern The Role of a Systems Analyst The system development life cycle (SDLC) is a seven phased approach to augment a gap in business capabilities (Kendall & Kendall, 2011). Throughout these seven phases from initial problem identification to overall integration it is important to have a system analyst. The system analyst will be the person driving the project through each phase, ensuring that each phase is accomplished, and the acquiring business is happy. The analyst acts as the main focal point of the project, dealing with businesses as a consultant and the design workforce as a technical expert. Interacting with all spectrums of business a system analyst will find they need to have a wide range of qualities. If implementing an e-commerce business strategy a system analyst will find they need an even wider skillset to address the increased complexities. Qualifications for E-commerce Today’s ubiquitous computer/internet society has caused a surge in e-commerce and m-commerce. To implement an e-commerce business strategy a system analyst must be knowledgeable of all stages of the e-commerce multistage model. The model has five stages: search, negotiation, purchasing, product delivery, and after sales delivery (Stair & Reynolds, 2012). To successfully design the interaction of these stage the system analyst must be familiar with databases, supply chain management (SCM),......

Words: 764 - Pages: 4

Free Essay

System Analyst Paper

...Mendoza System Analyst Paper CIS135 What is the role of a System Analyst? A System Analyst, (SA), may be a part of a team or an individual that is responsible for planning, researching, and implementing cost-effective computer systems. A “computer system will include the computer along with any software and peripheral devices that are necessary to make the computer function”. (Webopedia) What are the qualifications of a System Analyst? * Planning, designing, installing, and developing new computer systems * Revamping existing computer systems for new tasks * Networking computer systems with others systems * Preparing cost-benefit and return-on-investment (ROI) reports for management * Testing and debugging new or revamped computer systems and the networks on which they communicate Many employers require computer system analysts to be formally educated. The typical minimum is a bachelor’s degree. Some employers require advanced degrees for complex jobs and senior positions. Others require dual degrees for highly-specialized jobs, such as designing computer systems for biotech applications. Common degrees required include those in computer science, information science, or management information systems. Systems analysts hold a variety of degrees. Consequently, some employers require only a relevant degree without saying which type. ( What is the job outlook? Nationwide: The fastest-growing occupations in the Information Systems......

Words: 459 - Pages: 2

Premium Essay

System Analyst hardware and networking technology has dramatically changed how businesses organize their computing power, putting more of this power on networks and mobile handheld devices. The once powerful Dell computer last week said they are considering going private. Move over PC and make way for the smart phone. The world is changing. Dell failed to change and shareholders aren't happy. The new mobile digital computing platforms such as Apple's I-Phone have emerged as alternatives to PCs and larger computers. I-Phones have taken on many functions of handheld computer, including transmission of data, surfing he Web, transmitting e-mail and instant messages, displaying digital content, and exchanging dat with internal corporate systems. The new mobile platform also includes small low-cost lightweight subnotebooks such as the I-Pad. The book says in a few years, smartphones, netbooks, and tablet computers will be the primary means of accessing the Internet, with business computing moving increasingly from PC's and desktop machines to these mobile devices. Well, I got news for you Mr. Book, the world has already seen this changing of the guard. The world is no longer flat, it is the global universe. Jump on or get left...

Words: 253 - Pages: 2

Free Essay

Cis 510 Wk 4 Assignment 2 Creating a Context Diagram

...Assignment 2 - Creating a Context Diagram Refer again to the information about the Reliable Pharmaceutical Service (RPS) at the end of Chapter 1, “The World of the Information Systems Analyst.” Write a two to three (2-3) page paper in which you: 1. Create a context diagram using Visio or its open source alternative software based on the information provided. Note: The graphically depicted solution is not included in the required page length. 2. Write a narrative describing the diagram. The narrative should include: a. An overview of the diagram. b. A description of the primary system users. c. A description of the information exchanged between the users and the system. Activity mode aims to provide quality study notes and tutorials to the students of CIS 510 WK 4 Assignment 2 Creating a Context Diagram in order to ace their studies. CIS 510 WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM To purchase this visit here: Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 510 WK 4 ASSIGNMENT 2 CREATING A CONTEXT DIAGRAM CIS 510 WK 4 Assignment 2 - Creating a Context Diagram Refer again to the information about the Reliable Pharmaceutical Service (RPS) at the end of Chapter 1, “The World of the Information Systems Analyst.” Write a two to three (2-3) page paper in which you: 1. Create a context diagram using Visio or its open source alternative software based on the information......

Words: 574 - Pages: 3

Free Essay

Work Related Project Analysis

...Work Related Project Analysis, Part 1 BSA/376 Work Related Project Analysis, Part 1 System Analysis is a formal investigation that is done to help someone or a company to make better choices than what might have been made without a specific system (Principia Cybernetica Web, n.d.) . Included within a system analysis is identifying the underlying issue or the chief of complaint that is made by the client or person. Assessment of the problems and alternative methods are made which can include risks and benefits of the alternative methods. The risks and benefits must be considered so that the client and the developer are able to make a choice from the different methods of improvement (Principia Cybernetica Web, n.d.). System analysis is typically used in directing decision making in personal and business plans, development and other services. In the case study of The Reliable Pharmaceuticals Service that is located in the Systems Analysis E-Book which is written by John W. Satzinger, Robert B. Jackson and Stephen D. Burd is a company that offers pharmacy services to health-care delivery organizations that are unable to have their own pharmacy within their company (Satzinger, Jackson, & Burd, n.d.). The Reliable Pharmaceutical Service provides service to nursing homes, hospitals and residential rehabilitation facilities (Satzinger, Jackson, & Burd, n.d.) . The medical facilities are able to place telephone orders to the pharmaceutical Service Company and......

Words: 1544 - Pages: 7

Premium Essay

Systems Analyst

...We know that Jake runs a Delicatessen store in a high-crime section of the city. We know that he was robbed eight times in one year. We know that he obtained a permit and bought a pistol. We also know that a man came into the store brandishing a knife asking him for all the money in the cash register. We know that Jake moved towards the register and instead of opening it, he went for his weapon and without warning opened fire hitting the robber. What we don’t know if the permit was obtained legally. He could have gotten the permit by not going through the proper channels making him discharging his weapon illegally. What we don’t know if Jake was premeditated in his actions. Jake has been robbed multiple times and he may have believed the next time there’s an encounter he’s going to discharge his gun and ask questions later. Jake’s action wasn’t ethical, the fact that he pulled his weapon and point blank shot a person at point blank range isn’t justifiable. It’s understandable that he has been victimized many times in one year but that doesn’t give him a right to pull the trigger and shooting six times at that. He didn’t give the robber a warning shot or told him that he will pull the trigger if he doesn’t put his knife down. Just the simple fact that the robber was carrying knife he should’ve considered not shooting. Jake could’ve handle it by telling warning the robber to stop or he’ll shoot. There was no warning and I believe Jake had the upper hand in this......

Words: 341 - Pages: 2

Premium Essay

Systems Analyst

...Grading Summary | These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the "Details" section below. | Date Taken: | 11/20/2011 | Time Spent: | 2 h , 42 min , 46 secs | Points Received: | 197 / 200 (98.5%) | | Question Type: | # Of Questions: | # Correct: | Essay | 7 | N/A | | | Grade Details | 1. | Question : | (TCO A) Compare and contrast a merger with a tender offer. (15 points for merger and 15 points for tender offer; total 30 points) | | | Student Answer: | | Mergers are negotiated deals mutuality of negotiations and mostly friendly, while tender offers are made directly to the shareholders and hostile when offered and made without approval from the board. Mergers and tender offers are similar in that the restructuring of the two firms will make changes to improve operations, policies and strategies. There are different types of mergers - vertical, horizontal, conglomerate. The different types of tender offers are Conditional vs. unconditional, Restricted vs. unrestricted, Any-or-all tender offer, Contested offers, Two-tier offers and Three-piece suitor. Tender offers seek shareholder approval and mergers seek approval from the board of directors. | | Instructor Explanation: | A) In a tender offer, the acquirer makes an initial bid to the board of directors (management) of the target company. The board of directors (management) of the target company......

Words: 2401 - Pages: 10

Free Essay


...Marine Corp for four years. My interest in technology is based on the growing demand for technical professions in a wide array of industries. According to Marquardt, K (n.d.) the demand for computer systems analysts should grow at a steady clip this decade, as businesses and organizations increasingly rely on information technology. Personal/professional vision: I have entrepreneurship aspirations to start my own e-commerce website. I’m currently in the research aspect of developing a business plan for my website. Five years from now I see myself with a successful e-commerce website with top quality product and competitive prices. Northcentral and you: My education at NCU will contribute to the success of my online storefront by providing me with the educational and professional skills I need to start and run a successful online storefront. Northcentral resources: I feel comfortable accessing the student e-mail system, writing center, and library. I haven't used the APA style format in several years, so this is the area I may need support from Faculty and Advisers. Two outside resources: I read an article on the NY Times website about Walmart plans to increase stores and e-commerce in China. Reference: Marquardt , K. ((n.d.)). best technology jobs computer systems analyst. Retrieved from...

Words: 260 - Pages: 2

Premium Essay

Roles of a System Analyst

...Roles of a System Analyst | | Professor: Michael H. McGivern Course: IT510 Eric Harmon July 29, 2012 System analyst in today’s word have many hats, their many focus is primarily on supporting a company’s current system as well as possibly making upgrades to it. However this task cannot be completed without being able to communicate with the various departments within that company. An analyst will also need to be able to communicate with any external customers that a company may have, and when dealing with ecommerce a company will always have external customers. An analyst should have the capability to access. When you are hired to be a consultant your job will be to look at a company’s current setup if they have one, or to create one for them. As that person you will have to determine a company’s needs. Being able to communicate with current employees you will be able to conduct interviews to see how well the current system works, or if they feel changes are needed. If employees feel changes are needed you have to have the ability to obtain this information for the employees. Once this information is obtained you would then want to compile the information so you will be able to deliver it to upper management. Without knowing a company’s needs you will not be able to perform your job. Another key......

Words: 1156 - Pages: 5

Free Essay

The Role of a System Analyst

...The Roles of a System Analyst 1. What qualifications should a system analyst have in today’s ecommerce development industries? “A System Analyst systematically assesses how users interact with the technology and how businesses function by examining the inputting and processing of data and the outputting of information with the intent of improving organizational processes” (Kendall & Kendall, 2011, p. 6). The basic qualification that a System Analyst should have is a bachelor’s degree in business. In addition, other skills include: computer system knowledge, problem solving skills, analytical skills, a broad knowledge of hardware and software applications, and a working knowledge of programming. The ability to communicate and have good interpersonal skills is also an important qualification (McKay, 2013). An e-commerce analyst combines business with the Internet to take advantage of the opportunities to expand their company globally. In today’s ecommerce development industries a System Analyst should have several qualifications which include: a bachelor’s degree in e-commerce and a master’s with a specialization in marketing. Also, a System Analyst should have knowledge of e-commerce software and interface design, and the ability to work with technicians and developers to create websites. Most employers require a certain amount of experience as an e-commerce system analyst (Linton, 2013). 2. What personality charter traits are desirable in a system analyst who will be......

Words: 881 - Pages: 4

Premium Essay

System&Business Analyst

...El-Kholy Mobile: (002) (111) 2040400. : (002) (100) 7080618. E-mail: Gender: Male Nationality: Egyptian Birth Date: 15/11/1988 Marital status: Single Military Status: Exempted Languages: Arabic Native Language English Fluent spoken, read and write French Fair Objective Obtaining a challenging position in a respectful software house, or multinational organization in the field of information technology. Aiming to fully utilize my professional experience, academic background, and further develop my technical skills. Work Experience Etisalat Misr – Outsourced by BBI 4/2011-Present Role * System Analyst * System Analyst in Data Quality - DWH Team. * Include service quality measures in the requirement/design for all projects. * Achieve quality assurance for new and modified models. * Increase quality checks for early problems detection by keeping enhance data quality process and methodology. * Grant smooth end month/end year closing for the Finance Department. * Performing daily, weekly, and monthly statistical reports, spreadsheets and graphs that ensure the integrity of trends for vital areas of the telecom operation and KPIs that support in taking right decisions. * Checking usage and revenue trends and investigate the reasons behind any deviations or spikes. * Validate the quality of data extracted......

Words: 1028 - Pages: 5

Premium Essay

Asd Bgy Bh

...semiconductor analyst, Peter Thompson, had abruptly announced his resignation; he had received an offer from one of RSH’s competitors. But Peter was not only a star analyst, he was also RSH’s only semiconductor analyst. This was certainly not a role that could be left vacant for long and, right now, RSH particularly needed strong coverage of the semiconductor industry because of an upcoming deal with the PowerChip company. (See Exhibit 1.) Stephen examined how much money Peter generated for the firm and saw that he could legitimately raise Peter’s compensation. Then he devised a backup plan: to split Peter’s team by encouraging Peter’s junior analyst, Rina Shea, to stay at RSH. Peter ended up leaving the firm and Stephen promoted Rina to senior analyst, assigning her to cover PowerChip and the rest of the semiconductor industry, at least temporarily, while he decided whether to offer her the position permanently or hire someone from outside the firm. Now Stephen faced the task of finding a permanent replacement for Peter. Should he make Rina a permanent offer or hire from outside? RSH Research Department RSH’s corporate culture was especially strong in its research division. Senior research analysts often began as junior analysts and remained at the firm long after the research director gave them their own franchises. Instead of competing with each other, most analysts at the firm supported one another; many had open-door policies and encouraged less-experienced analysts to......

Words: 16177 - Pages: 65

Free Essay

Hostel Allocation System

...THE SYSTEM 1.1 DEFINITION “Hostel Management System” Hostel Management system is the system that manages the student data, staff data students’ admission process and create receipt for the fees paid by the student who stay in the hostel and also help in maintaining visitor’s messages. 2.1 INTRODUCTION TO EXISTING MANUAL SYSTEM Existing system is based on manual work and all the process are done manually, so they maintain registers and files for recording all the details of the system. They maintain several registers for recording the entry of daily transactions such as visitors visited the hostel, visitor drop the message for a particular student, etc. They maintain the record of the students so they keep each and every information regarding the students in the student master file. In the similar fashion they maintain the records of their fees so they keep each and every information regarding their fees details in the fees master file. They keep the bill Book or receipt Book to maintain the record for the fees collected by the student. They maintain the register or Book for staff so they can pay the salary. Thus maintaining Staff information, Student Information, Visitors information, Check-in and Checkout information and all the things are done manually. 2.2 PROBLEMS FACED BY EXISTING MANUAL SYSTEM [PROBLEM IDENTIFICATION] The phase of system......

Words: 2436 - Pages: 10