Tableau Data modeling
Not able to solve Data model in tableau
Here is the link for the data:-
thanks for reaching out! From what I can see you have a lot of tables and white spaces in your data. In order for it to be read correctly you'll most likely have to format it in a certain way. Preferably, each individual table should be in its own sheet without any whitespaces.
Thanks @Elitsa for your answer. So, what I understand is to format excel first and then use in tableau for data modeling. Is there any way to use directly as a data model in a tableau? And what are the other ways to approach for data modeling for this kind of data. Thanks
What you can try is use the tableau data interpreter to read the data and see how far this gets you. When you read a file, there's a box you can tick to use Tableau's data interpreter. This might save you some in cleaning up the data.
Alternatively, Tableau offers a prep builder, however its a paid product and I haven't used it myself, so I can't vouch for how effective it is and how complicated files are handled. You can check out their page here:
Otherwise, I mostly clean up the data, so that it's read with Tableau, or directly use csv files if I know I'll be working with Tableau.
Thanks Eli, I tried but tableau data intrepreter is not able to recognize the complex excel file which I shared with you.
A Tableau data model contains the following Connection information to the underpinning data source. The queries needed to recoup the data. fresh metadata, or data about the data, added to the underpinning data.
Data modeling is the process of diagramming data flows. When creating a new or alternate database structure, the developer starts with an illustration of how data will flow into and out of the database.
Source: Tableau Course in Pune