Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Warehouse in Microsoft Fabric
This is an overview of the fictitious company Wide World Importers and the workflows that are addressed in the WideWorldImporters sample databases for SQL Server and Azure SQL Database.
Wide World Importers (WWI) is a wholesale novelty goods importer and distributor operating from the San Francisco bay area.
As a wholesaler, WWI's customers are mostly companies who resell to individuals. WWI sells to retail customers across the United States including specialty stores, supermarkets, computing stores, tourist attraction shops, and some individuals. WWI also sells to other wholesalers via a network of agents who promote the products on WWI's behalf. While all of WWI's customers are currently based in the United States, the company is intending to push for expansion into other countries/regions.
WWI buys goods from suppliers including novelty and toy manufacturers, and other novelty wholesalers. They stock the goods in their WWI warehouse and reorder from suppliers as needed to fulfill customer orders. They also purchase large volumes of packaging materials, and sell these in smaller quantities as a convenience for the customers.
Recently WWI started to sell a variety of edible novelties such as chilly chocolates. The company previously didn't have to handle chilled items. Now, to meet food handling requirements, they must monitor the temperature in their chiller room and any of their trucks that have chiller sections.
The typical flow for how items are stocked and distributed is as follows:
While the team at WWI use SQL Server Reporting Services to generate operational reports from the WideWorldImporters database, they also need to perform analytics on their data and need to generate strategic reports. The team have created a dimensional data model in a database WideWorldImportersDW. This database is populated by an Integration Services package.
SQL Server Analysis Services is used to create analytic data models from the data in the dimensional data model. SQL Server Reporting Services is used to generate strategic reports directly from the dimensional data model, and also from the analytic model. Power BI is used to create dashboards from the same data. The dashboards are used on websites, and on phones and tablets. Note: these data models and reports aren't yet available
These are additional workflows.
The company operates with a financial year that starts on November 1.
The license for the sample database and the sample code is described here: license.txt
The sample database includes public data that has been loaded from data.gov and Natural EarthData. The terms of use are here: https://www.naturalearthdata.com/about/terms-of-use/
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Learning path
Implement a data warehouse with Microsoft Fabric DP-602T00 - Training
Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric. (DP-602T00)
Documentation
Install and configure WideWorldImporters sample database - SQL Server
Follow these instructions to download, install, and configure the WideWorldImporters sample database with SQL Server Management Studio.
Generate data in SQL samples WideWorldImporters - SQL Server
Use these SQL statements to generate and import sample data up to the current date for the WideWorldImporters sample databases.
WideWorldImportersDW - ETL workflow - SQL Server
Use the ETL package with SQL Server Integration Services (SSIS) to periodically migrate data from the WideWorldImporters database to the WideWorldImportersDW.