{"id":610,"date":"2020-03-30T16:14:05","date_gmt":"2020-03-30T16:14:05","guid":{"rendered":"http:\/\/jackofalltradesmasterofsome.com\/blog\/?p=610"},"modified":"2020-03-30T16:14:08","modified_gmt":"2020-03-30T16:14:08","slug":"microsoft-data-analytics-projects-to-take-on-while-covid-19-quarantine-is-in-place","status":"publish","type":"post","link":"https:\/\/jackofalltradesmasterofsome.com\/blog\/2020\/03\/30\/microsoft-data-analytics-projects-to-take-on-while-covid-19-quarantine-is-in-place\/","title":{"rendered":"Microsoft Data Analytics Projects to take on while COVID-19 Quarantine is in place"},"content":{"rendered":"\n<p>Are you looking for some Microsoft Data Analytic Projects to take on while the work from home COVID-19 Quarantine is in place? Here is a list of projects that can be completed easily and independently by your team with little supervision that you may have been kicking the can down the road on.\u00a0<\/p>\n\n\n\n<p>1) SQL Server 2008 has been end-of-life as of July 2019. Before you migrate to 2016\/2019 or the cloud, you must first create and review the inventory of objects, deprecated code and create a cutover plan to a greenfield environment.<\/p>\n\n\n\n<p>2) Do you have 100&#8217;s or 1000&#8217;s of SSRS reports? Take a quick inventory on which reports are being used (and which ones are not), to see if some of the clutter can be archived and retired.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15\">https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15<\/a><\/p>\n\n\n\n<p>3) Do you still create your SSIS or Data Factory Packages by hand every time a new table is needed? Try building a Python or BIML script to parse your source databases to auto-create entire packages.&nbsp;<\/p>\n\n\n\n<p>4) Still, running your ETL on-premise or on virtual machines? Start migrating your packages to run in the cloud.<\/p>\n\n\n\n<p>5) Replicate your staging database ETL to begin copying data into a data lake in parallel. This is a great way to put initial steps in place to move to modern data architecture and instantly have a more robust data retention strategy.&nbsp;<\/p>\n\n\n\n<p>Got any more ideas? Would love to hear them!&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you looking for some Microsoft Data Analytic Projects to take on while the work from home COVID-19 Quarantine is in place? Here is a list of projects that can be completed easily and independently by your team with little supervision that you may have been kicking the can down the road on.\u00a0 1) SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":611,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,28],"tags":[],"class_list":["post-610","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-azure"],"_links":{"self":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":1,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":612,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/610\/revisions\/612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media\/611"}],"wp:attachment":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}