{"id":31335,"date":"2024-11-05T19:27:45","date_gmt":"2024-11-05T18:27:45","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/created-24-interesting-dataset-challenges-for-december-sql-advent-calendar-%f0%9f%8e%81\/"},"modified":"2024-11-05T19:27:45","modified_gmt":"2024-11-05T18:27:45","slug":"created-24-interesting-dataset-challenges-for-december-sql-advent-calendar-%f0%9f%8e%81","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/created-24-interesting-dataset-challenges-for-december-sql-advent-calendar-%f0%9f%8e%81\/","title":{"rendered":"Created 24 Interesting Dataset Challenges For December (SQL Advent Calendar) \ud83c\udf81"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hey data folks! I&#8217;ve put together an advent calendar of SQL challenges that might interest anyone who enjoys exploring and manipulating datasets with SQL.<\/p>\n<p>Each day features a different Christmas themed dataset with an interesting problem to solve (all the data is synthetic).<\/p>\n<p>The challenges focus on different ways to analyze and transform these datasets using SQL. For example, finding unusual patterns, calculating rolling averages, or discovering hidden relationships in the data.<\/p>\n<p>While the problems use synthetic data, I tried to create interesting scenarios that reflect real-world data analysis situations.<\/p>\n<p>Starting December 1st at <a href=\"http:\/\/adventofsql.com\/\">adventofsql.com<\/a> &#8211; (totally free) and you&#8217;re welcome to use the included datasets for your own projects.<\/p>\n<p>I&#8217;d love to hear what kinds of problems you find most interesting to work on, or if you have suggestions for interesting data scenarios!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/AdventOfSQL\"> \/u\/AdventOfSQL <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1gkcsfm\/created_24_interesting_dataset_challenges_for\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1gkcsfm\/created_24_interesting_dataset_challenges_for\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-31335 jlk' href='javascript:void(0)' data-task='like' data-post_id='31335' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-31335 lc'>0<\/span><\/a><\/div><\/div> <div class='status-31335 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hey data folks! I&#8217;ve put together an advent calendar of SQL challenges that might interest anyone who&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-31335","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/31335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=31335"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/31335\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=31335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=31335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=31335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}