Compile data from client systems into enterprise

Reference no: EM133731433

Case: Modern companies compete in a challenging environment. To remain competitive, they must react rapidly to problems and opportunities that arise from extremely dynamic conditions. Enterprise information systems (EIS) include any kind of information system that improves the functions of enterprise business processes. EIS helps companies answer these challenges.

For the final project in this course, you are to imagine that you are a newly contracted junior data specialist working for a business intelligence unit that has been tasked by your manager to answer a question for your company's management. Your manager will provide you with the data sets to begin your work. With these, you will go through a series of actions to simulate an ERP environment. Finally, your manager will expect you to deliver a fully functional Access report that, when produced, will answer senior-management questions about sales.

You will be required to submit a completed Access database that meets your manager's specifications and contains data loaded from the provided Excel spreadsheets along with reports answering important management questions. Finally, you will use appropriate language to compose an executive summary that explains your process to management.

The project is divided into two milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules Three and Five. The final product will be submitted in Module Seven.

In this assignment, you will demonstrate your mastery of the following course outcomes:

Utilize appropriate tools and querying skills to mine relevant data from client systems

Compile data from client systems into enterprise information systems for the purpose of effectively answering business questions

Analyze data obtained from enterprise information systems to identify potential questions from management

Compose enterprise-level reports for management, utilizing audience-appropriate terminology, to respond to senior management inquiries

Prompt

For the final project, you will imagine yourself as a newly contracted junior data specialist. You have been tasked with identifying a business question and selecting and analyzing the relevant data to aid in answering the question. You will also be required to show your abilities in compiling and cleaning the data for a future presentation to management in the form of an executive summary.
You requested all 2015 sales data for Cedar County. Senior management has the following business questions. Select one of the questions below as your focus for the final project.
What were the total 2015 sales by month?
What were the total sales by store in December?

Reference no: EM133731433

Questions Cloud

Explain how the content you selected from the video : Discuss the evidence in this video/ clip that does or does not support the term/ concepts meaning as outlined in the textbook research

Discuss issues like data privacy-algorithmic bias : Consider issues like data privacy, algorithmic bias, and the "automation paradox" where skills degrade when tasks are automated.

Evaluate the advantages of outsourcing hr functions : Today my company has 47 employees and enjoys a great relationship with CBR, our HR outsourcing firm. Evaluate the advantages of outsourcing HR functions.

Identify and discuss the various ways of determining : Identify and discuss the various ways of determining validity. Provide examples of how this can be accomplished for each type of validity

Compile data from client systems into enterprise : Compile data from client systems into enterprise information systems for the purpose of effectively answering business questions Analyze data obtained

What key steps you take in new product development process : What are the key steps you would take in the new product development process, as outlined by Kotler and Keller? How would you prioritize these steps and why?

Implement a strategic approach to hr : Identify and discuss 2 or 3 major insights from Hardy (chapters 3-4) as applied to employee training and career development processes

Evaluate the appropriateness of their versioning strategies : Investigate the versioning methods used by companies for the programs/services/apps on your computer (or smartphone).

Which pricing objective do you think they are employing : Which pricing objective do you think they are employing: Survival, Maximum market share, maximum market skimming or product quality leadership?

User Account

All Pages