Vse nastavitve piškotka lahko prilagodite tako, da pomaknete jezičke na levi strani.
Vse nastavitve piškotka lahko prilagodite tako, da pomaknete jezičke na levi strani.
Pivot tables have always been the key reason why data analysts choose Excel. So in all their awesomeness two key shortages have lingered in the background.
Then in 2009 Power Pivot came around and it was a game changer. All of a sudden the user could create data models with multiple data sources and calculate “time intelligent” calculations and running totals with ease and then include all these calculations in a single(!) pivot table.
So this course is all about Power Pivot and empowering attendees with a workshop style learning process by building a Sales Data Model getting data from multiple sources.
Attendees should have Excel Professional Plus (Pro Plus) 2010 or higher. If they use Excel 2016 Pro Plus or 2013 Pro Plus they need no extra installations, for version 2010 Pro Plus Power Pivot Add-Inn for Excel 2010 will need to be installed.
Data Model
DAX language and creation of calculations (Measures)
Advanced Data Modelling Techniques
Sales Data Model
Posamezni piškotki so nujni za delovanje naše spletne strani in jih ni moč onemogočiti.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
Spletna stran uporablja tudi te piškotke:
Statistika, za spremljanje ogledov.
Please enable Strictly Necessary Cookies first so that we can save your preferences!