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

  Decomposition for r = (a,b,c,d,e )

Give a good decomposition for R = (A,B,C,D,E ) with the following functional dependencies:

  Create an sql query that uses an uncorrelated subquery

Create an SQL query that USES AN UNCORRELATED SUBQUERY2 AND NO JOINS3 to display the descriptions for products provided by a vendor in area code 615.

  Oracle general sql exercise

Oracle General SQL Exercise

  Write an update statement that modifies the row

Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the ProductName column to "Woodwinds", and it should use the CategoryID column to identify the row.

  Write a sql query for each of the following requirement

MIS 4300 / ACCT 4300 Database Fundamentals Spring 2014. How many times the vendor has placed an order for the item ID = 1 (rename it as NUMORD)?

  Select statement that uses the first select statement

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns.

  In this problem we will consider a movie database with

in this problem we will consider a movie database with three tablesmoviedirectortitle director yearmoviecasttitle actor

  Create the needed tables in the sql server environment

Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

  Explain simply how has the execution plan changed

Explain simply how has the execution plan changed from the original query to your query - Make any additional changes (for example indexing)

  Create the tables department employee computer and vehicle

Create the tables DEPARTMENT, EMPLOYEE, COMPUTER, and VEHICLE. Add the primary key field(s) and at least 2 non-key fields to each table that are relevant to that table (ie. PhoneNumber would be valid for EMPLOYEE).

  Create tables and relationships from database design discuss

Create the tables and relationships from the database design discussed. Add at least five records into each table (Note: You must determine the field values).

  Describe the meaning of keyword exists and not exists

Describe the meaning of the keyword EXISTS. Describe how any and all relate to EXISTS and NOT EXISTS. Write a query which will display names of any customers who are interested in all artists.

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