sqlpasshistory

ID: 23

Back to Main list

PASS BA Conference 2013

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
10-04-2013 08:00 Mark Tabladillo, Artus Krohn-Grimberghe Pre-Conference Session (full day) Advanced Analytics and Insights A Best Practices Cookbook for Data Mining
10-04-2013 08:00 Brian Mitchell, Robert Skoglund Pre-Conference Session (full day) Strategy and Architecture Architecting the Next Generation Information Analytics Platform
10-04-2013 08:00 Peter Myers Pre-Conference Session (full day) Data Analytics and Visualization Power to the Business Analyst: Self-Service Microsoft BI
10-04-2013 08:00 Andrew J. Brust Pre-Conference Session (full day) Big Data Innovations and Integration Big Data and NoSQL for Database and BI Pros
10-04-2013 08:00 Mark Whitehorn Pre-Conference Session (full day) Strategy and Architecture Collecting and Defining Users' Analytical Requirements
11-04-2013 08:00 Kamal Hathi, Amir Netz Keynote (75 minutes) Strategy and Architecture Big Data, Small Data, All Data
11-04-2013 08:00 Bill Graziano Keynote (75 minutes) Strategy and Architecture Welcome to the PASS Business Analytics Conference!
11-04-2013 08:00 Matt Wolken Keynote (75 minutes) Strategy and Architecture Dell Viewpoint: The Promise of Analytics
11-04-2013 10:00 Javier Torrenteras, Enrique Moreno Breakout Session (60 minutes) Strategy and Architecture Inside Atento: Strategies for a Corporate Data Warehouse
11-04-2013 10:00 Wayne Winston Breakout Session (60 minutes) Data Analytics and Visualization Sports Analytics: Big Data in the Big Time
11-04-2013 10:00 Eron Kelly Breakout Session (60 minutes) Big Data Innovations and Integration From Data to Insights with Microsoft’s Big Data
11-04-2013 10:00 Kay Unkroth, Diego Oppenheimer Breakout Session (60 minutes) Data Analytics and Visualization Deep Dive into PowerPivot in Office and SharePoint
11-04-2013 10:00 Rod Colledge Breakout Session (60 minutes) Information Delivery and Collaboration Self-Service Business Analytics in 2013
11-04-2013 10:00 Mark Whitehorn Breakout Session (60 minutes) Advanced Analytics and Insights What Is Data Science?
11-04-2013 11:15 Avi Perez Breakout Session (60 minutes) Information Delivery and Collaboration Extending PowerPivot into a Scalable Component for Enterprise BI
11-04-2013 11:15 Devin Knight Breakout Session (60 minutes) Data Analytics and Visualization Creating an End-to-End Power View Reporting Solution
11-04-2013 11:15 Doug Lane, Mark Vaillancourt Breakout Session (60 minutes) Information Delivery and Collaboration Hailing Frequencies: Analysis Services Terms and Concepts
11-04-2013 11:15 Marc Reguera Breakout Session (60 minutes) Data Analytics and Visualization From Data to Insight – Views from Microsoft Finance
11-04-2013 11:15 Denny Lee, Dianne Eckloff Breakout Session (60 minutes) Big Data Innovations and Integration Yahoo!, Big Data, and Microsoft BI: Bigger and Better Together
11-04-2013 11:15 Mark Tabladillo Breakout Session (60 minutes) Advanced Analytics and Insights Data Analysis with R and Julia
11-04-2013 13:30 Leif Brenne Breakout Session (60 minutes) Data Analytics and Visualization Advanced Dashboards Using Excel, Excel Services, and PerformancePoint
11-04-2013 13:30 Paul Turley Breakout Session (60 minutes) Data Analytics and Visualization Visualization Choices: What, When, and How?
11-04-2013 13:30 Artin Avanes Breakout Session (60 minutes) Big Data Innovations and Integration Relational and Non-relational Data Living in Peace and Harmony
11-04-2013 13:30 Marco Russo Breakout Session (60 minutes) Strategy and Architecture Modern Data Warehousing Strategy
11-04-2013 13:30 Ashvini Sharma, Kamal Hathi Breakout Session (60 minutes) Strategy and Architecture Present and Futures: Roadmap and Strategy
11-04-2013 13:30 Jen Stirrup Breakout Session (60 minutes) Information Delivery and Collaboration Mobile Business Intelligence, Apprentice Style!
11-04-2013 14:45 Andrew J. Brust Breakout Session (60 minutes) Big Data Innovations and Integration NoSQL: An Analysis
11-04-2013 14:45 Ashvini Sharma, Seayoung Rhee Breakout Session (60 minutes) Information Delivery and Collaboration Office as Your BI Platform
11-04-2013 14:45 Ayad Shammout, Denny Lee Breakout Session (60 minutes) Big Data Innovations and Integration Ensuring Compliance of Patient Data with Big Data and BI
11-04-2013 14:45 Drew Minkin Breakout Session (60 minutes) Advanced Analytics and Insights Crossing the Last Mile with Predictable Hospital Readmissions
11-04-2013 14:45 Peter Myers Breakout Session (60 minutes) Big Data Innovations and Integration Big Data Analytics with Excel 2013
11-04-2013 14:45 Hope Foley Breakout Session (60 minutes) Data Analytics and Visualization Power to the Pivot - Practical Intro to PowerPivot 2012
11-04-2013 16:00 Craig Utley Breakout Session (60 minutes) Strategy and Architecture Why BI Projects Fail (And What You Can Do About It)
11-04-2013 16:00 Oliver Engels, Tillmann Eitelberg Breakout Session (60 minutes) Data Analytics and Visualization Advanced Data Visualization with SQL Server Reporting Services
11-04-2013 16:00 Naga Krothapalli Breakout Session (60 minutes) Data Analytics and Visualization Advancing Analytics at Microsoft Advertising
11-04-2013 16:00 Chuck Heinzelman, Gilad Elyashar, David Magar Breakout Session (60 minutes) Strategy and Architecture Make Cloud BI Work for You
11-04-2013 16:00 Stacia Varga Breakout Session (60 minutes) Information Delivery and Collaboration Taking BI to the Next Level: Collaboration
11-04-2013 16:00 Cristian Vava Breakout Session (60 minutes) Advanced Analytics and Insights Analytics for Business Strategy
11-04-2013 17:15 Carter Shanklin Breakout Session (60 minutes) Advanced Analytics and Insights The Future of Apache Hive and Hadoop 2.0: Bigger, Faster, Stronger
11-04-2013 17:15 Hyoun Park Breakout Session (60 minutes) Big Data Innovations and Integration Building the Business Case for Big Data
11-04-2013 17:15 James Serra Breakout Session (60 minutes) Big Data Innovations and Integration Overview of Microsoft Appliances
11-04-2013 17:15 John Whittaker, Ben Boise Breakout Session (60 minutes) Information Delivery and Collaboration Enabling Collaborative Analysis while Maintaining Governance
11-04-2013 17:15 Dan Clark Breakout Session (60 minutes) Data Analytics and Visualization Mastering Time-Based Analysis in DAX
11-04-2013 17:15 Angel Abundez Breakout Session (60 minutes) Data Analytics and Visualization Measuring the Subscription Economy
12-04-2013 08:00 Steven Levitt Keynote (75 minutes) Strategy and Architecture Think Like a Freak
12-04-2013 10:00 Riccardo Muti, Sandy Rivas Breakout Session (60 minutes) Data Analytics and Visualization Drab to Dynamite! Managed Self-Service BI Using Real-World Data
12-04-2013 10:00 Brian Walker, Murshed Zaman Breakout Session (60 minutes) Strategy and Architecture PDW Architecture Gets Real: Customer Implementations
12-04-2013 10:00 Michael Raheem Breakout Session (60 minutes) Information Delivery and Collaboration 60-Minute Demo: Microsoft BI Tools on SAP Data
12-04-2013 10:00 Peter Myers Breakout Session (60 minutes) Data Analytics and Visualization Mastering the CUBE Functions in Excel 2013
12-04-2013 10:00 Jen Stirrup Breakout Session (60 minutes) Advanced Analytics and Insights Data Visualization with Power View and the Tabular Model
12-04-2013 10:00 Shaun Connolly Breakout Session (60 minutes) Big Data Innovations and Integration Big Data: Threat or Opportunity?
12-04-2013 11:15 Mike Stringer Breakout Session (60 minutes) Data Analytics and Visualization Data Analytics: Realizing the Full Potential
12-04-2013 11:15 Tim Mallalieu Breakout Session (60 minutes) Big Data Innovations and Integration Drive Smarter Decisions with Microsoft HDInsight
12-04-2013 11:15 Wayne Winston Breakout Session (60 minutes) Data Analytics and Visualization Excel Charting Tips
12-04-2013 11:15 Craig Utley Breakout Session (60 minutes) Information Delivery and Collaboration My Brain Hurts: Presenting Data with Microsoft Tools
12-04-2013 11:15 James Serra Breakout Session (60 minutes) Strategy and Architecture Building an Effective Data Warehouse Architecture
12-04-2013 11:15 Chris Webb Breakout Session (60 minutes) Data Analytics and Visualization Feed Your Data! OData Data Feeds for PowerPivot Users
12-04-2013 13:30 Antonio Zurlo Breakout Session (60 minutes) Advanced Analytics and Insights Parallelizing Large Excel-Based Calculations on HPC Server & Azure
12-04-2013 13:30 Cindy Gross, Eduardo Gamez Breakout Session (60 minutes) Data Analytics and Visualization How Intel Integrates Self-Service BI with IT for Better Business Results
12-04-2013 13:30 Neil Hambly Breakout Session (60 minutes) Strategy and Architecture MDS and DQS - Beyond the TLAs to Data Quality
12-04-2013 13:30 Jason Thomas Breakout Session (60 minutes) Data Analytics and Visualization GeoSpatial Analytics Using Microsoft BI
12-04-2013 13:30 Marco Russo Breakout Session (60 minutes) Data Analytics and Visualization Self-Service Data Modeling
12-04-2013 13:30 Julie Koesmarno, Josh Fennessy Breakout Session (60 minutes) Data Analytics and Visualization The Essential 8: Narrative Reporting Techniques
12-04-2013 14:45 Rob Collie Breakout Session (60 minutes) Strategy and Architecture Dark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future
12-04-2013 14:45 Dmitri Tchikatilov, Anna Skobodzinski, Trevor Attridge, Christian Bonilla Breakout Session (60 minutes) Data Analytics and Visualization Online Advertising: Hybrid Approach to Large-Scale Data Analysis
12-04-2013 14:45 Marc Smith Breakout Session (60 minutes) Data Analytics and Visualization Charting Collections of Social Media Connections with NodeXL
12-04-2013 14:45 Paco Gonzalez, Ruben Pertusa Lopez Breakout Session (60 minutes) Advanced Analytics and Insights Social Text, Sentiment, and Tone Analysis
12-04-2013 14:45 Dave DuVarney Breakout Session (60 minutes) Strategy and Architecture Delivering Agile BI Solutions
12-04-2013 14:45 Leif Brenne, Ari Schorr Breakout Session (60 minutes) Information Delivery and Collaboration Business Intelligence on Mobile Devices
12-04-2013 16:00 Dan Bulos Breakout Session (60 minutes) Data Analytics and Visualization The ABCs of Scoring: Why, How, and Getting a Good Grade
12-04-2013 16:00 Faisal Mohamood Breakout Session (60 minutes) Information Delivery and Collaboration Microsoft Data Explorer for Excel: Data Discovery & Transformation
12-04-2013 16:00 Artus Krohn-Grimberghe Breakout Session (60 minutes) Advanced Analytics and Insights Recommender Systems – A Walkthrough
12-04-2013 16:00 Raman Iyer Breakout Session (60 minutes) Advanced Analytics and Insights SQL Server Predictive Analytics: Customer Stories
12-04-2013 16:00 Joseph D'Antoni, Stacia Varga Breakout Session (60 minutes) Data Analytics and Visualization Using Power View and Hadoop to Unlock Hidden Markets
12-04-2013 16:00 Paul Bradley Breakout Session (60 minutes) Big Data Innovations and Integration Big Data - Top Ingredient to Improve Healthcare

