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
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
116-120 Goswell Road
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.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.