Nr: 437
SQLSaturday #437 - Boston - BI Edition 2015
SessionID: 36857
SQL Server Compression - Getting More Out of Less
Event Date: 17-10-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Michael Nowill
Title: SQL Server Compression - Getting More Out of Less
Abstract:
SessionID: 39766
100 Times Faster: Experiences making SQL Server go fast
Event Date: 17-10-2015 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Andrew Novick
Title: 100 Times Faster: Experiences making SQL Server go fast
Abstract:
When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”. Sometimes there’s a better algorithm. Sometimes a different technology is more appropriate. Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster.
This presentation is illustrated with examples from my work and we'll look for common threads that might help us all.
SessionID: 40058
Unleashing SSIS with expressions, configurable properties, and parameters
Event Date: 17-10-2015 - Session time: 09:45:00 - Track: Strategy and Architecture
Speaker: Daniel Bowlin
Title: Unleashing SSIS with expressions, configurable properties, and parameters
Abstract:
Have you struggled to build SSIS packages? You are starting to get the hang of it, but many things more than basic data movement remain a frustrating challenge. The SSIS expression language is an incredible source of power within SSIS but a profound challenge to many. Another area of power and flexibility in SSIS is its very broadly scoped configurability. This presentation will walk through the basics of the SSIS expression language including the whys and wherefores of a few expression peculiarities. Then we will review how you can use those expressions to configure so many of the properties in SSIS that you might barely recognize what your package can do when you are finished. Finally we will review input parameters and how to further influence the behavior of your packages at run time. Download includes slide deck, expression samples, and some packages.
SessionID: 40073
Event Date: 17-10-2015 - Session time: 09:45:00 - Track: BI Information Delivery
Speaker: Tim Mitchell
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
SessionID: 40136
You Can Still Analyze Data with T-SQL ... No Really
Event Date: 17-10-2015 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Steve Hughes
Title: You Can Still Analyze Data with T-SQL ... No Really
Abstract:
SessionID: 37271
Building a Big Data Solution
Event Date: 17-10-2015 - Session time: 11:00:00 - Track: Strategy and Architecture
Speaker: James Serra
Title: Building a Big Data Solution
Abstract:
As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases. We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built. We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data. We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices. You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in. The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data. You will need guidance on the best solution for your data warehouse going forward. This presentation will help to give you that guidance!
SessionID: 38459
The future of the data professional
Event Date: 17-10-2015 - Session time: 11:00:00 - Track: Professional Development
Speaker: Adam Jorgensen
Title: The future of the data professional
Abstract:
The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA's, BI Developers, and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path. I will go through the updated landscape and decisions facing data professionals today and help you chart a course to make sure your plans are right for you and your organization.
SessionID: 39945
Extending Your Data Warehouse With PolyBase and Hadoop
Event Date: 17-10-2015 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jason Strate
Title: Extending Your Data Warehouse With PolyBase and Hadoop
Abstract:
• Extend your data warehouse to Hadoop and the Azure cloud
• Save of costs and efforts when archiving data warehouse data
• Leverage new technologies with existing solutions
SessionID: 40075
Introduction to Biml
Event Date: 17-10-2015 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Tim Mitchell
Title: Introduction to Biml
Abstract:
In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
SessionID: 40286
Advanced SQL Server Analysis Services
Event Date: 17-10-2015 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Kevin Goff
Title: Advanced SQL Server Analysis Services
Abstract:
This session will go well beyond creating SSAS cubes with the cube wizard. I'll cover topics such as the pros and cons of ROLAP, XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code, Advanced MDX in SSRS, Partitioning and Aggregations, Data Driven KPIs, and Dimension Attribute Discretization.
SessionID: 37985
Managing Copy Data for BI
Event Date: 17-10-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Paresh Motiwala
Title: Managing Copy Data for BI
Abstract:
As BI professionals we are straddled with multiple issues pertaining to Copy Data.
We will discuss what 'Copy Data' is along with various terminologies that go with it.
The common issues are:
- Space
- Network Bandwidth
- Time
- Security
- Obfuscation/Masking
- Which Server does this go to?
- Onward protection of Copy Data
In this session we will study the issues above and see how we can avoid these issues. We will examine what technologies/products are available that help us mitigate such a massive problem.
SessionID: 38460
Delivering Agile Analytics with Azure Machine Learning
Event Date: 17-10-2015 - Session time: 13:15:00 - Track: Advanced Analysis Techniques
Speaker: Adam Jorgensen
Title: Delivering Agile Analytics with Azure Machine Learning
Abstract:
SessionID: 39268
Processing Temporal Telemetry Data -aka- Storing BigData in a Small Space
Event Date: 17-10-2015 - Session time: 13:15:00 - Track: Analytics and Visualization
Speaker: Thomas Grohser
Title: Processing Temporal Telemetry Data -aka- Storing BigData in a Small Space
Abstract:
The know how of this session can be applied to all data that is collected over time and needs to be very precise for a few months and than can be aggregated into a more trend like data.
Schema, ETL, Aggregation, Querying and grooming will be covered.
SessionID: 39319
Create a Power BI Dashboard in 90 Minutes or LESS
Event Date: 17-10-2015 - Session time: 13:15:00 - Track: BI Information Delivery
Speaker: Todd Chittenden
Title: Create a Power BI Dashboard in 90 Minutes or LESS
Abstract:
Power BI is quickly outpacing Excel as the one tool needed for self-service Business Intelligence. In this session we'll walk through Microsoft's exciting new Power BI SaaS offering, creating some Reports and Dashboards along the way. We'll explore some of the ready-made content packs for major SaaS providers such as Salesforce or Google Analytics, then create our own based on an Azure SQL Database. Next, we'll explore Power BI Desktop, a powerful new tool for creating advanced analytic data models and authoring reports using familiar experiences from the best of Excel's BI components. Finally, we'll deploy the reports to Power BI, extend and share our Dashboard, and configure Automatic Data Refresh. All inside 90 minutes! Don't miss this session on the cutting edge of Microsoft's self-service Business Intelligence offering.
SessionID: 40287
T-SQL for Application Developers - Attendees chose
Event Date: 17-10-2015 - Session time: 13:15:00 - Track: Application Database Development
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 30 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 30 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 36684
Big Data querying with HDInsight and Hadoop with Excel
Event Date: 17-10-2015 - Session time: 14:30:00 - Track: BI Information Delivery
Speaker: George Walters
Title: Big Data querying with HDInsight and Hadoop with Excel
Abstract:
More and more companies are tackling big data to gain business insight. In this presentation, we will learn how to process Big Data in Azure using HDInsight, Microsoft's implementation of Hadoop. It is oriented towards non-traditional data querying. We will go through how to set up an HDInsight cluster, load data, query it, and then use Power Query to pull the data into Excel for visualization. If you've been wondering what all the Big Data hype is about or how you can solve it with the Microsoft stack, this is the presentation for you.
SessionID: 36768
SSIS 2012/2014: The Quiet Revolution
Event Date: 17-10-2015 - Session time: 14:30:00 - Track: Application Database Development
Speaker: Bryan Cafferky
Title: SSIS 2012/2014: The Quiet Revolution
Abstract:
SessionID: 36918
Scratching the Surface: Designing your first Power View Report
Event Date: 17-10-2015 - Session time: 14:30:00 - Track: Self Service BI
Speaker: Chris Seferlis
Title: Scratching the Surface: Designing your first Power View Report
Abstract:
Dashboards have quickly become a cornerstone for decision-making by managers and business leaders in all facets of corporate operations. Microsoft Power View has enabled drastic improvements in the development of dynamic and interactive dashboards within the Microsoft SQL Stack. In this session, we will cover areas such as: Data Considerations; Deployment Options; Building your first report; and using some of the interactive features of Power View.
SessionID: 38356
Leadership Without Borders: Working with Global Teams
Event Date: 17-10-2015 - Session time: 14:30:00 - Track: Professional Development
Speaker: Mike Hillwig
Title: Leadership Without Borders: Working with Global Teams
Abstract:
As companies become more global, IT teams need to adapt. This often means having resources in locations outside our home countries as well as hiring outside parties for staff augmentation. As we place people in locations outside our own walls, processes and practices need to keep up with this shift.
Whether your people are in Boston, Berlin, Bangalore, or Beijing, they all need to work together. We look at the challenges of having a globally diverse team, including collaboration, feedback, work assignments, and performance evaluations. We also look at outsourcing, offshoring, and a combination of the two. And we look at one of the greatest benefits: follow-the-sun support.
In this session, we demonstrate how a language barrier isn't usually the biggest challenge and how cultural differences make the most impact.
SessionID: 38990
Handling Data Error in a Data Flow
Event Date: 17-10-2015 - Session time: 14:30:00 - Track: Strategy and Architecture
Speaker: Jack Corbett
Title: Handling Data Error in a Data Flow
Abstract:
Prerequisites:
Experience developing SSIS packages
T-SQL Experience
Basic .NET knowledge
SessionID: 36557
SQL Server Reporting Services 2014 on Steroids!!
Event Date: 17-10-2015 - Session time: 15:45:00 - Track: BI Information Delivery
Speaker: Steve Simon
Title: SQL Server Reporting Services 2014 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: 37276
Transitioning to a BI role
Event Date: 17-10-2015 - Session time: 15:45:00 - Track: Professional Development
Speaker: James Serra
Title: Transitioning to a BI role
Abstract:
Business Intelligence is an extremely hot career. If you are a DBA or have another IT position, how can you transition to a BI role? I will describe what exactly BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. Then I will delve into the steps to take to become a BI expert and how I made the transition, going from a salaried DBA to a high-in-demand and high-income BI consultant. If I can go from a complete unknown to building a personal brand that allowed me to present at the PASS Business Analytics conference in just two years, so can you!
SessionID: 37722
Self-Service ETL with Power Query
Event Date: 17-10-2015 - Session time: 15:45:00 - Track: Self Service BI
Speaker: Dan Clark
Title: Self-Service ETL with Power Query
Abstract:
SessionID: 38010
Dashboards, KPIs and Maps for any Device
Event Date: 17-10-2015 - Session time: 15:45:00 - Track: BI Information Delivery
Speaker: Sunil Kadimdiwan
Title: Dashboards, KPIs and Maps for any Device
Abstract:
Would you like to design and publish stunning, interactive and easy to use Dashboards, KPIs and Maps? Do it once? View and interact with them on any device; laptop, tablet and phone running iOS, Android or Windows? This is possible using Datazen technology, one of the newest additions to Microsoft Business Intelligence offerings.
In this session come to learn the power and ease of how you can make this possible.
SessionID: 39947
Azure SQL Data Warehouse Overview
Event Date: 17-10-2015 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jason Strate
Title: Azure SQL Data Warehouse Overview
Abstract:
• Scale from terabytes to petabytes
• Save on costs through on-demand scale
• Take advantage of architecture designed for scalable performance
• Gain a cloud integrated data warehouse solution