By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

TDWI Chicago Update

At TDWI, we have been working hard to navigate this ever-changing landscape in the face of COVID-19, and we want to assure you that the health and well-being of our employees, customers, and vendor partners is our top priority. Therefore, due to the growing concern around the coronavirus (COVID-19), and in alignment with the guidelines laid out by the CDC and WHO, we have decided to merge this year’s TDWI Chicago Conference (May 10-15) with TDWI Orlando 2020 (November 8-13), where it can be a successful experience for everyone. The Chicago 2020 agenda will be replicated at TDWI Orlando 2020.

Our registration team will be in contact with individual registrants and sponsors directly.

Course Description

M3 Hands-on: Business Analysis for Everyone with Excel—Becoming a Data Detective Made EasyNEW!

May 11, 2020

9:00 am - 5:00 pm

Duration: Full Day Course

Level: Beginner to Intermediate

Prerequisite: Students must set up their laptops in advance

Caitlin Johnson

Data Scientist

Schedulicity

David Langer

VP of Analytics

Schedulicity

As more organizations aim to harness the power of data-driven decisions, the demand has soared for data-literate professionals who can dive into and analyze data. In this hands-on course, you will learn foundational skills to robustly analyze business data and become a valued data detective.

Many find the prospect of gaining data literacy skills intimidating as they assume that learning advanced statistics is required—not true!

In this class you will learn all the fundamentals of robustly analyzing business data using Excel. No fancy Excel functions or complex calculations are required—we promise!

We will teach you a tool as simple as it is powerful: the process behavior chart. The process behavior chart is a visual tool uniquely suited for the data detective that allows you to answer questions such as:

  • Given historical business performance, what should we reasonably expect to see in the future?
  • We’ve implemented a new business initiative (e.g., an incentive plan). Is the initiative really working?
  • Is the business performance of Division A actually superior to the business performance of Division B?

With your newly acquired skills you will be positioned to become not only a data-literate detective but also a trusted advisor providing rigorous, compelling insights into the multitude of KPIs, dashboards, and scorecards so common in today’s organizations.

Want to know the best part? No programming or difficult mathematics are required!

You Will Learn

  • Basic data concepts: summaries and visualizations
  • Why business data often requires a different style of analysis
  • Data analysis fundamentals
  • The process behavior chart
  • How to build process behavior charts in Excel
  • How to rigorously identify trends/patterns in business data
  • How to rigorously compare groups/collections of business data
  • How to communicate your insights effectively
  • Additional resources to extend your learning

Geared To

Business/data analysts, database developers, BI/report developers, managers, and anyone else interested in developing their data literacy

No skills in programming or statistics are required

We make no assumptions about your level of data literacy!

Laptop Setup

Students must bring their own laptop to the class.

Participants should download and install the following BEFORE the event:

  • Microsoft Excel

Laptop setup is required BEFORE the conference.

There is no time allotted in class for laptop preparation.

* Enrollment is limited to 60 attendees.