sqlsathistory

Nr: 578

Back to Main list

SQLSaturday #578 - Atlanta - BI Edition 2016

Start Time (24h) Speaker Track Title
09:00:00 Scott Currie BI Platform Architecture, Development Administration Create and Load a Staging Environment from Scratch in an Hour with Biml
09:00:00 Julie Smith Cloud Application Development Deployment Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.
09:00:00 Jason Thomas PowerBI Data Storytelling Using Power BI
09:00:00 Melissa Coates BI Platform Architecture, Development Administration Good Habits of a DW/BI Developer
09:00:00 John Deardurff Professional Development How to get Microsoft Certified
09:00:00 Teo Lachev PowerBI Embed Interactive Reports in Your Apps
10:30:00 Sean Werick BI Platform Architecture, Development Administration SQL Server 2016 and PolyBase
10:30:00 Andy Leonard BI Platform Architecture, Development Administration Use Biml to Automate SSIS Design Patterns
10:30:00 Kiran Math Analytics and Visualization Extract, Transform And Load - Using R
10:30:00 Melody Zacharias BI Information Delivery Introduction to Microsoft Analytics – Turning Data into Intelligent Action
10:30:00 Javier Guillen PowerBI Deploying Power BI: A Blueprint for implementation success
10:30:00 Mark Tabladillo Advanced Analysis Techniques Microsoft Technologies for Data Science
10:30:00 Patrick LeBlanc BI Platform Architecture, Development Administration Zero to Tabular
11:45:00 Scott Currie Other BimlFlex: A Flexible, Extensible, and Completely Customizable Data Warehouse Framework
12:45:00 Vishal Pawar PowerBI Power BI-Create a Dashboard from Zero to Hero
12:45:00 Robert Cain Analytics and Visualization Zero to Hero with SSRS 2016 Mobile Report Publisher
12:45:00 Jonathan Buller Enterprise Database Administration Deployment Tips and Tricks for the SSIS Catalog
12:45:00 Ryan Wade PowerBI A Gentle Introduction to R for Power BI
12:45:00 Scott Currie BI Platform Architecture, Development Administration Are You Making False Assumptions about Your Data?
12:45:00 Jana Sattainathan Application Database Development Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins
14:15:00 Jonathan Stewart BI Platform Architecture, Development Administration An introduction to the magical world of BIML!
14:15:00 Ryan Wade BI Platform Architecture, Development Administration Why “R” you not leveraging the power of “R” in Power BI?
14:15:00 Kevin Wilkie BI Platform Architecture, Development Administration Learning R And Talking About Football
14:15:00 Chadwick Smith Enterprise Database Administration Deployment RAID??!!
14:15:00 Austin Senseman Advanced Analysis Techniques The 20% of DAX That Gets You 80% of the Way There
14:15:00 Patrick LeBlanc PowerBI Power BI: Data Refresh and On-Premises Connectivity
14:15:00 Chris Hyde Advanced Analysis Techniques SQL Server R Services in SQL 2016
15:45:00 Jonathan Stewart Analytics and Visualization Data Visualization: How to truly tell a great story!
15:45:00 Matt Martin BI Information Delivery Unlock the Power of the SSISDB for Dynamic Package Runtime
15:45:00 Pritesh Ostwal PowerBI Embed Power BI within your Web Application
15:45:00 Scott Currie BI Platform Architecture, Development Administration Incrementally Moving to the Cloud Using Biml
15:45:00 Ed Watson BI Platform Architecture, Development Administration Introduction to SQL Server Integration Services
15:45:00 Tim Radney Enterprise Database Administration Deployment Azure SQL Database for the Production DBA
15:45:00 Shabnam Watson BI Platform Architecture, Development Administration Advanced MDX scripting: Scope statements and Time Intelligence

SessionID: 54984

Create and Load a Staging Environment from Scratch in an Hour with Biml

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Currie

Title: Create and Load a Staging Environment from Scratch in an Hour with Biml

Abstract:

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie from Varigence will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

SessionID: 54990

Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Julie Smith

Title: Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Abstract:

How much Azure can you Azure? How many cloud can you cloud? Hear the lessons learned from an attempt at an “All Azure” BI Project. We’ll explore Azure SQL Database, Azure Data Factory and Power BI as pieces of the solution and learn where On Prem had to be used to fill in the gaps in the solution.

SessionID: 55036

Data Storytelling Using Power BI

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: PowerBI