SessionID: 4069

A Best Practices Cookbook for Data Mining

Back to calendar

Event Date: 10-04-2013 08:00 - Category: Pre-Conference Session (full day) - Track: Advanced Analytics and Insights

Speaker(s): Mark Tabladillo, Artus Krohn-Grimberghe

Title: A Best Practices Cookbook for Data Mining

Description:

Data mining increasingly fascinates business people and information technology professionals alike, with the promise of finding meaningful patterns, relationships, and opportunities in our continuously growing volumes of data. There are tried and tested best practices you can follow to begin and improve your data mining efforts. You’re invited to a full-day data mining seminar with Mark Tabladillo and Artus Krohn-Grimberghe to see these best practices in action. Aimed at the beginning to intermediate data scientist, this pre-conference workshop builds on Mark and Artus’ experience in teaching university students and advising industry clients. Following a cookbook theme for their presentation, they will be explaining and demonstrating their best practices framework by cooking through a data science example from beginning to end, covering these topics: <br/><br/>• How to avoid mythology while establishing a data science investigation <br/>• How to apply the best artistry in data cleansing and transformation (shaping) <br/>• How to apply best practices for machine learning algorithms <br/>• How to communicate your data mining story within and beyond your organization <br/><br/>The presenters have designed specific breaks during the workshop where you can discuss and interact with them and other attendees. Note that these best practices transcend Microsoft SQL Server Data Mining, applying equally to other software, such as Matlab, Octave, R, SAS, SPSS, and Weka. After this workshop, you and your data science team will have the knowledge and best practices to approach small to large data mining challenges with confidence.

SessionID: 4073

Architecting the Next Generation Information Analytics Platform

Back to calendar

Event Date: 10-04-2013 08:00 - Category: Pre-Conference Session (full day) - Track: Strategy and Architecture

Speaker(s): Brian Mitchell, Robert Skoglund

Title: Architecting the Next Generation Information Analytics Platform

Description:

SessionID: 4071

Power to the Business Analyst: Self-Service Microsoft BI

Back to calendar

Event Date: 10-04-2013 08:00 - Category: Pre-Conference Session (full day) - Track: Data Analytics and Visualization

Speaker(s): Peter Myers

Title: Power to the Business Analyst: Self-Service Microsoft BI

Description:

<p style="color:rgb(91,91,91);"><strong>Meet the speaker:</strong> Bonus session "Why? Where? Spatial Analysis in Excel 2013" – <a href="http://passbaconference.com/Sessions/SneakPeeks/24HOPSession9.aspx"&gt;&lt;u&gt;watch now</u>!</a></p>Business analysts today increasingly need to work directly with, and beyond, the data resources delivered by the IT department. Empowering key individuals in your organization can harness valuable potential and drive success by allowing the people who best understand their requirements to produce and manage their own data solutions. Interestingly, when appropriately managed, a side effect of this empowerment is reduced dependency – and thus, fewer resource demands – on the IT department. Join Peter Myers for this day-long pre-conference seminar designed to introduce and describe self-service business intelligence (SSBI). You’ll explore how to effectively enable business analysts by using Microsoft products and learn key concepts through many real-world demonstrations. And equally as important, you’ll see how your business can ensure that SSBI solutions are effectively managed, monitored, and governed.

