Tutorial: Expand Investigation Model relationship playing with Do just fine, Fuel Rotate, and you will DAX

Tutorial: Expand Investigation Model relationship playing with Do just fine, Fuel Rotate, and you will DAX

Abstract: This is basically the next course into the a series. In the first tutorial, Import Data to your and build a document Model, a get noticed workbook is made using study brought in from several present.

Note: This particular article means analysis models in the Prosper 2013. But not, an equivalent study modeling and you can Fuel Pivot has introduced in Do well 2013 together with apply to Do just fine 2016.

Within this lesson, you utilize Electricity Rotate to extend the knowledge Model, manage hierarchies, and create calculated industries away from current data to create the newest dating between tables.

This new sections within lesson is the after the:

This collection uses investigation explaining Olympic Medals, hosting nations, and differing Olympic football. New tutorials within this show certainly are the adopting the:

These types of lessons explore Do just fine 2013 that have Strength Rotate allowed. For more information on Prosper 2013, click here. Getting tips on enabling Energy Rotate, just click here.

Add a love playing with Drawing Check inside Strength Pivot

Inside area, you utilize the brand new Microsoft Workplace Fuel Pivot from inside the Do well 2013 incorporate-directly into increase the brand new design. Using Diagram Have a look at for the Microsoft SQL Servers Energy Pivot to have Do just fine can make performing relationships easy. Very first, you hot or not nasıl kullanılır will want to be sure to have the Energy Pivot put-for the allowed.

Note: The benefit Pivot from inside the Microsoft Prosper 2013 put-within the falls under Workplace Elite And additionally. Come across Initiate Stamina Rotate during the Microsoft Do well 2013 include-set for considerably more details.

Whenever Stamina Pivot was permitted, you will find a ribbon loss when you look at the Do well 2013 named Strength Pivot. Make it possible for Strength Pivot, follow these types of procedures.

The newest Do just fine workbook comes with a desk titled Machines. I brought in Hosts from the duplicating they and you may pasting they towards Do just fine, then formatted the information and knowledge because the a desk. To incorporate the new Hosts table towards the Investigation Model, we should instead expose a romance. Why don’t we play with Strength Pivot to aesthetically depict the new dating on Research Design, and then produce the dating.

Towards bow, select Fuel Rotate > Tables > Add to Research Model. This action adds the new Servers desk toward Data Design. In addition, it reveals the power Rotate add-for the, that you apply to perform the remainder steps in this action.

Note that the benefit Rotate window reveals most of the tables in the the fresh new design, and Servers. Click through several tables. Inside the Energy Pivot you will see the study one the design contains, even though they aren’t exhibited in just about any worksheets during the Excel, like the Procedures, Occurrences, and you may Medals data lower than, along with S_Groups,W_Organizations, and you can Sporting events.

Make use of the slip pub to resize the new drawing and that means you are able to see the stuff throughout the drawing. Reorganize the dining tables of the pulling their term bar, therefore they truly are visible and organized alongside one another. See that five dining tables was unrelated to your other countries in the tables: Servers, Events, W_Communities, and you can S_Groups.

The truth is one to both Medals table additionally the Occurrences desk has actually an area titled DisciplineEvent. Up on after that assessment, you dictate the DisciplineEvent career from the Incidents dining table comprise from book, non-frequent philosophy.

Note: Brand new DisciplineEvent industry represents a separate combination of each Punishment and you will Knowledge. From the Medals desk, not, brand new DisciplineEvent career repeats many times. That renders experience, due to the fact for each Punishment+Experience consolidation leads to about three awarded medals (silver, silver, bronze), being given for each and every Olympics Release the function try stored. Therefore, the relationships ranging from those tables is but one (that novel Punishment+Skills entryway regarding Procedures dining table) to numerous (numerous entries per Abuse+Event really worth).

Manage a love involving the Medals desk and the Incidents table. While in Drawing Examine, pull the fresh DisciplineEvent career on Situations table on the DisciplineEvent career into the Medals. A column seems between them, appearing a relationship has been based.

Deja una respuesta