Speaker: Jason Thomas

Title: Data Storytelling Using Power BI

Abstract:

In today's world, data is omnipresent and most organizations are presented with billions of data points every morning. Good analysis parses these numerical outputs into an understanding of the organization or process. In short, it “humanizes” the data by turning raw numbers into a story about the performance. The challenge is to interpret these stories correctly and for that, we need the help of data visualization tools like Microsoft Power BI.

Join me as I take you through on how to utilize Power BI effectively to tell data stories and engage your audience. Watch and learn some of the top techniques and hacks on making aesthetic as well as relevant Power BI reports for effective storytelling. Also, watch out for some engaging examples of storytelling using Power BI (which also includes the winning report of the Microsoft Power BI Best Report contest!)

SessionID: 55038

Good Habits of a DW/BI Developer

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Good Habits of a DW/BI Developer

Abstract:

In this session we will review sensible techniques that make a big difference in your data warehousing, business intelligence, and analytics environments. Lessons learned and strategies from prior projects will be shared. Attendee participation is encouraged as we discuss design principles, conventions, and reusability while dealing with infrastructure which grows increasingly complex.

SessionID: 56236

How to get Microsoft Certified

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: Professional Development

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

SessionID: 56237

Embed Interactive Reports in Your Apps

Back to calendar

Event Date: 10-12-2016 - Session time: 09:00:00 - Track: PowerBI

Speaker: Teo Lachev

Title: Embed Interactive Reports in Your Apps

Abstract:

You have the app. You have the data. What if your app could put the power of analytics everywhere decisions are made and allow your customers to gain insights? Modern apps with data visualizations built-in have the power to inform decisions in context—for any user and on any device. Join us to discover how you can embed data analytics in any app and on one device powered by Azure and Power BI Embedded. Learn how to:

SessionID: 54082

SQL Server 2016 and PolyBase

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sean Werick

Title: SQL Server 2016 and PolyBase

Abstract:

This session will focus on the brand new SQL Server 2016 feature called PolyBase. PolyBase#160;is a technology that accesses and combines both non-relational and relational data, all from within SQL Server. It allows you to run queries on external data in Hadoop or Azure blob storage. The queries are optimized to push computation to Hadoop.

In this session, you will learn how to install and set up PolyBase, and how to use it once you've got it configured.

SessionID: 54197

Use Biml to Automate SSIS Design Patterns

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Use Biml to Automate SSIS Design Patterns

Abstract:

Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Biml is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

SessionID: 54319

Extract, Transform And Load - Using R

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Kiran Math

Title: Extract, Transform And Load - Using R

Abstract:

In this session we will Learn R through an Example. We will Extracting Data from Multiple Excel sheets, transforming the data, Visualizing the data and Loading it into SQL Server Table.

SessionID: 54808

Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: BI Information Delivery

Speaker: Melody Zacharias

Title: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract:

Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients. In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits. We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.

SessionID: 56235

Deploying Power BI: A Blueprint for implementation success

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: PowerBI

Speaker: Javier Guillen

Title: Deploying Power BI: A Blueprint for implementation success

Abstract:

As companies become more familiar with Power BI, some have begun experimenting with it on production settings. Some, though, are confused as to how to properly deploy this powerful tool: Who should own Power BI as a solution within the organization? Who is responsible for what? Is this tool for the business or for I.T.? Can we look at it as a reporting tool or is it that plus something else?

This session will present a practical guide for implementing Power BI at your organization to maximize success and adoption. It will present technical and non-technical details to ensure your Power BI deployment is as successful as possible.

SessionID: 56476

Microsoft Technologies for Data Science

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques

Speaker: Mark Tabladillo

Title: Microsoft Technologies for Data Science

Abstract:

Microsoft provides several technologies in and around Azure which can be used for casual to serious data science. This presentation provides an overview of the major Microsoft options for both on-premise and cloud-based data science (and hybrid). These technologies have been used by the presenter in various companies and industries, both as a Microsoft consultant and previously independent consultant. As well, the speaker provides insights into data science careers, information which helps imply where the business will likely be for consultants and partners. Bring your beginner to advanced questions!

SessionID: 57614

Zero to Tabular

Back to calendar

Event Date: 10-12-2016 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Patrick LeBlanc

Title: Zero to Tabular

Abstract:

