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.
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.
2) Do you have 100’s or 1000’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.
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.
4) Still, running your ETL on-premise or on virtual machines? Start migrating your packages to run in the cloud.
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.
Got any more ideas? Would love to hear them!