sqlpasshistory

ID: 33

24 Hours of PASS: Business Analytics 2014

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
05-02-2014 16:00	Peter Myers	24 Hours of PASS (60 minutes)	Analytics and Visualization	End-to-End Power BI
05-02-2014 17:00	Mark Tabladillo, Artus Krohn-Grimberghe	24 Hours of PASS (60 minutes)	Advanced Analysis Techniques	Predictive Analytics for Absolute Beginners
05-02-2014 18:00	Mark Whitehorn	24 Hours of PASS (60 minutes)	Analytics and Visualization	Adding Valuable Techniques to your Data Science Toolbox
05-02-2014 19:00	Stacia Varga	24 Hours of PASS (60 minutes)	Big Data	Has Big Data Killed the EDW?
05-02-2014 20:00	Dejan Sarka	24 Hours of PASS (60 minutes)	Advanced Analysis Techniques	Advanced Analytics in Excel 2013
05-02-2014 21:00	Marco Russo	24 Hours of PASS (60 minutes)	Advanced Analysis Techniques	Introduction to Querying in DAX
05-02-2014 22:00	Karen Lopez, Joseph D'Antoni, Stacia Varga, Lynn Langit	24 Hours of PASS (60 minutes)	Strategy and Architecture	Panel: Myths, Misunderstandings, and Successes in Data Analytics
05-02-2014 23:00	Chris Webb	24 Hours of PASS (60 minutes)	Analytics and Visualization	Power Query: Beyond the Basics
06-02-2014 00:00	Lynn Langit	24 Hours of PASS (60 minutes)	Analytics and Visualization	Small Big Data - Phase 0 - Data Hygiene
06-02-2014 01:00	Jason Thomas	24 Hours of PASS (60 minutes)	Information Delivery	DataViz You Thought You Could NOT Do with SSRS
06-02-2014 02:00	Jason Strate	24 Hours of PASS (60 minutes)	Big Data	Implementation and Design on the Parallel Data Warehouse
06-02-2014 03:00	Carlos Bossy	24 Hours of PASS (60 minutes)	Advanced Analysis Techniques	An Introduction to Predictive Modeling

SessionID: 5905

End-to-End Power BI

Back to calendar

Event Date: 05-02-2014 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analytics and Visualization

Speaker(s): Peter Myers

Title: End-to-End Power BI

Description:

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 named 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. This session has been designed to provide perspective across the Power BI story.

SessionID: 5903

Predictive Analytics for Absolute Beginners

Back to calendar

Event Date: 05-02-2014 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analysis Techniques

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

Title: Predictive Analytics for Absolute Beginners

Description:

In this one-hour preview presentation, we cover the main motivation for learning something about predictive analytics. We will show some of the Microsoft technology which will be in the Pre-Conference session on May 7. We also will be answering any questions you may have. This session and the Pre-Conference session are for absolute beginners.

SessionID: 5913

Adding Valuable Techniques to your Data Science Toolbox

Back to calendar

Event Date: 05-02-2014 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analytics and Visualization

Speaker(s): Mark Whitehorn

Title: Adding Valuable Techniques to your Data Science Toolbox

Description:

Data Science requires us to see and understand complex patterns in data, so we use techniques like data mining to uncover them. There are other, less well-known but equally useful techniques and methodologies that we can add to our toolbox.

I’ll be covering a range of these in the full day, Pre-Conference, session that I am giving at The PASS Business Analytics Conference and I’ll use this one hour session to introduce you to a couple of my favorites. It is worth stressing that I love these techniques, not just because they are fascinating in their own rights but because I have found them immensely useful in my work of turning masses of data into useful information.

This session will NOT include any heavy (or, indeed, light!) mathematics; it is focused on how an understanding of these techniques can be of real benefit in your day-to-day work.

SessionID: 5915

Has Big Data Killed the EDW?

Back to calendar

Event Date: 05-02-2014 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data

Speaker(s): Stacia Varga

Title: Has Big Data Killed the EDW?

Description:

Big Data technologies have given us the ability to process massive amounts of data at a low cost, and yet the Enterprise Data Warehouse (EDW) still plays a key role in most corporate IT shops. Is it time for EDWs to transition? Or is the future of EDW doomed because we now need to solve different problems? This session will answer your questions about the future of EDW.

SessionID: 5914

Advanced Analytics in Excel 2013

Back to calendar

Event Date: 05-02-2014 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analysis Techniques

Speaker(s): Dejan Sarka

Title: Advanced Analytics in Excel 2013