SQL Server Analysis Services can be very intimidating to some people, especially if you have never designed a Semantic model (formally known as a cube). Join me in this demo-only session where I will show you how to quickly build your first Semantic model in less than 60 minutes. In addition, I will provide you with some best practices and show you how to enable your end-users to leverage the model to build their own reports using Power BI.

SessionID: 57587

BimlFlex: A Flexible, Extensible, and Completely Customizable Data Warehouse Framework

Back to calendar

Event Date: 10-12-2016 - Session time: 11:45:00 - Track: Other

Speaker: Scott Currie

Title: BimlFlex: A Flexible, Extensible, and Completely Customizable Data Warehouse Framework

Abstract:

You might have heard about the benefits of using Biml or other automation approaches to build your own metadata-driven reusable data warehouse and BI framework. What if you don't have the time to build your own framework, and would rather customize an existing framework? Enter, BimlFlex.

BimlFlex is built with the power of Biml and metadata-driven automation while employing the best and most commonly used modelling philosophies (Kimball, Inmon, DataVault). BimlFlex was created in collaboration with Biml experts and offers full transparency to users at every opportunity. Whether using traditional or modern data warehouse architecture, BimlFlex has you covered.

With BimlFlex, requirements are entered into Microsoft Excel enhanced by our BimlFlex Add-in and then stored in a machine-readable metadata database. The BimlFlex code uses this metadata to automate the creation of all your data assets, transformations, and documentation.

Learn more about BimlFlex while you enjoy lunch!

SessionID: 53837

Power BI-Create a Dashboard from Zero to Hero

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: PowerBI

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

SessionID: 54014

Zero to Hero with SSRS 2016 Mobile Report Publisher

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: Analytics and Visualization

Speaker: Robert Cain

Title: Zero to Hero with SSRS 2016 Mobile Report Publisher

Abstract:

SQL Server Reporting Services received many upgrades with the 2016 release. One of the most notible is the new Mobile Report Publisher. This tool allows you to easily create dashboards displayable on multiple platforms including web pages, tablets, and phones. In this sesson you'll see how to generate datasets, create and configure reports, then see them run in a web browser as well as on an iPad and iPhone.

SessionID: 54713

Tips and Tricks for the SSIS Catalog

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jonathan Buller

Title: Tips and Tricks for the SSIS Catalog

Abstract:

With the introduction of the SSIS Catalog in SQL Server 2012, we can now manage our SSIS package execution and monitor performance and logs in a much easier manner than executing packages from the file system. In this session, we'll walk through setting permissions for SSIS read-only access, executing packages from T-SQL or stored procedures, viewing the logs generated during a package execution, writing custom messages to the logs, and many other tips to make your use of the catalog easier!

SessionID: 54981

A Gentle Introduction to R for Power BI

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: PowerBI

Speaker: Ryan Wade

Title: A Gentle Introduction to R for Power BI

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI.

There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, or you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

SessionID: 54985

Are You Making False Assumptions about Your Data?

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Currie

Title: Are You Making False Assumptions about Your Data?

Abstract:

When starting on a new data project, the first step is usually to interview stakeholders and subject matter experts who list the many assumptions that they have been making about the data in the organization. Unfortunately, these assumptions are rarely 100% true which can cause a significant amount of troubleshooting and bug fixing later in the development process.

In this session, we will build a general purpose solution to this problem. Starting from a list of assumptions encoded in an Excel workbook, a collection of SQL statements to test the assumptions are automatically generated. The results of these statements are visualized using PowerBI to create a completely interactive analysis tool to validate assumptions, and diagnose the assumption violations when they are encountered.

Even better, a solution to automate and orchestrate this entire process using SSIS and Biml will also be presented. All code for the solution will be provide to attendees for free use in their projects.

SessionID: 55043

Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins

Back to calendar

Event Date: 10-12-2016 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Jana Sattainathan

Title: Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins

Abstract:

PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.

SessionID: 53834

An introduction to the magical world of BIML!

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 53838

Why “R” you not leveraging the power of “R” in Power BI?

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Wade

Title: Why “R” you not leveraging the power of “R” in Power BI?

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI.

In this session I will focus on the benefits of using R in Power BI. I will show how to leverage R for data munging and I will also show how to leverage R to create custom visualizations. I will focus on the quot;Wickham stackquot; which is a group of very popular R packages developed by Hadley Wickham. I will discuss logical use cases for using R within Power BI as well as some of the pitfalls that you may encounter.

SessionID: 53927

Learning R And Talking About Football

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Wilkie

