Tilmelding til MsBIP møde nr. 9 er nu åben

Mødet afholdes onsdag d. 21. november hos Microsoft i Hellerup. Vi starter ud med pizza buffet fra kl. 18:00-18:30, hvorefter den faglige del startes og forsætter til kl. 21. Det er lykkedes at sammensætte en agenda med to internationale indlæg af meget høj kvalitet, så der er virkelig noget at se frem til. Derudover lever vi endnu en gang op til ambitionen om et “blødt” og et “nørdet” emne.

“Excel 2013 PowerPivot in Action” præsenteres af Alberto Ferrari:
Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment where to build self-service BI solutions.
In this session we will see how to create a business solution from scratch, from loading tables inside PowerPivot, enriching them with new data, building complex formulas using the DAX language, leveraging the materialization of DAX queries in Excel and finally building dashboards and reports using the new PivotTable features and Power View. The goal of the session is to provide a clear understanding of the power of BI in Excel 2013 and raise your curiosity about the DAX language and the Tabular architecture.

“Layered Partitioning – (re)load your data fast” præsenteres af David Peter Hansen:
Loading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us.

Tilmelding til mødet vil, som tidligere, foregå via LinkedIn, hvor man denne gang skal indmeldes i sub-gruppen “MsBIP møde nr. 9“. Ses vi – det tor jeg nok Vi gør 🙂