University Challenge

Help Europe have a future of clean air

Europe has actively committed to improving air quality, setting its course toward a more sustainable future. Through various initiatives, EU member states have managed to reduce pollution and promote the use of clean and renewable energies. Your challenge is to dive deep into these efforts, uncovering achievements and areas of opportunity while focusing on specific country-centric analysis. Our inaugural Denodo University Challenge is open just for EMEA students (T&C)

Light breath

Europe works on sustainable progress, pushing for a cleaner, greener environment. Your challenge is to combine different datasets to fully grasp the sources, trends, and patterns of better air quality. While you have the liberty to analyze any number of countries, it’s advisable to concentrate on those that are most pertinent to our objectives; nations that highlight on exploiting renewable energies and enhancing air quality.

Dive deep to:

Carefully integrate the provided datasets, addressing disparities in data structures, formats, and units to create a unified foundation. Use Denodo Express.
Combine the integrated data to achieve a unified view of Europe’s energy landscape, considering the unique and relevant attributes of each dataset. Use Denodo Express.
Identify possible relations between Greenhouse gas (GHG) emissions, the use of renewable energies as a primary energy source, and the share of electricity generated from renewable resources. Use PowerBI Desktop.
Utilize advanced data visualization techniques from interactive graphs to detailed maps and insightful diagrams to present and share your findings. Use PowerBI Desktop.

These are some questions that can guide your analysis:

Which EU countries have shown the most significant progress in emissions reduction over the last decade?
Does the increase in the use of renewable energies relate to the improvement in air quality across different countries? If so, how?

Datasets

Energy consumption from renewable sources

Source: Eurostat

Statistical data illustrating the uptake and usage of energy derived from renewable resources within European countries. Highlights the region's shift towards sustainable energy solutions and trends.

Share of electricity from renewable sources

Source: OurWorldInData

Dataset detailing the global reliance on renewable energy sources for electricity generation. This dataset illustrates the international trajectory towards sustainable energy practices.

Greenhouse gas emissions

Source: Eurostat

Statistical data about the emissions of greenhouse gasses across European countries. Offers an in-depth view of the environmental impact and trends within the European region.

To assist with combining information from Our World in Data and Eurostat databases, it is recommended to download the following dataset

Deep Breath

We encourage you to also explore Eurostat and Our World in Data (or any other source with public information) to find more data on initiatives that member states have implemented to improve air quality.

This iteration is open for you to research more information apart from the datasets provided in “Light Breath” iteration. These questions can be used as a guide in the research but you are encouraged the ask and answer your own questions:

Which nations lead the transition towards electricity from renewable sources, and what tactics or policies have they implemented to achieve these feats?
Based on the analyzed databases, what other efforts have contributed to significant improvements in air quality in certain countries?

Below are some examples of additional databases that might be of interest:

Deliverables

The submission of the findings and conclusions must contain:

Denodo VQL exported from the Denodo Express.
Power BI (.pbix) with the reports and analysis done.
Slides with details of the implementation: Maximum of 5 slides to show the process:

Data Integration and Management in Denodo
Data Treatment and Visualization in PowerBI
Link to the additional sources used and explanation of the reasons for being selected.
Conclusions obtained.

Video explanation of the slides (2-3 minutes)
Source code or script (if any)

Evaluation

Evaluation criteria

Data Collection (15 points)
New, useful and reliable datasets added by the participants.
Data Integration (15 points)
Data integration process followed to connect to the predefined and additional datasets including the creation of the base views.
Data Manipulation (15 points)
The execution of relational algebra operations and optimization strategies to generate final views using the predefined datasets.
Optimization (10 points)
Optimization techniques to generate final views.
Data Treatment & Efficiency (10 points)
Streamlining data quality and enhancing visualization performance.
Insights Level (20 points)
Showcasing innovative data visualizations for insights, usefulness, and intuitiveness.
Submission (15 points)
Clear and concise transmission, structured documentation and reproducibility.

Prizes and Recognition

Prizes are awarded to the three top-performing teams and to the university that presents the highest number of teams.

Prices:

1st Place: Access to on-demand Denodo training courses and certification exams for 6 months; Amazon gift card worth €600 for the team; Exclusive Denodo Winner Badge; Invitation to the EMEA DataFest.
2nd and 3rd Place: Access to on-demand Denodo training courses and associate certification exams for 6 months; Denodo eco merchandising.
University Prize: 15 certification exams for their students.

Submission

For the submission of the challenge the Captain of each team will need to use the form below. Remember the submission deadline is 8th October, 2023 at 23:59 pm CEST.

For any question or if any change is needed in the teams, use the “Contact Us” button. Changes in teams will be considered on a case-by-case basis.