Let's talk about Adventureworks Database.
This database is popular among data enthusiasts as it is a one of the several free dataset out there to learn with.
In this thread, I will enlighten you on the business behind the database to help you better understand it.
I will put...
.. I will share links to help you learn more.
AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database.
It is a database for a fictitious multinational company called Adventure Works Cycles.
They are into the manufacturing of ..
... and selling of metal and composite bicycles to North American, European and Asian commercial markets.
HQ in Bothell, Washington with 290 employees, with several regional sales teams are located throughout their market base.
They acquired a manufacturing plant in Mexico in ..
.. year 2000. The company Importadores Neptuno manufactures several subcomponents for the Adventure Works Cycles product line. These subcomponents are then shipped to the Bothell (HQ) for final product assembly.
In 2001, Importadores Neptuno became the sole manufacturer and ...
... distributor of the touring bicycle product group.
The database are in different versions are available for download freely online. Links will be added at the end of the thread.
For versions, a new version of the database is available after each new release of a major SQL...
.. server version, starting with 2005. With each new version, there may be little to no changes from the previous, there may be updates to just the data (such as updating dates), or there may be larger changes to the schema to allow for the use of new functionality or techniques
The largest change has been from 2005 to 2008, where a number of schema changes were made. Changes in more recent versions (2008 to 2012 to 2014) have been much more minor. Always be aware of the version you’re using and the version which was used to create a specific demo.
You can find more details in this brief video
I also have more videos in the same playlist that show how to install Adventureworks Database and how to get started with SQL.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
Let's get this right, in the 4th Industrial Revolution which we are in, not everyone can be a Data Scientists, Analytics Engineer, or even a Data Analyst, but everyone must be digital literate to benefit from its numerous opportunities.
Let's see what it takes to be digitally ..
.. literate.
Simply put, digital literacy is the ability for every individual to leverage on the existing and modern technologies for improved productivity at work and in their personal lives.
This means you need to know how to use productivity & collaborative tools efficiently
Learning Microsoft Power Platform will naturally get you to be digitally literate.
For example, you get to know how to use the following apps MS Teams, OneDrive, SharePoint, Outlook, Power Automate, Power Apps, MS Forms etc.
You get to build solutions that will expose you ...