22-25 April 2026 
SQLBits 2012
Business Intelligence with Excel 2010
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll have a look at some of the most common BI features in Excel 2010 like: Pivot Tables and Pivot Graphs, combining these with Slicers, Dimension Search, Conditional Formatting and financial reporting with asymmetric Sets. You will learn about the limitations and best practices when it comes to use Excel as a BI analysis tool. And finally we'll see how you can build advanced free-format Excel reports using Cube functions.
Speakers
Stephan Stoltze's other proposed sessions for 2026
ChatGPT for SQL People: An Introduction to LLM-Powered Data Analysis - 2026
Stephan Stoltze's previous sessions
Master Data Services 2016
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Real Life Master Data Management with SQL Server and MDS
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
Excel 2013 - Whats new beside PowerPivot and Power View?
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
Business Intelligence with Excel 2010
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Writeback-Here Comes the Sun
With Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010.