MsBIP møde nr. 21

3 jun 2014 - 17:00

Saxo Bank, Philip Heymans Alle 15, Hellerup

Agenda

  • 17:00-17:15: Velkomst
  • 17:15-18:15: Using Extended Events for Real Time Monitoring of Saxo Banks SQL Servers, Ola Hallengren
  • 18:15-18:45: Let bespisning og mulighed for at netværke
  • 18:45-20:00: Power Query in Modern Corporate BI, Marco Russo

Tilmelding foregår via indmeldelse i MsBIP møde nr. 21 gruppen på LinkedIn. Der er til dette møde plads til ikke mindre end 130 deltagere :-)

Indlæg

Vi har på dette møde fornøjelsen af to udenlandske MVP’er som speakere. Dels Saxo Banks egen Ola Hallengren og italienske Marco Russo. De præsentere følgende to indlæg:

Using Extended Events for Real Time Monitoring of Saxo Banks SQL Servers, Ola Hallengren

Including Showcase from Saxo Banks Trading Platform & Data Warehouse.

Power Query in Modern Corporate BI, Marco Russo

In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, and Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and validate the access to corporate data sources? How do you share and validate new queries created by end users? How can users extract data at the right granularity level? Power Query bridges the gap between corporate and self-service BI. It empowers end-users so that they can extract and manipulate data from several data sources, inside and outside of the company. In this session, learn the Power Query best practices that enable the extraction of data from existing database and cubes, guided by an expert who understands both worlds (Corporate BI and Power Pivot data models).