From the course: Enhancing Excel with Generative AI Tools

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Challenge: Plan an analytics project with AI assistance

Challenge: Plan an analytics project with AI assistance

From the course: Enhancing Excel with Generative AI Tools

Start my 1-month free trial Buy for my team

Challenge: Plan an analytics project with AI assistance

“

(upbeat music) - [Instructor] This challenge is designed to help you consolidate everything you've learned about leveraging AI tools for data visualization, framing analytics problems, generating synthetic datasets, and using free AI tools to resolve tasks. Imagine you're a data analysts working for a mid-size retail company that operates both online and through physical stores. Your manager has tasked you with analyzing sales data to identify trends and opportunities for increasing revenue. However, due to confidentiality agreements, you cannot use the actual sales data with external, free AI tools. Your challenge is to generate a synthetic dataset that closely mirrors real-world data, use AI tools to conceptualize effective visualizations and frame your analytics problem to align with business objectives. Begin by using an AI tool, like Microsoft Copilot, to generate a synthetic dataset. The dataset should include 1,000 records with the following columns, Transaction ID, Date of…

Contents