Title: Learning R And Talking About Football

Abstract:

R -- it's included in SQL Server 2016. What can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who is the best qb in the league right now, statistically?

We'll go over the basics of R and how to do things with it, plus items such as:

SessionID: 54010

RAID??!!

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Chadwick Smith

Title: RAID??!!

Abstract:

All the things BI people want to know about RAID but are too afraid to ask, or too lazy to google! We will cover basic concepts, commonly used jargon, the evolution over time and how RAID is used today.

SessionID: 54054

The 20% of DAX That Gets You 80% of the Way There

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Austin Senseman

Title: The 20% of DAX That Gets You 80% of the Way There

Abstract:

For those of us coming from a SQL background It's easy to get intimidated by DAX. It's a weird language meant to appeal to Excel people while also mimicking much of the functionality of MDX. This session will cover the topics that will make you productive immediately with DAX. Those topics are 1) Calculated Columns v. Measures, 2) Implicit vs. Explicit Measures, 3) the CALCULATE function, 4) Time Intelligence, 5) CUBEVALUE. This is truly the 20% of DAX that will make you productive in 80% of situations. We're going to start with a working data model and start building calculations right away - bring your laptop.

SessionID: 54964

Power BI: Data Refresh and On-Premises Connectivity

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: PowerBI

Speaker: Patrick LeBlanc

Title: Power BI: Data Refresh and On-Premises Connectivity

Abstract:

Join me to go under the hood with a Power BI deep dive. Where I will discuss two Hybrid Scenarios for Power BI. I will explore the data refresh capabilities, allowing reports published to Power BI to connect to varying data sources for data refresh. I will also discuss exciting new capabilities that allows Power BI to connect directly to SQL Server Analysis Services on-premises and interactively query. Allowing customers to keep and manage data on-premises without the need to move their data to the cloud.

SessionID: 56448

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 10-12-2016 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 53835

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 53841

Unlock the Power of the SSISDB for Dynamic Package Runtime

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Matt Martin

Title: Unlock the Power of the SSISDB for Dynamic Package Runtime

Abstract:

In this session, we will be demonstrating how to leverage the SSISDB to change SSIS Package parameters at runtime using just T-SQL. This strategy makes it easier when deploying packages to both QA and production since things like connection strings, file names, and destination table names can change based on the environment you are in. We will show how to change all these features dynamically at runtime, so that you can deploy the package once, and configure it on the fly with just T-SQL.

SessionID: 53854

Embed Power BI within your Web Application

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: PowerBI

Speaker: Pritesh Ostwal

Title: Embed Power BI within your Web Application

Abstract:

Embed Power BI within your Web Application

Walk through on Integration of Power BI Pro and Embedded Power BI Service. Pros and Cons of each approach.

SessionID: 54982

Incrementally Moving to the Cloud Using Biml

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scott Currie

Title: Incrementally Moving to the Cloud Using Biml

Abstract:

Many organizations are interested in the cost savings, ease of maintenance, and other benefits of hosting data solutions on Microsoft Azure. For most, moving to the cloud is easier said than done, especially when they have a large existing solution that is being actively used by stakeholders.

In this session, we will examine various strategies for incrementally moving your solution to the cloud. This will include strategies that incorporate the use of:

  1. New value-added features and services, such as machine learning and big data
  2. Hybrid approaches where portions of your existing solutions can be moved to the cloud without requiring everything to be moved
  3. Failover and surge approaches that enable the cloud to supplement on premises resources
  4. and much more

Business Intelligence Markup Language (Biml) will be central to our approach, enabling the rapid movement of assets back and forth between on premises and cloud hosting.

All code will be shared with attendees.

SessionID: 54989

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 55019

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 55042

Advanced MDX scripting: Scope statements and Time Intelligence

Back to calendar

Event Date: 10-12-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: Advanced MDX scripting: Scope statements and Time Intelligence

Abstract:

Most Analysis Services (SSAS) cubes use an MDX script where additional calculations beyond the basic physical calculations are defined.

In this session you will learn about adding calculated measures to the cube using the cube's MDX script. Then you will learn about Scope statements, how to use them to implement conditional logic, and how they affect physical and calculated measures differently. Finally you will see some examples of time intelligence functions such as YearToDate and MonthToDate implemented using Scope statements.

The session is for those who are familiar with SSAS and have had some exposure to MDX syntax and concepts.

This site is open source. Improve this page.