SessionID: 4070

Big Data and NoSQL for Database and BI Pros

Back to calendar

Event Date: 10-04-2013 08:00 - Category: Pre-Conference Session (full day) - Track: Big Data Innovations and Integration

Speaker(s): Andrew J. Brust

Title: Big Data and NoSQL for Database and BI Pros

Description:

<p style="color:rgb(91,91,91);"><strong>Meet the speaker:</strong> Bonus session "Big Data on the Microsoft Platform" - <a href="http://passbaconference.com/Sessions/SneakPeeks/24HOPSession6.aspx"&gt;&lt;u&gt;watch now</u>!</a></p>These days, it's difficult to visit a technology Web site – or even a mainstream news site – and not read a story about big data. Big data is at the top of its hype cycle: It’s seemingly everywhere, and even Microsoft is getting into the game.

But what is big data really about? What about its sidekick, NoSQL? And how is any of it germane to business analytics, especially for database administrators, developers, and business intelligence specialists working in enterprise environments? Can Java-based, open-source software such as Apache Hadoop, which runs mostly on Linux, be relevant to SQL Server professionals supporting their organization’s analytics efforts? And if it is relevant, how can we cross-train into this strange new world?

There's good news here, I promise. Much of this technology now runs on Windows, and Microsoft has created tools that make it usable from Visual Studio, Excel, and Microsoft BI. Even more important, working with these technologies in non-Microsoft environments is approachable as well. All you need is a proper introduction to Hadoop, NoSQL, and related technologies that is free of hype and explained in terms a relational database or BI professional can understand.

That's exactly what you'll get in this full-day workshop, as Andrew Brust – a longtime SQL Server author and Microsoft BI influencer who also covers big data for ZDNet – shows you the ropes. You'll learn new skills that are in strong demand in the BI/BA world – and actually understand what you learn. It will be exciting, manageable… and fun. You can do this – come see for yourself.

SessionID: 4066

Collecting and Defining Users' Analytical Requirements

Back to calendar

Event Date: 10-04-2013 08:00 - Category: Pre-Conference Session (full day) - Track: Strategy and Architecture

Speaker(s): Mark Whitehorn

Title: Collecting and Defining Users' Analytical Requirements

Description:

<p style="color:rgb(91,91,91);"><strong>Meet the speaker:</strong> Bonus session "What is Big Data?" – <a href="http://passbaconference.com/Sessions/SneakPeeks/24HOPSession7.aspx"&gt;&lt;u&gt;watch now</u>!</a></p>Business intelligence is all about delivering solutions that provide accurate, rapid answers to users’ analytical questions. In theory, we simply ask the users to define their requirements. In practice, this approach rarely works because it is very difficult for anyone to know and precisely define their complete set of analytical needs. The good news is that as BA/BI architects and specialists, we can help business analytics users determine their requirements – and doing so turns out to be relatively simple. Spend the day with BI expert Mark Whitehorn to see how it’s done. Instead of asking for a complete set of requirements, for example, you can begin by asking for a relatively small set of specific requirements: “We want to plot unit sales over time” or “We want to investigate how profit varies with different product lines in different stores.” From those requirements, you can extrapolate to a generalized logical model that your users will not only understand but also approve. You can then turn that into a physical model, typically a star schema. This seminar will focus on how to collect the users’ requirements and create the logical model.

SessionID: 5149

Big Data, Small Data, All Data

Back to calendar

Event Date: 11-04-2013 08:00 - Category: Keynote (75 minutes) - Track: Strategy and Architecture

Speaker(s): Kamal Hathi, Amir Netz

Title: Big Data, Small Data, All Data

Description:

There has never been such an abundance of available and useful information as there is today, both across the web and across your organization. However, users are challenged with effectively discovering and connecting to this information so they can gain the meaningful insights they need. Join Kamal Hathi, Partner Director, Microsoft, and Amir Netz, Technical Fellow, Microsoft, at the Day 1 keynote as they discuss how Microsoft is making the ability to gain insights on Big Data more accessible to everyone through familiar and easy-to-use tools, such as the new Excel 2013. You’ll see how Microsoft is reducing the time to insight by empowering users to connect, analyze, and visualize data – Big Data, Small Data, All Data – in exciting and visceral new ways.

SessionID: 5147

Welcome to the PASS Business Analytics Conference!

Back to calendar

Event Date: 11-04-2013 08:00 - Category: Keynote (75 minutes) - Track: Strategy and Architecture

Speaker(s): Bill Graziano

Title: Welcome to the PASS Business Analytics Conference!

Description:

PASS President Bill Graziano will open the inaugural PASS Business Analytics Conference with a special welcome to attendees and a short introduction to the event and the PASS organization.

SessionID: 5148

Dell Viewpoint: The Promise of Analytics

Back to calendar

Event Date: 11-04-2013 08:00 - Category: Keynote (75 minutes) - Track: Strategy and Architecture

Speaker(s): Matt Wolken

Title: Dell Viewpoint: The Promise of Analytics

Description:

Join Matt Wolken, GM of Information Management at the new Dell Software Group, as he explores the promise and revenue opportunity that business analytics represents.

SessionID: 4094

Inside Atento: Strategies for a Corporate Data Warehouse

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Javier Torrenteras, Enrique Moreno

Title: Inside Atento: Strategies for a Corporate Data Warehouse

Description:

Atento is a call center company with offices in 16 countries. Each country has its own systems to manage and support daily operations, but all use the same processes and business units. The corporate office needed to consolidate all that information and align local indicators with the global business strategy. The company also had isolated data marts, based on different technologies, that weren’t shared across departments, so generating monthly executive reports was time-consuming, requiring lots of manual validation and coordination.

To solve these problems, Atento built an enterprise data warehouse, using Agile methodologies so that business users could quickly evaluate the project’s ROI and be involved as stakeholders in the following phases of the solution. The Azure platform is serving as an interim solution to support the entire BI stack so that it can be easily accessed by corporate and local teams. Come see how they did it.

SessionID: 4064

Sports Analytics: Big Data in the Big Time

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Wayne Winston

Title: Sports Analytics: Big Data in the Big Time

Description:

How do baseball, football, and basketball teams use Excel and data analytics to improve player selection and team performance? How will big data revolutionize pro basketball? Join this session to learn how analytics is changing the business of sports.

SessionID: 4215

From Data to Insights with Microsoft’s Big Data

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Eron Kelly

Title: From Data to Insights with Microsoft’s Big Data

Description:

SessionID: 4219

Deep Dive into PowerPivot in Office and SharePoint

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Kay Unkroth, Diego Oppenheimer

Title: Deep Dive into PowerPivot in Office and SharePoint

Description:

Don’t miss this deep dive into the Microsoft BI stack, exploring Office 2013, SharePoint 2013, and SQL Server 2012. You will learn the platform architecture as well as technical details of the new PowerPivot engine across the Excel client, SharePoint server, and SQL Server platform, gaining a holistic view of this powerful stack. The session will also be full of fun demos that will showcase the new engine in various real-world business scenarios.

SessionID: 4096

Self-Service Business Analytics in 2013

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Rod Colledge

Title: Self-Service Business Analytics in 2013

Description:

On its own, self-service analytics struggles to give business users the insights they need. But when combined with a corporate BI platform, the power of self-service analytics shines, and the sometimes toxic relationship between the IT department and business users changes to one of mutual respect and working together to achieve common goals. In this demo-rich session, we’ll explore the use-case scenarios and benefits of self-service business analytics as part of a broader reporting and analytics strategy using SQL Server 2012, SharePoint 2013, and Office 2013.

