Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
Do you need an OLAP database? Do you know how the data changed over time?
Do you need an OLTP database? Do you need to write, never block and never lose a change?
Then Temporal Databases tick those boxes and are a simple solution to these problems.
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
In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.
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.
Learn how XLCubed unlocks the value of Multi-dimensional and Tabular SSAS and SQL for power users in Excel; providing pixel perfect delivery of reporting, dashboards for both Web and Mobile and with or without SharePoint.
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.