Tutorial: Increase Investigation Design matchmaking having fun with Do well, Fuel Pivot, and you can DAX

Abstract: This is the next lesson inside a sequence. In the first tutorial, Import Studies towards and construct a data Design, a be noticeable workbook was developed using investigation brought in of several offer.

Note: This informative article identifies studies models in Do well 2013. not, an equivalent data acting and you will Energy Pivot features brought in the Excel 2013 plus affect Do just fine 2016.

Contained in this class, you employ Electricity Rotate to extend the content Model, would hierarchies, and build calculated sphere out of current studies to produce the fresh matchmaking between dining tables.

The areas inside course is the following:

That it series spends data outlining Olympic Medals, hosting nations, and other Olympic activities. The brand new training within this collection could be the after the:

These sdc kortingscode types of training explore Prosper 2013 having Energy Rotate permitted. For additional information on Excel 2013, view here. To have some tips on enabling Power Rotate, follow this link.

Add a love playing with Drawing Check in the Stamina Pivot

Within this part, make use of this new Microsoft Office Energy Pivot in the Excel 2013 create-into extend this new model. Having fun with Diagram Examine in Microsoft SQL Server Stamina Pivot to own Prosper can make undertaking dating easy. First, you need to definitely have the Fuel Pivot add-for the permitted.

Note: The power Rotate inside Microsoft Excel 2013 include-in the falls under Work environment Top-notch Together with. Find Begin Fuel Rotate when you look at the Microsoft Do well 2013 incorporate-in for more information.

Whenever Power Rotate is allowed, the truth is a bend case into the Excel 2013 named Fuel Pivot. Allow Energy Pivot, realize these strategies.

The newest Do just fine workbook includes a desk entitled Hosts. I imported Servers from the duplicating they and you can pasting it on the Do just fine, following formatted the data as a table. To incorporate the new Machines table on the Data Design, we must present a relationship. Let us play with Fuel Pivot in order to aesthetically portray the latest dating in the Data Design, then create the dating.

On ribbon, look for Power Rotate > Dining tables > Add to Research Model. This step adds this new Computers desk into Study Design. Additionally, it opens up the power Rotate put-from inside the, that you use to perform the remaining stages in this step.

Note that the benefit Rotate windows suggests all the tables within the new model, in addition to Hosts. Click through a couple dining tables. Within the Strength Pivot you can view all the study one your own design include, regardless if they’re not displayed in virtually any worksheets for the Do well, like the Disciplines, Events, and you may Medals studies lower than, in addition to S_Teams,W_Organizations, and you can Activities.

Make use of the slide club to resize the brand new drawing and that means you can see most of the stuff about drawing. Rearrange the dining tables by hauling their identity bar, so they’re visible and you can positioned close to one another. See that four tables was unrelated to the other countries in the tables: Servers, Incidents, W_Teams, and you may S_Organizations.

You will find you to both the Medals dining table as well as the Occurrences desk provides an area named DisciplineEvent. On then check, your influence the DisciplineEvent occupation on the Occurrences desk is made up out of unique, non-repeated thinking.

Note: Brand new DisciplineEvent industry means yet another combination of for every single Punishment and you will Feel. About Medals table, but not, the fresh DisciplineEvent job repeats a couple of times. That makes experience, given that for each Punishment+Skills combination results in about three awarded medals (silver, gold, bronze), that are issued each Olympics Release the event is actually stored. So that the relationships anywhere between those tables is one (you to definitely novel Discipline+Experiences entryway from the Disciplines table) to numerous (several records for every Discipline+Experiences well worth).

Do a romance between the Medals desk together with Events table. During Diagram View, pull the DisciplineEvent profession regarding Incidents table on the DisciplineEvent field when you look at the Medals. A line seems between them, proving a relationship could have been situated.

Vélemény, hozzászólás?

Az e-mail címet nem tesszük közzé. A kötelező mezőket * karakterrel jelöltük