Nr: 237
SQLSaturday #237 - Charlotte BI Edition 2013
SessionID: 10327
Dive into the Query Optimizer-Undocumented Insight
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Benjamin Nevarez
Title: Dive into the Query Optimizer-Undocumented Insight
Abstract:
SessionID: 10716
Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 9
Speaker: Brent Greenwood
Title: Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
Abstract:
You may not see this in the marketing materials, but the reality is PowerPivot and AS Tabular together provide some powerful options for Data Warehousing professionals. This session is for DW dimensional modeling pros interested in streamlining optimizing the design delivery process for enterprise-quality data marts dimensional semantic models.
We'll touch on Agile Lean disciplines, how they can be applied to DW solution delivery. Then we’ll walk through demos of practical applications in the form of PowerPivot POCs prototypes that can be promoted to AS Tabular models and refitted to the finished DW structures once delivered. We’ll focus on key DW challenges and how these technologies and techniques can be used to speed and improve effectiveness of requirements gathering and user testing, optimize sequencing of deliverables, minimize risk of rework and ultimately deliver quality DW solutions successfully.
SessionID: 11226
Creating Queries using Microsoft Power Query for Excel
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Cathy Miller
Title: Creating Queries using Microsoft Power Query for Excel
Abstract:
SessionID: 11253
“Indexing” Encrypted Data
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Chris Bell
Title: “Indexing” Encrypted Data
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 12909
Self-Service BI using Excel 2013
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Doug Cox
Title: Self-Service BI using Excel 2013
Abstract:
SessionID: 14494
Smart Rats Leave First
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 10
Speaker: Geoff Hiten
Title: Smart Rats Leave First
Abstract:
IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.
SessionID: 14839
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Gregory Suarez
Abstract:
Did you know that you may already have the skills you need to process BIG DATA in Hadoop? Come learn about three applications that are included in Microsoft HDInsight cluster - Pig, Hive, and Sqoop.
SessionID: 14849
Enrich your applications with SQL Server Reporting Services
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Guillermo Caicedo Santiago
Title: Enrich your applications with SQL Server Reporting Services
Abstract:
SessionID: 15572
Transitioning to a BI role
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 10
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: 15823
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16113
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jose Chinchilla
Abstract:
Change Data Capture (CDC) is one of the newest features available since SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore. On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as in ETL for Business Intelligence, Disaster Recovery, Auditing, and more.
SessionID: 16542
Data Visualisation with Hadoop Mashups, Power View and Excel 2013
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jen Stirrup
Title: Data Visualisation with Hadoop Mashups, Power View and Excel 2013
Abstract:
Join us at this session in order to see how your Big Data can empower your business users via familiar Business Intelligence tools such as Excel and Power View.
SessionID: 16686
1000 ways to die (your SSAS Server)
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Jesus Gil Velasco
Title: 1000 ways to die (your SSAS Server)
Abstract:
How can you kill your server?
Bad Practices?
Bad Queries?
This session I'll tell you about urban legends, true stories and horror stories!!
Do not miss this opportunity to learn, how you can avoid!
SessionID: 16910
From Impaired To Insightful Geospatial Reporting
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Julie Koesmarno
Title: From Impaired To Insightful Geospatial Reporting
Abstract:
It is expected that business reports be insightful and engaging. Region based reporting can be transformed from boring grids to visually interactive maps. This session will describe how to embark upon self-service and mobile BI solutions that are available within the Microsoft BI stack for analytical geospatial reporting. You will learn the basics of geographical data, including GIS, Longitude-Latitude coordinates and free form text. Using these different data types, we will discuss SSRS 2012, Power View and Excel 2013 tools that can leverage insightful analysis. Finally and most importantly, attending this talk will get you started in learning the essential techniques to deliver geospatial reports that tell meaningful stories for users.
SessionID: 16966
Tips and Tricks for Dimensional Loading
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jose L. Rivera
Title: Tips and Tricks for Dimensional Loading
Abstract:
Dimensions are an integral part of any Data Mart/Data Warehouse initiative. In this session we will cover the different techniques to load the most common types of Slow Changing Dimensions (Type 1 2) using TSQL and various SSIS design patters using native components only.
SessionID: 17202
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: John Welch
Abstract:
SessionID: 17811
Understand Evaluation Contexts in DAX
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jeffrey Wang
Title: Understand Evaluation Contexts in DAX
Abstract:
DAX is the query and programming language for future Microsoft BI solutions, yet many users found DAX hard to learn because they couldn't grasp what the "context" was. This session will turn you into a DAX expert by mastering this core concept of DAX. You will learn what row contexts and filter contexts are and how to access them. You will learn functions which create row and filter contexts. You will learn the initial contexts of a calculated column expression, a row level security expression, and a measure expression. You will learn how initial contexts are created from an MDX query. You will learn how to manipulate filter contexts using the overwrite and intersect semantics. You will see a lot of examples and learn a few DAX tricks along the way.
SessionID: 18639
Getting Started with Power Query
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Devin Knight
Title: Getting Started with Power Query
Abstract:
SessionID: 19631
DANGER: The Art and Science of Presenting
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Vaillancourt
Title: DANGER: The Art and Science of Presenting
Abstract:
Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
SessionID: 19632
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Mark Vaillancourt
Abstract:
SessionID: 20389
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Mickey Stuewe
Abstract:
SessionID: 20390
Scalable SSRS Reports Achieved Through the Powerful Tablix
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Mickey Stuewe
Title: Scalable SSRS Reports Achieved Through the Powerful Tablix
Abstract:
Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control.
In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.
SessionID: 20693
Temporary Insanity
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Michael Femenella
Title: Temporary Insanity
Abstract:
SessionID: 21373
MDS and DQS - Beyond the TLAs to Data Quality
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Neil Hambly
Title: MDS and DQS - Beyond the TLAs to Data Quality
Abstract:
Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.
High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.
SessionID: 21789
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 21816
Automating SSIS Development with Biml
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 10
Speaker: Paul Waters
Title: Automating SSIS Development with Biml
Abstract:
In this session we will start by showing the power of Biml. We will then step back, and start from the beginning of using BimlScript. Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development.
SessionID: 21948
Mastering the CUBE Functions in Excel 2013
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Peter Myers
Title: Mastering the CUBE Functions in Excel 2013
Abstract:
This session explores the seven CUBE functions that are natively available in Excel 2013. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.
The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.
This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is also applicable to Excel 2007 and Excel 2010.
SessionID: 22341
Tips Tricks for dynamic SSRS Reports
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 23026
Hadoop Part I - Launch Hadoop in just 4 clicks!
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 10
Speaker: Rick Hallihan
Title: Hadoop Part I - Launch Hadoop in just 4 clicks!
Abstract:
Introduction to Windows Azure HDInsight - In this session we will discuss Microsoft’s Hadoop offering for the cloud. We will explain which services are available, how to launch your first Hadoop cluster and start processing BIG DATA.
SessionID: 23267
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Rob Volk
Abstract:
SessionID: 24671
A Big Data Primer
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Stacia Varga
Title: A Big Data Primer
Abstract:
The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
SessionID: 24777
SQL Impossible: Restoring/Undeleting a table
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mladen Prajdić
Title: SQL Impossible: Restoring/Undeleting a table
Abstract:
Yes, you read the title right.
No, it's not about the usual "one table per partition" and "restore full backup then copy the data over" methods.
No, there are no 3rd party tools involved. Just you and your SQL Server.
Yes, it's crazy. No, it's not for production purposes. And yes, that's why it's so much fun.
Prepare to dive into the world of data pages, log records, deletes, truncates and backups and how it all works together to get your table back from the endless void.
Want to know more? Come and see!
SessionID: 24982
SSIS and Azure - ETLing in the Cloud
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 9
Speaker: MIKE DONNELLY
Title: SSIS and Azure - ETLing in the Cloud
Abstract:
A Windows Azure SQL Database can be used as a source or destination in SQL Server Integration Services and there is a good chance you'll be looking at this option soon. In this session we'll go over the basics of setting up this connection, best practices for how to load data into the cloud, and things to be aware of when Azure is your source database.
SessionID: 25376
Challenges to designing financial warehouses, lessons learnt
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Steve Simon
Title: Challenges to designing financial warehouses, lessons learnt
Abstract:
In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time.
In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
SessionID: 25670
SSIS 2012: More Than Just a Pretty UI
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Steve Wake
Title: SSIS 2012: More Than Just a Pretty UI
Abstract:
SessionID: 25770
Using PowerPivot to Drive Quality into ETL Processes
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Steve Hughes
Title: Using PowerPivot to Drive Quality into ETL Processes
Abstract:
Throughout the past year, we have effectively used PowerPivot, Data Explorer, and Power View to map, evaluate, and measure our ETL processes. In this session, you will learn how PowerPivot can be a key component in verifying data quality. You will also see how Data Explorer can help you shape data for test harnesses and test plans. Finally, you will see how Power View in Excel 2013 can be used to easily share results of ETL projects, especially during the development process.
SessionID: 26099
Best Practices for Implementing an Enterprise BI Solution
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 9
Speaker: Teo Lachev
Title: Best Practices for Implementing an Enterprise BI Solution
Abstract:
Learn best practices to make your organization a center of BI excellence. I’ll walk you through top lessons learned during our implementation of an enterprise end-to-end BI solution, which is discussed in the Records Management Firm Saves $1 Million, Gains Faster Data Access with Microsoft BI case study published by Microsoft. Working experience with the dimensional modeling and the Microsoft BI stack is assumed.
SessionID: 26516
Attributes Hierarchies in Analysis Services 2012
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Thomas LeBlanc
Title: Attributes Hierarchies in Analysis Services 2012
Abstract:
SessionID: 26601
Handling Errors and Data Anomalies in SSIS
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Mitchell
Title: Handling Errors and Data Anomalies in SSIS
Abstract:
Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure...
In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.
SessionID: 27676
Understand/Code/Debug Many-to-Many Relationships i
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Wayne Snyder
Title: Understand/Code/Debug Many-to-Many Relationships i
Abstract:
SessionID: 28171
The 20-Minute Tabular Model
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Bill Anton
Title: The 20-Minute Tabular Model
Abstract:
The Tabular model is the new kid on the block in Analysis Services 2012. Join me in this introductory-level session where we'll quickly cover the differences between Tabular and Multidimensional models before diving into Visual Studio and creating a basic tabular model.
SessionID: 8763
Inferred Dimension Members within MDS and SSIS
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Reza Rad
Title: Inferred Dimension Members within MDS and SSIS
Abstract:
Combining Master Data Services with Data Warehouses, will cause some challenges in ETL Scenarios. In this session we will go through a demo of Inferred Dimension Members implementation with SSIS considering the fact that MDS keeps the single version of truth for the dimension record.
In this session you will learn how we will write back new record's data into MDS entity as an Inferred member. The staging structure of Master Data Services and Batch Processing will be used for this. Then you will learn what is the best practice to add the inferred record into Data Warehouse dimension. Updating the existing dimension member also would consider the Inferred member and apply SCD types only if this is not an inferred Member.
SessionID: 8842
SQL Server Database Development with SSDT
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Aaron Nelson
Title: SQL Server Database Development with SSDT
Abstract:
Most importantly we’ll show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we will also highlight and demonstrate the features that have been added to SSDT in the past year.
SessionID: 9092
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Isley
Abstract:
PDW is the newest appliance offering from Microsoft. The sales person makes it sound great. Come hear how PDW is the real deal. Thinking about implementing one? We will uncover the landmines and show you how to navigate them.
PDW truly is a great product for a Data Warehouse!!!!!
SessionID: 9298
Hadoop for the Microsoft Guy
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 9
Speaker: Allan Mitchell
Title: Hadoop for the Microsoft Guy
Abstract:
This session is going to take Hadoop and break it apart. I will also look at some of the tooling Hive and Pig.
Keep an open mind and let me show you that Hadoop has lots to offer.
SessionID: 9506
Hacking the SSIS 2012 Catalog
Event Date: 19-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Andy Leonard
Title: Hacking the SSIS 2012 Catalog
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!