After laying the foundation, we'll launch into a range of demos covering PerformancePoint dashboards, Report Alerts with SQL Server Reporting Services, Report Parts with Report Builder, Power View, Pivot, and PowerPivot. All demos will show how corporate BI solutions can be extended and enhanced with self-service analytics. We’ll also highlight new analytics features in SharePoint 2013 and Excel 2013 – and when to use each.

SessionID: 4063

What Is Data Science?

Back to calendar

Event Date: 11-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Mark Whitehorn

Title: What Is Data Science?

Description:

According to the Harvard Business Review*, data scientist is “The sexiest job of the 21st Century.” However, other definitions include, “An analyst who lives in California.” So what is the truth? Is “data science” really a valuable job or marketing hype?

This session will argue that the skills a good data scientist possesses are real and will explain why that particular combination of talents is so valuable. We’ll cover exactly what those skills are during the session, but here is a taste: Data scientists have the ability to take a set of complex data (very often, big data) and find the complex patterns hidden therein. This often involves rapid prototyping and coding in a variety of languages (Java, R, MDX, Erlang). Data scientists have a good statistical background, excellent data visualization skills, and the ability to communicate their ideas clearly to a non-technical audience. Oh, and did I mention curiosity?

SessionID: 4341

Extending PowerPivot into a Scalable Component for Enterprise BI

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Avi Perez

Title: Extending PowerPivot into a Scalable Component for Enterprise BI

Description:

PowerPivot is a breakthrough for self-serve business intelligence, but deploying it across the enterprise can prove difficult.. Join us for this fast-paced, technical demonstration on how to extend PowerPivot into secure and scalable tabular cubes using Pyramid Analytics’ BI Office Suite for fast and easy deployment across an organization. We’ll cover the use of business logic, calculations, parameterization, and scripted sets through a complex “Market Basket Analysis” example. And we’ll demonstrate how to deploy analytics and dashboards for thin client access to data across the enterprise.

SessionID: 3978

Creating an End-to-End Power View Reporting Solution

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Devin Knight

Title: Creating an End-to-End Power View Reporting Solution

Description:

Power View lets you create eye-popping visualizations and provides intuitive ad-hoc reporting that a variety of business users can use to make critical decisions. But before you can begin building these incredible reports, you must have your data properly prepared. This session will give you a beginning-to-end view of what is needed to create Power View reports, from organizing a PowerPivot model source to preparing the actual Power View report.

SessionID: 4184

Hailing Frequencies: Analysis Services Terms and Concepts

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Doug Lane, Mark Vaillancourt

Title: Hailing Frequencies: Analysis Services Terms and Concepts

Description:

In this Star Trek-themed presentation aimed at non-technical folks, we will explain the terms and concepts important to understand when participating in projects involving SQL Server Analysis Services (SSAS).

You’ll learn the key differences between the SSAS Multidimensional Model (Cubes) and the SSAS Tabular Model. You’ll also learn the definitions and examples of key terms for each model, including but not limited to: measure groups, measures, dimensions, attributes, and hierarchies in the SSAS Multidimensional Model and tables, columns, and calculated measures in the SSAS Tabular Model. We will also demonstrate the basics of browsing of both Multidimensional and Tabular models using Excel 2013.

SessionID: 4082

From Data to Insight – Views from Microsoft Finance

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Marc Reguera

Title: From Data to Insight – Views from Microsoft Finance

Description:

SessionID: 4226

Yahoo!, Big Data, and Microsoft BI: Bigger and Better Together

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Denny Lee, Dianne Eckloff

Title: Yahoo!, Big Data, and Microsoft BI: Bigger and Better Together

Description:

Would you like to know more about how Yahoo! built one of the world’s largest SQL Server Analysis Services cubes at 24TB? Join us for this technical deep-dive showcasing how Yahoo! leverages Analysis Services with Hadoop to deliver more meaningful and useful analytical data faster.

As a leading digital media company, Yahoo! provides a range of online services, including a group of popular consumer websites that attract more than 700 million unique visitors a month. To improve ad campaign effectiveness and increase revenue, Yahoo! implemented a solution integrating the Yahoo! Hadoop data processing framework with Analysis Services. This session will focus on the design decisions and best practices for implementing a large- scale analysis environment as learned through this implementation.

SessionID: 4061

Data Analysis with R and Julia

Back to calendar

Event Date: 11-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Mark Tabladillo

Title: Data Analysis with R and Julia

Description:

SessionID: 4218

Advanced Dashboards Using Excel, Excel Services, and PerformancePoint

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Leif Brenne

Title: Advanced Dashboards Using Excel, Excel Services, and PerformancePoint

Description:

Learn more about exciting new ways to build dashboards in Excel, Excel Services, and PerformancePoint. In this session, we will examine key new features in each product and look at how the new Apps for Office let you create rich dashboards in Excel and Excel Services, empowering your Excel and Excel Services Reports with interactive web applications. We will not stare at pretty, pre-built dashboards. Instead, we will look at how you can easily use Microsoft BI to build them yourself.

SessionID: 4089

Visualization Choices: What, When, and How?

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Paul Turley

Title: Visualization Choices: What, When, and How?

Description:

When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.

SessionID: 4216

Relational and Non-relational Data Living in Peace and Harmony

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Artin Avanes

Title: Relational and Non-relational Data Living in Peace and Harmony

Description:

Can you mash structured and unstructured worlds together and still make sense of it all? The answer is yes, using SQL Server Parallel Data Warehouse, which is rolling out version 2 of the product. In addition to introducing new features, such as a new appliance architecture and ColumnStore technology, this session will show you how SQL Server PDW makes it easy to query unstructured data stored in a Hadoop cluster and integrate that data with data stored in relational format.

SessionID: 4059

Modern Data Warehousing Strategy

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Marco Russo

Title: Modern Data Warehousing Strategy

Description:

The recent introduction of new technologies such as PowerPivot, the BI Semantic Model, and columnstore indexes in SQL Server and advances in self-service business intelligence and big data might be considered threats to the classic data warehouse ecosystem. In reality, a good data warehouse is still the best starting point for any kind of analysis, but we do need to update our strategy for data warehouse implementation to fit the requirements of this new era.

This session will start the conversation about what a modern strategy for data warehousing can and should be. What type of data modeling should we use for the data warehouse? What is the role of data marts? Does the use of technologies such as PowerPivot or Analysis Services Tabular affect the way we should model our data? Do columnstore indexes remove the need for an analytical server like Analysis Services? We will discuss these and other questions, offering an updated approach to the data warehouse modeling methodology.

SessionID: 4083

Present and Futures: Roadmap and Strategy

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Ashvini Sharma, Kamal Hathi

Title: Present and Futures: Roadmap and Strategy

Description:

Join this session to learn the latest about Microsoft's platform for business analytics, showcasing the tight integration and convergence between Office and SQL Server tools and technologies. Then look to the future as our speakers share their vision and roadmap for enabling billions of users across the globe to make sense of ever-growing oceans of data, on premise and in the cloud.

SessionID: 4060

Mobile Business Intelligence, Apprentice Style!

Back to calendar

Event Date: 11-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Jen Stirrup

Title: Mobile Business Intelligence, Apprentice Style!

Description:

How can you implement mobile BI at your organization right now? During this session, you’ll be invited to try out mobile BI on a variety of mobile devices so that you can maximize your learning experience with this technology and become your organization’s mobile BI expert.

SessionID: 4054

NoSQL: An Analysis

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Andrew J. Brust

Title: NoSQL: An Analysis

