sqlsathistory

Nr: 352

Back to Main list

SQLSaturday #352 - Sydney 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Craig Bryden	Track 024	Automate your Data Profiling insights using Power BI
00:00:00	Geoff Black	Track 104	Mash it up with Power Query
00:00:00	Grant Paisley	Track 104	Kick-ass Ad-hoc Cube Browser build in SSRS 2014
00:00:00	Shehab El-Najjar	Track 106	Performance dreams wait for you at SQL Server 2014
00:00:00	Iman Eftekhari	Track 104	365 days with Power BI
00:00:00	Julie Koesmarno	Track 104	Interactive Actionable Data Visualisation With Power View
00:00:00	Konstantin Khomyakov	Track 104	Everything you would like to know about Power BI - QA
00:00:00	Leila Etaati	Track 024	“Show Me Potential Customers “ : Data Mining Approach
00:00:00	Martin Cairney	Track 106	Thinking Out of the Box: Manage SQL Server Using Built-in Tools
00:00:00	Mohamed Kabiruddin	Track 024	Crack open the AMO for SSAS Tabular
00:00:00	Peter Avenant	Track 024	A New Approach to Unit Testing and Integration Testing in SSIS
00:00:00	Stanley Roos	Track 106	Indexing for performance
00:00:00	Victor Isakov	Track 106	Understanding the High-Availability Options in SQL Server 2014
00:00:00	Warwick Rudd	Track 106	Performance Eye for the SQL Guy
00:00:00	Reza Rad	Track 024	ETL Architecture for Solving Data Warehouse Challenges

SessionID: 11994

Automate your Data Profiling insights using Power BI

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 024

Speaker: Craig Bryden

Title: Automate your Data Profiling insights using Power BI

Abstract:

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.

SessionID: 14469

Mash it up with Power Query

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 104

Speaker: Geoff Black

Title: Mash it up with Power Query

Abstract:

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!

SessionID: 14725

Kick-ass Ad-hoc Cube Browser build in SSRS 2014

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 104

Speaker: Grant Paisley

Title: Kick-ass Ad-hoc Cube Browser build in SSRS 2014

Abstract:

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.

SessionID: 15257

Performance dreams wait for you at SQL Server 2014

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 106

Speaker: Shehab El-Najjar

Title: Performance dreams wait for you at SQL Server 2014

Abstract:

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

SessionID: 15290

365 days with Power BI

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 104

Speaker: Iman Eftekhari

Title: 365 days with Power BI

Abstract:

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, QA, and mobile access.

SessionID: 16930

Interactive Actionable Data Visualisation With Power View

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 104

Speaker: Julie Koesmarno

Title: Interactive Actionable Data Visualisation With Power View

Abstract:

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.

SessionID: 18671

Everything you would like to know about Power BI - QA

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 104

Speaker: Konstantin Khomyakov

Title: Everything you would like to know about Power BI - QA

Abstract:

One of the Power BI features users have been interested in is QA, which takes data exploration to a whole new level. With QA, 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.

SessionID: 19011

“Show Me Potential Customers “ : Data Mining Approach

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 024

Speaker: Leila Etaati

Title: “Show Me Potential Customers “ : Data Mining Approach

Abstract:

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.

SessionID: 19731

Thinking Out of the Box: Manage SQL Server Using Built-in Tools

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 106

Speaker: Martin Cairney

Title: Thinking Out of the Box: Manage SQL Server Using Built-in Tools

Abstract:

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.

SessionID: 20017

Crack open the AMO for SSAS Tabular

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 024

Speaker: Mohamed Kabiruddin

Title: Crack open the AMO for SSAS Tabular

Abstract:

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.

SessionID: 21937

A New Approach to Unit Testing and Integration Testing in SSIS

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 024

Speaker: Peter Avenant

Title: A New Approach to Unit Testing and Integration Testing in SSIS

Abstract:

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.

SessionID: 25245

Indexing for performance

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 106

Speaker: Stanley Roos

Title: Indexing for performance

Abstract:

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.

SessionID: 27439

Understanding the High-Availability Options in SQL Server 2014

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 106

Speaker: Victor Isakov

Title: Understanding the High-Availability Options in SQL Server 2014

Abstract:

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.

SessionID: 27667

Performance Eye for the SQL Guy

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 106

Speaker: Warwick Rudd

Title: Performance Eye for the SQL Guy

Abstract:

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 .

SessionID: 8782

ETL Architecture for Solving Data Warehouse Challenges

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 024

Speaker: Reza Rad

Title: ETL Architecture for Solving Data Warehouse Challenges

Abstract:

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.

This site is open source. Improve this page.