Tableau Report on Survey Data in PostgreSQL

Annulleret Opslået 4 år siden Betalt ved levering
Annulleret Betalt ved levering

This project is to analyse some customer data. The application that generates the data is used to monitor customers (patients) who have long-term needs that eventually get resolved. Each week a customer gets asked two questions, one about how they are feeling (personal question), and one about what they think of the company who is serving them (the corporate question).

The column 'about_company' is true for entries corporate questions, and false for personal questions.

The answers that they give to each question is an integer (x,y) pair where -2 <= x < 2 and -2 <= y < 2.

(-2, -2) is very bad, (+2, +2) is very good. If it helps, we have emoticons that represent each possible answer to show you.

The managers in charge of this program would like a Tableau dashboard created (or several dashboards if it makes sense).

- Customers with very negative values for x_trend and y_trend in customer_progression

- Overall view of customers this week (i.e. visualise customer_responses for data in the last week)

- Names and phone numbers of customers whose response this week was in one of the corners (-2, +2), (+2, +2), (+2, -2), (-2, -2) -- this would be 4 different worksheets, and will involve joining to the customers table. We can create an SQL view for this if it necessary.

- Being able to set a filter to only see one customer and thus see a picture of that customer's responses over time (the customer_responses table)

We have a sample set of data that you can access that is in a public Amazon RDS (Postgresql) instance, or we can give you a pgdump of the data.

You will deliver a set of Tableau files for these reports suitable for running in Tableau Desktop.

Here are the relevant database tables and schema if this helps in your quoting:

CREATE TABLE customers (

customer_id uuid primary key,

customer_name varchar,

mobile_phone varchar,

active bool,

date_activated timestamp not null,

date_deactivated timestamp

);

CREATE TABLE customer_responses (

customer_id uuid references customers,

survey_id uuid references surveys_sent,

about_company bool,

x_pos int check (x_pos >= -2 and x_pos <= 2),

y_pos int check (y_pos >= -2 and y_pos <= 2),

when_received timestamp not null

);

create table customer_progression (

customer_id uuid references customers,

about_company bool

x_trend float

y_trend float

); -- actually implemented as a view, but that won't make any difference to this project

PostgreSQL Tableau

Projekt ID: #23944179

Om projektet

16 bud Remote projekt Aktiv 4 år siden

16 freelancere byder i gennemsnit $1073 timen for dette job

jinc772

Hi, I am a senior web developer and have good experience in DB Administration. I have deep knowledge in several types of SQL and NoSQL DBs such as MySQL, MSSQL, MongoDB, DynamoDB and so on. Also have experienced in DB Flere

$1125 AUD in 7 dage
(1 bedømmelse)
4.4
bakulpatela1

Hi, I am an experienced data/Business analyst and expert in PostgreSQL, Tableau and it's products, SQL, Access, Excel, Google sheets, Power BI, Office365, SQL server analytics services. I am more than happy to comple Flere

$900 AUD in 7 dage
(2 bedømmelser)
3.0
schoudhary1553

Hello, I can help you with your project - Tableau Report on Survey Data in PostgreSQL I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have alrea Flere

$1200 AUD in 10 dage
(3 bedømmelser)
3.4
dvcontact

Hi, Reading your project description about building your on Survey Data in PostgreSQL makes me feel like you have me in mind when creating the project. I have all it takes to deliver. I have vast experience working on Flere

$1000 AUD in 7 dage
(0 bedømmelser)
0.0
nikhilgupta84

Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end Flere

$1500 AUD in 7 dage
(0 bedømmelser)
0.0
rdakova

Hello, When I read that your project is related to medical data, I got really excited :) I graduated several years ago from my bio and medical informatics masters program and I have been itching to work on such project Flere

$1200 AUD in 10 dage
(0 bedømmelser)
0.0
julakanti

Hello I can get this job done as requested. I need more info on the data and other specs. feel free to contact me. Dinesh

$999 AUD in 7 dage
(0 bedømmelser)
0.0
shshankchawathay

Hi There, This sounds like a pretty straightforward project. Thanks for all the details. Happy to help get this turned over quickly

$800 AUD in 5 dage
(0 bedømmelser)
0.0
Sourabh7023

I have created many survey dashboards from scratch. I have Worked for data engineering and dash-boarding for Medallia, Qualtrics, Foresee data (all 3 are survey data vendors),which are far too complex than your data a Flere

$850 AUD in 7 dage
(0 bedømmelser)
0.0
venkatmaruti

I work in Google as AI Manager and expertised in making dashboards as we regularly work with making dashboards and I can make the dashboard with few more visualisations apart from what you had mentioned to ensure it pr Flere

$1125 AUD in 7 dage
(0 bedømmelser)
0.0
rameshballa

I am working as a data Analytics professiona since 7 years so it will be easy for me to deliver the project with in the time i mentioned provided all the requirements

$1111 AUD in 2 dage
(0 bedømmelser)
0.0