Data Hiker's Pub

Mastering Excel Spreadsheets - Data Hikers Pub
This Meetup brings the spreadsheet community together to encourage mastery of Excel while exploring advanced concepts in automating. We'll discuss complex workflows commonly stuck in manual spreadsheets, impeding productivity and crowding out more meaningful work. Python, SQL, AI, and related technologies will be introduced to provide a full landscape of options for business professionals determined to leverage IT best practices for solving business problems. Audience can send in questions for special use cases and problems to solve as a group.

3rd Tuesday, 10am to 11am PST

Agenda Schedule:

Feb - Automation Stages with Excel - Visualizing the strategy behind our spreadsheets tactics.
Mar - What Everybody Should Know About Excel - Basics in a Nutshell
Apr - Key functions: V/H/Xlookup, Sumifs, Index/Match and their various use cases - Spreadsheet like it was a database!
May - Macros, VBA to Javascript to Python
Jun - Meeting cancelled
July- Data Centric Spreadsheets/Emerging Spreadsheet Technologies
Aug - Using Sumifs() for Data Centric Spreadsheeting
Sep - UX Design - Making Art Through Constraints
Oct - Let’s Make Excel Better (Community Addin Project)
Nov - Show and Tell, Spreadsheet Successes to Inspire
Dec (2nd wk) - The One with all the Favorite Tips and Tricks

AGENDA:
10:00 AM: Sign-on, catch up, and network (virtually)
10:15 AM Topic: Continued SQL Approaches
10:50 AM: Q&A and Social, sign-off

SQL Fundamentals - Data Hikers Pub
11 courses in all. You will be provided with hands-on experience, covering the basics of SQL with help and insight from industry experience and even AI. Key concepts will be emphasized to help business professionals and new developers understand the data world and its opportunities.

3rd Wednesday - 10am to 11:30am PST

| | Agenda Schedule - SQL Fundamentals |
| --- | ---------------------------------- |
| Feb | Select, From, Aliases, Simple Joins and Order By |
| Mar | Distinct, Top, Where and Indexes |
| Apr | Aggregates (Group By), CTE, and Subqueries |
| May | Temp Tables and Table Variables |
| Jun | Data Types, Nulls and Type Conversions |
| Jul | Try/Catch and Transactions |
| Aug | Scripting your DB to GIT, GIT concepts |
| Sep | Dynamic SQL and SQL Injection |
| Oct | XML, JSON and SQL |
| Nov | Stored Procedures, Views, Functions |
| Dec (2nd wk) | Security and Disaster Recovery |

AGENDA:

12:00 PM: Sign-on, catch up, and network (virtually)

12:15 PM Topic: Continued SQL Approaches

1:15 PM: Q&A and Social, sign-off