A solution to last week’s challenge can be found here. As the world grapples with the transition to more sustainable energy production, nuclear energy is often forgotten despite the many reactors that exist in countries all over the world. Use the provided datasets to generate a report giving a high level overview of the world's current nuclear capacity. Use the 4 files containing nuclear reactor data to create a report including the following: * A map showing the locations of reactors with a status of: "operational", "under construction", or "planned" (only include reactors with a set location) * A table listing - by country - the number of operational reactors, the total capacity of those reactors, and the most common type of operational reactor. (only include reactors presented in map) Dataset from www.kaggle.com Designer Version Used to Create: 2018.4 challenge_223_start_file.yxzp challenge_223_solution.yxzp

Great Challenge. My Solution attached. I found the map not so good at zooming in ? challenge_223_JB.yxmd

Solved! Spoiler challenge_223_Carolyn.yxzp

Challenge #223: Going Nuclear

A solution to last week’s challenge can be found here.

As the world grapples with the transition to more sustainable energy production, nuclear energy is often forgotten despite the many reactors that exist in countries all over the world. Use the provided datasets to generate a report giving a high level overview of the world's current nuclear capacity.

Use the 4 files containing nuclear reactor data to create a report including the following:

A map showing the locations of reactors with a status of: "operational", "under construction", or "planned" (only include reactors with a set location)
A table listing - by country - the number of operational reactors, the total capacity of those reactors, and the most common type of operational reactor. (only include reactors presented in map)

Dataset from www.kaggle.com

Designer Version Used to Create: 2018.4

challenge_223_start_file.yxzp

challenge_223_solution.yxzp

Join

Preparation

Advanced

Data Analysis

Intermediate

Transform

Accepted answers

All comments

Blake

That challenge was a blast!

Spoiler

Check out my video walk through below :

Spoiler

challenge_223_start_fileBH.yxzp

dsmdavid

Spoiler

david_223.yxzp

Aaron_Harter

I was able to complete the solution without a Meltdown!

Spoiler

challenge_223_AB Data_Aaron.yxzp

johnemery

Fun challenge. Not particularly difficult, but it has many elements that were a pleasure to string together. It's also always good practice to use reporting tools.

Spoiler

View my solution video here:

Spoiler

Challenge 223 jemery solution.yxzp

sonyakasenkramer

This was a fun one 🙂

Spoiler

challenge_223_SKK.yxmd

RolandSchubert

Spoiler

Not really difficult, but an opportunity to use reporting tools.

challenge_223_solution_rsc.yxmd

phottovy

challenge_223_ph_solution.yxmd

kat

Spoiler

Challenge #223.yxzp

Kenda

Spoiler

challenge_223_start_file.yxmd

JustinBabbitt

So many datasets to use this with Health care, Pollution, Cost of living...

Spoiler

challenge_223_Complete_MissionBI.yxmd

AngelosPachis

My solution for challenge #223

Spoiler

Output :

Spoiler

challenge_223_solved_AP.yxzp

etzele

Nice challenge, good to stay enganged regarding spatial and reporting!

Spoiler

challenge_223_solution.yxmd

Ladarthure

my solution

challenge_223_start_file.yxmd

ChloeL-H

This is a fun one!

Here is my solution:

Spoiler

Here are my results:

Spoiler

Challenge_223_Solution.yxmd

cplewis90

So many witty puns to insert in so little time so instead I have gone fission 🙂

Spoiler

challenge_223_CL.yxmd

unknown

Fun one!

Spoiler

challenge_223_start_file-Qiu.yxmd

Sudha8990AI

Good One! Learned how to use the legend effectively

223.pdf

223_WC.yxmd

hamza_khan

This challenge was tough. I had no idea how to create maps. Had to take some inspiration from @Blake 's solution as to how to create maps.

challenge_223_start_file.yxmd

TonyA

Finally got a chance to look at this! Fun challenge, but after doing this I definitely want to investigate the Map Legend manipulation tools to see how much I can customize the legend.

I feel like I used more tools than necessary -- interested in looking at other solutions.

Spoiler

By the way, I tried this with the AMP engine and did get the same results except for Finland, where there were two each of two types of reactors so there was a tie for most common type. E1 consistently picked "Boiling Water" and AMP usually went with "Pressurized Water." (This could be disambiguated by extending the sort before the last Summarize to include Total Capacity.)

challenge_223_TonyA.yxmd

DaisukeTsuchiya

Spoiler

challenge_223_start_file_DT.yxzp

grazitti_sapna

Hi, Solution to Challenge 223.

Spoiler

challenge_223_Solution_GS.yxzp

paulfound

Spoiler

challenge_223.yxmd

JohanRanschaert

Spoiler

My solution in attach.

Remark : Finland has 4 reactors, 2 of each type.

and the 1st one is taken in the report as most common.

challenge_223_solution_JR.yxmd

patrick_digan

Spoiler

challenge_223_start_file.yxmd

balajilolla

Spoiler

Solution Attached

challenge_223_start_file.yxmd

FlorianC

Great exercise to demonstrate how to use the spatial and reporting tools.

Spoiler

Workflow

Report

Challenge #223.yxzp

vsetia46

This problem is Amazing. I enjoyed it 🙂

Here is my Solution.

Spoiler

challenge_223_solution_varun.yxmd

ccadwell

Starting to get a little more comfortable with the map tool.

Spoiler

challenge_223_solution_file.yxmd

bbaker

Challenge complete.

Spoiler

Output:

Flow:

challenge_223_bbaker.yxzp

ggruccio

Like @JohanRanschaert , I ran into an issue with Finland where two types tied for most common. I thought maybe there was an error in the data and forced them to all be Boiled Water.