Is it possible to build Data warehouse by myself?

I work for the insurance company little more than a year, my SQL experience around 2-3 years including SSIS, SSRS. We have approximately 1 TB of data.

Is it possible to build data warehouse by myself? Should I do that with my experience?

There are lots of materials and SQL groups I can get help from. But still, is it too complicated?

Thanks

It's a lot like asking, "Can I build a house by myself?"

It depends a lot on what your definition of "house" is. Talk with your internal users to build a set of requirements first - that's going to need to happen regardless of who builds it.

When you're done building requirements, then you can start sketching out what you'll need to build in order to satisfy those requirements.

Then, you can start building time estimates for what needs to be built.

As you work through this process, you'll have a better understanding of what the house looks like and whether you can build it yourself with your existing toolbox and skills.

StackExchange Database Administrators Q#172275, answer score: 9