Description:

NoSQL is often mentioned in the same breath with big data and analytics. At other times, NoSQL is juxtaposed with relational database technology, in an adversarial context. So just what is NoSQL about, anyway? Are NoSQL databases better than relational ones? And is NoSQL a big data technology, or do the two just have a special relationship?

Join SQL Server author, Microsoft BI expert, and ZDNet big data blogger Andrew Brust for this down-to-earth session, which will explain what NoSQL is and discuss the four major categories of NoSQL databases. The discussion will start at a high level, and then quickly segue into demos. You’ll explore the NoSQL-big data connection through the same combination of conceptual and practical coverage. And to tie things back to the familiar, the session will end by looking at features of SQL Server, Windows Azure SQL Database, and the .NET data access stack that have NoSQL-like qualities.

SessionID: 4076

Office as Your BI Platform

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Ashvini Sharma, Seayoung Rhee

Title: Office as Your BI Platform

Description:

Learn about leveraging Office 365 and SharePoint as your business intelligence platform to deliver custom BI solutions anywhere and on any device. Office 2013 delivers rich new BI functionality in Excel 2013 with Office Apps, PowerPivot, and Power View. Join this session to learn how to create a rich analytics experience with the familiar tools you are using today.

SessionID: 4078

Ensuring Compliance of Patient Data with Big Data and BI

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Ayad Shammout, Denny Lee

Title: Ensuring Compliance of Patient Data with Big Data and BI

Description:

To help meet HIPAA and HealthAct compliance, Beth Israel Deaconess Medical Center (BIDMC) is expanding on the “Reaching Compliance: SQL Server 2008 Compliance Guide” to more easily handle larger volumes of unstructured data and to gain richer and deeper insight using the latest analytics. To achieve this, BIDMC is building a Big Data-to-BI project involving HDInsight, SQL Server 2012, Integration Services, PowerPivot, and Power View. This session will give you the architecture and details behind this project within the context of patient data compliance.

SessionID: 4176

Crossing the Last Mile with Predictable Hospital Readmissions

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Drew Minkin

Title: Crossing the Last Mile with Predictable Hospital Readmissions

Description:

Hospital readmissions is a $20 billion annual problem in the US. Recent Medicare changes have resulted in huge fines and no reimbursements for hospitals performing poorly on their 30-day readmission rate. Each readmission costs a hospital an average of $20,000. This is a big problem. This is also a solvable problem.

Join Drew Minkin, Director, Analytics Solutions, Predixion Software, to learn how his team implemented and deployed a predictive readmissions solution using SQL Server and other components that enables nurses, doctors, and care managers to understand the nature of their facilities readmission risk, who to target for specialized interventions, and what the impact could be.

In this session, you will see how Predixion team members interpreted the business drivers into development of a predictive model that they then deployed across the last mile of analytics and integrated into a hospital’s daily processes, solving a real-world business problem for immediate impact.

SessionID: 4003

Big Data Analytics with Excel 2013

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Peter Myers

Title: Big Data Analytics with Excel 2013

Description:

Interested in learning more about big data? New to self-service data modeling with PowerPivot, and interested in understanding what is new for PowerPivot and data analysis in Excel 2013? This session is for you. This session will describe and demonstrate how to create a big data analytics solution with structured data by using Windows Azure HDInsight, Excel 2013, and Office 365.

The first demonstration will show how to create a big data solution by provisioning an Apache Hadoop cluster in the cloud with Windows Azure HDInsight. The next demonstration will create a PowerPivot data model to integrate a big data query result with on-premise data. We’ll then analyze and report on the data by using Power View. Finally, we’ll complete the loop, publishing the PowerPivot workbook back to the cloud with Office 365.

SessionID: 4098

Power to the Pivot - Practical Intro to PowerPivot 2012

Back to calendar

Event Date: 11-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Hope Foley

Title: Power to the Pivot - Practical Intro to PowerPivot 2012

Description:

Want to create snazzy reports to impress the boss but aren't a BI expert? Don't climb the clock tower just yet. Go get yourself PowerPivot 2012, and come to this session. We'll review some very real-world analytics issues and ways PowerPivot can help solve them. Demos will be filled with new features from PowerPivot 2012, giving you a good base to get started using this valuable tool.

The session wouldn't be complete without covering BISM. So we will cover how the BI world is coming together as one to have, hold, and cherish in the BI Semantic Model. We will work through demos together, covering 10 different functional uses within this tool to help start you down the path of self-service BI.

SessionID: 4136

Why BI Projects Fail (And What You Can Do About It)

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Craig Utley

Title: Why BI Projects Fail (And What You Can Do About It)

Description:

Is your organization planning to build a data warehouse or BI solution? While it’s obviously possible to successfully complete a data warehousing project and deliver value to the business, data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories.

Craig Utley has witnessed Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.

SessionID: 4194

Advanced Data Visualization with SQL Server Reporting Services

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Oliver Engels, Tillmann Eitelberg

Title: Advanced Data Visualization with SQL Server Reporting Services

Description:

With the standard SQL Server Reporting Services (SSRS) engine, you can quickly and easily deliver basic charts. In real-life reporting, however, requirements are much more complex. You need to follow the techniques for enhanced information delivery by applying methods from Edward Tufte, Stephen Few, or Prof. Rolf Hichert, including ways to visualize by corporate identity or work with spatial information.

This session focuses on charts, gauges, and maps and will show you advanced techniques that will help you get the most out of SSRS. We’ll cover tricks and workarounds, tips for building your own charting engine and creating your own maps, and ways to visualize data you never thought possible with Reporting Services.

SessionID: 4084

Advancing Analytics at Microsoft Advertising

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Naga Krothapalli

Title: Advancing Analytics at Microsoft Advertising

Description:

SessionID: 4220

Make Cloud BI Work for You

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Chuck Heinzelman, Gilad Elyashar, David Magar

Title: Make Cloud BI Work for You

Description:

Not all business intelligence needs are the same; if they were, this world would be a very boring place. With Microsoft's BI offerings in Azure, you have the flexibility to create the BI environment that best fits your needs. Whether you need traditional SQL Server Reporting Services, PowerPivot, or full-blown PowerView, Azure provides the building blocks for your solution. Join this scenario-based, demo-driven presentation to learn how you can build and leverage Azure-based Reporting Services, PowerPivot, and full Infrastructure as a Service BI options.

SessionID: 4058

Taking BI to the Next Level: Collaboration

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Stacia Varga

Title: Taking BI to the Next Level: Collaboration

Description:

Self-service business intelligence is usually an independent activity. But when individuals discover interesting information they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it.

As individual products, SQL Server, SharePoint, and Excel expand your options for enabling BI in your organization. But collectively, they create a solid platform for collaborative BI. Come to this session to learn how to use these tools to create portals and dashboards that foster collaboration.

SessionID: 4062

Analytics for Business Strategy

Back to calendar

Event Date: 11-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Cristian Vava

Title: Analytics for Business Strategy

Description:

Strategy has remained one of the few areas of business activity not completely under the spell of business analytics. The main reason has been the unknowns in the supporting data, but other issues – such as overestimating the power of predictive algorithms or ignoring the effect of error propagation in complex computations – have created the impression that business analytics isn’t appropriate for strategy analysis. However, the human mind isn’t infallible either, and knowledge limitations, personal biases, or both often result in inappropriate business strategies.

This session will discuss fundamental issues we encounter in predictive analytics based on deep unknowns and analytics for low and very low probability events and then look at potential solutions. We’ll also analyze how the human mind works and what we can do to extend its capabilities and, thus, complement traditional strategic analysis tools.

SessionID: 4149

