User Account

All Pages

Write a reflection paper to outline the organizational need

Assignment Help PL-SQL Programming
Reference no: EM133059291

This task consists of three sections:

In Section 1, you will use SQL(Postgresql) and a business intelligence tool(Tableau) to create data dashboards to support executive decision-making. Your dashboards should enable leaders to answer a specific research question on an organizational need.

Your dashboard will integrate data from two sources:

1. Provided data set (Churn dataset):

2. Additional data set (Here you can use the dataset of the sample superstore available in the tableau which is also provided) : You will identify an external, public data set as an additional data set for your dashboard. This data set should contain data and variables that complement the data set you chose from the provided options and should enhance the insights you can gain from the provided data set. Recommended sources include U.S. census data, Kaggle, or other public data repositories. You are responsible for ensuring that you have the rights to use the data set.

In Section 2, you will give a simulated presentation to a panel of peers. You will describe the use of SQL in preparing the data from the two data sets for the analysis and then demonstrate the functionality of the SQL scripts and other codes that supported the creation of the dashboards.

In Section 3, you will write a reflection paper to outline the organizational need and summarize the findings from the analysis.

Refer to the data dictionary for your chosen provided data set for additional background information about the audience of your data representations.

Section 1: Data Dashboards
A. Provide a copy of your dashboards that support executive decision-making.
1. Provide both data sets that serve as the data source for the dashboards.- Datasets are given
2. Provide step-by-step instructions to guide users through the dashboard installation.
3. Provide clear instructions to help users navigate the dashboards.
4. Provide a copy of all SQL code and other code supporting the dashboards.

Section 2: Demonstration (It should be a writeup)
B. You should do all of the following in your presentation:
1. Describe the technical environment used to create the dashboards.
2. Demonstrate the functionality of the dashboards.
3. Explain the SQL scripts used to support the creation of the dashboards.
4. Explain how the data streams were prepared to support the analysis.
5. Describe how data were aligned with other data points.
6. Demonstrate how the databases were created.
7. Explain how referential integrity was enforced in the database.

Section 3: Report
C. Write a report to outline the data exploration, use of advanced SQL operations, and the analysis of the data. Do the following as Section of your report:
1. Explain how the purpose and function of your dashboard aligns with the needs outlined in the data dictionary associated with your chosen data set.
2. Justify the selection of the business intelligence tool you used.
3. Explain the steps used to clean and prepare the data for the analysis.
4. Summarize the steps used to create the dashboards.
5. Discuss the results of your data analysis and how it supports executive decision-making.
6. Discuss the limitation(s) of your data analysis.

Attachment:- Telecommunications Churn.rar

Reference no: EM133059291

Questions Cloud

Research important in health care industry : Why is research important in the health care industry? Provide an example. Do you have any experience with research? Explain.
What will be the yield on the bond : Assume that the above assessments are true, what will be the yield on the bond, one year from now assuming that the bond's default and liquidity premium
Analyze the current process for inefficiencies : Describe Target and how the selected process fits into the overall framework of the company. Analyze the current process for inefficiencies.
How much is the total contributed capital of ABC Corporation : Unrealized Gain on financial asset at FMV through OCI/L, P200,000. How much is the total contributed capital of ABC Corporation
Write a reflection paper to outline the organizational need : Describe the use of SQL in preparing the data from the two data sets for the analysis and then demonstrate the functionality of the SQL scripts and other codes
What is the gain or loss to be recognized : What is the gain or loss to be recognized in the profit or losses as a result of the distribution of the property dividends on January 31
Determine the net present value of acquiring the new asset : The company also accounted that the acquired asset has 1,686,375 salvage value. Determine the net present value of acquiring the new asset
Should the airline accept your offer : Should the airline accept your offer if it employs the incremental principle? Will the airline accept your offer? Why or why not
Re-draft the statement of financial position : On June 30, 2021, McNeil Limited has the following statement of financial position: Reserves 7,750. Re-draft the statement of financial position

Reviews

len3059291

1/2/2022 10:54:32 PM

Also, I have a few questions If the task answers provided are wrong, what is the procedure and how will you correct them What no. of days you will take to correct the task as the matter is time-sensitive Do you correct the task until it is confirmed without any additional cost?

len3059291

1/2/2022 10:54:16 PM

I will provide you with the task details(word file) and two datasets(churn and superstore). You will provide all correct answers to the questions mentioned in the task word document which is having 3 parts with each part having multiple questions. The correct answers will need to be written/printed below the actual question in the task document. You will provide the worked files(PostgreSQL and tableau with the source datasets( 2 datasets) attached to them) The sample superstore dataset is readily available in the tableau software too You will be responsible for the software(PostgreSQL and Tableau) The answers should not be generic. They have to be specific to the work. For Eg if a question is asked how you created the dashboard and explain it to the client. The answer should state the exact sheets used and why were they used for the dashboard creation and will have to explain how the dashboard will behave with any dropdowns if used and how will it help the client The deadline for this task is one week.

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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