top of page
vdata text logo small final.png
leaf transparent2.png

Excel to SQL

created by Selena Frey

Transaction Data Set in Excel

1) transactions.png

Lookup

2) lookup.png

Tax Summary

3) tax summary.png

Expense
Investigation

4) expense investigation.png

Load to SQL

b1) load to sql.png

Create Stage
Table

b2) create stage table.png

Load Data to Stage Table

b3) load to stage-2.png

Create .edw Table

b4) create edw table.png

Line of Business

6) line of business.png

Tax Category

7) tax category.png

Personal
Category

8) personal category.png
bottom of page