SQLBits 2015

Excel Services 2013-the BI frontend of the future

The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective. (1) Overview of the publish options (2) How to control the layout (3) Tips & Trick from real world examples

We start with an overview of the new features in Excel Services 2013 and go on with the publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities:

Full page - The lazy solution
PerformancePoint Services Dashboard - The smart solution
WebPart page - The customizable solution

Last but not least the session will include “Tips & Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the "Name Manager" and how you can burst the limits from PivotTables with the of use "Cube Functions" and "Names Sets". The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.

New features in Excel 2013
Overview of the publish options
How to control the layout
Tips & Trick from real world examples

Just Blindbæk's other proposed sessions for 2026

Building a Unified Semantic Model - The 20-Minute Pattern - 2026

Choosing the Right Storage Mode: Import, Direct Lake, DirectQuery & Hybrid - 2026

Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026

Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026

Demystifying the Data Lakehouse in Microsoft Fabric - 2026

Mastering Spark Notebooks and Capacity Optimization in Microsoft Fabric - 2026

Unified Semantic Models & KPI Reporting: Architecture That Scales - 2026

Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026

Just Blindbæk's previous sessions

Mastering Fabric: Workspace Governance and Organization

Learn how to optimize and master workspace organization in Fabric. Explore best practices for effective governance, enhancing user experience, security, and permissions management. Gain practical insights and checklists for streamlined workspace management.

The Hitchhiker's Guide to navigating Power BI

Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.

Architectural blueprints for the Modern Data Warehouse

This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.

Power BI: From Self-Service to Enterprise

How do you master to grow a Power BI solution from self-service to something that is scalable, managed and governed? A solution that can be trusted and used in the whole enterprise! Make a successful ownership transfer!

Excel Services 2013-the BI frontend of the future

The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective. (1) Overview of the publish options (2) How to control the layout (3) Tips & Trick from real world examples