AdventureWorks Analytics - OLTP

Overview

AdventureWorks is a fictional bicycle manufacturing company created by Microsoft, this database contains standard transactions data from an Enterprise Resource Planning System. It contains data from the following scenarios of the company: Human Resources, Product Management, Manufacturing, Purchasing, Inventory, Sales, and Admin. This analysis makes a brief summary of the following areas: HHRR, Person, Production, Sales and Purchasing. Microsoft Power BI has been used to create an interactive dashboard while pulling data from SQL Server.

Data Source

OLTP: On-Line Transaction Processing. -> fictional bicycle manufacturing company created by Microsoft.

Data Source

SQL Database Diagrams

Data Model

Report and presentation

Advertisement: Export caused changes to visualizations.

Power BI Dashboard

Built With

•Power BI •SQL Server