Training > Case Studies

Open Data - CoronaVirus - latest statistics from data.europa.eu

The Open Data data source we connect to is: data.europa.eu
We then manipulate this data to focus on any country in top 10, since 1 Feb 2020
- showing statistics by date.
Various interactive visualisations and reports are provided in Power BI.
CoronaVirus latest

Wide World Importers

Wide World Importers is one of the latest sample data bases provided by Microsoft (earlier samples included Adventure Works).
It provides a data structure, with volumes of sample data.
It includes - in SQLServer 2017, with examples of significant new features.

1) Source system (OLTP) database tables in SQL server
2) Datawarehouse (OLAP) database tables in SQL server. With star schemas, with Dimensions and Facts
3) ELT, with SSIS packages - to transform data from 1) to 2)
4) Demo Power BI visualisation/report

We have added:

Data models for 1) and 2)
The addition of invented unstructured sector via xml files
ETL to consolidate and integrate data
SSAS (cube) tabular data warehouse, with certain "measures" added
Further Power BI visualsations and reports