I’m excited to share that I have two new O’Reilly Online Learning courses coming up in April 2020:
First Steps with Power Query for Microsoft Excel
Course description:
Power Query is a Microsoft extract, transform, and load (ETL) technology that enables users to access data from structured and unstructured sources, reshape it, and load it into Excel workbooks.
Analysts, researchers, and project managers want to build repeatable data cleaning processes on large datasets. Rather than write complex Excel formulas or programs in Visual Basic for Applications (VBA), these users can conduct their work in Power Query with no coding required.
The focus of this course will be using Power Query to transform tabular data sources into tables that are ready for data analysis. By the end of the course, users will be able to pivot, filter, and merge data so that it’s ready for analysis in Excel.
Read the full course summary and agenda on the O’Reilly Online Training platform.
Excel Statistics for Business Analytics
Course description:
Inferential Statistics involves inferring parameters of a population based on the values of a sample. Professionals in e-commerce, manufacturing, and other industries use inferential statistics as the basis for decision-making.
Conducting their work in Excel, participants will take a hands-on approach to conducting statistical inference. By the end of this course, users will be able to organize, present, and draw valid conclusions from data, using inferential statistics for business impact.
Read the full course summary and agenda on the O’Reilly Online Training platform.
I hope to see you there. Access to these workshops (along with so many others, even daily) is open to all subscribers to the O’Reilly Learning platform.
Leave a Reply