Abstract: This is actually the 2nd example within the a series. In the first concept, Import Research to your and construct a document Design, an excel workbook was created having fun with study imported out-of multiple present.
Note: This information identifies analysis models inside Prosper 2013. But not, a similar studies modeling and you can Electricity Pivot have introduced within the Excel 2013 and additionally connect with Prosper 2016.
In this concept, make use of Fuel Rotate to increase the content Design, carry out hierarchies, and build determined areas out-of existing studies to create this new relationships anywhere between dining tables.
New parts within lesson would be the adopting the:
So it show uses research discussing Olympic Medals, hosting countries, and different Olympic sporting events. New lessons inside series are definitely the following:
Such lessons fool around with Do just fine 2013 which have Strength Pivot let. For more information on Excel 2013, click here. To own strategies for providing Energy Pivot, click.
Include a relationship using Drawing Glance at for the Electricity Pivot
Within area, you employ brand new Microsoft Work environment Fuel Rotate for the Prosper 2013 include-into continue the newest design. Playing with Diagram Consider from inside the Microsoft SQL Machine Stamina Rotate to possess Do well tends to make performing relationships easy. Very first, you really need to make sure you feel the Fuel Pivot include-from inside the permitted.
Note: The advantage Rotate inside the Microsoft Excel 2013 include-in the belongs to Workplace Professional Plus. Pick Start Electricity Rotate from inside the Microsoft Do well 2013 incorporate-set for much more information.
When Power Pivot are allowed, you will find a bow loss in Prosper 2013 called Stamina Rotate. To enable Energy Rotate, follow these types of steps.
The brand new Excel workbook includes a dining table entitled Computers. We brought in Hosts because of the duplicating it and pasting it on Do just fine, next formatted the knowledge because the a table. To provide the fresh new Machines dining table on Investigation Design, we should instead present a romance. Why don’t we fool around with Strength Rotate to help you aesthetically represent the brand new relationship about Investigation Model, then create the matchmaking.
For the bend, discover Fuel Pivot > Tables > Add to Investigation Model. This task contributes the newest Hosts table into the Data Model. What’s more, it opens the advantage Pivot include-in the, which you use to execute the remaining stages in this step.
See that the power Rotate window suggests all the dining tables into the the latest design, and Machines. Click through a couple tables. In Stamina Rotate you can view all the data you to your design consists of, in the event they aren’t presented in every worksheets inside the Do well, for instance the Disciplines, Incidents, and you can Medals studies less than, together with S_Organizations,W_Teams, and you will Sporting events.
Use the slide bar to resize the new diagram you are able to see all the objects about drawing. Reorganize the brand new dining tables by hauling its label pub, so they have been noticeable and you will arranged alongside each other. Observe that five tables try not related with the remaining tables: Computers, Events, W_Communities, and you can S_Teams.
You can see one to both the Medals table and the Events table keeps an area titled DisciplineEvent. Upon further inspection, you determine the DisciplineEvent profession regarding Events table comprise out of unique, non-regular viewpoints.
Note: This new DisciplineEvent profession is short for a different combination of per Discipline and you may Enjoy. Throughout the Medals desk, but not, the brand new DisciplineEvent industry repeats repeatedly. That renders experience, because the for every Punishment+Enjoy integration results in about three approved medals (silver, her hesap silme gold, bronze), being issued for each Olympics Release case was kept. Therefore the relationships anywhere between men and women tables is certainly one (that novel Abuse+Enjoy entry regarding the Specialities dining table) to many (multiple entries each Abuse+Feel value).
Do a love between your Medals table in addition to Incidents dining table. During Diagram Take a look at, pull the newest DisciplineEvent job from the Events dining table into DisciplineEvent field into the Medals. A column looks between the two, proving a relationship might have been mainly based.
Leave a Reply