Description:

Excel is “the” analytical tool in Microsoft’s suite for advanced analysts. Of course, you know that Excel 2013 includes PowerPivot and Power View add-ins out of the box. You also may have heard that you can use Big Data and Azure DataMarket data in Excel and that you can mash up data from different sources. However, you probably don’t know how to use PowerPivot data for data mining, how to combine Big Data with PowerPivot data, how to use data mining models in PowerPivot, or how to mash up data when you don’t have common identification.

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.

SessionID: 5916

Introduction to Querying in DAX

Back to calendar

Event Date: 05-02-2014 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analysis Techniques

Speaker(s): Marco Russo

Title: Introduction to Querying in DAX

Description:

The DAX (Data Analysis Expressions) language can be used to query a Tabular and PowerPivot data model. This session will introduce the syntax of DAX queries and will show several scenarios in which you can use DAX as a query language, such as Excel and Reporting Services, as well as creating a quick prototyping environment for new DAX measures in your model.

There will be many practical demos where you will learn which tools you can use to write and format the DAX formulas and queries, including SQL Server Management Studio, DAX Studio, and DAX Formatter. At the end of the session, you will have the right pointers to start writing your own DAX queries.

SessionID: 5909

Panel: Myths, Misunderstandings, and Successes in Data Analytics

Back to calendar

Event Date: 05-02-2014 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Strategy and Architecture

Speaker(s): Karen Lopez, Joseph D'Antoni, Stacia Varga, Lynn Langit

Title: Panel: Myths, Misunderstandings, and Successes in Data Analytics

Description:

Big Data, Business Analytics, Data Analytics, NoSQL, Relational . . . do we even agree on what we mean by those terms? In this panel session, industry thought leaders will discuss and debate the most common myths, truths, and mostly-truths of new and traditional approaches for enterprise data management and analytics

SessionID: 5908

Power Query: Beyond the Basics

Back to calendar

Event Date: 05-02-2014 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analytics and Visualization

Speaker(s): Chris Webb

Title: Power Query: Beyond the Basics

Description:

You already know that you can accomplish a lot within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require some knowledge of advanced functionality, including the M language. This session will examine what these requirements might be, how to implement them, and how best to deploy them to end users. We will cover how to create common types of calculations in M, how to best use functions, calling to web services, and OData data sources, and more. We will also discuss the best way to use Power Query with the rest of the Power BI stack, especially PowerPivot. <div> </div><div>** We apologize for an audio issue for this recording between 27:00 – 30:00</div>

SessionID: 5904

Small Big Data - Phase 0 - Data Hygiene

Back to calendar

Event Date: 06-02-2014 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analytics and Visualization

Speaker(s): Lynn Langit

Title: Small Big Data - Phase 0 - Data Hygiene

Description:

In this talk, we will talk about the starting point for every Big Data project - getting your current (data) house in order. Drawing from real-world experience, Lynn Langit will discuss patterns, tools, and techniques for improving data hygiene with SQL Server. These will include use of SSDT, 3rd party tools, such as D&B and Melissa Data, and more.

Learn how to get ready for Big Data with practical tips from this session.

SessionID: 5907

DataViz You Thought You Could NOT Do with SSRS

Back to calendar

Event Date: 06-02-2014 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Information Delivery

Speaker(s): Jason Thomas

Title: DataViz You Thought You Could NOT Do with SSRS

Description:

Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around "impossible in SSRS" visualizations and construct them live in SSRS!

SessionID: 5906

Implementation and Design on the Parallel Data Warehouse

Back to calendar

Event Date: 06-02-2014 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data

Speaker(s): Jason Strate

Title: Implementation and Design on the Parallel Data Warehouse

Description:

If you need to design a data warehouse that scales for today and into the future, then you need to know about Microsoft's Parallel Data Warehouse (PDW). In this preview session, we will review the architecture of PDW with an emphasis on what makes PDW the solution of choice for data warehouses.

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.

SessionID: 5917

An Introduction to Predictive Modeling

Back to calendar

Event Date: 06-02-2014 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analysis Techniques

Speaker(s): Carlos Bossy

Title: An Introduction to Predictive Modeling

Description:

This session will show you how to solve a real-world data mining problem by demonstrating the entire development life cycle of a predictive model. You will learn the essentials required to harness the power of a decision tree algorithm to develop and optimize a production-ready predictive model. You will also see how to iterate through the process to improve the model’s effectiveness. Then you will learn how to make the most of a predictive model by seeing how to deploy it and use in your applications and reports