Search for question
Question

Assignment #1 This assignment requires you analyze data about electricity demand and production in 28 European countries from 2000 to 2020. The data for this assignment is contained in the

Excel file "Europe_Power_Gen". There are four variables: ● ● ● Year: The year the electricity was generated or used Country: Country name (28 values) Category: The demand for electricity, or the source/method used to generate electricity: O Demand -Total electricity demand for a given country and year o Bioenergy - Derived from recently living organic materials (renewable energy source) Coal - Carbon-based sedimentary rock burned to produce power (fossil fuel source) Gas Natural gas burned to produce power (fossil fuel) Hydro - Fast moving water spins turbine blades to generate power (renewable) Nuclear - Use of nuclear reactions to produce electricity (some people consider this "green") Other fossil - Fossil fuels other than coal or gas Other renewables - Renewable power sources other than bioenergy, hydro, solar, or wind Solar - Manufactured cells transform sunlight into electricity (renewable) Wind - Wind spins turbine blades to generate power (renewable) Generation (TWh) - amount of electricity generated or used (in terawatt hours) Demand for a given country and year is typically met by the sources/methods listed for that country in that year. That is, the value for Demand (listed in the Generation column) equals the sum of the values for the nine listed sources/methods (Demand = Bioenergy + Coal + + Wind). If electricity demand for a given country and year was not met by the sources listed, the untry imported the remaining power. If a country produced more than it needed, it exported the rest. A negative number for generation means that the country exported that amount of electricity from that source/method. Do not make any modifications to the Excel file. Perform any calculations, filtering, etc. in Tableau. Assignment Instructions 1. Use Tableau Desktop to create a visualization that shows the viewer how European electricity demand and/or production has changed over the years 2000 to 2020. Determine an interesting message or "story" contained in the data. That is, what observations and/or information are most important to show the reader? Determining what is most important is ultimately up to you, but it should be something that you consider significant, surprising, and/or unexpected. Perform your own analysis and create a visualization that conveys your findings effectively. Create the visualization for a general audience, but one that understands the variables and their values. 2. Create a static visualization – either a choropleth map or line chart. You do not have to use all of the countries, but you must use at least five of them. You may use a calculated field if desired. Do not add any additional data (anything that is automatically generated by Tableau can be used). Do not use customized tooltips or animations since this will be a static visualization. You may group related data values together (any groups that you create should be clearly noted on your visualization). You can also filter your data as needed or desired (the filter will not be displayed on the visualization graphic). 3. Follow the guidelines for good visualization design discussed in class and summarized on the slides. Implement your chart carefully. For example, use appropriate colors, titles, axis labels, legends, data labels, and notes to the reader (if needed). Ensure that the reader can quickly recognize and understand what you are trying to show them. Format any legends appropriately. Don't feel that you need to create an overly complex chart – sometimes simpler charts are most effective. Do provide a good title to help guide the reader in what you are showing with your visualization. 4. Generate an image file (.jpg) of your visualization (use Dashboard/Export Image). Be sure to leave the boxes for caption and legend checked. Also create a Tableau .TWBX file that contains your worksheet and the data. Upload these two files to Canvas by the assignment deadline. Double-check your submission in Canvas to ensure that you have uploaded the required files in the proper formats, and that the files were submitted successfully. 5. This assignment will be graded on a scale of A, B, C (potentially with a plus or minus). Items that will factor into your grade include 1) the type of chart used, 2) how well it effectively conveys the data, 3) how well the visualization is implemented, 4) well-written titles, legends, axis labels, data labels, and notes (as applicable), 5) good and proper use of color, 6) following the instructions above, and 7) attention to detail./nDescription Download the attached Excel data set along with the PDF file, which contains assignment instructions. Perform your data analysis using Tableau Desktop. When you are finished, upload the completed files specified in the instructions. Comment

Fig: 1