OrderDate bumpled up 4 years: SELECT YYYYYEAR(OrderDate), Orders COUNT() FROM GROUP BY YEAR(OrderDate) ORDER BY YYYY DESC / YYYY Orders 2008 13951 2007 12443 2006 3692 2005 1379 / SELECT YYYYYEAR(OrderDate), Orders COUNT() FROM GROUP BY YEAR. In upcoming posts, I’ll continue to explore some of the great features and services available in the data analytics space within Azure services. I noticed that some of the dates were made more recent. Now you have an up-to-date Adventure Works database for creating solutions and without feeling outdated! What’s next? Of course, you need to avoid some other dates like BirthDate or HireDate. I had to delete some foreign keys to facilitate the modifications and compress some tables to be able to publish into Github (let me know if you have any issues). Tools AdventureWorks Portal Reports Welcome Teo Lachev T AdventureWorks Portal > Reports > Shared Documents > AdventureWorks Sample Reports l'f. The maximum date in one of the fact tables was from January 2014, so I decided to run a few scripts to update the data.Ĭreating this new version of the database wasn’t difficult at all. I just updated the existing information to be more recent! So, if the date is 2014, add a few years… and convert it to 2020. Microsoft hasn’t continued adding more recent data. The data available in the database is outdated.
You can also easily build reports using non-real information that make sense to your clients.Īdditionally, you can use it for studying and learning. I’ve always used the Adventure Works DW database for demos and as a reference because it gives you a lot of good artefacts to explain different Data Warehouse component. GitHub Link (there is a backup for SQL Server 2019 and one for SQL Server 2016) Download the backup for the Adventure Works database with data from 2020 from the following link:
0 kommentar(er)