The Future of Apache Hive and Hadoop 2.0: Bigger, Faster, Stronger

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Carter Shanklin

Title: The Future of Apache Hive and Hadoop 2.0: Bigger, Faster, Stronger

Description:

Apache Hive, a SQL-like interface for Apache Hadoop, is used for reporting and analysis over huge volumes of data. Hundreds of companies use it for reliable data processing and unmatched scale. Hadoop 2.0 and the YARN framework promise to make Hive faster than ever and with lower latency.

This session will examine the next generation of Hive and how it lets you gain deeper insight in real time. Join us to learn real-world data and query patterns organizations are employing to get deep insights out of data in Hadoop using Apache Hive, see some of the upcoming Hive query features and effective patterns for using them, and discuss how Hadoop 2.0 will improve Hive throughput and latency.

SessionID: 3992

Building the Business Case for Big Data

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Hyoun Park

Title: Building the Business Case for Big Data

Description:

The sheer scale and hype of big data is grabbing companies’ attention across industries, but what are the secrets behind actual business cases that lead to successful big data projects? Above and beyond the technical aspects of deploying big data, companies must have targeted business goals, a realistic expectation of potential benefits, and a structured project plan to unlock the benefits of big data.

Based on multiple, documented big data projects, this session will show how successful projects begin, how these companies identify and prioritize business goals, and how they create a viable and defensible ROI model for their projects.

SessionID: 4020

Overview of Microsoft Appliances

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): James Serra

Title: Overview of Microsoft Appliances

Description:

Learn how SQL Server 2008 can scale to hundreds of terabytes for BI/DW solutions. This session will focus on Fast Track solutions and appliances, reference architectures, and Parallel Data Warehousing (PDW). It will also cover performance numbers and lessons learned from one of the very first production PDW deployments in the world and how a successful BI solution was built on top of it using SSAS.

Explore all the different appliances – HP Business Decision Appliance (BDA), HP Business Data Warehouse appliance (BDW), HP Enterprise Data Warehouse Appliance (EDW), and HP Database Consolidation Appliance (DBC) – and how they can save you significant time and money instead of building on your own. If you’re involved in the decision making for purchasing one or more servers for SQL Server, this session will show you options to ordering a server and internally installing the hardware, OS, and SQL Server.

SessionID: 4757

Enabling Collaborative Analysis while Maintaining Governance

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): John Whittaker, Ben Boise

Title: Enabling Collaborative Analysis while Maintaining Governance

Description:

Collaboration, Analysis, or Data Integration all capabilities found in BI today. Enabling all three capabilities can involve many different tools requiring different personnel skill sets. Today's data environment evolves to be more complicated with very turn and many IT departments find themselves supporting both Microsoft and DB2. This complex environment requires governance and security. However the business requires all this data to be accessible for analysis. Analysis needs to have agility and flexibility when it comes to data because asking a single question results in additional questions. This question and answer process requires collaboration with different groups and the collaboration needs to easily accomplished. Learn how to turn your existing data infrastructure into an agile, flexible and collaborative information environment.

SessionID: 4131

Mastering Time-Based Analysis in DAX

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Dan Clark

Title: Mastering Time-Based Analysis in DAX

Description:

So much analysis that a business typically performs on its data involves dates and/or times. Many organizations, for example, probably need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built-in time intelligence functions to help make date- and time-based calculations easier. Although the time intelligence functions are very useful, they can also be misused and give erroneous results. To avoid this, you need to understand which functions to use when and how to use them.

This session will guide you through the various time intelligence functions available in DAX and provide practical examples of how to correctly use them. We will also cover time intelligence best practices and how to avoid the many “gotchas” that can occur by misapplying these functions.

SessionID: 4052

Measuring the Subscription Economy

Back to calendar

Event Date: 11-04-2013 17:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Angel Abundez

Title: Measuring the Subscription Economy

Description:

In today's mobile landscape, many companies – including Spotify, Dropbox, XBox Live, and Audible – rely on a subscription-based business model. Measuring and monitoring subscription data can provide a wealth of information to these organizations, but conventional methods using CRM and ERP systems to track such business simply don’t work. However, several key metrics in membership and revenue can (and should) be used to monitor the health of these kinds of companies.

This session will show you how to dimensionally model the subscription economy and uncover these key metrics. We'll explore lessons learned, team requirements, and the business rules you need to be successful. You’ll be faced with hard questions around “freemium” subscriptions, grace periods, and legacy data – we’ll cover that, too. Then, we’ll end with some good data visualizations you can use to uncover additional value from these critical measures.

SessionID: 5150

Think Like a Freak

Back to calendar

Event Date: 12-04-2013 08:00 - Category: Keynote (75 minutes) - Track: Strategy and Architecture

Speaker(s): Steven Levitt

Title: Think Like a Freak

Description:

SessionID: 4217

Drab to Dynamite! Managed Self-Service BI Using Real-World Data

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Riccardo Muti, Sandy Rivas

Title: Drab to Dynamite! Managed Self-Service BI Using Real-World Data

Description:

Not every business has perfectly structured data. But with managed self-service business intelligence, you can now create rich, powerful analytics solutions that let you glean and share business insights from that data.

This walk-through session will begin with actual small business data in Excel format and add data from Windows Azure to expand your analytics possibilities and show how to integrate data from SQL or other sources. PowerPivot will take the stage next, joining the data and enhancing it with calculated fields and KPIs. We’ll step through Power View to produce beautiful visualizations and deep exploration functionality. We’ll finish by sharing our solution, publishing it to SharePoint (using both PowerPivot Gallery and Excel Web Services) and via PowerPoint.

Whether you’re an IT pro or business user and whatever your data’s structure, after this session, you’ll have the start-to-finish instruction manual to take any data set from drab to DYNAMITE!

SessionID: 4223

PDW Architecture Gets Real: Customer Implementations

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Brian Walker, Murshed Zaman

Title: PDW Architecture Gets Real: Customer Implementations

Description:

Dive into the world of SQL Server Parallel Data Warehouse (PDW), and discover the power of the Massively Parallel Processing (MPP) architecture as this session shares actual customer implementations from the PDW Center of Excellence (CoE) and SQL Server Customer Advisory Team (SQLCAT). We will review the new features in SQL Server PDW 2012 and how improvements in the product can be leveraged by your VLDB applications. We will also discuss proven best practices adopted by real customers and how to solve big data challenges with the integration of structured and unstructured data.

SessionID: 4118

60-Minute Demo: Microsoft BI Tools on SAP Data

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Michael Raheem

Title: 60-Minute Demo: Microsoft BI Tools on SAP Data

Description:

Did you know there are many innovations in SQL Server 2012, SharePoint 2010, and Office 2010 that let you provide self-service BI solutions? Using these new features, your users can access their own data, build reports, perform ad-hoc analysis, collaborate and share their insight, and create compelling visualizations on SAP data. These tools create an environment that lets business users perform the analysis they need to make better business decisions quickly and efficiently - all on top of SAP data.

In this 60-minute demo session, we’ll build an end-to-end BI system from scratch, using a common business scenario to show how the solution evolves from Personal-BI to Team-BI to Corporate-BI. We’ll cover tools such as Excel with PowerPivot, SharePoint, Power View, SQL Server Data Tools, and Analysis Services Tabular Model and show how to leverage Neudesic’s CountERPart solution to enable self-service BI on top of your SAP data.

SessionID: 4005

Mastering the CUBE Functions in Excel 2013

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Peter Myers

Title: Mastering the CUBE Functions in Excel 2013

Description:

Join this session to explore the seven CUBE functions natively available in Excel 2013. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.

