A Schema serves as a fundamental blueprint or model for organizing and structuring data within a database.
This architectural framework delineates the structure of the data, establishes relationships between diverse data elements, and outlines constraints or rules essential for the storage and retrieval of data.
Upon dataset creation, the subsequent step involves constructing a Schema. This process involves combining data from different sources through blending or joining tables. Once a join schema is established, users can seamlessly integrate data from various tables into a unified dataset, facilitating comprehensive analysis and insight discovery.
The schema serves as a foundation for database design and is crucial for ensuring data consistency, integrity, and organization.
Following the dataset upload, the subsequent step involves creating a schema to facilitate the construction of a dashboard.
Steps for creating a Schema:
Step 1: Upon selecting “Create Schema“, the schema window will appear. If the data contains multiple sheets, the user needs to choose “Join Tables” and then click on “Proceed”.
Creating Joins Between Different Datasets:
Creating joins between different datasets involves combining or merging data from multiple sources or datasets based on common attributes or fields. In the context of databases or data analysis, a join is a way to bring together related information from different tables or datasets, allowing for a more comprehensive and interconnected view of the data.
For example, if you have one dataset containing information about customers and another dataset containing information about their purchases, you might join these datasets using a common identifier, such as a customer ID. This allows you to combine the information and analyze customer behavior, preferences, and purchase history in a more integrated manner.
Step 2: In the Join Schema, the user must select the table and column of both sheets (the chosen column in both sheets should be identical). Step 3: Various types of joins are at your disposal; choose the appropriate join based on your requirements. For the demonstration, we are choosing inner join.
Types of Joins:
- Inner Join: Selects common records from both Table A and Table B where the specified join condition is satisfied.
- Left Join: Retrieves all records from Table A and only those from Table B for which the join condition is met (if any).
- Right Join: Retrieves all records from Table B and only those from Table A for which the join condition is met (if any).
- Full Join: Retrieves common records from both Table A and Table B, along with the remaining non-join records from Table A and Table B.
Step 4: Upon successfully creating joins, a “Joins are valid” message will be displayed. Proceed by clicking “Save”. Step 5: Provide the schema name and click “Save”.Step 6: Upon saving the schema, the Schema Manager window will open. For more details on Schema Manager, please refer to the Schema Manager document. Now you can create a dashboard by clicking on “Create dashboard”.