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.

Solution: Plan an analytics project with AI assistance

Solution: 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

Solution: Plan an analytics project with AI assistance

“

(upbeat music) - [Instructor] To tackle this challenge, we'll start by generating a synthetic data set using Microsoft Copilot. Since we can't use actual sales data due to confidentiality agreements, we'll create a data set that closely mirrors real world scenarios. All instruct Copilot as follows, with the prompt found in the document, in the exercise files for this chapter. We're going to ask for a synthetic data set with 1000 records. We have the columns that we want. We have examples for those columns. We are asking for realistic distributions and some examples there. We are also asking for random seats for reproducibility. Let's run, as expected, Copilot provides a Python script here to generate the data. It looks like in this case, the faker package is actually not used. However, there are some other popular Python packages being used here, and again, if you're not familiar with Python, executing and running and downloading these scripts, feel free to use generative AI to help…

Contents