Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 15
In the most marketing departments, the tactical question is about who are going to buy our products.  It is more cost effective to identify and spend money on highly potential customers (than those who are not likely to purchase).  This also affects the advertisement strategy. Potential customers and their traits can be identified by analysing previous purchasing information. Management experts can predict who is going to be their new customers by analysing their current customer purchase information. There are many data mining algorithms which can help with this task.  Microsoft Business Intelligence employs data mining algorithms that are deployed in an easy to use environment.
This demonstration based session will show how to use previous customer purchase information to predict potential customers. We will discuss how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions.
Speaker:

Session Type:
Regular Session

Track:
Track 024

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session Iman will share his 1 year journey with Power BI, evolution of the toolset, ups and downs, feedbacks from clients, etc.

He will also demonstrate scenarios which include the end-to-end build of a report using Power Query, Power Pivot, Power Map, and Power View. Also the cloud features such as sharing reports/data sets, setting up Data Management Gateway, automated data refresh, Q&A, and mobile access.  
Speaker:

Session Type:
Regular Session

Track:
Track 104

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Testing is critical to managing a high-quality data lifecycle. Unfortunately, SSIS has no built-in support for test authoring and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered. In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic. All code will be shared with attendees for free and unrestricted use within their own projects.
Speaker:

Session Type:
Regular Session

Track:
Track 024

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Data profiling is a critical input task to any database initiative that incorporates source data from external systems. With the right data profiling, it’s possible to gain a huge amount of insight into the data quality in your systems, and as a result, be able to make radically more accurate estimates of the cost to go from the "as is" to the "to be". The Data Profiling task in SSIS can be very powerful, but it is tricky to use and time consuming to review the findings, until now. 
In this session I will demonstrate how you can automate data profiling of any SQL Server Database using Integration Services, and use the output of the data profiling task to populate a Power Pivot data model. 
This data model can then be used to analyse table structures, data quality and identify problems with your data. By using the different profiles you can determine how to clean up your incoming data prior to loading it into your database. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 024

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Analysis Services Management Objects API is under utilised by many organisations (and not even heard of by some). In this session, I will walk through the features in AMO that help organisations build, customise, manage and administer SSAS tabular models using an automated and programmatic approach. The session will include demos to illustrate the capability of various AMO classes and methods. If you want to show off the length and breadth of programmatic features available in SSAS to your stakeholders, this session is your sure shot guide to being a glorified SSAS professional.
Speaker:

Session Type:
Regular Session

Track:
Track 024

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture.
Speaker:

Session Type:
Regular Session

Track:
Track 024

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the Power BI features users have been interested in is Q&A, which takes data exploration to a whole new level. With Q&A, users type ad-hoc questions and the system provides them with answers in the form of interactive charts and graphs.  The search like experience is instantaneous and uses a natural language query, interpreting the semantics of question the user is typing. This session will be covered with a lot of samples of deployment, configuration, optimization etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 104

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

An effective indexing strategy is one of the most important responsibilities of a database professional. In this session we will briefly look at the internals of indexes and how the engine decides how to utilise them. We will explore the different options and choices available in the different versions of SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 106

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go.   
  
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 104

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Hot from USA PASS Analytics Conference session.

You will learn how to use generic reporting techniques in SQL Server Reporting Services (SSRS) to create a virtually unlimited set of dynamic reports for your users by simply changing report parameters. Just change dashboard report contents and share components for looking up values.

The techniques we will discuss are based on concepts in the books “Advanced Reporting Services 2012” and “Reporting Services Recipes.” By attending this session, you will learn enough to use the Angry Koala Cube Browser and Angry Koala Cube Surfer and modify to your own organization’s needs. Join this practical session, which will give you lots of ideas for your own users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 104

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will see how to unleash Microsoft Excel and gain an understanding of what all the hype is about in the world of Power BI. We will show you the true meaning of the word ‘Power’ in Power BI. You will witness world-shattering evolutionary changes in Excel data access with Power Query and how this product can be used to transform this widely known and well used tool into a sophisticated next generation ETL platform that rivals even the likes of SQL Server Integration Services (SSIS) itself! Not only will we show you how to access data from both internal and external sources, but you will see how simple and easy it is to transform and shape data in a variety of sophisticated ways. From world population statistics, economic and health trend indicators, scraping web pages and spreadsheets to MotoGP championship racing and your favourite movies – the world of data is changing, attend this session to see how you can enable yourself to catch the wave and ‘mash it up’ today!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 104

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance dreams wait for you at SQL Server 2014 , it is just like this because you will  that unbelievable performance reads and substantial improvement that you will not give up at all those new SQL Server 2014 features , come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 regarding performance particularly like  Microsoft project “Hekaton” for In-memory built for OLTP , In-Memory columnstore index ,Resource Governor for IO consumption,lock management  and also Single partition online index rebuild technologies ,you will get much hands-on experience  for all definitions , architecture design , values and benefits ,caveats  and recommendations related to each one of them and in addition  I will add a practical flavor for this session by conducting multiple stress tests on most of these technologies to be more close to these performance dreams and explorer concretely these outstanding performance improvements of SQL Server 2014
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 106

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2014 comes some new features which can provide performance improvements for your SQL Server environment. In this session Warwick will take you through these new features including Buffer Pool Extension, Resource Governor for I/O, InMemory OLTP, InMemory DW,  Managed Lock Priority & Single Partition Online Index Build  that could help improve performance in your SQL Server environment .
Speaker:

Session Type:
Regular Session

Track:
Track 106

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

It’s often the case that your budget doesn’t stretch far enough for all the great third party tools that help manage your SQL Servers. So, how can the in-built components of SQL Server help you with your daily tasks?

Policy Management, Data Collector and Extended Events, all included in both Enterprise and Standard Editions, provide a framework to keep your configurations consistent and give you some insights into the performance of your SQL Server instances. In this session, we will see how to make use of these components to formalize your configuration and track some performance attributes.

After this session you’ll be able to build out an effective management and monitoring toolkit using only “out-of-the-box” features.
Speaker:

Session Type:
Regular Session

Track:
Track 106

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2014 (and Windows Server 2012R2) there are more High-Availability (HA) options available than ever before. And your prior knowledge / experience might be detrimental to you architecting an appropriate HA solution for your organization. In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the different HA options available in SQL Server 2014. Along the was he will discuss the important considerations and offer some practical advice and practices to help you implement the correct HA solution. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 106

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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