Dibatalkan

Tableau Report on Survey Data in PostgreSQL

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

Kemahiran: PostgreSQL, Tableau

Lihat lagi: report collating data, excel sheet marketing research survey data entry, report manova data, enter tally survey data, free survey data india applied multivariate, survey data layout, survey data collection garment shop, article writing technical writing report writing data entry, excel report mysql data using php, vba report containing data missin database, can create vbscript html form survey data, curl report post data, limesurvey survey data, reports qualitative survey data, devexpress report xml data, report survey facebook, report mysql data php script

Tentang Majikan:
( 11 ulasan ) Beecroft, Australia

ID Projek: #23944179

17 pekerja bebas membida secara purata $1098 untuk pekerjaan ini

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 Lagi

$1125 AUD dalam 7 hari
(1 Ulasan)
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 Lagi

$900 AUD dalam 7 hari
(2 Ulasan)
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 Lagi

$1200 AUD dalam 10 hari
(3 Ulasan)
3.4
bgreddycs

1.I have around 5 years of experience in BI Tools Tableau,Spotfire,Power bi,Altetyx. [login to view URL] knowledge in creating reports dashboards ,Score cards and Story using Tableau desktop. [login to view URL] knowledge in Tableau serve Lagi

$1111 AUD dalam 5 hari
(3 Ulasan)
1.8
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 Lagi

$1000 AUD dalam 7 hari
(0 Ulasan)
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 Lagi

$1125 AUD dalam 7 hari
(0 Ulasan)
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 Lagi

$850 AUD dalam 7 hari
(0 Ulasan)
0.0
Udeep

Greetings - Thank you for posting such an exciting project. I'm very much interested in your project as I have been working as BI Consultant for over 6 years and have professional history of designing and implemen Lagi

$1000 AUD dalam 10 hari
(0 Ulasan)
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 dalam 5 hari
(0 Ulasan)
0.0
snaciri81

Hi You know, Data viz and data analysis are my passion. I am inspired when I work with people to achieve their goals while providing a high quality data insights. with More than 8 years in BI and analytics and more Lagi

$1000 AUD dalam 7 hari
(0 Ulasan)
0.0
somarastogi05

Proficient in Statistics and [login to view URL] good knowledge of databases. Proficient in Tableau for data visualization. Worked with various UK and US based clients . Can show you my sample work . Message me to discus Lagi

$1125 AUD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$1200 AUD dalam 10 hari
(0 Ulasan)
0.0
kiranpadshetty77

I have 3 years of experience in [login to view URL] using various data [login to view URL] many dashboards. Good experience in actions,filters and [login to view URL] in calculations. Creating KPI's is very important for project. Lagi

$1125 AUD dalam 5 hari
(0 Ulasan)
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 Lagi

$1500 AUD dalam 7 hari
(0 Ulasan)
0.0
d1scoveritech

Good day! I am an expert developer in PHP, HTML, Tableau, Magento, Laravel, and WordPress, I am always ready to work on various customer application development needs from effective visualization to completion to Lagi

$1500 AUD dalam 14 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0