Star data are usually data organized around a central collection of business measures and related descriptive information. For instance it could be that total transactions are recorded in one table and customer, product and date information in other tables. With this setup, it’s simpler to filter reports and analyze business performance from various angles. It’s particularly valuable for dashboards and analytical workloads where people are often summarizing large amounts of data. It is also crucial to understand how the tables are related to one another before creating reports, as the structure could affect the performance of the queries and usefulness of the data.
