Thank you to those for submitting  some great sessions this year. It was always going to be a difficult task in selecting the final 11 sessions for the Database and BI track. Congratulations to those who have been selected and we look forward to working with you on finalizing the presentations.

Attendees please ensure you start building your schedule and selecting the sessions. You can view the full catalog at - https://australia.msteched.com/topic/list/. Below are the Database & BI related ones:

 

Look forward to seeing you in Gold Coast.

 

Data Quality Services in Enterprise Info Management

Track Database and Business Intelligence

Type Track Session

James Beresford

This session introduces the basic concepts of SQL Server Data Quality Services (DQS) and how to use it as part of building Credible, Consistent Data. It will cover the concepts and terminology that the product uses and the basics of how to use it to cleanse data. The session will also showcase the automation of Data Quality processes via its integration with SQL Server Integration Services (SSIS), and how it can be used to help manage reference data in Master Data Services (MDS).

DBI224

Killer real world PowerPivot examples part II

Track Database and Business Intelligence

Type Track Session

Grant Paisley

This session is even more jam packed with amazing PowerPivot report examples than last years entertaining presentation. This is *the* session to attend if you want to get the most out of Powerpivot visualizations. Essentially you will see real world PowerPivot reports from clients in Education, Retail, Banking, and Telco and learn a variety of visualization techniques including sparklines, slicers, and charts. You will leave this fun session armed with plenty of ideas for your next personal BI project. Oh and watch out for flying Koala's.

DBI225

Big Data for Relational Practitioners

Track Database and Business Intelligence

Type Track Session

Len Wyatt

You’ve heard the hype about Big Data, Hadoop, and so on… How does this relate to you? This session will describe how the Hadoop ecosystem relates to the ETL, Data Warehousing and BI that you are already doing. We’ll discuss what no-SQL means in practice: What is gained and what is lost. There will be some examples showing Hadoop tools like Pig, Hive and Sqoop, and when you might use them. Finally, what skills should you focus on to make the transition from relational expert to Big Data expert?

DBI226

Data Mining for Fun and Profit

Track Database and Business Intelligence

Type Track Session

Kevin Clarke, Russ Blake

SQL Server Data Mining is the crown jewel of the Microsoft BI stack, delivering Best of Breed data mining algorithms packaged for ready use. But these powerful tools remain neglected on the shelf of many shops in spite of the fact that, according to Gartner Group, BI is the top priority of IT organisations over the next 5 years, with the biggest skills gap in the data mining area. We’ll demystify the data mining algorithms, terminology and tools so you can apply the technology with ease to help your organisation look into its future and adapt as needed in the present, all without any need for a Cube. EB Games will join us to discuss how they have used Data Mining to improve their countrywide retailing operations.

DBI234

Scalable SQL Server design with just a Credit Card

Track Database and Business Intelligence

Type Track Session

Peter Ward

The traditional approach to database scalability has been to simply buy a bigger box. However with the ongoing data explosion that is occurring in organisations today there is a need to re-think how to achieve scalability for the database platform. In this session we will explore how to deploy Microsoft SQL Server into a Private Cloud and how to extend this scalability as a Hybrid solution using the Azure platform. With nothing more than a credit card and the Azure platform you will see how it is now possible to create highly-available, infinitely scalable SQL Server environments that support automated deployment and elastic scale.

DBI312

Keeping the Lights On with SQLServer 2012 AlwaysOn

Track Database and Business Intelligence

Type Track Session

Warwick Rudd

In today’s ever changing environment, the requirements for High Availability and Disaster Recoverability are becoming more complex. Are you able to meet these requirements with your current SQL Server Stack ? With the release of SQL Server 2012, the High Availability/Disaster Recovery feature AlwaysOn provides a more granular approach and control over your environment. In this presentation we will look at how to configure, setup & monitor SQL Server 2012 AlwaysOn.

DBI313

Turbocharging a Warehouse with Columnstore Indexes

Track Database and Business Intelligence

Type Track Session

Len Wyatt

Do you have data warehouse queries that run too long? Adding a columnstore index can provide a tremendous performance boost. Do you know why? Do you know when to create a columnstore index and how to get the best performance from your columnstore indexes? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.

DBI315

Develop a SSAS Tabular Project BI Semantic Model

Track Database and Business Intelligence

Type Track Session

Peter Myers

In this session learn how to develop and deploy a tabular project BI Semantic Model – a new data modelling approach made available to developers in SQL Server 2012 Analysis Services. The session will cover all design features including how to load and relate data, how to enrich the model with hierarchies and calculations, and how to secure and process the model data. Additionally, it will introduce and cover Data Analysis Expressions (DAX) and how it can be used to define calculated columns, measures and KPIs. A specific emphasis will be made on the new DAX functions available in the SQL Server 2012 release. Finally, and with due emphasis, theory and discussion to help you decide when the tabular project BI Semantic Model is the appropriate modelling choice will be covered.

DBI321

SQL Server Database Private Cloud Deep Dive

Track Database and Business Intelligence

Type Track Session

Danny Tambs

In this session, learn about the DPC (Database Private Cloud) Reference Architecture and how it can be used to consolidate thousands of databases on a single scalable platform. The session will drill into the hardware and software configuration and cover how its wired together. We will cover the use cases, savings, workload types and migrating workloads to the solution as well as discuss management options.

DBI332

SQL Server Warehousing (Fast Track 4.0 & PDW)

Track Database and Business Intelligence

Type Track Session

Matthew Winter, Stephen Strong

Whats in Windows Server 2012 for SQL Server

Track Database and Business Intelligence

Type Track Session

James Crawshaw, Raja Narayanaswamy

Learn about the new, key Windows Server 2012 features which compliments SQL Server on its High Availability, Performance & Scalability, Mobility and Security. The session will drill into the major enhancements such as SMB( SMB Transparent Failover, SMB Multichannel, SMB Direct (Remote Direct Memory Access), SMB Scale-Out, increased performance, and more), Hyper-V (replication-HA, Scalability, Mobility and Security enhancements)