Class Project: Create Your Own World Bank GDP Report

In this class project, you'll apply what you've learned to create your own customized GDP report using real-world data from the World Bank. This hands-on project is designed to help you practice key skills in data transformation and visualization while building something you can proudly showcase.

Project Objectives:

Transform Data with Power Query:
Use Power Query to clean, organize, and prepare the raw World Bank GDP dataset for analysis. This is an essential skill for handling messy data and turning it into something usable for reporting.
Build a Visual Report:
Design a compelling report featuring three distinct types of visuals (e.g., bar charts, line graphs, and maps) to present your findings. Make sure the visuals are clear, relevant, and visually engaging.

Resources Provided:

Raw Data: Use the World Bank GDP Data as your starting point.
Pre-Prepared Dataset: If you run into challenges while transforming the raw data, I’ve attached the dataset I used during the lesson. Feel free to use this to continue building your report.

Sharing Your Work:
Once you’ve completed your report:

Upload screenshots or a PDF of your visuals.
Share a brief summary of your process: What did you find challenging? Which visuals worked best for your report?

Tips for Success:

Focus on storytelling: What insights can you highlight from the data?
Experiment with visuals: Think about the best way to convey trends, comparisons, or geographical insights.
Stay creative: Customize your report with colors, labels, and layouts that make your work stand out.

Need Help?
If you have questions or run into any issues while working on the project, feel free to ask for support in the discussion section. I’m here to help you succeed!

Let’s see your creativity and data skills in action—happy reporting!

Ajit Devrukhkar

1

2