See Create a Data Model in Excel for details. You can also use the Power Pivot add-in to create or manage the model. Relationships exist within a Data Model-one that you explicitly create, or one that Excel automatically creates on your behalf when you simultaneously import multiple tables. For example, a database that you import might represent order data by using three related Digital This is the approach used in relational databases like SQL Server. One solution to this problem is to split the data into multiple tables and define relationships between those tables. Storage is cheap, but if the e-mail address changes you have to make sure you update every row for that customer.

This approach can work, but it involves storing a lot of redundant data, such as the customer e-mail address for every order. You could track all the data in a single table having a structure like Movie-Maker

To see why relationships are useful, imagine that you track data for customer orders in your business. A relationship is a connection between two tables that contain data: one column in each table is the basis for the relationship. Add more power to your data analysis by creating relationships amogn different tables.

Download meaning of true relationship