BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel olympics - ECPv5.9.0//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel olympics
X-ORIGINAL-URL:https://excelolympics.com
X-WR-CALDESC:Events for Excel olympics
BEGIN:VTIMEZONE
TZID:Europe/Ljubljana
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20180325T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20181028T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20181102
DTEND;VALUE=DATE:20181103
DTSTAMP:20260502T051039
CREATED:20180720T201527Z
LAST-MODIFIED:20180820T091136Z
UID:1058-1541116800-1541203199@excelolympics.com
SUMMARY:Power Pivot MasterClass
DESCRIPTION:Course Overview\nPivot 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. \n\nAnalyzing data from multiple tables in one Pivot Table (could be done but only if certain conditions were met);\nAnalyzing datasets with more than 1.000.000 rows (there was OLAP\, but that was a sort of “what you see is what you get” deal);\n\nThen 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. \nSo 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. \nSoftware Requirements\nAttendees 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. \nCourse at а Glance\nData Model \n\nImporting Data From Multiple Sources (Excel\, Access\, Web\, Txt or CSV)\nFact Tables and Dimensions\nCreating Connections in our Data Model\nCalendar Table\nSort By Column\nData Types\nHide what you don’t need\n\nDAX language and creation of calculations (Measures) \n\nBasic Calculated Columns\nBasic Calculated Fields (Measures)\nCALCULATE\nThe X functions\ntime intelligence\n\nYTD (Year to Date)\nPY (Previous Year)\nPM (Previous Month)\nFunctions for filtering data\n\n\n\nAdvanced Data Modelling Techniques \n\nDisconnected Slicers\n\nManaging  Calculations\nNew Calculations connected to Disconnected Slicers\n\n\nChange Pivot Tables to Functions\n\nCUBE functions\nOLAP Tools in Excel\n\n\n\nSales Data Model \n\nComparing Actuals to Plan (Forecast)\nActual vs. Budget\nComparing Actuals to previous periods
URL:https://excelolympics.com/event/power-pivot-masterclass-2/
LOCATION:Hotel Maison – Sofia\, улица „Атанас Дуков“ 36\, Sofija\, 1407 Promishlena zona Hladilnika\, Bulgarija
CATEGORIES:Predavanja
ATTACH;FMTTYPE=image/png:https://excelolympics.com/wp-content/uploads/2018/07/logo-green-white.png
END:VEVENT
END:VCALENDAR