jayshilj / AdventureWorks-Retail-Store-DW-and-BI-Using-Altreyx-and-Talend- Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Data Warehousing and Business Intelligence performed over a Retail Store's Dateset

1 star 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
Alteryx_jobs		Alteryx_jobs
Data		Data
ER Studio File		ER Studio File
Images		Images
SQL Queries		SQL Queries
Talend Jobs/PURCHASEDW		Talend Jobs/PURCHASEDW
Alteryx_Jobs.pdf		Alteryx_Jobs.pdf
PurchaseDWPowerBI File.pbix		PurchaseDWPowerBI File.pbix
README.md		README.md
Talend_Jobs.pdf		Talend_Jobs.pdf

Repository files navigation

AdventureWorks-Retail-Store-DW-and-BI-Using-Altreyx-and-Talend-

Data Warehousing and Business Intelligence performed over a Retail Store's Dateset

Follow the steps for installation:

Install and setup Oracle 11g, MySQL Workbench, Postgres and SQL Server
Install Alteryx, Talend, PowerBI and ER Studio
Run the SQL Scripts to create tables
Run all the Jobs in Atreyx and Talend
Use PowerBI to see the visualizations of the data

Sample Altreyx Jobs created in the project:

Sample Talend Jobs created in the project:

ER Model generated by the using ER Studio for generating DDL scripts

About

Data Warehousing and Business Intelligence performed over a Retail Store's Dateset

Report repository

Releases

No releases published

Packages

No packages published