SQL Saturday Precon -
Self-Service BI and Office 2013
Location: Microsoft Auditorium, EPDC2, Leopardstown
Date: Friday, 21st
Time: Registration from 9.00. Class starts at 9.30
Cost: €199 Early bird till
31st May. Full Price €249
Microsoft has a new focus for its BI solutions: Office. After years of concentrating on its corporate BI tools, Microsoft is now investing in self-service BI and with Office 2013 is creating a suite of tools that will empower Information Workers to build reports and dashboards, and to analyse data, themselves.
This day-long seminar will look at what’s new and what’s coming in Office 2013, and how these tools can be used to build a self-service BI solution.
- What is self-service BI?
This session will provide an introduction to the idea of self-service BI and what it means to your organisation. It will also compare it with a traditional corporate BI approach and show how the two are not mutually exclusive, and indeed how you will need both forms of BI.
- What is Microsoft’s self-service BI strategy, and how does Office 2013 fit in with it?
With a definition of what self-service BI actually is, we can then look at what Microsoft’s plans for this sector are. We will also identify which parts of Office 2013, and which other tools, can be used to build a self-service BI solution.
- Excel 2013 and PowerPivot
Excel 2013 is at the heart of the Microsoft self-service BI strategy, and PowerPivot and the new Excel Data Model are the most important BI features in Excel 2013. In this session we will look at what has changed in PowerPivot since Excel 2010, how to use PowerPivot and the Excel Data Model to integrate data from multiple data sources.
- Writing calculations and queries in DAX
Following on from the previous session, we will look at the DAX language, how it works and how it can be used to write complex calculations and queries.
- Introduction to OData
This session will introduce the OData protocol, a way of querying data sources through a REST-based interface. We will look at some of the OData data sources that are currently available including Excel Services, Sharepoint and the Windows Azure Marketplace, and see how to create OData feeds using Visual Studio LightSwitch.
- Self-service ETL with Data Explorer
Data Explorer is a sophisticated new Excel addin that makes it easier for users to automate the extraction and transformation of data from multiple data sources, and the loading of that data into Excel. This session will show how it works and provide a brief introduction to its powerful formula language.
- Reporting in Excel 2013
- PivotTables connected to the Excel Data Model, including advanced functionality such as named sets
- Using regular Excel tables bound to DAX queries
- Using Excel Cube Formulas against the Excel Data Model
- Building dashboards and visualisations using Power View
- Exploring geospatial data with GeoFlow
- Publishing reports using Excel Services and Sharepoint