Datalere Supports Data Science in the DTC and Denver SQL Server User Group Datalere contributes to the tech community sponsoring SQL Saturdays Datalere participates and has a member on the board of the tech community

Datalere is committed to the tech community. Datalere supports the tech community as participants, sponsors, and volunteers for local, regional and national tech community events. Our consultants have experience delivering technical talks and presentations, varying in cutting edge topics. Additionally, some consultants have held current and past board members of professional associations. Datalere supports local Meetups, the Professional Association of SQL Server and The Data Warehouse Institute, just to name a few.

Tech Community Events

If you want to run into Datalere, here are some future events you may find presenting or sponsoring.

Sep
5
Tue
SQL Lunch @ Slattery's Irish Pub
Sep 5 @ 11:30 am – 12:30 pm
SQL Lunch @ Slattery's Irish Pub

SQLunch is intended to be an relaxed, comfortable atmosphere for questions, networking, and everything social that we can’t cover in presentations! This is also a great opportunity to meet your fellow members and board members while enjoying lunch. Please join us at one of the following event:

SQLunch

Slattery’s Irish Pub (located in Landmark)

5364 Greenwood Plaza Blvd
Greenwood Village, CO 80111-1932
(303) 741-2115

http://slatteryspublichouse.net

*** Upon arriving, ask for “Denver SQL” at the front. ***

In the event that the restaurant cannot meet our size requirements, we may split into smaller groups. Keep in mind that DenverSQL will not be covering any of the lunch cost.

Sep
12
Tue
Data Science in the DTC – September 2017 @ Innovation Pavilion
Sep 12 @ 6:00 pm – 8:00 pm

Speaker, Title and Abstract: TBD

 

Sep
16
Sat
SQL Saturday Denver @ Denver University
Sep 16 all-day
SQL Saturday Denver @ Denver University

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, and Analytics

Oct
3
Tue
SQL Lunch @ Slattery's Irish Pub
Oct 3 @ 11:30 am – 12:30 pm
SQL Lunch @ Slattery's Irish Pub

SQLunch is intended to be an relaxed, comfortable atmosphere for questions, networking, and everything social that we can’t cover in presentations! This is also a great opportunity to meet your fellow members and board members while enjoying lunch. Please join us at one of the following event:

SQLunch

Slattery’s Irish Pub (located in Landmark)

5364 Greenwood Plaza Blvd
Greenwood Village, CO 80111-1932
(303) 741-2115

http://slatteryspublichouse.net

*** Upon arriving, ask for “Denver SQL” at the front. ***

In the event that the restaurant cannot meet our size requirements, we may split into smaller groups. Keep in mind that DenverSQL will not be covering any of the lunch cost.

Oct
10
Tue
Data Science in the DTC – October 2017 @ Innovation Pavilion
Oct 10 @ 6:00 pm – 8:00 pm

Speaker, Title and Abstract: TBD

 

Oct
31
Tue
PASS Summit 2017
Oct 31 – Nov 3 all-day
PASS Summit 2017

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.

Nov
7
Tue
SQL Lunch @ Slattery's Irish Pub
Nov 7 @ 11:30 am – 12:30 pm
SQL Lunch @ Slattery's Irish Pub

SQLunch is intended to be an relaxed, comfortable atmosphere for questions, networking, and everything social that we can’t cover in presentations! This is also a great opportunity to meet your fellow members and board members while enjoying lunch. Please join us at one of the following event:

SQLunch

Slattery’s Irish Pub (located in Landmark)

5364 Greenwood Plaza Blvd
Greenwood Village, CO 80111-1932
(303) 741-2115

http://slatteryspublichouse.net

*** Upon arriving, ask for “Denver SQL” at the front. ***

In the event that the restaurant cannot meet our size requirements, we may split into smaller groups. Keep in mind that DenverSQL will not be covering any of the lunch cost.

Nov
14
Tue
Data Science in the DTC – November 2017 @ Innovation Pavilion
Nov 14 @ 6:00 pm – 8:00 pm

Speaker, Title and Abstract: TBD

 

Dec
5
Tue
SQL Lunch @ Slattery's Irish Pub
Dec 5 @ 11:30 am – 12:30 pm
SQL Lunch @ Slattery's Irish Pub

SQLunch is intended to be an relaxed, comfortable atmosphere for questions, networking, and everything social that we can’t cover in presentations! This is also a great opportunity to meet your fellow members and board members while enjoying lunch. Please join us at one of the following event:

SQLunch

Slattery’s Irish Pub (located in Landmark)

5364 Greenwood Plaza Blvd
Greenwood Village, CO 80111-1932
(303) 741-2115

http://slatteryspublichouse.net

*** Upon arriving, ask for “Denver SQL” at the front. ***

In the event that the restaurant cannot meet our size requirements, we may split into smaller groups. Keep in mind that DenverSQL will not be covering any of the lunch cost.

Dec
12
Tue
Data Science in the DTC – December 2017 @ Innovation Pavilion
Dec 12 @ 6:00 pm – 8:00 pm

Speaker, Title and Abstract: TBD