Content

Minimize

 

Business Intelligence (BI) Sessions

Title:

Optimizing DAX Queries

Speaker:

Alberto Ferrari

Abstract:

Take a deep dive into the details of how the DAX query engine works by examining and understanding DAX query plans. In this session, we will explore several queries and optimize them live on stage.

Level: 400

 


Title:
10 Tips and Tricks for Better SSIS Performance
Speaker:

David Peter Hansen

Abstract:

Your SQL Server Integration Services packages are taking longer than they should, but you aren't sure what to do about it. Join this session to get 10 tips and tricks for gaining better performance. You’ll not only learn 10 reasons why your packages are running slow, but also 10 things to do about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and more.

Level: 300


Title:
Automating Data Warehouse Patterns Through Metadata
Speaker:
Davide Mauri
Abstract:

Around 80% of the work to create a data warehouse/BI solution is spent on the ETL phase. Although building an ETL solution can be a challenge, you can break down the project into at least two separate processes for easier management. One process is strictly related to business modeling, and therefore cannot be replicated. But the other is made up of purely technical processes that are always the same, regardless of the business environment we operate in, and thus can be highly automated.

In this session, we will look at well-known patterns to solving common problems and how they can be automated with the help of specific tools and techniques that use metadata to reduce development time and bugs. Using these engineering techniques, you will be able to adopt an Agile approach to your BI solution.

Level: 300


Title:

Microsoft Power BI 101

Speaker:

Gerhard Brueckl

Abstract:

The new Power BI suite is Microsoft’s answer to the rising demand for self-service BI solutions. Combining formerly separate tools such as Data Explorer (now called Power Query) and GeoFlow (now Power Map) with PowerPivot and Power View, Power BI offers a complete suite within the familiar Excel environment to quickly build self-service BI solutions. This session will give you an overview of all the Power BI components and insights on how to work with them in the real world.

Level: 200


Title:
SQL Server 2012 PDW V2 Insights
Speaker:
Henk Van der Valk
Abstract:

Learn about the basic Massively Parallel Processing (MPP) architecture and appliance approach of SQL Server 2012 Parallel Data Warehouse (PDW) compared to a traditional SQL Server 20xx SMP approach. Then see where PDW can help you analyze more data easier and faster with new features such as the updatable columnstore index and Hadoop integration. We will look at real-world customer cases and the benefits they achieved by using PDW.

Level: 200


Title:
Analyzing Data with Power View
Speaker:

Jen Stirrup

Abstract:

Come learn about the best ways to present data to your Business Intelligence data consumers, and see how to apply these principles in Power View, Microsoft's data visualization tool. Using demos, we will investigate Power View based on current cognitive research around data visualization principles from such experts as Stephen Few, Edware Tufte, and others. We will then examine how data can be analyzed with Power View and look at where Power View is supplemented by other parts of the Microsoft BI stack.

Level: 100


Title:
Data Warehouse in the Cloud – Marketing or Reality?
Speaker:
Alexei Khalyako
Abstract:

Despite the buzz around cloud-based solutions, IT and business still have concerns: Is the cloud-based platform reliable? Will I meet my SLA? Will the solution scale? Even more critical yet, can it handle heavy workloads such as data warehouses? Running SQL Server on Windows Azure Virtual Machines, we have validated the scenarios around these questions, using SQL Server 2012 as well as the early bits of SQL Server 2014. And the answer is “Yes!” Join us to find out what we have learned from our research and get some useful tips for future development.

Level: 400


Title:

Create a Data Science Lab with Microsoft and Open Source Tools

Speaker:

Marcel Franke

Abstract:

The Big Data era has elevated the role of the data scientist. What is expected of data scientists today, and how can we establish an effective Data Science lab with Microsoft tools? In this session, you will see how to set up a Data Science workplace using SQL Server, Hadoop, Excel and Power Query, R, and other analytic tools. You will also see how to leverage all these tools together to analyze datasets.

Level: 300


Title:

Optimizing Data Models for Tabular Solutions and PowerPivot

Speaker:
Marco Russo
Abstract:

Is your new Tabular solution performing at its peak? Are you using best practices to reduce memory footprint, increase query speed, and get the most out of the new engine? In this session, we will look at several techniques that can really make a difference in your Tabular solution. We will cover distinct count reduction, join optimizations, condition consolidation, pros and cons of normalized data models, and selection of columns to store in the database. We will also highlight best practices, as well as those that were best practices for Multidimensional models but became worst practices for Tabular models. As I like to say: If you know Multidimensional, you need to forget it to let the new Tabular concepts shape your model.

Level: 400

 


Title:
Use the Power of Analytical Hierarchies in Your Cubes
Speaker:
Tim Peterson
Abstract:

Analytical hierarchies bring business analysts’ questions into the structure of your cubes. This session will examine the power of analytical hierarchies, looking specifically at the opportunities provided by calculation hierarchies. Calculation hierarchies let you build business models into your cubes. As the insights of business analysts are built into cube calculations, higher levels of insights can be achieved. Analytical hierarchies can model forecasts and scenarios. They organize multidimensional data into meaningful patterns. Some of the most popular analytical hierarchies provide insight along the time dimension, such as Current Period Calculations, Relative Date Period Calculations, Period To Date and Rolling Average Calculations, and Comparison, Ratio, and Forecasting Calculations. This session will demonstrate all these types of analytical hierarchies and show you how to design and create the specific analytical hierarchies your organization needs.

Level: 400

 


MAIN  SPONSOR


ENTERPRISE  SPONSORS
 

   
 

STANDARD

 

Become a sponsor