When:
October 31, 2017 – November 3, 2017 all-day
2017-10-31T00:00:00-06:00
2017-11-04T00:00:00-06:00
Where:
Seattle WA
PASS Summit 2017 *Datalere will give 4 presentations at this year’s PASS Summit*

Datalere’s Carlos Bossy, Gabriel Villa and Marc Beacom will provide four presentations at this year’s PASS Summit.

Data Science Tips and Tricks using R and SQL

Speaker(s): Carlos Bossy
Duration: 75 minutes
Track: Analyze
The practice of Data Science has arrived and as data professionals we’re on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, we will start by providing an introduction to R, the defacto programming language for data scientists. Carlos will then cover predictive analytics using T-SQL and R, providing a practical understanding of what it takes to develop your own predictive models making the most of the expertise you already have. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into a BI environment.

Implement a complete Business Intelligence Solution in the Cloud

Speaker(s): Carlos Bossy
Duration: 75 minutes
Track: Design

The Azure cloud has matured to the point where a complete Business Intelligence solution can be designed and developed in the cloud. The ability to create dashboards and scorecards, perform what-if analysis, data science, data movement and advanced analytics, makes the cloud a natural place to build out an analytics environment. The availability of a rich set of cloud-enabled tools and platforms today, including Azure Data Warehouse, Analysis Services, Data Lake, PowerBI, Machine Learning, Data Factory, and many more, has made it a choice to consider for data architects. This session will demonstrate how to bring these tools together to develop a full BI solution, while understanding the cost and challenges. In addition to live demonstrations, Carlos will discuss data architectures and strategies that would benefit by using these new technologies. Come see some of these new features in action, allowing you to determine if it’s right for you and your architecture.

Two Guys and a Transformation: ETL Best Practices and Techniques

Speaker(s): Gabriel Villa, Marc Beacom
Duration: 75 minutes
Track: Design

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gain helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.

Know Your Options: Databases on Amazon Web Services

Speaker(s): Gabriel Villa
Duration: 75 minutes
Track: Design

Are you considering to move your databases to Amazon Web Services but unsure of your options? Understand the possibilities to leverage Infrastructure as a Service and Platform as a Service and what is the best for cloud solution your situation. Gain insights from years of lessons learned to minimize your maintenance and costs. Discover scaling possibilities for relational and NoSQL databases to petabyte size demands. I will demonstrate how to get started with the basics of managed services and platforms for running databases on AWS. DBAs, hear how to use managed relational databases such as MS SQL Server with minimal administration. Architects, Developers, DBAs, Managers or IT Professionals, discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.