The session will introduce each of the seven functions. Demonstrations will range from the simple to the more sophisticated, involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts. We’ll also cover the publication of Excel workbooks to SharePoint and the embedding of reports into web part pages.

This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content we’ll cover is also applicable to Excel 2007 and Excel 2010.

SessionID: 4068

Data Visualization with Power View and the Tabular Model

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Jen Stirrup

Title: Data Visualization with Power View and the Tabular Model

Description:

SQL Server 2012 introduces us to data visualization in the form of Power View and new in-memory technology for Tabular models. This session will focus on Power View and its roots in data visualization theory and practice, when to use the Tabular model and how it stacks up against multi-dimensional models, and successful Tabular model implementation. Come learn how these new features can power up your visualizations and business intelligence.

SessionID: 4115

Big Data: Threat or Opportunity?

Back to calendar

Event Date: 12-04-2013 10:00 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Shaun Connolly

Title: Big Data: Threat or Opportunity?

Description:

Big data is everywhere. We see it on commercials. We hear it in conversations over coffee. It is an expanding topic in the boardroom. The hype is palpable, but what is real and - better yet - how does it affect the status quo?

At the center of the big data discussion is Apache Hadoop, a next-generation enterprise data platform that lets you capture, process, and share the enormous amounts of new, multi-structured data that doesn’t fit into traditional systems.

Microsoft and Hortonworks have partnered to help you bridge this new world of unstructured content with the structured data you manage today. See how this partnership is bringing Hadoop to the masses as an addition to your current enterprise data architecture so that you can gain net new insight without net new headache.

SessionID: 4292

Data Analytics: Realizing the Full Potential

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Mike Stringer

Title: Data Analytics: Realizing the Full Potential

Description:

Data – whether big, small, slow, or fast – has failed to live up to the hype of transforming how companies do business. Why? In this session, Mike Stringer will argue that the reason we are not yet realizing the vast potential of data is that we are spending too much time improving the technical aspects and tools used in business analytics rather than exploring new ways data can be used as a valuable resource to solve problems and design new products. Come learn how to help refocus your team on the top priorities and get the most of out of data for your organization.

SessionID: 4081

Drive Smarter Decisions with Microsoft HDInsight

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Tim Mallalieu

Title: Drive Smarter Decisions with Microsoft HDInsight

Description:

Microsoft HDInsight helps you embrace Hadoop - Microsoft's big data platform for helping you enrich your data through discovery and advanced analytics - enabling you to seamlessly manage data of any type or size. With HDInsight, you can easily extend your data warehouse to include unstructured data with Hadoop on Windows Azure or Windows Server. In this session, you'll learn how to provision a Hadoop cluster on Windows Azure in minutes and then easily manage, monitor, and scale it. Come see how to enable all users to glean insights from their data, whether structured or unstructured, through familiar tools such as Excel.

SessionID: 4065

Excel Charting Tips

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Wayne Winston

Title: Excel Charting Tips

Description:

Join this session to dig into cool and little known Excel charting tips that will help your charts and dashboards come alive. You’ll learn how to add bling to your column graphs, how to use List boxes to choose the series charted in a graph, and how to use Checkboxes to select the series that show in a chart. We’ll cover using the OFFSET function to control the data points that appear in a chart, and finish up with a demonstration on how to use GETPIVOTDATA and the Excel Table feature to efficiently pull data from a PivotTable into a chart that dynamically updates as new data is added.

SessionID: 4140

My Brain Hurts: Presenting Data with Microsoft Tools

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Craig Utley

Title: My Brain Hurts: Presenting Data with Microsoft Tools

Description:

There is an old saying, “May you live in interesting times.” But interesting times can be both a blessing and a curse. Microsoft certainly makes viewing data interesting. Excel, Excel Services, SQL Server Reporting Services, PerformancePoint Services, PowerPivot, Power View… all are tools that Microsoft provides for looking at your data. Which should you choose?

In this session, Craig Utley demonstrates each of these tools, showing you not only their capabilities, but also assessing their strengths and weaknesses based on the target audience. If you want to get a handle on the crowded world of Microsoft BI delivery tools, this session is for you.

SessionID: 4021

Building an Effective Data Warehouse Architecture

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): James Serra

Title: Building an Effective Data Warehouse Architecture

Description:

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model in SQL Server 2012 change things? What’s the difference between a data warehouse and a data mart? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data?

Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise – or at least lead you down the correct path to adding business value to your organization!

SessionID: 4024

Feed Your Data! OData Data Feeds for PowerPivot Users

Back to calendar

Event Date: 12-04-2013 11:15 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Chris Webb

Title: Feed Your Data! OData Data Feeds for PowerPivot Users

Description:

You may have seen the option in PowerPivot or Excel 2013 to import data from a data feed, but do you know how this option can benefit your analysis and what kind of data you can get from a data feed? This session will explain in a non-technical way what an OData data feed is and look at some of the data sources that expose data feeds, such as the Windows Azure DataMarket, SQL Server Reporting Services, and Excel Services 2013. You’ll then see how you can use data feeds to build your own BI applications.

SessionID: 4350

Parallelizing Large Excel-Based Calculations on HPC Server & Azure

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Antonio Zurlo

Title: Parallelizing Large Excel-Based Calculations on HPC Server & Azure

Description:

SessionID: 4221

How Intel Integrates Self-Service BI with IT for Better Business Results

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Cindy Gross, Eduardo Gamez

Title: How Intel Integrates Self-Service BI with IT for Better Business Results

Description:

Learn how Intel has worked across organizational boundaries to successfully blend self-service, rapid iteration reporting with IT needs for security, one version of the truth, and sharability to enable true Business Intelligence. A combination of Microsoft PowerPivot, Power View, SharePoint, SQL Server, Reporting Services, and Analysis Services tabular models – running on powerful, scalable and energy-efficient Intel® processor-based platforms – has helped Intel build a flexible and responsive BI environment to deliver impactful insights to help Intel not only better manage the day-to-day business operations, but also make strategic and long-term decisions.

SessionID: 4143

MDS and DQS - Beyond the TLAs to Data Quality

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Neil Hambly

Title: MDS and DQS - Beyond the TLAs to Data Quality

Description:

Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.

High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.

SessionID: 3991

GeoSpatial Analytics Using Microsoft BI

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Jason Thomas

Title: GeoSpatial Analytics Using Microsoft BI

Description:

This session will start by explaining why GeoSpatial analytics is important in today's world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will also feature practical demos for each of these tools, during which we will work on some of the publicly available datasets to uncover some interesting facts.

SessionID: 4055

Self-Service Data Modeling

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Marco Russo

Title: Self-Service Data Modeling

Description:

Self-service business intelligence looks promising, empowering information workers to grab amazing insights from data. But are Excel 2013 and DAX language knowledge enough to analyze data? The answer in most cases is no – information workers will also need an ability to properly model their data and the skill to use some new tools to reshape data in the correct way. In this session, we will analyze some common problem scenarios where data analysis is difficult due to the shape of the model and see how to solve them.

SessionID: 3989

The Essential 8: Narrative Reporting Techniques

Back to calendar

Event Date: 12-04-2013 13:30 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Julie Koesmarno, Josh Fennessy

Title: The Essential 8: Narrative Reporting Techniques

Description:

Boring static reports are no longer acceptable in today's business culture. Analytics should be highly visual, interactive, and tell a meaningful story. The latest version of Microsoft Excel is designed to perform those duties and more, supporting narrative reporting that goes far beyond the tabular format and eliminates the need for comments.

Learn how to craft narrative-style reporting in this unique session, which guides you through several design scenarios that business analysts commonly face. You'll learn Excel reporting techniques that will enable you to build highly visual and interactive reports without the need for heavy infrastructure requirements. Using the session’s eight essential tips, you’ll be able to equip report consumers to make well-informed decisions using data, not commentary. After this demo-filled session, you’ll feel like an information novelist.

