It's important to know what a record (row) in the data represents. So what should be a row or column? What is a row?Ī row, or record, can be anything from information around a transaction at a retail store, to weather measurements at a specific location, or stats about a social media post. That is, data stored in rows and columns, with column headers in the first row. Tableau Desktop works best with data that is in tables formatted like a spreadsheet. But if you can optimize the data structure it will likely make your analysis much easier. For an example of how to perform the same analysis with different data structures, see Tableau Prep Day in the Life Scenarios: Analysis with the Second Date in Tableau Desktop (Link opens in a new window). It is often still possible to perform the analysis but you may need to change your calculations or how you approach the data. However, there may be situations when you can't pivot or aggregate your data as desired. The rest of this topic assumes you have access to the raw data and the tools needed to shape it, such as Tableau Prep Builder. The structure of your data may not be something you can control. ![]() If you do not already have a data set you can use, see our tips for finding good data sets (Link opens in a new window). ![]() Tip: It may help to go through the following topic with a data set of your own. ![]() rows and columns, as well as aspects of data cleanliness, such correct data types and correct data values. Data can be generated, captured, and stored in a dizzying variety of formats, but when it comes to analysis, not all data formats are created equal.ĭata preparation is the process of getting well formatted data into a single table or multiple related tables so it can be analyzed in Tableau. There are certain concepts that are fundamental to understanding data prep and how to structure data for analysis.
0 Comments
Leave a Reply. |