Building a Data Warehouse Project

My new consulting job, first few weeks I worked remote from home.

This week, I've been on a new client's site, working on Proof of Concept Data Warehouse.

Spent first day modeling the data on the white board, documenting to Excel in a Data Dictionary.

Yesterday I created the SQL-Server database as well as the staging data warehouse tables.  As well as connecting to the database using ODBC.

Today I need to create the SSIS ETL jobs for the 6 Dim tables and 1 Fact table, due by the end of the day.  We are grabbing data from two data sources, however think I'll get the first one working from start to finish then get the other data source working.

That way we can begin building the SSAS cube tomorrow and start on the PerformancePoint on Monday.

I've been given creative freedom on this project, although I do send a few emails to the boss occasionally for confirmation or questions.

And I still have work to do on my other client.  However, I like the fact that I don't have a full time job at one company, swimming in mediocrity and boredom and politics while not learning any new skills with a 2% raise if I'm lucky.

Things are working out fine!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder