MsBIP møde nr. 16

Program:

• 17:00-17:45: Let buffet fra Danske Commodities Meyer-kantine
• 17:45-18:00: Velkomst ved Head of Business Intelligence, Jacob Guldberg Poulsen
• 18:00-19:00: Intro to Tabular Model in Analysis Services 2012, Chris Webb
• 19:00-19:15: Kaffepause
• 19:15-20:15: Power Query – Beyond The Basics, Chris Webb
• 20:30-22:00: Rundvisning i Danske Commodities lokaler samt networking (Optional)

Tilmelding foregår via indmeldelse i MsBIP møde nr. 16 gruppen på LinkedIn. Bemærk at der er begrænsede pladser og tilmeldingen derfor bliver lukket ved 70 tilmeldinger. Efterfølgende tilmeldinger vil komme på venteliste.

Indlæg:

Hermed følger en beskrivelse af de to indlæg der bliver præsenteret på mødet.

Intro to Tabular Model in Analysis Services 2012, Chris Webb

The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes.

Power Query – Beyond The Basics, Chris Webb

A lot can be accomplished within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require some knowledge of advanced functionality, including the M language. This session will explore what these requirements might be, how they can be implemented and how best to deploy them to end users. Topics covered will include how to create common types of calculation in M, how to best use functions, calling to web services and OData data sources, and how best to use Power Query with the rest of the Power BI stack, especially Power Pivot.