Dibatalkan

Microsoft BI or Tableau: recommendation on DB design for an existing key-value pair db

Since freelancer is removing line breaks, you might look at the attached text file with a better layout.

I have a table that contains about 5,000,000 records.

It is a key-value pair and It has recordID, field_name, field_value, date_created. There are 3,000 different field_names.

Some values have JSON with some additional properties. Ex.

recordID; field_name; field_value

1; name; John;

2; name; Steve;

1; reg_date; Oct 1, 2018

1; age; 21

1; car; ("carType": ["Truck", "SUV"])

2; car; ("carType": ["Sedan"])

3; some_field; ("gameType": ["6","5","7","1","9","3","4","6","66","88","66","2","123"])

1; skin_color; Blue

1; skin_color; Green

1; teeth; 6

1; skin_color; Yellow

1; domestic, Yes

In this case, for recordID 1, it is John, 21 year old, has a truck and SUV, with 6 teeth, and the colors are Blue, Green, Yellow.

Steve drives a sedan.

Table 4 contains 5MM records (about 5,000 different gamers, but each of them might have a completely different set of field_names, on average each gamer has about 1,000 of them)

I would like to know what would be the best way to change this table so that I can use Microsoft BI or Tableau graphical interface and for example select a pie chart representing all the gamers where x-axis = Registration Date, y-axis = number of gamers, and I can filter by Gamer's Age and Skin Color.

Please remember: there are 3,000 different variables (field_names) I could be reporting on.

They are not really categorized, they are just various random properties.

I don't think it's a best practice to have a big table with about 3,000 columns and then creating a separate table that splits JSON contents. Again, the end goal is to use a visual GUI with friendly field names and create various graphs with filters.

What would be your reco on changing the DB architecture to quickly analyze the info using friendly names in Microsoft BI or Tableau?

Kemahiran: Sains Data, Data Visualization, Pembangunan Pangkalan Data, SQL, Tableau

Lihat lagi: cross database joins tableau, how to choose which database to use, using a .tdc file with tableau desktop, how to choose a database engine, tableau server odbc, mindtree power bi interview questions, tableau tdc, power bi cosmos db direct query, design existing home, key value pair php soapclient, microsoft project templates free web design, microsoft word resume template graphic design, microsoft aspnet web application screen design, change design existing drupal project, db design basic hostel details, db design leave management system, autocomplete jquery key value pair, jquery autocomplete key value pair example, autocomplete key value pair, autocomplete jquery key value pair database

Tentang Majikan:
( 5 ulasan ) Kelowna, Canada

ID Projek: #18960533

13 pekerja bebas membida secara purata $213 untuk pekerjaan ini

schoudhary1553

Hello, 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 already completed several projects like this. For evidence you can see my profile. Lagi

$250 CAD dalam 3 hari
(15 Ulasan)
5.6
$200 CAD dalam 3 hari
(19 Ulasan)
4.5
dhanuitdevendra

Hello, Hope you are doing well! We can help you in DB Designing with our Data Architect as a Service (ARCaaS). Please visit [login to view URL] for details. Lagi

$400 CAD dalam 5 hari
(3 Ulasan)
4.2
hemantjhalani

Hey I am expert in building and maintaining dbs and I have more than 5 years of experience in development so I am one of the suitable candidates for this project. I have done master's in mathematics and statistics Lagi

$250 CAD dalam 3 hari
(8 Ulasan)
3.6
cyash61

Hello, I am an analytics consultant with more than 6 years of expertise working with 2 major consulting firms. With over 50 projects delivered using tableau and power bi in the past, I have the depth of experience Lagi

$250 CAD dalam 3 hari
(4 Ulasan)
3.5
ExperSolutions

Hi we are expert in python machine learning and data science related problem using tools like BI, TABLEAU, you can contact us for further details

$200 CAD dalam 7 hari
(8 Ulasan)
2.4
kyleevert

Hi, Thanks for sharing your requirements and I'm glad to apply for that. I am familiar with Angular.js/React.js for the frontend SPA development, along with Node.js/Express.js/for the backend. I’ve experienced ful Lagi

$155 CAD dalam 3 hari
(0 Ulasan)
0.0
DaveSing

Have gone through the requirements. You can share the files and let me help you to solve the problem. Looking forward to working with you.

$140 CAD dalam 5 hari
(0 Ulasan)
0.0
kraman0025

I am a Oracle Database developer in infosys with experience of 2 year in oracle in project basically i am using PLSQL for DB Devleopement.

$111 CAD dalam 2 hari
(0 Ulasan)
0.0
CitachiTech

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data Lagi

$250 CAD dalam 20 hari
(0 Ulasan)
0.0
ektasethi

Hi: If you would like to visualize your data in Tableau with handy filters which shall allow you to take quick decisions, I shall be happy to help. I will help you create a single customized dashboard/report with Lagi

$250 CAD dalam 3 hari
(0 Ulasan)
0.0
joracab

⦁ Obtain results that add value using company data and integrate them from data sources to make them available for exploitation and dissemination. ⦁  Perform concept tests to open advanced analytical market, Machine L Lagi

$200 CAD dalam 10 hari
(0 Ulasan)
0.0
m0hd7ah1r

Will used this project to test my Data Science Skills, Being my first Time will try to give my best.

$111 CAD dalam 3 hari
(0 Ulasan)
0.0