Power View and the Cube (300)
Now that Power View users can connect to multidimensional BI Semantic Model (cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models.
The session we'll present
- An understanding of the Multidimensional Model Objects in Power View
- How to create a Shared Report Data Source Connection to a Multidimensional Model
- How to create a Power View Report with a Multidimensional Model Data Source
- An visual exploration of a Multidimensional Model by using Power View
Schema-less Table & Dynamic Schema (300)
How to manage a system in which the schema of data cannot be defined a priori? How to look for entities whose data are on multiple lines? In this session we are going to address all these issues, historically among the most complex to manage yet very common and very challenging for what concern performances.
SQL Server 2012 Statistical Semantic Search (300)
SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search.
In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions.
You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.
High Performance Statistical Queries (300)
The Data Scientist role is the new big role in IT business. A data scientist should, in short, know statistics and programming. This in-depth session shows some extremely efficient statistical queries using SQL Server 2012 that exploit the new Window functions and other Transact-SQL elements. The statistics calculated, its usage and correct interpretation, is explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.
Database Development with SSDT (300)
SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development. In this session we'll dive into Online and Offline development as well as the Productivity and tools that the SSDT team keeps providing to us.
The Power in Your Hands: DMVs (300)
SQL Server offers several DMVs in order to analyze the performance and the health status of the system. This session will show the most important ones and each one will be analyzed in detail, understanding how the information provided can be helpful in determining the cause of a problem, to anticipate corrective action or to proactively optimize the database.
From indexes to buffer cache analysis, from slowest query detection to wait stats analysis, from object dependencies to partitions data, in this session the heart of SQL Server will be exposed and analyzed.
Fast Track Data Warehouse, An Introduction (300)
Microsoft SQL Server Fast Track Data Warehouse is a reliable, scalable reference architecture that will help you reduce costs, reduce risk, and save time.
In this session you will learn what Fast Track is, what types of data warehousing workloads it is designed for, and what distinguishes it from other data warehouse architectures.
Excel 2013 Analytics to the Max (300)
Excel is "The" analytical tool in Microsoft suite for advances analysts. With Excel, you can analyse both, relational and unstructured big data. With PowerPivot, Excel becomes a single-user Analysis Services in tabular mode. The performance of your analytical processing is amazing. With Power View inside Excel, you can create ad-hoc reports on the tabular model with minimal effort. With Data Mining Add-in, you can perform even the most advanced analyses on your Excel data. With Hive ODBC driver, Excel can reach Big Data. You might already know all of these capabilities. However, this session goes beyond basic introduction, and shows how you can combine different analytical techniques that are not compatible out of the box.
Real Life Solutions to Real Life Problems with Data Quality Services or The Secret Life of a Data Steward. (300)
Is DQS here to stay or is it the emperor's new clothes ? in this session we will a look at how DQS can empower data cleansing in the enterprise , how we can use it in SSIS and some advanced techniques to solved complex data cleansing problems that'll make you a cleansing and matching hero with concepts such as Term Based Relationships, Domain/Composite Domain Rules, and using Remote Data Services in Windows Azure marketplace. We will also demonstrate how to enhance your DQS KB as you cleanse, enabling a cycle of data quality improvement. If you’ve looked at DQS but aren’t sure how to get the most out of it for your data, come to this session to see how to move beyond the basics
Relational Division - Take the Bull by the Horns (300)
The “relational division” is one of the missing operators in databases and unfortunately it’s also one of the most useful. Solving the problem of the Relational Division may not be an easy task, especially for beginners. In this sessions we’ll see what problem the relational division can help to solve and how it can be implemented using T-SQL. You’ll be amazed to find out how the relational division can help in your daily work!