Day of Data topics Day of Data topics Mon, 20 Sep 2021 02:33:38 GMT DayofData 2021-09-20T02:33:38Z Discussion with Charles Simonyi <P>Charles Simonyi, the leader of the original Excel team, will take over the Excel Twitter handle on December 8th for some Q and A. Let us know what you want to hear about on Twitter!</P> <P><A href="#" target="_blank" rel="noopener"></A></P> <P>&nbsp;</P> Wed, 02 Dec 2020 23:45:12 GMT Sharon910 2020-12-02T23:45:12Z Congratulations 🎉🎉🎉 <P>A big congratulations to&nbsp;<LI-USER uid="836771"></LI-USER>,&nbsp;the winner of our Day of Data visualization challenge! Chris made a beautiful visualization showcasing diversity in space. Here are some words from our judges about Chris's visualization: "Eye-catching!" "Love the technique with beeswarm." "A fantastic combination of eye-catching, engaging, and readable." "Love the visualization of people in space by gender."</P> <P>&nbsp;</P> <P>Check out Chris's visualization here: <STRONG><A href="" target="_blank" rel="noopener">Diversity in Space (Day of Data submission)</A></STRONG>.</P> <P>&nbsp;</P> <P>If you missed the announcement from Charles Simonyi, the leader of the original Excel team, check it out here! The Day of Data segment begins at 14:48. <STRONG><A href="#" target="_blank" rel="noopener">Day of Data event</A></STRONG>.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sharon910_0-1605723603695.png" style="width: 400px;"><img src=";px=400" role="button" title="Sharon910_0-1605723603695.png" alt="Sharon910_0-1605723603695.png" /></span></P> <P>&nbsp;</P> Wed, 18 Nov 2020 18:20:48 GMT Sharon910 2020-11-18T18:20:48Z Announcing challenge winner on November 18th! <P>We invite you to join us on November 18th at 9am PST for a conversation with Charles Duke and Charles Simonyi! We will be announcing the winner of the visualization challenge during the event. Visit <A href="#" target="_blank" rel="noopener"><STRONG></STRONG></A>&nbsp;to join.</P> <P>&nbsp;</P> <P>Mr. Duke was the tenth person to walk on the moon and remains the youngest person to ever walk on the moon. Mr. Simonyi is a two-time space tourist and led the team that created Microsoft Excel. We hope you can attend!</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DukeSimonyiEvent.png" style="width: 936px;"><img src=";px=999" role="button" title="DukeSimonyiEvent.png" alt="DukeSimonyiEvent.png" /></span></P> Wed, 18 Nov 2020 01:11:47 GMT Sharon910 2020-11-18T01:11:47Z That's a wrap! ✅ <P>Thank you all for participating in the Day of Data visualization challenge! Remember to vote for your favorite visualizations,&nbsp;<STRONG><A href="#" target="_blank" rel="noopener">tune in</A></STRONG> on November 18<SUP>th</SUP> to hear the results, and check&nbsp;back in this discussion space for more fun over the next few weeks!</P> Tue, 03 Nov 2020 08:00:22 GMT Sharon910 2020-11-03T08:00:22Z Answer to challenge questions 2 and 3 <P>Hi. This is Tanushree. I love working with Excel on different projects and fascinated with its immense capabilities. I have attempted to answer challenge questions 2 and 3 through a merged data using Power query. I found maximum stay at ISS happened in 2010 decade and dominated by United States and Russia. Further it is interesting to see that 1970 decade saw no female participation in space exploration and same for 2020 decade as of now. Here is my submission. Thanks!<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Day_of_Data_Infographic_Tanushree.PNG" style="width: 775px;"><img src=";px=999" role="button" title="Day_of_Data_Infographic_Tanushree.PNG" alt="Day_of_Data_Infographic_Tanushree.PNG" /></span></P> Tue, 03 Nov 2020 04:46:27 GMT tansubhash 2020-11-03T04:46:27Z Answer to challenge question #1 <P>Hi, I am Devashree. I enjoy exploring different types of datasets. I found this space dataset quite interesting and had fun building a dashboard in Excel for the same.&nbsp;</P> <P>My submission to challenge question 1 involves using a Pivot table on the merged dataset.</P> <P>It can be seen that although the space sector is quite underrepresented by females, 90s decade saw the maximum participation by female astronauts in the entire 1960-2020 period. So, here is my submission. Hope you find it interesting too!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Day_of_Data_Dashboard_Devashree.PNG" style="width: 999px;"><img src=";px=999" role="button" title="Day_of_Data_Dashboard_Devashree.PNG" alt="Day of Data Dashboard (DevashreeSM)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Day of Data Dashboard (DevashreeSM)</span></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 02 Nov 2020 20:31:22 GMT DevashreeSM 2020-11-02T20:31:22Z Answer to question#2 <P>As a response to Question No. 2, I have tried creating a visualization on a very simple dataset of Astronauts who visited the ISS. &nbsp;In my spreadsheet, I have just used some data sorting functions such as VLOOKUP and data filters and presented that information in a design form.</P> <P>Following information has been visualized in the design:</P> <UL> <LI>Nationalities of Astronauts</LI> <LI>No. of days spend by individual astronaut at ISS</LI> <LI>Gender distribution among each country</LI> <LI>Total No. of days spent by astronauts from individual countries</LI> <LI>Categorization of countries as per continents.</LI> </UL> Mon, 02 Nov 2020 19:40:16 GMT Richa_Patidar 2020-11-02T19:40:16Z 20th anniversary! 🎉 <P>Happy <STRONG>20th anniversary</STRONG> of humans living and working aboard the International Space Station!</P> <UL> <LI>Check out <STRONG><A href="#" target="_self">this video from MrExcel</A></STRONG>&nbsp;<LI-USER uid="10858"></LI-USER>&nbsp;showing what he has found in the <STRONG><A href="#" target="_blank" rel="noopener">space data set</A></STRONG>!</LI> <LI><STRONG>15 hours remaining</STRONG>&nbsp;in our visualization challenge. Post your entry in this discussion space!</LI> <LI><STRONG>1 hour&nbsp;</STRONG>until our live event with an astronaut. Tune in at <STRONG><A href="#" target="_blank" rel="noopener"></A></STRONG>.</LI> <LI>Looking for <STRONG>curated data sets</STRONG> to teach your students or family members about data? Check out our education resources at <STRONG><A href="#" target="_self"></A></STRONG>!</LI> </UL> Mon, 02 Nov 2020 17:17:41 GMT Sharon910 2020-11-02T17:17:41Z Answer to Question #4 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JavierReyna_0-1604210039760.png" style="width: 400px;"><img src=";px=400" role="button" title="JavierReyna_0-1604210039760.png" alt="JavierReyna_0-1604210039760.png" /></span></P><P>My wildcard is about Liftoff Mass</P><P>&nbsp;</P><P>I decided to visualize this because the space career consists now, not in how many humans you put on space, is about how many satellites you put on orbit and how many experiments you can also stablish there. And for both, you have to carry mass.</P><P>&nbsp;</P><P>Some interesting insights I found:</P><UL><LI>Europe is on 4 place, but seems that they have been retiring though time. Those space vehicules who helped them liftoff mass, are now retired, and they active ones, are not even the 20% of what they had lifted.</LI><LI>Ukraine got place 7th!, but seems it has retired from the lifting mass topic, because all of their vehicules are retired</LI><LI>Brazil, France &amp; UK seems they have abandoned the game. All their vehicules are retired.&nbsp;</LI><LI>US, Russia and China are the only ones who like lifting off mass with crew. They have big differences between them, but they do like a lot to put their men into space.</LI></UL><P>&nbsp;</P> Sun, 01 Nov 2020 05:56:29 GMT JavierReyna 2020-11-01T05:56:29Z Answer to question #2 <P>I created two columns so I can get all needed data on one table.&nbsp;</P><OL><LI>If it was already calculated the duration in days for all the ISS missions, and the instructions says that just to add one day after the launch date; I just substract 1 day to that previous calculation in order to get that number required</LI><LI>A simple Vlookup function to know their nationalities.</LI></OL><P>Then, with a pivot table, I summarize what was required. Filtering of course for just ISS.&nbsp;</P><P>And formatting with data bars.&nbsp;</P><P>Wow, you can be visually surprised of the big difference between US &amp; Russia against the other countries.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JavierReyna_0-1604209173799.png" style="width: 400px;"><img src=";px=400" role="button" title="JavierReyna_0-1604209173799.png" alt="JavierReyna_0-1604209173799.png" /></span></P><P>&nbsp;</P> Sun, 01 Nov 2020 05:42:37 GMT JavierReyna 2020-11-01T05:42:37Z Answer to question #1 <P>My name is Javier Reyna.&nbsp;</P><P>I like to make meaningful dashboards that help visualize and understand data.</P><P>&nbsp;</P><P>Here's my answer to question 1. I grouped the same type of spacecraft and divided by decade. Also I apply format bars on conditional formatting per decade so it can be better visualize the huge difference on the 70's &amp; 2010's.&nbsp;</P><P>&nbsp;</P><P>And also there are small tables per decade, so you can simplify the visualization of the pivot table.</P><P>&nbsp;</P><P>I end with I think is the most representative of all, the graphs bars. The are ordered like a podium. The first place (and the top 3) are centered on this podium, with a small representation of them.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JavierReyna_0-1604208251836.png" style="width: 999px;"><img src=";px=999" role="button" title="JavierReyna_0-1604208251836.png" alt="JavierReyna_0-1604208251836.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="JavierReyna_1-1604208283388.png" style="width: 999px;"><img src=";px=999" role="button" title="JavierReyna_1-1604208283388.png" alt="JavierReyna_1-1604208283388.png" /></span></P><P>&nbsp;</P> Sun, 01 Nov 2020 05:34:51 GMT JavierReyna 2020-11-01T05:34:51Z One week left! 💹📉📊 <P>Just <STRONG>one week remaining </STRONG>to the challenge. We’d love to see more charts and visualizations using the space data set! Found something interesting that doesn’t fit into one of the existing questions? Post it as a “wildcard”!</P> Mon, 26 Oct 2020 20:31:05 GMT Sharon910 2020-10-26T20:31:05Z Combine data on Power query <P>I'm trying to combine data from the folder. There is several txt files with the same format of data. Unfortunately there isn't unique column to be used for combining. I need to merge two columns before combining. We have new files twice a week so I cant do this manually. Can anyone help, please?</P> Tue, 20 Oct 2020 07:05:11 GMT zuzana008 2020-10-20T07:05:11Z Challenge questions 2: Show the nationalities of astronauts <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Q2.png" style="width: 999px;"><img src=";px=999" role="button" title="Q2.png" alt="Q2.png" /></span></P><P><BR /><A href="#" target="_blank" rel="noopener nofollow noopener noreferrer">Base Data.xlsx</A></P><P>2. Show the nationalities of astronauts who have visited the International Space Station. By country, show the total number of human-days on the ISS for each country. This only includes time spent at the ISS, not other space stations such as Skylab or Mir. Simplifying assumption: Assume the space travelers arrive at the ISS on the day after they launch.<BR /><BR /><BR /><BR /><BR /></P> Sun, 18 Oct 2020 19:54:02 GMT ExcelWizard 2020-10-18T19:54:02Z Challenge questions 1 <OL><LI>Show the number of astronauts who have launched on each launch vehicle in the dataset. Your visualization should include at least the top three spacecraft that carried humans to space. Bonus: which spacecraft was most prevalent for crewed missions in each decade from 1960's to 2020's?<BR /><BR /><A href="#" target="_blank" rel="noopener">Base Data.xlsx</A><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Q1.png" style="width: 999px;"><img src=";px=999" role="button" title="Q1.png" alt="Q1.png" /></span></LI></OL> Sun, 18 Oct 2020 18:55:38 GMT ExcelWizard 2020-10-18T18:55:38Z Diversity in Space (Day of Data submission) <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cmorenostokoe_0-1603044799960.png" style="width: 400px;"><img src=";px=400" role="button" title="cmorenostokoe_0-1603044799960.png" alt="cmorenostokoe_0-1603044799960.png" /></span></P><P>&nbsp;</P><P><STRONG>Abstract</STRONG></P><P>In the 59 years since the first space flight there has never been a year without a man in space. However, there have been 26 years without a woman in space. In fact, the peak gender diversity has not significantly improved since 1963. Furthermore, throughout most of history America has dominated space exploration but the new Millennium has seen more astronauts than even from regions such as Asia, South America and Africa.</P><P>&nbsp;</P><P><STRONG>Entry</STRONG></P><P>My name is Chris Moreno-Stokoe, I am a doctoral researcher from the University of Bristol, UK, and this is my submission for the Day of Data visualisation challenge. It started as an entry for category #3 (human days in space) but turned into a #4 wildcard exploration as I learned about diversity from exploring this dataset. I was surprised by what I learned and hope others will enjoy this too! In my workbook you can see my transformations and calculations made on the data to produce these visualisations.</P><P>&nbsp;</P><P>The background was modified from&nbsp;<A href="#" target="_blank" rel="noopener">Jeremy Perkins</A>' photo (Unsplash), all other art is copyright myself (@Chris Moreno-Stokoe).</P> Sun, 18 Oct 2020 20:50:25 GMT cmorenostokoe 2020-10-18T20:50:25Z Out-of-this-world visualizations 🌎📊✨🌠 <P><STRONG>Happy World Spreadsheet Day!!!</STRONG></P> <P>&nbsp;</P> <P>Try your hand at a space-themed visualization challenge, using the same data set at <A href="#" target="_blank" rel="noopener"><STRONG></STRONG></A> as we saw with trivia. <LI-USER uid="10858"></LI-USER>, “MrExcel,” offers three questions for your perusal. Choose one (or more) to visualize, or show us something awesome and unexpected with the wildcard challenge!</P> <P>&nbsp;</P> <P><STRONG>Post your answer as a new post in the Day of Data discussion space</STRONG> with the question you’re answering, a screenshot of your visualization, and a link to your Excel workbook. “Like” the visualizations others have posted that you think are super cool! The best visualization for each question (chosen using a combo of judging panel and popular vote) gets a shout-out from Microsoft and <STRONG>Charles Simonyi</STRONG>, the father of Excel and two-time space tourist.</P> <P>&nbsp;</P> <P><STRONG>Challenge questions:</STRONG></P> <OL> <LI>Show the number of astronauts who have launched on each launch vehicle. Your visualization should include at least the top three spacecraft that carried humans to space. Bonus: which spacecraft was most prevalent for crewed missions in each decade from 1960's to 2020's?</LI> <LI>Show the nationalities of astronauts who have visited the International Space Station. By country, show the total number of human-days on the ISS for each country. This only includes time spent at the ISS, not other space stations such as Skylab or Mir. Simplifying assumption: Assume the space travelers arrive at the ISS on the day after they launch.</LI> <LI>Show the distribution of human-days in space by decade. This includes all crewed spaceflights and stays at the Moon or any space station including Mir, Skylab, and the ISS.&nbsp;Optionally, add interesting Filters such as gender, launch site, astronaut nationality. Consider a way to show the 20 years of continuous space presence.&nbsp;</LI> <LI>Wildcard! Show us an interesting or surprising insight!</LI> </OL> <P>&nbsp;</P> <P>The challenge will run from October 17<SUP>th</SUP> 12am PDT to November 2<SUP>nd</SUP> 11:59pm PST. For more information, check out the blog post on the <A href="" target="_blank" rel="noopener"><STRONG>Day of Data visualization challenge</STRONG></A>. Good luck!</P> <P>&nbsp;</P> <P>Note: If you have any trouble accessing the data set, try our alternate location at <A href="#" target="_blank"><STRONG></STRONG></A>&nbsp;or use the file attached to this post. Thanks to the folks who let us know they were having trouble opening the file!</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dayofdata_withgraph.png" style="width: 936px;"><img src=";px=999" role="button" title="Dayofdata_withgraph.png" alt="Dayofdata_withgraph.png" /></span></P> Fri, 30 Oct 2020 16:51:40 GMT Sharon910 2020-10-30T16:51:40Z Space Trivia 🚀👩🏽‍🚀 <P>EDIT: Thanks Bill for a video with the answers! If you want to check out the answers to the trivia and how to get them, view the video here:&nbsp;<STRONG><A href="#" target="_blank"></A>&nbsp;</STRONG></P> <P>&nbsp;</P> <P>Let's do a warm-up with some space-themed trivia! <STRONG><A href="#" target="_blank" rel="noopener">Here's a data set</A></STRONG> of all the astronauts, rockets, launches, and space walks...can you answer these five trivia questions?</P> <P>&nbsp;</P> <OL> <LI><SPAN>How many space travelers have been on a mission that orbited the Moon? (Hint: Be careful... Jim Lovell orbited the moon on two missions, but he only counts as one traveler!)</SPAN><SPAN>&nbsp;</SPAN></LI> <LI><SPAN>Which astronaut had the most minutes of spacewalk (EVA) activity? How many minutes have they spacewalked? </SPAN><SPAN>&nbsp;</SPAN></LI> <LI><SPAN>Which astronaut has launched the greatest number of times? How many times did he or she launch? </SPAN><SPAN>&nbsp;</SPAN></LI> <LI><SPAN>Who is the woman with the most days in space? </SPAN><SPAN>&nbsp;</SPAN></LI> <LI><SPAN>How many people&nbsp;launched on&nbsp;the Space Shuttle and returned&nbsp;on&nbsp;a Soyuz spacecraft?</SPAN><SPAN>&nbsp;</SPAN></LI> </OL> <P>&nbsp;</P> <P>Shoutout to Excel MVP <LI-USER uid="10858"></LI-USER>, "MrExcel",&nbsp;&nbsp;for coming up with these questions! We'll follow up with the answers on October 17th, World Spreadsheet Day.</P> Sun, 18 Oct 2020 06:52:10 GMT Sharon910 2020-10-18T06:52:10Z Talk to NASA Astronaut Stephen Bowen! <P>Join a live event with NASA Astronaut Stephen Bowen in&nbsp;<STRONG>40 minutes</STRONG>, at <STRONG><A href="#" target="_self"></A></STRONG>. He will be joined by NASA propulsion engineer Erik Lopez and Blue Origin astrophysicist Christine Reilly for a panel discussion about space and the impact data has on each of their jobs.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sharon910_0-1602692432996.png" style="width: 400px;"><img src=";px=400" role="button" title="Sharon910_0-1602692432996.png" alt="Sharon910_0-1602692432996.png" /></span></P> <P>&nbsp;</P> Wed, 14 Oct 2020 16:22:22 GMT Sharon910 2020-10-14T16:22:22Z Get your students excited about data! <P>Want to introduce your students to data and data visualizations? Check out our scaffolded experiences and lesson plans! Students get a taste of data analysis in an interactive workbook, and have the opportunity to earn a Space Data badge.</P> <P>&nbsp;</P> <P>Check out this blog post to learn more:&nbsp;<A href="" target="_blank"></A></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sharon910_0-1602646908752.png" style="width: 400px;"><img src=";px=400" role="button" title="Sharon910_0-1602646908752.png" alt="Sharon910_0-1602646908752.png" /></span></P> <P>&nbsp;</P> Wed, 14 Oct 2020 03:42:06 GMT Sharon910 2020-10-14T03:42:06Z Welcome to the Day of Data! <P><SPAN>We're partnering with NASA to bring you the&nbsp;</SPAN><STRONG>Day of Data</STRONG><SPAN>, where you can explore how data powers astronauts, space missions, and our world! Join us over the next few weeks to celebrate World Spreadsheet Day and 20 years of humans living and working aboard the International Space Station. This is the place to find space-themed trivia, an exciting visualization challenge, and live events with an astronaut! Hope to see you soon!</SPAN></P> <P><SPAN>For more info, check out our blog post: <STRONG><A href="" target="_blank" rel="noopener">Celebrate World Spreadsheet Day with the Day of Data!</A></STRONG></SPAN></P> <P>&nbsp;</P> <P><SPAN><LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI></SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Astronaut_TechCommunity.jpg" style="width: 400px;"><img src=";px=400" role="button" title="Astronaut_TechCommunity.jpg" alt="Astronaut_TechCommunity.jpg" /></span></P> <P> </P> <P><SPAN><LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI></SPAN></P> Tue, 13 Oct 2020 03:59:22 GMT Sharon910 2020-10-13T03:59:22Z