n business, people are constantly making decisions. Show that you understand the decision-making process and the applications, technologies, and processes for gathering, storing, accessing, and analyzing data to help business users make better decisions.

In this assignment, you will discuss the importance of using historical data from a database, data warehouse, or data mart for making decisions for an organization. You will learn about the different types of data analytics and the different ways to present the data to make effective decisions. You will also practice using a spreadsheet as a tool for business analytics. You are to complete the assignment on your own, without assistance from others.

There are two parts to this assignment. You will complete lessons located within the WileyPlus Lab, then you will write an essay discussing the information.

Part 1:

Marketing managers at TED, known for TED Talk events and conferences, feel that the data they have collected over the years could be analyzed to provide them with some insights about their products. They have come to you because of your expertise in data management, knowledge management, and business analytics to ask for your recommendations.

First, you need to complete the following data analytics lessons in WileyPlus using Excel© spreadsheets with formulas, to answer the questions presented. Use the information from the spreadsheets in your essay and provide the spreadsheets or formulas that were used.

You will find the following lessons after the assignment page:

Data Analytics Lesson 01: Excel Activity

If you need additional assistance in completing this activity, review the tutorial located after the last question on using formulas and functions.

Data Analytics Lesson 02: Excel Activity

If you need additional assistance in completing this activity, review the tutorial located after the last question on using sorting and filtering.

Data Analytics Lesson 04: Excel Activity

If you need additional assistance in completing this activity, review the tutorial located after the last question on using the formula bar.

Clearly indicate your answers to the questions in the lessons. Ensure that you clearly identify the formulas that were used in your calculations. Any spreadsheets must be submitted separately because if they are attached as appendices, they will not show to the instructor.

Part 2:

Separately, you will write at least a 3-page essay discussing your recommendations as to how you might assist the company based on the data from the spreadsheets you just completed. What is a data warehouse and the three types of analytics that you can provide? What tools could you use? What are the ways that this information might be presented to them to be the most effective?

Explain how organizations use data management, knowledge management, and big data to make them more efficient and effective. Demonstrate that you understand business analytics.

Review the Unit 4 Assignment Rubric and instructions to ensure your work address all criteria.

Components

Your paper must be double-spaced and include at least three pages (minimum 750 words) of content, in addition to the title and reference page.

You are required to have at least three references, one of which must be including the textbook and two quality sources from the Purdue Global Library. Remember that APA uses both in-text citations and a reference list with hanging indents (both are required).

If you need help with these requirements, please use the services of the Writing Center. You may access the Writing Center from Academic Tools.

Utilize spelling and grammar checker in Word to minimize errors.

Put your name in the filename of all submissions.