Build Schedule

Advanced Filters:
  • Track

    clear all





















  • Speaker


  • Level


  • Session Type

Sessions Found: 43
The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, knowing the difference helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analysis Services

Level: Beginner

Session Code:

Date: January 09

Time: 3:45 PM - 4:45 PM

Room: Centennial

"Its.Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!") 

What's slow? Since when? Compared to what?

Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analysis Services

Level: Intermedia

Session Code:

Date: January 09

Time: 12:45 PM - 1:45 PM

Room: Highlands

The quality and accuracy of Business Intelligence depends on more than just a few processes. Learn how centralized workload automation enables you to schedule and monitor multiple processes in SQL, ERP platforms and other business systems. Create predictable and reliable BI workflows that your business can depend upon.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: January 09

Time: 11:45 AM - 12:45 PM

Room: Grant

This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 09

Time: 10:30 AM - 11:30 AM

Room: Piedmont

Let's take a lap around Azure Data Lake Store & Analytics!  We'll cover what it is, how it's architected, why you might want to use it, and what other tools are involved (U-SQL!).  The session will consist of an overview of the data store and analytics options, a live demo, and some discussion of how it all comes together.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 09

Time: 12:45 PM - 1:45 PM

Room: Underground

You've probably heard a lot about Biml for SSIS automation, but did you know it can also be used for building complex, yet reusable T-SQL statements for common database tasks – in most cases much faster and more easily than you could with dynamic T-SQL.

This will be a scenario driven session where we discuss many real world examples of manual tasks that can be automated with Biml snippets and the free BIDS Helper AddIn to BIDS/SSDT. You will receive all code for your own use.

Scenarios include:
1) Generation of T-SQL merge statements that removes all the drudgery of manually mapping columns - including complex SCD column handling.
2) Stale data detection that uses Biml to create queries that display ranges for all date/time columns in each table of a target database - perfect for retiring tables from WorkDB and other ad hoc environments.
3) Sample data creation that automatically produces test data based on DDL schema information from your data model.
4) And much more
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BIML

Level: Intermedia

Session Code:

Date: January 09

Time: 9:00 AM - 10:00 AM

Room: Centennial

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture.  Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database.  This session will provide a review of change tracking syntax and implementation with detailed demos.  It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Integration Services

Level: Intermedia

Session Code:

Date: January 09

Time: 12:45 PM - 1:45 PM

Room: Buckhead

In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits. We will also visualize this data using PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Intermedia

Session Code:

Date: January 09

Time: 2:15 PM - 3:15 PM

Room: Underground

The learning curve for DAX isn't a straight line - it starts off gradual and quickly gets steep.  With a syntax similar to Excel, DAX seems easy enough for an Excel power user but things quickly get confusing without a good foundation in the basics of DAX.  Those basics - context and calculation - are the topic for this session.

This session is for the intermediate DAX user who has produced some quality data models and DAX calculations but who is still having difficulties with functions around filtering, time intelligence, and complex calculations.  We'll go through a number of practical examples that show that DAX at a fundamental level is a combination of creating filter and row CONTEXTS and then using those contexts to produce CALCULATIONS.  Understanding this concept is a must to produce more complex code in DAX and it's also a very useful framework for someone just getting started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: January 09

Time: 10:30 AM - 11:30 AM

Room: Highlands

This session outlines and presents Cortana Analytics Suite and answers many of the common questions about it. Cortana Analytics Suite analysis and identifies patterns in big and small data. Its critical in answering complex business questions. This session presents the use of Cortana Analytics Suite and Cortana Perceptual APIs in common business scenarios. This session will introduce Cortana Perceptual APIs (Face, Vision, Speech, LUIS, Tone), These tools are based on complex machine learning models that help us move from unstructured big data (video, text, audio, speech) to structured data. We’ll show a demo of how it works and business cases in different industries where Cortana improved IT ROI, compliance and customer retention.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: January 09

Time: 9:00 AM - 10:00 AM

Room: Underground

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, Jay Harris 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, Jay will start from scratch and by the end of the session create a full-blown staging environment. 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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BIML

Level: Beginner

Session Code:

Date: January 09

Time: 10:30 AM - 11:30 AM

Room: Midtown

The ability to view your data in any way is a key tenet in Power BI.  To satisfy this requirement, Microsoft introduced the ability for developers to create and include custom visuals in Power BI reports and dashboards.  This session will teach you how to create your own custom visual, deploy it to a report, and use it in your own dashboards.  Limited development experience is needed for this session and to create custom visuals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: January 09

Time: 12:45 PM - 1:45 PM

Room: Piedmont

Your Network carries a wealth of data that you can use to improve your Business Intelligence practice. By mining the data on the wire you can gain access to new data sources, deliver real-time stream analytics, and even provide frictionless monitoring of your SQL Server databases without the need for profilers. Learn how ExtraHop can turn nondescript communications between systems into structured wire data from which you can derive new insights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: January 09

Time: 11:45 AM - 12:45 PM

Room: Piedmont

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability.  PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out.  The rewards of the SQL Community are endless.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 09

Time: 3:45 PM - 4:45 PM

Room: Underground

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS. 
Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Integration Services

Level: Beginner

Session Code:

Date: January 09

Time: 9:00 AM - 10:00 AM

Room: Piedmont

Have you been curious about Biml but find many of the samples and initial tutorials to be a bit theoretical? Would you rather see a Biml solution that works with real-world data? Look no further! In this session, Daniel McLeod, who works on the Biml development team, will demonstrate an end-to-end patterns-based metadata-driven integration using a real world Customer Interaction Center (http://www.inin.com/solutions/Pages/Contact-Center-Software.aspx) database. With just the source database and a simple but complete metadata store, the Biml solution will generate a data mart that is PowerBI ready. All Biml code will be shared with attendees.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BIML

Level: Intermedia

Session Code:

Date: January 09

Time: 3:45 PM - 4:45 PM

Room: Midtown

How to interact with your corporate data right from within the Cortana experience including voice integration for querying your data. How Q&A can resolve our day today question from organization. How to Use natural language queries to find answers in your own data. Start with a question, and have fun traveling through your data refining or expanding your question, uncovering trust-worthy new information, zeroing in on details and zooming out for a broader view
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
PowerBI

Level: Beginner

Session Code:

Date: January 09

Time: 2:15 PM - 3:15 PM

Room: Chastain

Introduction to SQL Server spatial data types. For starters will create basic geometric shapes and discuss how it can be used to improve search of complex polygons. Next will discuss spatial data type static functions and touch on spatial indexes. Lastly will create SSRS reports using spacial data. Focus will be on real world examples from transportation industry (U.S. Xpress, Inc.) and how spatial data and report can be used to make correct decisions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: January 09

Time: 3:45 PM - 4:45 PM

Room: Chastain

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: January 09

Time: 2:15 PM - 3:15 PM

Room: Highlands

This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: January 09

Time: 10:30 AM - 11:30 AM

Room: Chastain

Sessions Found: 43
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids