sqlpasshistory

ID: 556

PASS BA Marathon 2

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
10-12-2015 15:00	Chris Webb	Breakout Session (60 minutes)	Discover & Integrate	Create Amazing 3D Topographic Maps In Excel
10-12-2015 16:00	Ken Raetz	Breakout Session (60 minutes)	Discover & Integrate	Modular Data Extraction and Integration Patterns
10-12-2015 17:00	Jordan Goldmeier	Breakout Session (60 minutes)	Discover & Integrate	Creating Outstanding Spreadsheet Models
10-12-2015 18:00	Ginger Grant	Breakout Session (60 minutes)	Communicate & Lead	Implementing Data based Decision Making
10-12-2015 19:00	Mark Wilcock	Breakout Session (60 minutes)	Analyze & Interpret	Tools For Exploratory Data Analysis
10-12-2015 20:00	Matt Allington	Breakout Session (60 minutes)	Discover & Integrate	Moving From Excel to PowerBI.com (a Business Analyst's perspective)
10-12-2015 21:00	Rick Grantham	Breakout Session (60 minutes)	Visualize & Inform	Making Informed Decisions: Guidelines for Creating an Effective Dashboard

SessionID: 42001

Create Amazing 3D Topographic Maps In Excel

Back to calendar

Event Date: 10-12-2015 15:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate

Speaker(s): Chris Webb

Title: Create Amazing 3D Topographic Maps In Excel

Description:

Before you read on, watch this video: https://youtu.be/IcfBujIokqY. In this session you’ll learn how to create amazing 3D topographic maps like the one in the video, and along the way learn a lot of advanced Power Query, Power Pivot, and Power Map tips and tricks.

You’ll discover how: • the source data was generated and where to download it • to transform the data (a non-standard text file format) using Power Query and M code, and load it into Power Pivot • to display the data in Power Map using a custom map, make it look as good as possible and create an animated tour.

SessionID: 42002

Modular Data Extraction and Integration Patterns

Back to calendar

Event Date: 10-12-2015 16:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate

Speaker(s): Ken Raetz

Title: Modular Data Extraction and Integration Patterns

Description:

Engineers and programmers alike have known for many years that when working with complex systems, you must “divide and conquer” to solve problems efficiently and effectively. This pattern of modularizing application code is a fundamental principle of structured programming and system design, and creates reusability and elegance in applications.

With some adaptation, these same techniques can be applied to data integration and analytics solutions with great success. This webinar will show you how to achieve the same great efficiencies and reusability while solving your analytics problems.

Learn the techniques used by information technology professionals! You will also see demos in Excel with Power Query, PowerBI.com, and SQL.

SessionID: 42003

Creating Outstanding Spreadsheet Models

Back to calendar

Event Date: 10-12-2015 17:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate

Speaker(s): Jordan Goldmeier

Title: Creating Outstanding Spreadsheet Models

Description:

This is an hour-long discussion on creating outstanding spreadsheet models in which I propose three conceptual points to optimize: layout and design, code and formulas, and presentation. I will go through each topic and provide you with directives to build better spreadsheet models. Most importantly, you will develop the tools and confidence necessary to apply these principles across spreadsheet models in all fields.

SessionID: 42004

Implementing Data based Decision Making

Back to calendar

Event Date: 10-12-2015 18:00 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead

Speaker(s): Ginger Grant

Title: Implementing Data based Decision Making

Description:

Self-Service BI tools have made it easier than ever to move data analysis out of the realm of IT staff and into the hands of business users. To improve the ability of business users to gain insight, a better model would be to have the data team do what they know best: build a model and let the analyst use that model to derive answers to questions with data. Using Power BI, this webinar will define the tasks involved in developing the framework, documentation, and training needed to go from getting data from applications, to analyzing the data to provide meaningful direction, including how the business is doing now and identifying future trends and forecasts.

SessionID: 42005

Tools For Exploratory Data Analysis

Back to calendar

Event Date: 10-12-2015 19:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret

Speaker(s): Mark Wilcock

Title: Tools For Exploratory Data Analysis

Description:

The first thing we need to do with a new set of data is to explore it. We want to get an idea of the usefulness, relevance, completeness, and quality of the data for our purposes and to explore patterns, trends, and outliers to gain some insight.

In this session we’ll explore a public dataset, the Titanic passenger list. Most people know the tragic event: The RMS Titanic sailed from Southampton on April 10, 1912, hit an iceberg in the Atlantic four days later and sank. Of the 2000 people on board, only 700 survived.

We'll build some rough and ready visualisations and crunch some basic statistics on this dataset using four different tools: Excel and Power Query, Power BI Desktop, R, and Azure Machine Learning. The purpose of the session is to introduce you to some tools that you may not be familiar with so that you can decide which tools you prefer to use to explore your data.

SessionID: 42006

Moving From Excel to PowerBI.com (a Business Analyst's perspective)

Back to calendar

Event Date: 10-12-2015 20:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate

Speaker(s): Matt Allington

Title: Moving From Excel to PowerBI.com (a Business Analyst's perspective)

Description:

PowerBI.com is a new and exciting BI platform from Microsoft that became generally available in July 2015. The product is on a rapid development cycle with new capabilities being released every month. Any Business Analyst that uses Excel for analytics and reporting can get value from PowerBI.com, but may find it difficult to get started. This session covers the types of Excel reporting that are ideal to be migrated to Power BI and provides a path for Excel Business Analysts to start their PowerBI.com journey.

SessionID: 42007

Making Informed Decisions: Guidelines for Creating an Effective Dashboard

Back to calendar

Event Date: 10-12-2015 21:00 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform

Speaker(s): Rick Grantham

Title: Making Informed Decisions: Guidelines for Creating an Effective Dashboard

Description:

This session will provide guidelines for developing a dashboard that helps your organization make better-informed decisions. By attending this session, you will:

• determine the best ways to scope your dashboard project, including tips for gathering requirements and eliciting feedback

• see what’s required to build an effective dashboard, from documenting query mockups to creating dashboard prototypes.

I will go through every step of the requirements gathering process and provide the audience with live demonstrations at every step, including real-life examples of how to best scope your dashboard.

After this webinar, you will know when you should (and when you should not) start your KPIs with your company’s annual report. You will be armed with the most efficient process to create the most effective dashboards.