İptal Edildi

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

Beceriler: PostgreSQL, Tableau

Daha fazlasını gör: 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

İşveren Hakkında:
( 11 değerlendirme ) Beecroft, Australia

Proje NO: #23944179

Bu iş için 17 freelancer ortalamada $1098 teklif veriyor

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 Daha Fazla

$1125 AUD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$900 AUD in 7 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$1200 AUD in 10 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$1111 AUD in 5 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$1000 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1125 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$850 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1000 AUD in 10 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1000 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1125 AUD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1200 AUD in 10 gün içinde
(0 Değerlendirme)
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. Daha Fazla

$1125 AUD in 5 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1500 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$1500 AUD in 14 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
0.0