Help create a dynamic T-SQL Table / View for Data Visualisation : Network Graph
$10-30 USD
Paid on delivery
Looking for a sql developer to help 1) prepare data in SQL View or table so that I can visualise the data as a 'Network Chart' in Tableau.
The chart should show Territories with Countries, Companies and Contacts linked. Please see this video to help explain how the data should be prepared :[login to view URL]
From the video, the data is prepared manually, I need this prepared so that row ids, x and y axis are generated dynamically so that I can plot the data in Tableau.
The relationships and datasets are simple yet there are a lot of contacts and companies.
Perhaps a Skype call would be easier to explain? Have you done something like this before?
Project ID: #17599209
About the project
20 freelancers are bidding on average $64 for this job
Hello, I have checked project requirements and can work on this project. It will be delivered with quality. Thanks.
Hello! I'm a software engineer with more than 10 years of experience in database management, reporting, and related data management projects and tasks. I also have the MCSA SQL Server 2014 certificate. I have extensive More
Hi there - I'm Aly, I've seen your post and I'm interested. I've had much experience in MS SQL Server. I've written much dynamic and relatively complex queries. I can deliver you a query that brings the data in any More
Hi There, 1. Where is this data stored now "The chart should show Territories with Countries, Companies and Contacts linked" ? in MS access/SQL Server/My SQL. Row ID can be generated dynamically and X and Y as we More
i think i can solve your problem, i will try that if i can do it i am very happy to be able to help you
I have in depth knowledge of Sql . I have already worked in this area Relevant Skills and Experience Oracle SQL
Hi My name Is Rafael and work with BI. Development reports and Dashboards in Tableau • Participation of meetings with coordinators and managers to understand the demand and to be able to create the Dashboards in Table More
Hi, i haven't done the same before, But I have written various SQLs which generates dynamic data. After looking at the video, I am sure, I should be able to do the same. Thanks and Regards Sandesh
Dear sir/madam I would like to, first of all, thank you for the opportunity. I am confident that my skill set matches the proposed work and I am able to have it completed within the specified timeline. I am a More
Hi Looks like an interesting problem you have there! It will probably take a few attempts in order to get the SQL to generate the data as you need it. The SQL itself will be quite simple. What will be harder is det More
I enjoy deriving insight from data. I am most comfortable working in Tableau for Data visualization, Talend as ETL tool and MySQL for Database. I always looking for the simplest yet effective way to communicate the in More