Loading...

Course Description

The degree to which business decisions are informed is dependent on the accuracy of related analytics reports, which requires that you assess performance regularly using the latest data. Standardized SQL code is often implemented to ensure that summary reports are up to date for businesses, but this process can be a challenge for teams.

Instead, in this course, you will assess how to extract insights from data more efficiently using a variety of new tools. You will work with time-stamped data and explore how large, intricate queries can be simplified and more easily debugged. Along the way, you will discover how to approach queries using conditional logic and temporary tables, empowering you to resolve complex problems efficiently.

The following courses are required to be completed before taking this course:

  • Exploring Data
  • Integrating Data From Multiple Tables

Faculty Author

Vishal Gaur

Benefits to the Learner

  • Create expressions to clean and manipulate dates and date calculations
  • Use conditional logic to clean messier types of data and distill useful information from raw data
  • Write complex, multi-step queries using temporary tables to answer more intractable business problems

Target Audience

  • Business analysts
  • Professionals who work with databases or data warehouses
  • Managers using data insights to make business decisions
  • Marketing analysts
  • Product analysts

Applies Towards the Following Certificates

Loading...
Cornell Johnson Graduate School of Management
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .