Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
Explore Power Query features to import data from existing Corporate BI systems.
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to?
Migration, Security, Administration and other tips and tricks.
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want
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.
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
Reporting Services is a powerful tool that can make designing reports a snap...most of the time. Design format starts with your report query. Take your queries to the next level with MDX concepts to conquer the trickiest report layouts.
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.