Tableau Report on Survey Data in PostgreSQL
$750-1500 AUD
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
Projekt ID: #23944179
Om projektet
16 freelancere byder i gennemsnit $1073 timen for dette job
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
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
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
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
Hi There, This sounds like a pretty straightforward project. Thanks for all the details. Happy to help get this turned over quickly
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
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
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