Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 14
Take your Power BI analytics skills to the next level. In this session we will introduce and walk-through a variety of popular advanced analytic techniques and tools. We will cover prescriptive and predictive analytics, methodology and tools including but not limited to Microsoft Power BI: Excel, Power Pivot, Power Query, SQL Server Data Mining, Predixion, Frontline Systems Solver and R. Advanced analytics lifecycle topics discussed include choosing the right analytic technique and tool, data preparation, developing analytic models, evaluating models and implementing analytics into smart reports, dashboards, business processes and applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

As a BA/BI Professional you are in a key position of influence.  Helping to guide your organization to embracing automation of testing, deployment and configuration will help your company deliver better, safer software faster.  If you are interested in understanding automation’s role 
•	What is automation, really?
•	Why is it important to me and my company?
•	Is this just one more thing to learn and do?
•	Where do you start?
•	When to start?
•	How can I be an influencer?
•	What’s in it for me?
•	What’s automation’s role in Big Data
Mike has spent years successfully helping companies start or restart their path to automation.  For some years Mike has had a passion for automating tasks & processes related to the Software Development Lifecycle (SDLC), helping companies deliver the business value of their software more rapidly. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

The problem with the old way of organizing and analyzing data in RDBMS is that it is painfully slow, incomplete and costly. We are obligated to be selective and work with data in small chunks. In the best case scenario we partitioned our data and archived it with the hope to eventually use it, but the fact is that when data is being archived, usually, it is never used again. We don’t even bother with collecting all the data due to economics and technical limitations. 
In this presentation I will introduce BI and Big Data, explain advantages and disadvantages of OLTP, OLAP and Big Data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this hour I will show you how to set up a Big Data environment, how to load and transform data, and how to access the data using Hadoop and Microsoft utilities. I will leave you with all of the pieces, parts, instructions, and additional experiments to set up your own environment and get some actual stick time. This is part one in a three part series which will take you from setting up your environment to basic analytics to applying analytics to business decision making.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this hour I will build on the exercises in Part 1 of this series. I will cover more advanced data acquisition and transformations, building 'tidy' data sets, plotting and visualizations, and basic data mining using a variety of tools and utilities. This is part two in a three part series which takes you from setting up your environment to basic analytics to applying analytics to business decision making.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, Dmitri will talk about internal structure of Clustered Columnstore Indexes. He will demonstrate how to design ETL processes and Columnstore Index Maintenance routines in the way that improve query performance in the system. Finally, Dmitri will discuss how to utilize Columnstore Indexes in reporting solutions that work with volatile data in OLTP environments. 
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services have many useful but not well-known features. Many BI developers do not know how to create interactive reports or reports with dynamic columns; how to use JavaScript in reports or display an image in multiple columns.
Come to this session and you will learn 12 useful tips and tricks, which will help you to make impressive reports and simplify their development.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

A session focused on ramping you up on what Hadoop is, how its works and what it's capable of. We will also look at what Hadoop 2.0 and YARN brings to the table and some future projects in the Hadoop space to keep an eye on.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Building an SSAS cube isn't for everyone. PowerPivot is! This session is for anyone who wants to get started in PowerPivot. Join us as we build a PowerPivot model from the ground up and then create some reports, all in just over an hour. Learn how to use data from existing sources, such as SQL Server databases or Analysis Services, as well as how to integrate currently unrelated data from sources such as Excel workbooks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data.  We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions.  Real life examples and solutions will provided to give better context to each step in the process.
After the data structure has been created we will focus on how to best “clean” and validate the geographic data.  We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types.
Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports.  This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as:
Events that occurred at a specific address, zip code, and even block range and events within a mile radius.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Mike as he shows you how to be prepared for technology job interviews. Learn the do's and don'ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow.  I'll be showing some basic .NET Script code in both C# and VB.  I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.  Everyone is welcome to attend.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

As a hiring manager, I see the same mistakes over and over again. In this session we'll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We'll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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