sqlsathistory

Nr: 647

Back to Main list

SQLSaturday #647 - Boston - BI Edition 2017

Start Time (24h)	Speaker	Track	Title
09:30:00	Jonathan Stewart	Analytics and Visualization	From problem to Power BI: A journey in data visualization
09:30:00	Melissa Coates	BI Platform Architecture, Development Administration	Tips for Getting Started with the Azure Data Platform
09:30:00	Steve Simon	BI Platform Architecture, Development Administration	Master Data Services and Rapid Application Development
09:30:00	George Walters	Analytics and Visualization	Build Your First SSAS Cube!
10:45:00	Steve Simon	Information Delivery	SQL Server Reporting Services 2016 on Steroids!!
10:45:00	David Patrick	BI Information Delivery	Microsoft and Big Data - An Overview of the Power Tools and more!
10:45:00	Edward Pollack	Analytics and Visualization	Finding Islands, Gaps, and Clusters in Complex Data
10:45:00	Adam Saxton	BI Platform Architecture, Development Administration	What's new with Power BI
12:00:00	Matt Henderson	Sponsor Session	Architecting for performance
13:00:00	Vishal Pawar	Analytics and Visualization	Power BI-Create a Dashboard from Zero to Hero
13:00:00	James Serra	Professional Development	Learning to present and becoming good at it
13:00:00	Brett Powell	BI Information Delivery	Relationship Modeling Patterns in SSAS and Power BI
13:00:00	Melody Zacharias	Strategy and Architecture	Azure Data Catalog – Turning Unused Assets into Usable Knowledge
14:15:00	Simon Cho	BI Platform Architecture, Development Administration	Build ETL efficiently (10x) with Minimal Logging
14:15:00	Thomas Grohser	Professional Development	Why candidates fail the job interview in the first minute
14:15:00	Belinda Allen	BI Platform Architecture, Development Administration	DAX 101
14:15:00	Sunil Kadimdiwan	BI Information Delivery	Power up SSRS with Power BI and other new enhancements
15:30:00	Kevin Feasel	Strategy and Architecture	Much Ado About Hadoop
15:30:00	Beth Wolfset	BI Information Delivery	Take Me to your Data - why Data Stewardship is needed NOW!
15:30:00	Yana Berkovich	Information Delivery	Give more power to the users! - Decision Support Using Power BI SP O365 data for a Small Business
15:30:00	Jack Corbett	BI Platform Architecture, Development Administration	It's All about the Rules: A Dynamic ETL Architecture

SessionID: 65216

From problem to Power BI: A journey in data visualization

Back to calendar

Event Date: 23-09-2017 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: From problem to Power BI: A journey in data visualization

Abstract:

Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

SessionID: 66956

Tips for Getting Started with the Azure Data Platform

Back to calendar

Event Date: 23-09-2017 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Tips for Getting Started with the Azure Data Platform

Abstract:

This session is packed with practical tips and lessons learned about using Azure as a database platform. You will learn the fundamentals about how Azure is structured to help you make architectural decisions. Ideas will be shared for planning resource groups, naming conventions, and the separation of Dev, Test, and Prod. We will discuss database platform options, data storage options, and why PowerShell and ARM are so important to deployment scenarios.

SessionID: 67436

Master Data Services and Rapid Application Development

Back to calendar

Event Date: 23-09-2017 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Simon

Title: Master Data Services and Rapid Application Development

Abstract:

Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.

SessionID: 68483

Build Your First SSAS Cube!

Back to calendar

Event Date: 23-09-2017 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: George Walters

Title: Build Your First SSAS Cube!

Abstract:

A new-to-SSAS data professional can build a simple tabular SSAS cube from a dataset.

We will discuss how SSAS Tabular can create a data model, and easily be surfaced as a data source for reporting.

SessionID: 62955

SQL Server Reporting Services 2016 on Steroids!!

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Information Delivery

Speaker: Steve Simon

Title: SQL Server Reporting Services 2016 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 63033

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: BI Information Delivery

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 64301

Finding Islands, Gaps, and Clusters in Complex Data

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Analytics and Visualization

Speaker: Edward Pollack

Title: Finding Islands, Gaps, and Clusters in Complex Data

Abstract:

Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!

SessionID: 65496

What's new with Power BI

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Saxton

Title: What's new with Power BI

Abstract:

A lot of changes have come to Power BI. Do you understand how Premium fits in? What is an app workspace and why would you use it? And, what the heck is a capacity? We will take a look at Premium, Apps and App Workspaces along with the changes to embedding. We will also see how Power BI Report Server fits into the picture.

SessionID: 68456

Architecting for performance

Back to calendar

Event Date: 23-09-2017 - Session time: 12:00:00 - Track: Sponsor Session

Speaker: Matt Henderson

Title: Architecting for performance

Abstract:

Successful reporting and transactional systems start with proper architectural principles and considerations. Learn how to design new database systems for optimal performance and how to discover, document and prove when performance issues are caused by the system configuration.

SessionID: 62937

Power BI-Create a Dashboard from Zero to Hero

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Vishal Pawar

Title: Power BI-Create a Dashboard from Zero to Hero

Abstract:

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips.

Learn how to create Power BI Dashboard from scratch.

SessionID: 63049

Learning to present and becoming good at it

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: Professional Development

Speaker: James Serra

Title: Learning to present and becoming good at it

Abstract:

Have you been thinking about presenting at a user group? Are you being asked to present at your work? Is learning to present one of the keys to advancing your career? Or do you just think it would be fun to present but you are too nervous to try it? Well take the first step to becoming a presenter by attending this session and I will guide you through the process of learning to present and becoming good at it. It's easier than you think! I am an introvert and was deathly afraid to speak in public. Now I love to present and it's actually my main function in my job at Microsoft. I'll share with you journey that lead me to speak at major conferences and the skills I learned along the way to become a good presenter and to get rid of the fear. You can do it!

SessionID: 64607

Relationship Modeling Patterns in SSAS and Power BI

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Brett Powell

Title: Relationship Modeling Patterns in SSAS and Power BI

Abstract:

The relationships defined in Power BI and SSAS Tabular data models directly impact both the filter context and the performance of queries. This session will briefly review the fundamentals of relationships in Power BI and SSAS Tabular models including filter propagation in classic one-to-many star schema relationships. The majority of the session, however, will cover the features and design patterns available to handle common but more complex modeling scenarios such as many-to-many, multiple granularities, counting values from dimension tables, and implementing 'virtual relationships' via DAX when physical relationships can't be created in the model.

Example models will be shared using single and bidirectional relationships as well as relationship functions such as CROSSFILTER(), USERELATIONSHIP(), and TREATAS(). Recommended practices for choosing and implementing the alternative modeling techniques will be shared along with relationship pitfalls to avoid.

SessionID: 68379

Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: Strategy and Architecture

Speaker: Melody Zacharias

Title: Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Abstract:

Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community. This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization. The reason for this is simple: We live in the information age. Being able to leverage the data you gather is the invitation you need just to compete in information age.

ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.

SessionID: 62922

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

Event Date: 23-09-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Cho

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract:

This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

SessionID: 63002

Why candidates fail the job interview in the first minute

Back to calendar

Event Date: 23-09-2017 - Session time: 14:15:00 - Track: Professional Development

Speaker: Thomas Grohser

Title: Why candidates fail the job interview in the first minute

Abstract:

In the last two decades Thomas always had more open positions than I could fill, not because of lack of applicants, I must have interviewed close to 300 people for DBA, database developer, data architect, data modeling and other data related positions. Come to this highly interactive session to learn why 99% of the candidates failed the simplest questions and disqualified them self.

Thomas will share what he misses in resumes and how to respond to questions better.

SessionID: 64413

DAX 101

Back to calendar

Event Date: 23-09-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Belinda Allen

Title: DAX 101

Abstract:

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. We will introduce you to the concept of calculated columns, measures and basic data modeling, with some practical examples you will reproduce on your machine. This introduction will cover basic calculations and an overview of all the scalar and table functions.

SessionID: 64493

Power up SSRS with Power BI and other new enhancements

Back to calendar

Event Date: 23-09-2017 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Sunil Kadimdiwan

Title: Power up SSRS with Power BI and other new enhancements

Abstract:

SSRS 2016 provides a modern, on-premises solution for enterprise reporting and mobile business intelligence.

Will start off by demonstrating recent technical previews that support hosting Power BI reports (.PBIX) in SSRS.

Then also review and demonstrate the new Mobile Reports, KPIs and Paginated reports. The new Mobile Report publisher produces stunning dashboards that can be viewed on any device (iOS, Android and Windows). Other enhancements include, parameters can now be positioned across more than two columns and custom branding your SSRS portal's with your choice of colors and logo.

SessionID: 63436

Much Ado About Hadoop

Back to calendar

Event Date: 23-09-2017 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform. We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more. We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.

SessionID: 63835

Take Me to your Data - why Data Stewardship is needed NOW!

Back to calendar

Event Date: 23-09-2017 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Beth Wolfset

Title: Take Me to your Data - why Data Stewardship is needed NOW!

Abstract:

You've heard the buzz words. Stewardship. Governance. But what does it all mean? Learn from an individual that has successfully formed and co-chaired Data Governance teams at multiple companies. I will cover how to sell Data Stewardship to the management, composition of a team, and the activities to perform in order to prevent a Data Information Disaster. In a world where the data architecture is comprised of multiple DBs and business users have direct access, data stewardship is needed NOW.

SessionID: 64003

Give more power to the users! - Decision Support Using Power BI SP O365 data for a Small Business

Back to calendar

Event Date: 23-09-2017 - Session time: 15:30:00 - Track: Information Delivery

Speaker: Yana Berkovich

Title: Give more power to the users! - Decision Support Using Power BI SP O365 data for a Small Business

Abstract:

Power BI provides analytics solutions for your whole organization. Small Businesses can profit by exposing their data, and see the impact in their clients sites. I will introduce "Oil test Systems" a small business that tests oil in trucks. It's clients portal and the test data as other insights and recommendations, can be viewed by the clients using SharePoint 365. Performance dashboards are displayed using PowerBI, giving the business the opportunity for efficient decision making. The demo was built without code, every ITPro can do it!.

SessionID: 66443

It's All about the Rules: A Dynamic ETL Architecture

Back to calendar

Event Date: 23-09-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jack Corbett

Title: It's All about the Rules: A Dynamic ETL Architecture

Abstract:

You are provided with requirements for an ETL Process that has hundreds of rules that need to be applied and you code them all and during testing some rules change and more are added requiring you to modify SSIS packages taking hours of your time and there is no simple method to isolate testing the changed and new rules costing even more time. In this session we will go over how we addressed this situation with a rules-based architecture, where rules are defined in a database and read and executed from SSIS.

This site is open source. Improve this page.