Click on the Session Topic to view the Livemeeting Recording.
Speaker: Marco Russo
While in classical OLAP cubes the clear winner data modeling technique is dimensional modeling, it is interesting to understand what will happen with the new Vertipaq engine. In Vertipaq there is no real need to do dimensional modeling, because the engine is able to manage relational modeling too. In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both UDM and Vertipaq. This will lead to an interesting discussion about how to develop your data warehouse in order to make it working with both UDM and Vertipaq.
Speaker: Josef Richberg
Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of "parallel path choicing".
Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination
(to get around the identity column conundrum). See how use Script Tasks to build directory scanners
for efficient file import techniques. We'll also go over some the tunable properties of the
Data Flow object.
Speaker: Alberto Ferrari
The introduction of many to many dimension relationships in SSAS (since 2005) opened new scenarios that can be solved using OLAP cubes. Now, with the introduction of the Vertipaq engine and the DAX programming language, it seems that many-to-many relationships are no longer supported. As we are going to show, this is not true: many-to-many relationships can be leveraged in DAX too, even if this means some deep understanding of the Vertipaq engine and of the DAX programming language. During the session we will show many scenarios where many-to-many relationships can be managed by using DAX. The implementations are different from those used in SSAS, both from the data modeling and from the programming points of view. Gaining the ability to master many-to-many relationships will open new modeling scenarios that look very promising in SSAS.
Speaker: Chris Webb
This session will look beyond the basics of security in Analysis Services 2008 R2, covering more advanced topics such as dynamic security and security on parent/child hierarchies and providing tips and tricks that even experienced SSAS developers may not know about.
Speaker: Peter Myers
SQL Server 2008 R2 PowerPivot allows analysts to use Excel 2010 to load and prepare large volumes of data from various data sources to create a data model. The data model can then be enriched with calculations to become a data source for Excel PivotTable, PivotChart and CUBE function reports. And as compelling as these BI experiences can be that’s not the end of the story. A PowerPivot workbook deployed to SharePoint Server 2010 can be used to create even more compelling BI experiences using Reporting Services and PerformancePoint Services. In this presentation learn about the fundamentals of PowerPivot data model creation, and the exciting ways PowerPivot data models can be used to visualize and share data.
Speaker: Jen Stirrup
The new Business Intelligence and Data Visualisation features and functionality are key to the strategic and technical changes in SQL Server 2012. We will take a look at:
- Power View and its impact for Data Visualisation according to the principles of Stephen Few, Tufte and other data visualisation experts
- PowerPivot improvements and new features
- Reporting Services and its future in Sharepoint
Attend this webinar in order to 'hit the ground running' with Business Intelligence and Data Visualisation in SQL Server 2012.
Speaker: Josef Richberg
How is it possible to aggregate 12,000,000 records of sales data in a short time window? In this presentation you will learn the techniques used to make this possible. These include workload distribution,pipeline elinimation and thread management.
Speaker: Chris Price
A Lap Around Data Quality Services 2012We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
Speaker: Simran Jindal
Reporting is an integral part of any BI solution and as the adoption of the Microsoft Cloud platform increases, it is inevitable to leave reporting out of the cloud offerings. This session will explore, what is Azure Reporting, SSRS to the cloud architecture and the integrated Windows Azure platform experience.
Speaker: Chris Price
Introduction to Master Data Services 2012 Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.
Speaker: Cathy Dumas
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, and learn some of the trade-offs involved in including any or all of these visualizations in your BI portal.
Speaker: Javier Guillen
PowerPivot is known primarily as a Self-Service Business
Intelligence tool (SSBI). As it adoption has been increasing over the last year, there is an important question regarding how to leverage all the insights and data discoveries achieved through it and incorporate it into a more robust Corporate BI framework. This session explores the options available when designing a strategy that ties a Corporate BI vision using SSAS BISM Tabular models with a flexible approach to Self-Service BI.
Speaker: Bhavik Merchant
"SSIS is a flexible tool that can be used for various data loading
scenarios. However, when considered alongside the features offered by the SQL Server relational database engine, a downside emerges - there can be multiple approaches to particular solutions. This can negatively affect performance. In a step by step fashion with live demos, you will be introduced to an approach for performance monitoring and tuning in SSIS. Along the way you will learn best practice design patterns and configuration tweaks that will make your packages fly!"
Speaker: Jen Stirrup
What does Azure offer to Business Intelligence developers, and to those who use Business Intelligence every day? Come to this session to see how you can transfer your skills in SSIS and SSRS to add Azure to your existing Business Intelligence skill set. We will look at: - the differences in developing SSIS packages that use Azure as a source and as a target. - developing SSRS reports deployed to Azure. - mobile devices and Azure such as tablets Come and see the similarities and differences in using Azure SQL Business Intelligence, and learn to avoid some of the 'gotcha!' pitfalls. Key Learnings: 1.How Windows Azure can be used to meet enterprise Business Intelligence requirements 2. How SQL Server on-premise Business Intelligence developers can transfer their existing skill.
Speaker: Julie Koesmarno
The new and flashy Tabular Model for Analysis Services has been highly pitched with the in-memory (VertiPaq) capability allowing for complex queries to run very fast. This session with some live demo will uncover:
* Advantages and disadvantages of using in-memory cache to store and query data;
* Restrictions on DirectQuery tabular model;
* Hybrid mode utilization;
* Impersonation and Partitioning techniques
Speaker: Lynn Langit
In this session, you will get a look at the new Data Explorer tools. There is both a desktop and a cloud version. This toolset is designed for DBAs, SQL Developers and Analysts to perform light-weight extract, transform and load tasks. These tasks can be completed on SQL Server data as well other data sources, such as SharePoint list data, Excel data, text files, as well as RSS feeds, data from cloud data markets, such as Windows Azure Data Market and more. This demo-driven session will get you started with the beta release of Data Explorer. You will understand the what, why, when, where and how that Data Explorer brings to ETL.
Speaker: Bhavik Merchant
In SQL 2012, SSIS has had its largest facelift since SQL 2005. A raft of new features have been introduced, and the most significant of them from an ETL framework perspective is the new Project Deployment model. This completely redefines how we could architect and deploy our solutions with configurations supporting multiple environments. It also raises some concerns around upgrading/migrating older solutions.This session briefly looks at common approaches for configuration management in SQL 2008R2. The new 2012 deployment and configuration model is then introduced and we look at how to best migrate these legacy configurations over.
Speaker: Mark Vaillancourt
Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary,including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.
Session Level: Beginner
Speaker: Ira Whiteside
Did you ever want to be able to track the progress of your SSIS production packages similar to how you can in the BIDS Designer, and explorer your package with windows explorer like capability. We will walk thru the process of building analytical application for tracking and debugging package progress and problems. We will use the “out of the box” SSIS Logging with no changes required to your logic or packages, except adding logging. We will also use a SSIS to scan existing packages and automatically discover Master / Child package relationships. But we won’t stop there we will also add a capability for package restartability. This design pattern can be use to replace earlier “Stored Proc” version of SSIS Framework greatly reducing the code required. This functionality is complementary to the 2012 Package Tracking capability, we will explore that also. Full working sample code will be available.
Speaker: Jason Thomas
SSRS has opened a new realm of reporting possibilities by including the spatial data support. Come and join this session to get familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them.
Speaker: Alex Whittles
In this session we’ll look at how merge can be used to perform complex multi-stage tasks such as loading data into data warehouse dimensions, including the handling of type 0, 1 & 2 slowly changing dimensions. I’ll present a summary of my MSc dissertation findings, comparing the performance of using T-SQL Merge against other more traditional methods of loading data warehouse dimensions in SSIS. We’ll also look at how we can use simple metadata configuration and dynamic SQL to completely automate the generation of the merge statement, resulting in an incredibly simple meta-data configurable data warehouse platform.
Speaker: Melissa Coates
You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft's vision of delivering "BI for the Masses." In this session we will dismiss the hype & examine how this new world of "Managed Self-Service BI" complements Corporate BI in SQL Server 2012 and SharePoint 2010.
Speaker: Thomas LeBlanc
This session is going to help create a dimensional Data Mart from the AdventureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.
Speaker: Jesse Kraut
Dive into the the SSIS toolkit by creating SSIS Custom Components in SQL Server 2008 and 2012. Discuss how to Register the Custom Components and add to the SSIS Toolbox. Demonstrate a method to open an SSIS package with C# script and read or make changes to the package design. The start of Data Driven design and programmatically creating packages, scan an entire BIDS Solution all Cubes, dimensions, and Connections in SSAS using Analysis Management Objects (AMO) with C# creating a MetadataMart and full documentation
Speaker: Reza Rad
This session is all about SSIS catalog which is a specific database recently presented in SQL Server 2012. SSIS logs execution of packages, validations, error and warning messages within this database. Structure of SSIS catalog tables and usage of stored procedures will be covered in this session. many useful queries and reports which is required in real world ETL scenarios will be show up and discussed. Real ETL Scenarios require execution log of each step of control flow and data flow, how long each step takes, messages during execution. Using data taps also will be discussed which is a new feature and very handy in production environments to catch data rows in specific data paths.
Speaker: James Beresford
Bothered by poor data? Looking for something beyond hardcoded error trapping? Then in SQL2012 we have the thing for you – SQL Server Data Quality Services (SSDQS) – with a friendly UI and a hook into SSIS handling and cleaning that dirty data becomes a simple task that users rather than ETL people can control. James will run you through the basics of SSDQS including the client and SSIS interfaces
Speaker: Thomas LeBlanc
This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demonstration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints. Session Level: Advanced
Speaker: Russ Blake and Kevin Clark
SQL Server Data Mining is the crown jewel of the Microsoft BI stack, delivering Best of Breed data mining algorithms packaged for ready use. But these powerful tools remain neglected on the shelf of many shops in spite of the fact that, according to Gartner Group, BI is the top priority of IT organizations over the next 5 years, with the biggest skills gap in the data mining area. We’ll demystify the data mining algorithms, terminology and tools so you can apply the technology with ease to help your organization look into its future and adapt as needed in the present, all without any need for a Cube.
EB Games will join us to discuss how they have used Data Mining to improve their countrywide retailing operations.
Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.
SQL Server 2012 provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case as used by a Coeo customer to present a business case for using SQL Server 2012 within your business.
Can you can give more power to your BDM? Yes, it´s possible! Using the BI features added in the new version of Excel + SQL Server 2012, we could increase the power of decisions makers with a familiar tool. Join Diego Nogare - SQL Server MVP - in this session to see the benefits in work with the news features inside Excel to BI field. Just a flavor, now PowerView is available inside Excel, come to this session to know other...
Speaker: Ira Whiteside
How would you like to create an SSIS package and run it 10 seconds. Then what if you could change the package by simply changing a value in a table. Abracadabra!!! data driven BI , at least the ETL / SSIS. We will look at two examples one using Native SMO (System Management Object) and on using the EzAPI created by Evgeny Koblov from Microsoft SSIS Testing Team, available on Codeplex. The examples we look at will use c# and can be created with the Express Edition. Next time we will look t generating SSAS Cubes.
Speaker: Rafael Salas
Dealing with bad data is a painful and expensive experience. In this session, we explore the main causes of bad data and layout key data quality concepts that will helps us better understand how data quality issues can be very costly. Then, we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals. You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.
Speaker: Doug Lane
At first, you loved working with Reporting Services, but now the honeymoon's over. What good are charts and tables when Reporting Services won't tell you what's wrong, renders too slow, and messes up your layout? You may be thinking about seeing other reporting products, but don't give up.
In this couples therapy for you and Reporting Services, rekindle your passion by reviewing how reports perform best, seeing what the report server has been trying to tell you (but you haven't been listening), and discovering new and simple tricks you never knew your reports could do. You'll learn about the following and more:
• Dealing with blank extra pages
• Designing reports for high performance
• Powerful properties for precise layout and appearance
• Troubleshooting using the execution log
Speaker: Adam Jorgensen
Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!