1 of 1 people found this helpful
i want to build Star Schema and Snowflake Schema using tableau can i build this please help me to understand?
In Tableau we dont have option to do data modelling .You can perfrom the data modelling at your data base end and then you can connect those datewarehouse with tableau.You cannot create any new table in Tableau. You can connect to the existing tables. So unfortunately, you would have to do this in database only and then connect to these tables in Tableau and join them
In tableau you just connect to existing data sources, there's no need to build a star schema within the product. If connecting to a database you could just write a SELECT statement to bring in the data you want or you could just connect to each table and join them within Tableau
What type of data model should we use with Tableau?
Traditionally, dimensional data models or star schemas have been used in a data warehouse to serve the purposes of integrating data from different sources and improving the performance of analytical queries. With Tableau’s data engine, we may or may not need a dimensional model in order to support our analysis depending on whether we are using In-Memory Data or a Direct Connection and considering Performance and Data Integration objectives..