Next week is my first installment of live training offered through O’Reilly Media’s online platform. I’m so excited to partner with this outstanding organization to deliver workshops on business analytics.

My first two courses will offer a unique perspective on SQL and R. For each, I will start with a data concept as demonstrated in Excel, then move into its equivalent in each of these tools.

Through this method, I hope to show how much spreadsheet users already instinctively understand about data — that rather than “giving up on bad habits,” working with these tools from an existing “mental model” of spreadsheets is a huge advantage.

Below are the course descriptions. Read the full schedule at the link.

• SQL-Powered Excel for Business Analytics: Structured Query Language (SQL) is the primary language used for accessing and managing data in a relational database system. Analysts, project managers, and other professionals want to make informed decisions using large datasets, but often have to request IT staff to perform these data retrievals. By relating the foundations of SQL to everyday Excel tasks, professionals will be empowered to perform their own data analysis and exploration on databases.
• R-Powered Excel for Business Analytics: R is an open-source programming language widely used for statistical and data analysis. Project managers, analysts, and other professionals want to make informed decisions using data, but may run into limitations using Excel for advanced, reproducible analysis. By relating the foundations of R to everyday Excel tasks, professionals will be empowered to perform data analysis and exploration in R.

I hope to see you there — O’Reilly’s platform is required to register, but there’s so much in store when you do. If you can’t make this week’s workshops, I will be offering them again in November.

Learn more about my approach to data education here.