This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     

Microsoft Analytics Platform System Workshop

17th November 2014 - 20th November 2014

Who is it for?

This course is aimed at SQL Server and BI professionals who want to learn about Microsoft Analytics Platform System (APS). No previous knowledge of APS is required.

What you will learn

Having problems scaling your data warehouse? Fed up with trying to optimise queries to maximise your parallelism? There is another way! Learn how to design and scale out your data warehouse and analytics solutions using Microsoft Analytics Platform System (APS).   Join this four day course and learn all about how APS can seamlessly scale out your data warehouse using the Parallel Data Warehouse Region of the appliance; providing fantastic performance, increased ease of management and reduced complexity. You will also learn about how APS also integrates with Hadoop using it’s open agnostic architecture called project PolyBase. Finally, get the opportunity for real hands on exposure to APS via immersive labs designed specifically for this platform; helping you to really understand how to make the most of this dynamic platform.

Areas covered in the training include:

  • Scale Out Concepts
  • APS Appliance Architecture
  • Introducing the PDW Region
  • Database Design
  • Table Design & Statistics Management
  • Resolving queries with PDW
  • Data Loading Patterns
  • Migrating to PDW
  • Augmenting ETL Frameworks
  • Managing the Appliance
  • Introducing the Hadoop Region
  • Integrating with Hadoop using PDW & PolyBase

Hands on Labs will Cover:

  • Database Design
  • Table Design
  • Data Movement
  • Loading Data
  • Big Data Integration

Key benefits

In this intensive four day workshop you’ll get both the theoretical knowledge, hands on experience and the practical advice needed to bring “parallelism, all the time, every time” to your data warehouse project.

Cost: £1499 (to August 31 2014), 1699 (from September 1 2014) +VAT


James Rowland-Jones is a Principal Consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server Parallel Data Warehouse and Hadoop ecosystems. He also enjoys training and mentoring both partners and customers on leveraging MPP technology to solve business problems.
James is a keen advocate for the SQL Server community; both internationally and in the UK. He currently serves on the Board of Directors for PASS and sits on the organising committee for SQLBits - Europe's largest event for the Microsoft Data Platform. James has been awarded Microsoft’s MVP accreditation since 2008 for his services to the community.



Skills Matter
116-120 Goswell Road

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration decoration decoration decoration