| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 07-05-2014 08:30 | Jason Strate | Pre-Conference Session (full day) | Big Data | Implementation and Design on the Parallel Data Warehouse |
| 07-05-2014 08:30 | Rob Collie | Pre-Conference Session (full day) | Analytics and Visualization | PowerPivot: Fundamentals and Patterns to Make You Effective TODAY |
| 07-05-2014 08:30 | Mark Tabladillo, Artus Krohn-Grimberghe | Pre-Conference Session (full day) | Advanced Analysis Techniques | Predictive Analytics for Absolute Beginners |
| 07-05-2014 08:30 | Lynn Langit | Pre-Conference Session (full day) | Big Data | Real-World Small Big Data |
| 07-05-2014 08:30 | Peter Myers | Pre-Conference Session (full day) | Analytics and Visualization | Superhero Power BI |
| 07-05-2014 08:30 | Mark Whitehorn | Pre-Conference Session (full day) | Advanced Analysis Techniques | Data Science Master Class: Exploring More Exotic Patterns in Data |
| 08-05-2014 10:00 | Sanjay Soni | Breakout Session (60 minutes) | Analytics and Visualization | 3D Visualization and Storytelling with Power Map for Excel |
| 08-05-2014 10:00 | Erika Bakse | Breakout Session (60 minutes) | Advanced Analysis Techniques | Stats Across the Stack |
| 08-05-2014 10:00 | Carlos Bossy | Breakout Session (60 minutes) | Advanced Analysis Techniques | An Introduction to Predictive Modeling |
| 08-05-2014 10:00 | Rod Colledge | Breakout Session (60 minutes) | Strategy and Architecture | Enterprise BI Architecture with Power BI |
| 08-05-2014 10:00 | Devin Knight | Breakout Session (60 minutes) | Information Delivery | Creating an End-to-End Power View Reporting Solution |
| 08-05-2014 10:00 | Lara Rubbelke | Breakout Session (60 minutes) | Big Data | Deploying Hadoop in the Cloud |
| 08-05-2014 11:15 | Todd McDermid | Breakout Session (60 minutes) | Strategy and Architecture | Analytics and OLTP Systems: Is Hekaton a Game-Changer? |
| 08-05-2014 11:15 | Karen Lopez, Joseph D'Antoni, Stacia Varga, Josh Fennessy, Lynn Langit | Breakout Session (60 minutes) | Big Data | Panel: Has Big Data Killed the EDW? |
| 08-05-2014 11:15 | Konstantin Korobkov | Breakout Session (60 minutes) | Big Data | Hadoop for SQL Server Professionals |
| 08-05-2014 11:15 | Michael Tejedor | Breakout Session (60 minutes) | Analytics and Visualization | Data Analysis in Excel and Power BI for Office 365 |
| 08-05-2014 11:15 | Jose Chinchilla | Breakout Session (60 minutes) | Advanced Analysis Techniques | Real-World Sentiment Analysis with Big Data Tools |
| 08-05-2014 11:15 | Rebecca Shockley | Breakout Session (60 minutes) | Analytics and Visualization | What it Takes to Create Value from Data and Analytics |
| 08-05-2014 13:30 | David Smith | Breakout Session (60 minutes) | Advanced Analysis Techniques | Real-Time Big Data Analytics with R |
| 08-05-2014 13:30 | Oliver Engels, Tillmann Eitelberg | Breakout Session (60 minutes) | Analytics and Visualization | Web Analytics with Microsoft BI |
| 08-05-2014 13:30 | James Serra | Breakout Session (60 minutes) | Strategy and Architecture | Building an Effective Data Warehouse Architecture |
| 08-05-2014 13:30 | Sanjay Soni, Zoe Krumm | Breakout Session (60 minutes) | Big Data | Fighting Global Cybercrime and BotNets using Power BI and Big Data |
| 08-05-2014 13:30 | Niko Neugebauer, Scott Stauffer | Breakout Session (60 minutes) | Information Delivery | Managing Your Alibi with Social Media |
| 08-05-2014 13:30 | Dan Clark | Breakout Session (60 minutes) | Big Data | Using Hive to Query and Process Big Data |
| 08-05-2014 14:45 | Jason Strate | Breakout Session (60 minutes) | Big Data | Introduction to PDW Distribution Theory |
| 08-05-2014 14:45 | Rob Collie | Breakout Session (60 minutes) | Strategy and Architecture | Your Own Data Revolution: PowerPivotPro’s Six Principles |
| 08-05-2014 14:45 | Val Fontama, Derek Bevan | Breakout Session (60 minutes) | Advanced Analysis Techniques | Unlocking Business Value with Advanced Analytics |
| 08-05-2014 14:45 | Dana Zuber, Evelyn Lawson | Breakout Session (60 minutes) | Analytics and Visualization | Using Time Series Clustering to Understand Customer Behavior |
| 08-05-2014 14:45 | Chris Webb | Breakout Session (60 minutes) | Analytics and Visualization | MDX for PowerPivot Users |
| 08-05-2014 14:45 | Marc Smith | Breakout Session (60 minutes) | Advanced Analysis Techniques | NodeXL: Charting Collections of Connections in Social Media |
| 08-05-2014 16:00 | Chuck Heinzelman | Breakout Session (60 minutes) | Strategy and Architecture | BI in Windows Azure Virtual Machines: From Creation to User Access |
| 08-05-2014 16:00 | Christopher Schnieper, Rick Wedgeworth | Breakout Session (60 minutes) | Big Data | Real Time with Big Data: Fact or Fiction? |
| 08-05-2014 16:00 | William E Pearson III | Breakout Session (60 minutes) | Information Delivery | Through Gardens Overgrown: PowerPivot to SSAS 2012 Tabular |
| 08-05-2014 16:00 | Alberto Ferrari | Breakout Session (60 minutes) | Analytics and Visualization | DAX from the Field: Real-World Case Studies |
| 08-05-2014 16:00 | Karen Lopez, Joseph D'Antoni, Stacia Varga, Erika Bakse, Lynn Langit | Breakout Session (60 minutes) | Strategy and Architecture | Panel: Myths, Misunderstandings, and Successes in Data Analytics |
| 08-05-2014 16:00 | Artus Krohn-Grimberghe | Breakout Session (60 minutes) | Advanced Analysis Techniques | Predictive Analytics for Beginners |
| 08-05-2014 17:15 | Madhu Iyer | Breakout Session (60 minutes) | Advanced Analysis Techniques | Using Customer Data to Drive New Business Initiatives |
| 08-05-2014 17:15 | Tom Lawry | Breakout Session (60 minutes) | Analytics and Visualization | Health Analytics: Quality and Effectiveness of Healthcare with Power BI |
| 08-05-2014 17:15 | Cristian Vava | Breakout Session (60 minutes) | Advanced Analysis Techniques | The True Value of Your Data Analytics Project |
| 08-05-2014 17:15 | Dejan Sarka | Breakout Session (60 minutes) | Analytics and Visualization | Advanced Analytics in Excel 2013 |
| 08-05-2014 17:15 | Rafael Salas | Breakout Session (60 minutes) | Strategy and Architecture | ETL: Avoiding Costly Mistakes |
| 08-05-2014 17:15 | Javier Guillen | Breakout Session (60 minutes) | Strategy and Architecture | Business Insight through Cloud-Based Data Models |
| 09-05-2014 10:00 | Wu Feng, Maxim Lukiyanov | Breakout Session (60 minutes) | Big Data | DNA Sequencing Analysis in the Cloud |
| 09-05-2014 10:00 | Rob Collie, Michael Miskell | Breakout Session (60 minutes) | Strategy and Architecture | The Reality of “Industrial Strength” Excel – A Case Study |
| 09-05-2014 10:00 | Joseph D'Antoni | Breakout Session (60 minutes) | Strategy and Architecture | The Modern Analytics Architecture |
| 09-05-2014 10:00 | Dev Nambi | Breakout Session (60 minutes) | Advanced Analysis Techniques | Using Data to Make Decisions |
| 09-05-2014 10:00 | Edwin M Sarmiento | Breakout Session (60 minutes) | Information Delivery | Integrating Big Data with SharePoint 2013 |
| 09-05-2014 10:00 | Oliver Engels, Julian Breunung | Breakout Session (60 minutes) | Advanced Analysis Techniques | M versus P versus R |
| 09-05-2014 11:15 | Alejandro Jaimes | Breakout Session (60 minutes) | Big Data | Insights from Big Data: Interaction, Design, and Innovation |
| 09-05-2014 11:15 | Jason Horner | Breakout Session (60 minutes) | Advanced Analysis Techniques | Advanced Spatial Analysis: Beyond Bubble Charts |
| 09-05-2014 11:15 | Samuel Zhang | Breakout Session (60 minutes) | Strategy and Architecture | Power BI from an IT Pro Perspective |
| 09-05-2014 11:15 | Olivier Matrat, Marc Reguera, Jason Hahn | Breakout Session (60 minutes) | Analytics and Visualization | How Microsoft BI Helps the Grameen Foundation Improve Lives |
| 09-05-2014 11:15 | Elena Verna | Breakout Session (60 minutes) | Advanced Analysis Techniques | Growth Hacking Using Data |
| 09-05-2014 11:15 | Grant Paisley | Breakout Session (60 minutes) | Information Delivery | Kick-Ass Ad Hoc Cube Browser Built in SSRS 2014 |
| 09-05-2014 13:30 | James Rowland-Jones | Breakout Session (60 minutes) | Strategy and Architecture | Migrating to PDW? Lessons from the Field |
| 09-05-2014 13:30 | Peter Myers | Breakout Session (60 minutes) | Advanced Analysis Techniques | Introduction to Time Series Forecasting |
| 09-05-2014 13:30 | Marco Russo | Breakout Session (60 minutes) | Analytics and Visualization | Querying in DAX |
| 09-05-2014 13:30 | Matt Masson, Theresa Palmer-Boroski | Breakout Session (60 minutes) | Analytics and Visualization | Deep Dive into Power Query Formula Language |
| 09-05-2014 13:30 | Mark Tabladillo, Lynn Langit | Breakout Session (60 minutes) | Advanced Analysis Techniques | Machine Learning Smackdown |
| 09-05-2014 13:30 | Kasper de Jonge | Breakout Session (60 minutes) | Strategy and Architecture | Solving Complex Business Problems with DAX |
| 09-05-2014 14:45 | Anil Kaul | Breakout Session (60 minutes) | Advanced Analysis Techniques | Bridging the Gap Between Decision Makers and Advanced Analytics |
| 09-05-2014 14:45 | Mark Davis | Breakout Session (60 minutes) | Big Data | Big Data and the Challenge of Unstructured Information Analysis |
| 09-05-2014 14:45 | Jen Stirrup | Breakout Session (60 minutes) | Big Data | R and Hadoop: From Data Sources to Secret Sauce |
| 09-05-2014 14:45 | Josh Fennessy | Breakout Session (60 minutes) | Strategy and Architecture | A Master Data Management Case Study: MDS and DQS |
| 09-05-2014 14:45 | Paco Gonzalez | Breakout Session (60 minutes) | Advanced Analysis Techniques | Big Data Mining with Mahout |
| 09-05-2014 14:45 | Adam Wilson | Breakout Session (60 minutes) | Analytics and Visualization | Natural Language Data Exploration with Power BI Q&A |
| 09-05-2014 16:00 | Giovanni Seni | Breakout Session (60 minutes) | Advanced Analysis Techniques | Regularization in Regression and Deep Learning Methods |
| 09-05-2014 16:00 | Will Thompson | Breakout Session (60 minutes) | Advanced Analysis Techniques | Data Visualization Deep Dive with Power View in Power BI |
| 09-05-2014 16:00 | Jason Thomas | Breakout Session (60 minutes) | Information Delivery | DataViz You Thought You Couldn't Do with SSRS |
| 09-05-2014 16:00 | Carlos Bossy | Breakout Session (60 minutes) | Advanced Analysis Techniques | Introduce Yourself to Data Mining Using Case Studies |
| 09-05-2014 16:00 | Brian Mitchell, Tammy Richter Jones | Breakout Session (60 minutes) | Advanced Analysis Techniques | The Role of SQL Server 2012 PDW AU1 & Polybase in the Modern Data Warehouse |
| 09-05-2014 16:00 | Dana Zuber | Breakout Session (60 minutes) | Strategy and Architecture | Managing Big Data Teams in a Big Company |
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Big Data
We will discuss what it takes to migrate a data warehouse to PDW and what bottlenecks you could expect to see in a migration. Through live demonstrations, you will witness the power and performance of PDW and see the performance impact of PDW's data distribution.
This session will also explore the successes that real-world clients already on PDW are seeing and why it is the key to future data warehouses. By the end of the day, you will have a clear understanding of the value that PDW can provide your organization when it comes to performance and scale.
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Analytics and Visualization
The next surprise, however, is even better: a remarkable simplicity underlies all of that power. In fact, the most useful capabilities are conveniently the most learnable.
In this Pre-conference session, Rob Collie has filtered his years of PowerPivot education, writing, and consulting experience down to that set – the things anyone can learn and retain in a short period of time, while simultaneously building a confident foundation for future learning. He brings the technology’s power to you, not vice versa. Together, we will take a 100% human and pragmatic approach.
But that down-to-earth approach, geared toward absolute beginners, will give you analytical superpowers. This learning strategy is built on four pillars:
The only prerequisite is that you enjoy data. Join us for the revolution.
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Advanced Analysis Techniques
Aimed at absolute beginners, this pre-conference session builds on the experience of the presenters in teaching university students and advising industry clients. Join this structured, full-day journey into the following topics:
• How to understand the major data mining tasks (including regression, classification, and clustering) • How to map business problems to machine learning algorithms • How to apply the best practices in data cleansing and transformation (shaping) • What technology options are available for the Microsoft platform (including Windows and Azure)
With regular stopping points for you to interact with other attendees and the presenters, this session is designed to empower you and enable you and your analytics team to more confidently approach any challenges in your organization.
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Big Data
We will examine implementations in vertical industries, including heath care, education, government, and financial services. We will also explore a full range of big data technologies and products, including relational databases, Hadoop, NoSQL, aggregation solutions such as Cubes, Tabular Models, and visualization solutions such as Power View, Tableau, Qlikview, and more.
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Analytics and Visualization
The aim of this session is to excite you with the potential of Microsoft's new self-service suite of BI products and collaboration platform, called Power BI. You will learn about four “Power” authoring products available in Excel and how they function to discover, acquire, transform, relate, and enrich data for analysis and reporting. Topics include Power Query, PowerPivot, Power View, and Power Map.
You will also learn how to effectively share and collaborate on Power BI solutions in the cloud with Office 365. Topics include data refresh to on-premise data, the data catalog to search for data queries, natural language query (Q&A) to intuitively query data, and a mobile application for Power BI.
This session has been designed to provide perspective across the Power BI story. Theory and an end-to-end series of real-world demonstrations will allow you to appreciate how the Power BI products span on-premise and cloud environments and how they attain super-strength as they work together.
Event Date: 07-05-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Advanced Analysis Techniques
Data science requires us to see and understand complex patterns in data. We use techniques such as data mining to uncover them. However, there are other, less well-known but equally useful techniques and methodologies directly applicable to data science that we can add to our toolbox, including:
• Monte Carlo simulations • Nyquist’s Theorem • Techniques for handling outliers • Type 1, 2, and 3 errors • False positives • Simpson’s paradox • Benford’s Law
This session will NOT include any heavy (or, indeed, light!) mathematics; instead, it will focus on how understanding these techniques can help you understand complex data patterns in your day-to-day work.
Understanding random walks, for instance, is mathematically so complex that Einstein worked on the problem. Happily, non-mathematicians can use Monte Carlo simulations to understand them. (The connection from the question above is that Einstein also held a US patent, No. 1,781,541, for a gas-powered fridge).
In this session, you will see how Monte Carlo simulations are highly applicable to business problems, such as optimizing web design; how Nyquist’s Theorem can be used to tell us, for example, how often to sample smart electricity meters; and much more.
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
This will be a demo-heavy session with use cases of Power Map with customers. We will start with an overview of Power BI for Office 365 and where Power Map fits, go into roadmap for regular updates, and observe Power Map in action across industry-relevant demos.
The goal of this session is to learn how Power Map can be a huge differentiator from other geospatial and storytelling BI tools. This session will also highlight the collective value of the self-service BI feature in Excel along with the data discovery of Power Query and dashboard visualization of Power View.
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
In this session, Rod will focus on; 1. What is Power BI? 2. What do you need to run Power BI, and how do you get it? 3. Where does Power BI fit in an organization's broader enterprise BI strategy?
In addition to answering the above questions, Rod will build a Power BI solution from scratch, in real time. Rod will use Power Query, Power Pivot, Power View and Power Map inside Excel 2013, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q & A, the new natural language query technology.
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery
This session will give you a beginning-to-end view of how to create Power View reports, including organizing a PowerPivot source to prepare the actual Power View report.
Event Date: 08-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Big Data
We will walk through HDInsight usage scenarios, as well as alternative approaches to run various distributions of Hadoop in Windows Azure. The session will couple demonstrations with real-world deployment topologies, focusing on the benefits in each model.
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
Business analysts should be very skeptical about tool vendor claims of being able to drop analytics on top of existing systems "in days" or "weeks." At a business analyst level, this session will explain why those poor outcomes happen and what techniques data professionals can use to overcome them.
The landscape has changed a little with PowerPivot, allowing in-memory analytics on what appears to be more traditional data. But now a real game-changer might be on the horizon, in Microsoft's Hekaton engine. Is it the vehicle for the perfect combination of LOB data with analytics? Or does the dream of one database for all purposes remain out of reach?
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Big Data
Join industry experts in this panel discussion examining the trade-offs of big data solutions that use Hadoop or NoSQL solutions, as compared to relational databases and SQL Server Parallel Data Warehouse.
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Big Data
This session will provide an overview and comparison of several commercial Hadoop distributions (Cloudera, MapR, HortonWorks, Microsoft, IBM, Intel, and EMC-Greenplum), looking at features, components, and extensions. We will explore what you need to start a small proof-of-concept Hadoop project, including hardware, software, network, installation, configuration, testing, and tuning details. We will also walk through several demos on a small desktop, 3-node Hadoop cluster with data access via ODBC from familiar Windows tools (Excel, SQL Server Integration Service, SQL Server Reporting Services, etc.).
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
You'll leave this session with a solid understanding of the capabilities for self-service Business Intelligence in Excel and in the Power BI service, how it can empower business users and data experts within an organization, and how to get started right away.
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Big data has democratized the ability to do sentiment analysis, also known as opinion mining, across much bigger data sets and a variety of data sources. It has also reduced the time-to-data, improving informed decision-making and uncovering time-sensitive opportunities.
In this session, we will explore the process of sentiment analysis and how big data tools can help. We’ll also walk through a live real-world sentiment analysis demo from social media to gauge the attitudes and opinions of PASS BA Conference attendees.
Event Date: 08-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
These are among the key findings from the 2013 IBM Institute for Business Value research study on how organizations around the global are leveraging key capabilities to amplify their ability to create value from data and analytics. In our new research, Analytics: A blueprint for value/ Converting big data and analytics insights into results, we identify the nine levers to value creation through data and analytics, and the leading practices used by high-performing organizations to deliver the optimal value from their analytics investments.
And while all nine levers differentiate top performing analytics organizations from others, our research goes further to identify the relative impact each of the levers has on value creation. In this session, we will identify which levers are required for analytic discovery to occur, those that are critical to moving from discovery to value creation, and those needed to amplify the value delivered to the organization.
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
The R language, the lingua franca of data scientists, is widely used for model development. In this talk, we'll focus on the big data capabilities of Revolution R Enterprise and integrate R into this real-time analytics deployment process. We'll also explore how Revolution R Enterprise integrates with other technologies in the real-time analytics deployment process, including Hadoop, database warehousing systems, and end-user applications.
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
You will see how to load Google Analytics data using SQL Server Integration Services, for example, and merge that data with your local data. In addition, we will walk through a demonstration of important web analytics KPIs and how you can analyze them using Microsoft Business Intelligence tools.
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
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!
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Big Data
In this session, we will show how the Cybercrime team is using Microsoft’s portfolio of big data solutions including simple, familiar Power BI tools, SQL Server Parallel Data Warehouse, and cutting-edge cloud technologies to fight BotNets that commit hundreds of millions of dollars of identity fraud ever year.
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Information Delivery
Join this session for a hour of data exploration around favorite bars and coffee shops you check into on FourSquare.
Event Date: 08-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Big Data
HiveQL is a declarative language modeled to provide a similar experience as writing SQL. If you are familiar with SQL, using HiveQL should be intuitive. With HiveQL, you construct and run the statement, submitting it to a query engine. The query engine then transforms the query into a series of Map-Reduce jobs. By not having to worry about the low-level coding, you become much more productive and can concentrate on data analysis.
This session, designed to get you up to speed and productive with Hive, includes several practical examples to make data analysis with Hive as concrete as possible.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data
In this session, we will review the rules that comprise PDW's distribution theory and see demonstrations of how these rules work on PDW. You will walk away with a clear understanding of the distribution rules and their impact on data distribution and query execution.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
In this session, Rob Collie will explain his six key principles – the driving factors and the differentiators that will help you navigate the road ahead of you and your organization. Surprisingly simple once you’ve heard them, they are easy to remember AND to apply. There is no “one map fits all” guide to the road ahead, but everyone will leave this session with an excellent compass.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
This session shows how Microsoft is applying data science to solve real business challenges. Through practical examples, we show how our own data scientists from the Data and Decision Sciences Group are solving challenging business problems at Microsoft with advanced analytics.
Attend this session to learn practical applications of advanced analytics to business problems, such as customer churn reduction, customer targeting, and segmentation.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
We will explore the filtering and discretization techniques used to pre-process the data, and tools for identifying patterns in the big data environment. We also address the advantages and disadvantages of our methodology, what we learned along the way, and how data visualization helped bring the results to life and make them relevant to the business.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
In this session, you will learn how to use MDX with Excel features such as sets and query tables, as well as how MDX is used in Excel cube formulas. There will be a strong practical focus, showing you examples of how you can use MDX to solve real-world problems when building Excel dashboards and reports.
Event Date: 08-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Networks are a data structure commonly found across social media services that let you create collections of connections. The Social Media Research Foundation's free, open NodeXL project makes analysis of social media networks accessible to most Excel users. With NodeXL, networks become as easy to create as pie charts.
NodeXL supports the exploration of social media with import features that pull data from Twitter, Flickr, YouTube, and email networks. Come see how this tool lets you quickly generate useful network statistics and metrics and create visualizations of network graphs.
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
We’ll start out by talking about how to use the standard gallery images to run BI workloads in IaaS, and then discuss building custom scaled-out BI infrastructures in Azure Virtual Machines. From there, we will dive into the different authentication and authorization options you might want to take advantage of – options that will work both in the cloud and on-premises, but are especially useful in a cloud-based environment.
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Big Data
What happens when the data gets REALLY big? In this session, we will review how to integrate current and new big data technologies such as Hadoop, Cassandra, and Data Grids. You will also learn about approaches to partitioning and sequencing the data to balance data availability and system performance.
In addition, you will learn how different systems can work together, key areas to address, and the right questions to ask your team to successfully implement your big data system while meeting your customers' demanding needs.
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery
Session topics include an overview of Microsoft Business Intelligence needs, an overview of PowerPivot for Excel and PowerPivot for SharePoint; a look at growing pains in PowerPivot (when differences in Tabular matter), and migrating PowerPivot to SSAS 2012 Tabular.
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
How do you make a database fit in memory if it doesn’t fit? How do you handle billions of rows with a complex calculation? Can you perform reporting in any time zone, with time intelligence, efficiently? What tools can you use to benchmark and choose the right hardware? How do you scale up performance on both small and large databases? What are the common mistakes in DAX formulas that might cause performance bottlenecks?
These are just a few questions we will answer by looking at best practices that are working for real customers. Don’t miss this session if you want to learn efficient DAX solutions and how far you can push the limits of the system.
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
Event Date: 08-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
You will get guidance on how to map business problems to these tasks and the PA toolset. You will also get an overview of how to shape data for better results and apply advanced techniques such as ensembling and online learning for highest quality predictions. A high-level case study will round out the session, highlighting how to apply PA to a customer scoring problem.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
The key takeaways from the presentation will be how to mine customer data in order to understand customers, and identifying top predictors of profitability.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
This session will provide a framework for implementing analytics in a healthcare environment, define special opportunities for impactful BI, and showcase real world examples of how Power BI is being used to by healthcare organizations globally
Attendees will come away with specific information that can be used to drive high value analytics in any healthcare setting.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
The popular belief is that a data science project will deliver a complete mathematical model describing all dependencies and interactions that have eluded experts in the field, letting us automate and optimize everything from business processes to health care. In reality, data science has its limitations. And the promised accuracy, although it has a certain allure in the scientific and financial worlds, also brings new risks and substantial unforeseen costs.
This session will examine the true value of a data analytics project in a business context, using practical examples to help you plan ahead and manage expectations.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
This session is not about introducing the cool new features; instead, it will focus on the most advanced part of Excel analytics: data mining with Excel.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
You will get a checklist you can use in your projects to ensure that the ETL processes include the capabilities a solid data integration subsystem should have. After this session, you will be better prepared to assess the reliability of ETL solutions.
Event Date: 08-05-2014 17:15 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
This session will explore promotion paths for PowerPivot models that mature to demand robust data transformations, as well as cleansing and master data procedures. You will learn the pros and cons of using cloud-based PowerPivot environments, as well as the recommended architectures for model growth.
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Big Data
Working through a grant provided by the National Science Foundation in partnership with Microsoft, a team of computer scientists at Virginia Tech addressed this challenge by developing an on-demand, cloud-computing model using Windows Azure HDInsight Service.
Join us in this session as we share our solution to storing and processing genome sequencing data using Windows Azure and Windows Azure HDInsight Service.
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
Bottom line trends at public companies, however, are a “blend” of myriad smaller trends – in Kaman’s case, 180+ business locations make up the overall result, and any fixes would need to be implemented at that level.
The first obstacle was to pinpoint the likeliest opportunities for improvement – to build a unified system of measurement that could drive potentially thousands of “micro changes” in the field while maintaining visibility at the executive level.
Traditional BI methodologies were unable to fill that need. Director of Process Management, Mike Miskell, was tapped to find alternate methods. The results are dramatic: Mike and another employee, with occasional coaching from consultant Rob Collie, built the entire required measurement framework in four short months.
Come hear the “how” and the “why” of industrial strength Excel.
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Join this fun, demo-filled session on how to use data to solve three real-world buying challenges: cars, houses, and health care. We will use precision questions, machine learning, and common tools such as Excel and T-SQL. You'll leave with practical tricks and techniques - as well as the confidence to use them - to make any choice easier using data.
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery
We will look at surfacing big data via Excel with PowerView and eventually publishing it in a SharePoint 2013 farm. We will also look at the security and performance implications of integrating big data with SharePoint 2013, so you will be able to properly design your Business Intelligence infrastructure.
Event Date: 09-05-2014 10:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Using use cases, we will "battle" these languages against each other to get a better understanding of how and where they perform the best. Join us for this demo-driven session, and get a good start on working with these three languages.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Big Data
In particular, we will discuss on how the combination of qualitative and quantitative methods can be of benefit, giving examples around social media and giving an overview of some of the areas of research we are currently focusing on at Yahoo. Within this context, we will discuss a blueprint for a framework as it applies to innovation, and discuss specific technical approaches within that framework. We will go over the importance of taking a human-centered view and highlight what are considered to be the most fundamental problems in big data from that perspective.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Join us for a discussion where we'll explore several options for visualizing the results in SQL Server Reporting Services and PowerPivot.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
Join us for an end-to-end tour of Power BI, delivered from an IT Pro perspective. We’ll cover topics from provisioning Power BI, setting up Data Management Gateway and cloud refresh of on-prem data sources, Power Query, BI Sites, Mobile BI, Data Source Management, and Data Stewardship experiences.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
This session will show all the steps that the team went through to identify key KPI’s, assess existing data infrastructure and data quality, and implement Microsoft BI solutions that were adapted to Grameen needs. This includes leveraging Power Query to extract data from open source databases and using Power Pivot and Power BI to zoom/filter, and ultimately discover insight.
We will share the actual views that Grameen is using to manage more closely their finances and preliminary information about a new dashboard and Pre/Post Natal care in Ghana.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Using analytics, we'll learn how to evaluate business changes and explore visualization techniques on communicating findings to the rest of the company.
Event Date: 09-05-2014 11:15 - Category: Breakout Session (60 minutes) - Track: Information Delivery
The techniques we will discuss are based on concepts in the books “Advanced Reporting Services 2012” and “Reporting Services Recipes.” By attending this session, you will learn enough to use the Angry Koala Cube Browser and Angry Koala Cube Surfer and modify to your own organization’s needs. Join this practical session, which will give you lots of ideas for your own users.
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
In this 1-hour session, you will learn how to "embrace the change" and accelerate your migration to the data warehouse storage engine for the Microsoft Data Platform. This session will be packed with advice and recommendations from actual customer deployments and real-world experiences. Get on board the PDW train, and transform your data warehouse with the Microsoft Big Data Analytics Appliance!
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
SQL Server Analysis Services includes the Microsoft Time Series algorithm to provide an approach to intuitive and accurate time series forecasting. The algorithm can be used in scenarios where you have a historic series of data and where you need to predict a future series of values based on more than just your gut instinct.
This session will describe how to prepare data, create and query time series data mining models, and interpret query results. Various demonstration data mining models will be created by using Visual Studio and, in self-service scenarios, by using the data mining add-ins available in Excel.
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
This session will introduce DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations. Many practical examples based on common patterns and an analysis of the query plans will show how to get the best out of DAX.
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
In this session, we will go beneath the UI and learn how to unlock the full power of the underlying query engine and the formula language. You will learn how to conquer your data and data-shaping needs.
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
In addition, we will cover real-world data preparation for model building, including outlier detection and removal, discretization, and other common machine learning techniques. You will take away practical experience with machine learning processes that you can use in common business scenarios with Microsoft software, particularly Office.
Event Date: 09-05-2014 13:30 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
In this demo-heavy session, we will do a deep dive into several more complex DAX solutions that will help you solve some common business problems like running totals, year over year comparison, sales predictions, 4-5-4 calendars, automatic time filters, and tool tables.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
In this session, we will highlight how embedding advanced analytics in decision support systems provides an opportunity for it to impact significant business decisions and create tremendous value for all types of organizations.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data
In this session, we will discuss methods for unlocking insights from big data by acquiring and enriching the data using intelligent processes that scale over distributed computing infrastructure. Enrichment leads, in turn, to new opportunities for data engagement through interactive examination of big data.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Big Data
In this session, we will look at R, the world's favorite free data analysis tool, and HDInsight, which is Microsoft's distribution of Hadoop. We will also look at an end-to-end solution to see how to discover key business strengths based on the data. We will then visualize the results in Microsoft's latest Business Intelligence toolset, Power BI.
Big data is not just about storing massive amounts of data in a common database; it is a force of change for the organization. This means we have to consider the collective capabilities of the platform to serve the business - from data source to secret sauce - to help the organization make data-driven decisions that drive the enterprise forward.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
SQL Server 2012 includes two platforms to help implement and manage MDM solutions: Master Data Services (MDS) and Data Quality Services (DQS). MDS is used to create corporate data models and allows for storage, management, and versioning of important enterprise data. DQS can be used as a companion to MDS, ensuring that new data being imported into an analysis solution is being checked and validated against the enterprise data store.
In this session, you will gain a good understanding of MDS and DQS and learn how to implement a simple solution. We will also explore a case study of how to use MDS to manage corporate data using Excel. Finally, you will see how the ETL/ELT process can use DQS and MDS to ensure that data being loaded is correct and accurate.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Combining traditional data mining with the power of Mahout in Hadoop, this session will cover the full data mining cycle from ETL and building, testing, and training data models to visualization, testing, and real-time querying. You will see how to discover patterns and make predictions, classifications, and recommendations to get all the insights from your structured and non-structured big data.
Event Date: 09-05-2014 14:45 - Category: Breakout Session (60 minutes) - Track: Analytics and Visualization
In this session, you will learn how Q&A understands questions and chooses the right visualization. With new language modeling capabilities, you can teach Q&A how to respond even better to questions over time. We will also cover tips and tricks to get the most out of Q&A and your data.
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
Minimizing the augmented error criterion requires a certain increase in accuracy to "pay" for the increase in model complexity (e.g., adding another term to the model). This session will offer a concise introduction to this topic and its application to linear regression and deep learning algorithms for neural networks.
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
You’ll also learn about the architecture of Power View and related components such as PowerPivot. If you’re eager to gain a deeper understanding of Power View, don’t miss this session!
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Information Delivery
Join this session as we bust popular myths around "impossible in SSRS" visualizations and construct them live in SSRS!
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
This session will take a look at real case studies showing how predictive models were developed for the benefit of various enterprises in the areas of event management, worker’s compensation claims, and more. Through these studies, you will learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target, selecting the appropriate data, and adapting it for maximum results.
Take a step towards making data mining pervasive in your organization by integrating predictive models into your architecture in a way that impacts the decision-making ability of everyone in your organization.
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Advanced Analysis Techniques
We’ll also discuss Polybase in depth. This session will not only discuss the technical details of the new features, but also the use cases for this technology, by examining how Polybase can help you:
• Streamline your ETL process by using Hadoop as the staging area of the backroom • Export to your Hadoop environment your Enterprise Data Warehouse conformed dimensions • Use Hadoop as a low cost, online data archive • Enrich your relational data with ambient data resident in Hadoop
Event Date: 09-05-2014 16:00 - Category: Breakout Session (60 minutes) - Track: Strategy and Architecture
We will also discuss some of the challenges that we've encountered and some of the best-practices that we have employed along the way.
If you are building out a big data analytics team at your big company, this session is for you!