SessionID: 4299

Dark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Rob Collie

Title: Dark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future

Description:

The biggest missing pieces of your organization’s Big Data, data science, or business intelligence strategy aren't “missing” at all – you already have them, if you know where to look. For too long, we have allowed the technology tail to wag the domain expertise dog; organizations that reverse that relationship in a controlled fashion realize dramatic improvements in short periods of time – with improved clarity, greater agility, higher ROI on tech investments, and improved IT-business relations. Cutting-edge fields like Big Data come into focus, allowing you to make high-ROI, low-risk investments.

Come learn how “small” advances in spreadsheet technology open the door to that new culture while simultaneously turning your “Excel problem” into your biggest competitive advantage. Noted spreadsheet sociologist and time traveler Rob Collie leads this interactive discussion: a short introduction of four critical concepts, followed by a menu of discussion topics for audience selection.

SessionID: 4327

Online Advertising: Hybrid Approach to Large-Scale Data Analysis

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Dmitri Tchikatilov, Anna Skobodzinski, Trevor Attridge, Christian Bonilla

Title: Online Advertising: Hybrid Approach to Large-Scale Data Analysis

Description:

Explore the business value and learn the technical details behind a solution for large-scale data analysis developed for advertising agencies. Designed to provide streamlined analysis of terabytes of online advertising data, the solution’s goal is to improve the efficiencies and ROI of online marketing campaigns. The analysis solution uses an on-premise SQL Server Parallel Data Warehouse appliance (PDW), which is extended with HDInsight Azure capabilities. The session will also cover data analysis scenarios using the latest Microsoft business intelligence tools, including PowerPivot and Power View, as well as statistical analysis with R.

SessionID: 4210

Charting Collections of Social Media Connections with NodeXL

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Marc Smith

Title: Charting Collections of Social Media Connections with NodeXL

Description:

NodeXL supports the exploration of social media with import features that pull data from Twitter, Flickr, YouTube, Facebook, web hyperlinks, and personal email indexes. Come see how this tool lets non-programmers quickly generate useful network statistics and metrics and create visualizations of network graphs.

SessionID: 4160

Social Text, Sentiment, and Tone Analysis

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Paco Gonzalez, Ruben Pertusa Lopez

Title: Social Text, Sentiment, and Tone Analysis

Description:

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with the format depending on the social network. Twitter messages are limited to 140 characters and use hashtags, for example; Facebook messages can be longer.

This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning.

This session also presents the development of a tone analysis tool for economic indicators, built by SolidQ. We’ll look at SQL Server Integration Services text mining, Hadoop, SQL Server data mining, and Microsoft .NET technologies.

SessionID: 4108

Delivering Agile BI Solutions

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture

Speaker(s): Dave DuVarney

Title: Delivering Agile BI Solutions

Description:

Many business intelligence teams work within traditional software development life cycles. These cycles follow a waterfall-based approach: Gather all your requirements, do a design, do some development, and then several months later, hopefully there is something for business users to get their hands on. Analytical requirements are significantly more fluid and require a more agile development approach. In this session, you will learn how to set up an Agile BI team. We will cover roles and meeting cadence in an Agile team, tools for tracking user requirements and feedback, and real-world examples of how to break larger analytical needs into small iterations.

SessionID: 4213

Business Intelligence on Mobile Devices

Back to calendar

Event Date: 12-04-2013 14:45 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Leif Brenne, Ari Schorr

Title: Business Intelligence on Mobile Devices

Description:

Get mobilized! Learn how to leverage Microsoft Business Intelligence and SQL Server technologies with a variety of mobile devices, including Microsoft Surface, Apple iPad, Kindle Fire, Windows 8 and Windows Phone, and more. This session will cover top mobile delivery options available today, focusing on browsers as well as the future. Don't miss these real-world implementation tips, tricks, best practices, and lessons learned in the field.

SessionID: 4191

The ABCs of Scoring: Why, How, and Getting a Good Grade

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Dan Bulos

Title: The ABCs of Scoring: Why, How, and Getting a Good Grade

Description:

This session will look at why scoring models are a valuable tool in business analytics and survey some common examples in a business context. We'll then dive into the details of how to build a scoring model and evaluate the decisions you need to make in building the model.

SessionID: 4214

Microsoft Data Explorer for Excel: Data Discovery & Transformation

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery and Collaboration

Speaker(s): Faisal Mohamood

Title: Microsoft Data Explorer for Excel: Data Discovery & Transformation

Description:

Microsoft Data Explorer for Excel is a new set of experiences that enable analysts and business users to discover, transform, and acquire data of any shape and size. Come learn more about how to reduce your overall time to insight with this fresh and innovative approach for querying and mashing up data in Excel and PowerPivot.

SessionID: 4056

Recommender Systems – A Walkthrough

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Artus Krohn-Grimberghe

Title: Recommender Systems – A Walkthrough

Description:

Join this session to learn about recommender systems, which use a nifty predictive analytics technique for estimating user preferences on movies, retail products, e-learning items, and almost anything else. We’ll begin with an introduction to industry applications for recommender systems and their potential as marketing, customer satisfaction, and customer support agents. We’ll then go on a demo-driven dive through the inner workings of a state-of-the-art recommender algorithm, showcasing key elements. The session will end with a question-and-answer period with presenter Dr. Artus Krohn-Grimberghe, who wrote his dissertation on recommender systems and will share important readings and electronic resources to help you on your way.

SessionID: 4224

SQL Server Predictive Analytics: Customer Stories

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analytics and Insights

Speaker(s): Raman Iyer

Title: SQL Server Predictive Analytics: Customer Stories

Description:

SQL Server provides a rich predictive analytics platform as part of Analysis Services that you can apply in a wide range of business scenarios, from cross-sell to churn analysis to forecasting and more. Join us for this overview of the platform capabilities and explore real-world customer applications that have delivered significant business value with SQL Server.

SessionID: 4057

Using Power View and Hadoop to Unlock Hidden Markets

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Data Analytics and Visualization

Speaker(s): Joseph D'Antoni, Stacia Varga

Title: Using Power View and Hadoop to Unlock Hidden Markets

Description:

A practical way to derive business value from big data is to micro-target customers, but where do you begin? In this session, we’ll examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. Then we’ll walk through a demonstration of how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We’ll demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that you can use to connect more effectively with customers.

SessionID: 4053

Big Data - Top Ingredient to Improve Healthcare

Back to calendar

Event Date: 12-04-2013 16:00 - Category: Breakout Session (60 minutes) - Track: Big Data Innovations and Integration

Speaker(s): Paul Bradley

Title: Big Data - Top Ingredient to Improve Healthcare

Description:

As healthcare undergoes a major shift toward outcome-based payment and financial models, hospitals now more than ever need to utilize their big data assets to operate optimally and improve patient health. Healthcare providers currently have a treasure trove of data that can be turned into actionable information to improve operations immediately.

In this session, we will discuss using SQL Server to crunch the numbers and maximize resources to ensure that 1) appropriate charges are captured, 2) payer reimbursement is accurate, 3) patient quality and effectiveness is optimized, and 4) manual repetitive tasks can be automated. You’ll see how a Pioneering ACO health system achieved a 3% net revenue increase, 150% productivity increase, and 11-to-1 ROI using predictive analytic solutions. With momentum shifting to outcome-based reimbursement models, you’ll learn how analysis and modeling of patient-centered datasets can provide a foundational pillar to improve population health outcomes and minimize hospital readmissions.