Pre-Conference Seminars
Pre-Conference Seminars
Pre-Conference Seminars (Pre-Cons) are full-day, focused, deep-dive, classroom training aligned to DPS 2017 tracks.
- There will be 11 pre-cons this year.
- Each pre-con will be delivered by an international & renowned technology expert.
- Pre-Conference Seminars are scheduled a day before DPS 2017, on August 16, 2017.
- Pre-Conference Seminars are designed to offer you advanced training to enhance your summit experience for next 3 days.
- You also receive exclusive content for the training you attend.
- Regular 3-day Conference is from Aug 17 to 19.
Explore the eleven DPS 2017 pre-cons below and choose the right one for yourself. Remember, pre-cons are exclusive day-long training delivered by a Master and you get exclusive content too! It is highly recommended that every DPS delegate chooses a pre-con that matches his/her profile & project needs.
Data Platform Summit 2017 Pre-Conference Seminars (Registration Details Below)
Azure Infrastructure (Denny Cherry)
Pre-Con Code | PRECON001 | ||
Pre-Con Title | Azure Infrastructure | ||
Track(s) | Cloud | ||
Trainer | Denny Cherry | ||
Abstract |
In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier. Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime. With the introduction of multiple Azure data centers now available in India many companies will be begin moving services from data centers into the Azure and a solid foundation is key to successful migrations. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Advanced Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning (Chris Testa-O’Neill)
Pre-Con Code | PRECON002 | ||
Pre-Con Title | Advanced Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning | ||
Track(s) | Â Data Science/BI/Analytic | ||
Trainer | Chris Testa-O’Neill | ||
Abstract |
Machine learning and R are the new buzz words. R became a language for data analysis and machine learning which makes it important to learn more about it . |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
70% of this pre-conference seminar is demo |
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Zero to Microsoft Power BI (Peter Myers)
Pre-Con Code | PRECON003 | ||
Pre-Con Title | Zero to Microsoft Power BI | ||
Track(s) | Business Intelligence & Analytics | ||
Trainer | Peter Myers | ||
Abstract | Join Peter Myers—a consultant, trainer, presenter and Data Platform MVP who has worked with Microsoft database and development products since 1997—for a full day workshop on Microsoft Power BI. The workshop has been specifically designed to empower attendees with the technical knowledge required to become proficient with the Power BI service and also its growing number of capabilities and features. It is sure to inspire attendees with opportunities, and to provide them with resources to help them take the next steps on their path to mastering Power BI. The workshop will include the following modules: 1: Microsoft Power BI Overview 2: Working with the Power BI Service 3: Connecting to Power BI Data Sources 4: Creating Power BI Desktop Solutions This workshop is suitable for a broad array of professionals, including business analysts, IT managers, Business Intelligence practice leads and architects. As an introductory workshop, there is no requirement to have existing Power BI skills. Also, apart from having a basic understanding of database technologies, there are no specific technology or product prerequisites. Attendees are encouraged to bring a computer to participate in the workshop activities. The computer must have Windows 7, or later, installed. Note that there is no requirement to have a Power BI account, as attendees will be provided with a trial account for the duration of the workshop. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Watch Peter Myers talk about his DPS2017 Pre-Con Session
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Plan-first Querying – Writing Queries to Suit the Optimizer (Rob Farley)
Pre-Con Code | PRECON004 | ||
Pre-Con Title | Plan-first Querying – Writing Queries to Suit the Optimizer | ||
Track(s) | Database Development/Administration | ||
Trainer | Rob Farley | ||
Abstract | This day-long seminar takes a different approach to T-SQL, by teaching you to cater for what the Query Optimizer is doing. The Query Optimizer turns your T-SQL query into a program known as a query plan, which runs to produce the data you’ve requested. GROUP BY does grouping, but the plan can choose a few different ways to do that. ON, WHERE and HAVING all filter, but the physical implementations can be identical or vastly different, depending on many other factors. When you were taught to write T-SQL, you learned about how to create queries that are logically correct to produce the results you want. You were probably taught about using indexes, and other techniques for tuning, but not about Hash Aggregates, Spools, or Parallelism. In this seminar, you will learn to write queries that produce the plans you want, and identify how particular query plan operators can help or hinder the performance of your queries, to give the kind of performance you should expect. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |  Oh, it’s almost all demo… | ||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Watch Rob Farley talk about his DPS2017 Pre-Con Session
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Building a Database DevOps Process (Steve Jones)
Pre-Con Code | PRECON005 | ||
Pre-Con Title | Building a Database DevOps Process | ||
Track(s) | Database Development | ||
Trainer | Steve Jones | ||
Abstract | DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration, Continuous Deployment, and performing regular deployments to their production environments. There is no shortage of books, articles, training, and advice on how to build an application using a DevOps process. In almost all of this literature, the database is largely ignored.
In one-day class, we will discuss the challenges of database development and how to fit a database into a DevOps process. Learn how to store code in a VCS, implement a continuous integration process, setup automated releases with human approvals and ensure your database is included in your DevOps process. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Watch Steve Jones talk about his DPS2017 Pre-Con Session
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Analysis of Your SQL Server Like a PRO (Uwe Ricken)
Pre-Con Code | PRECON006 | ||
Pre-Con Title | Analysis of Your SQL Server Like a PRO | ||
Track(s) | Database Administration | ||
Trainer | Uwe Ricken | ||
Abstract | SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyse and tune SQL Server like a BOSS. In this full training day, I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Watch Uwe Ricken talk about his DPS2017 Pre-Con Session
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
In-Memory Technologies in SQL Server – From 0 to Operational Analytics Master (Andreas Wolter)
Pre-Con Code | PRECON008 | ||
Pre-Con Title | In-Memory Technologies in SQL Server – From 0 to Operational Analytics Master | ||
Track(s) | DBA/DEV | ||
Trainer | Andreas Wolter | ||
Abstract |
Since SQL Server 2016 Service Pack 1, most programming features have been available in all editions, including the two In-Memory technologies: Columnstore Indexes and In-Memory OLTP. Columnstore indexes, which have been existing since SQL Server 2012 (actually PDW v2008), are mainly optimized for big amounts of data (millions of rows) and offer blazingly fast OLAP-style queries, which is made possible by their special structure (columnar storage), sophisticated compression, and batch-mode processing for much more efficient CPU-usage than traditional row-store-queries. The In-Memory OLTP engine, which will be the second topic of this full day, came into the product with SQL Server 2014 and has since then been extensively improved in terms of both scalability and T-SQL language support, taking away many of the relevant limitations for adaption of version 1 in a similar way as the Columnstore technology over the course of its development. Thirdly, the so-called In-Memory Operational Analytics are supported by the ability to create Columnstore Indexes on memory optimized tables! All those improvements will make In-Memory technologies a viable option in many projects. For Datawarehouses, many say that Columnstore will become the default storage type for all objects in the near future. And it can be foreseen that over the years the same will happen for OLTP-tables that have to support highly concurrent workloads, which will all be based on memory optimized tables. It’s time to extend your skills to embrace those technologies, and learn how to implement and support those new types of storage that are coming to our databases, addressing the challenge of ever more data being stored and queried and performance demands and (real time) analytic requirements going up. During this full-day training session, Microsoft Certified Master for the Data Platform Andreas Wolter, familiar with SQL Server’s In-Memory technologies from the early bits on, will give a complete picture on the current state of technology. Attendees will learn how and where to use either In-Memory OLTP or Columnstore or even both for efficient queries and data storing, but also which problems still exist in real-worldprojects that sometimes make it hard to find the right solution design to profit from those technologies, and cover the important bits and pieces both from a developer’s and administrator’s perspective. |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Data Modeling and Data Visualization (Sivakumar Harinath)
Pre-Con Code | PRECON011 | ||
Pre-Con Title | Data Modeling and Data Visualization | ||
Track(s) | BIA | ||
Trainer | Sivakumar Harinath | ||
Abstract |
Get to know the theory behind data modeling concepts in Power BI and get a behind-the-scenes view of the Power BI engine to learn the foundations of the DAX language and how Power BI evaluates DAX formulas. Learn the principles of creating effective data visualizations. You will understand how to use different charts to answer business problems and how to use a report to tell an effective story or draw actionable insights |
||
Modules/Topics |
|
||
Key Takeaways |
|
||
Demos |
|
||
What Is Included? |
|
||
Date | August 16, 2017 | ||
Time | 9:00 am to 5:00 pm IST | ||
Duration | 8 hours | ||
Venue | Davanam Sarovar Portico Suites (4 Star Deluxe Suite Hotel) Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068 (Near Silk Board) |
||
List Price |
|
Pre-Con Registration Options (for Individuals/Self-Sponsored):
- Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
- Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
Pre-Con Registration Options (for Companies/Groups):
- Online Registration & Payment: For online individual corporate registration & payment Click Here
- If you are a group from the same company and are being nominated by your company/manager,  Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
- If you are an individual getting sponsored by your company/manager, Download Corporate Registration Kit  or drop us an email (mamita[at]dataplatformgeeks[dot]com)
Questions? Contact the Conference Team
Questions? Contact the Conference Team
Terms & Conditions
- All prices are quoted in INR only
- Cancellations terms:
- For any cancellation on or before June 15, 2017, there are two options:
- Option 1: 50% of the registration fee will be charged and the remaining amount will be duly refunded back within 15 days of cancellation (or)
- Option 2: The entire registration fee can be adjusted with next year’s conference/pre-conference fees, respectively.
- For any cancellation after June 15, 2017, there is only one option:
- 50% of the registration fee will be charged and the remaining amount will be adjusted with next year’s conference/pre-conference fees, respectively (No refunds will be made).
- For any cancellation on or before June 15, 2017, there are two options:
- All incidental expenses incurred towards travel, boarding & lodging etc., will be borne by the delegate/delegate’s company. However, conference team is committed to provide the best deals/offers on hotel accommodation to all the registered delegates of DPS 2017. For more details, & assistance in booking, contact the DPS 2017 registration team in Bangalore at: mamita@dataplatformgeeks.com
- Session materials are solely for participant’s personal and non-commercial use.
- Session material including decks, training manual, demo scripts, hands-on-labs, etc., cannot be copied, reproduced, republished, uploaded, posted, transmitted, shared, distributed, re-sold, offered for re-sale, assigned, displayed, transferred or sub-licensed or in any other way exploited in whole or in part.
- Session materials including decks, training manual, demo scripts, hands-on-labs, etc., will be protected by copyright of respective presenters/speakers.
- Registration fees might change in case registration quotas are filled before the mentioned dates.
- Feedback provided by you may be used by DataPlatformGeeks for marketing purposes.
- Full refund will be made in case the conference is cancelled by DataPlatformGeeks. Refunds will be processed within fifteen days of cancellation announcement.
- Data Platform Summit 2017 cannot be used as a platform for any promotional activity. If any such promotional activity is found or identified, and/or conflicts with the interest of any sponsor or exhibitor, your participation in the conference may be cancelled.
- Executive vegetarian lunch will be served at the conference venue. Tea/Coffee & Vegetarian snacks will also be served at all times.
- Video, audio or any form of recording during the sessions, is strictly prohibited.
- DPS 2017 reserves the right to share the conference registration details, only with its gold/platinum/diamond sponsors.
- Our conference is dedicated to providing a harassment-free conference experience for everyone, regardless of gender, age, sexual orientation, disability, physical appearance, body size, race, or religion (or lack thereof). We do not tolerate harassment of conference participants in any form. Sexual language and imagery is not appropriate for any conference venue, including talks, workshops, parties, Twitter and other online media. Conference participants violating these rules may be sanctioned or expelled from the conference without a refund at the discretion of the conference organizers.
Get Social
RSS
Facebook
Twitter
Google +1
LinkedIn
Youtube