Skip to content

SQL & Power BI. Diagrams, select/view, Power Query, DAX, etc.

Notifications You must be signed in to change notification settings

victoria-mascaro/AdventureWorks2019-OLTP

Repository files navigation

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

HHRR-Diagram

Person-Diagram

Production-Diagram

Sales-Diagram

Purchasing-Diagram

Data Model

Model

Report and presentation

Advertisement: Export caused changes to visualizations.

Power BI Dashboard

Built With

Power BISQL Server