Imagine this: You've just joined a fast-growing analytics team at a major retail organization. The team is swamped with data projects, and your supervisor, Karen, has tasked you with solving two critical data challenges on your first day. Your success in handling these tasks efficiently will prove you can leverage AI to simplify complex, tedious processes and set you up for success in future projects.
You and your teammate will need to rely on AI tools and Excel to complete these tasks within 45 minutes. The clock is ticking, and your solutions will show whether you can meet the expectations of a fast-paced analytics environment. Good luck!
Scenario:
Karen assigns you a major data consolidation project. You have 99 Excel worksheets, each containing survey data, and you need to aggregate this into a single master sheet. Manually copying and pasting the data would take forever, so your job is to automate the process.
Your challenge:
Use GenAI tools of your choice (or anything you like) to help you figure out the solution to automate the aggregation of data from Sheet 1 into Column A, Sheet 2 into Column B, and so on.
This task will likely become a recurring one, so the solution you develop should be scalable and repeatable.
Last update: Nov 24, 2024