Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TWD38
Starting Member
7 Posts |
 Posted - 2012-04-16 : 12:26:39
|
| Hey guys,I am currently employed as a data analyst, and found a great job opportunity. However, the listing does have one requirement that makes me uneasy:Experience with SSIS, SSAS, and SSRSWell in short, I have zero experience with these components. I do have a lot of exporting exporting data out of SQL into Access, Excel, Crystal Reports and other reporting software like Tableau. From what I gather, the concepts are basically the same in the SQL tools. My question is given my background, would I be able to self-teach myself these components, or am I way out of my league here? I've wrote hundreds of queries, know how to manipulate and export data. Unfortunately, I don't have direct access to the SQL server to access these SQL tools. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-16 : 13:44:47
|
| Go for it, but be honest with them about your experience, or lack thereof. If you've been using Crystal and Tableau you can pick up SSRS pretty quickly. SSIS is also easy to learn. SSAS is the only one I've been challenged to learn, as my head doesn't wrap around dimensional modeling. If you can do that kind of thinking then it should be easy for you to learn SSAS as well. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-16 : 15:57:37
|
| You most definitely can teach yourself and pick it up real quick, as long as you are dedicated for some lab workthis is what I did1. got a book on ssis and ssrs from BArnes and Nobles2. Installed sql server on my home network on vmware ESX3. Went through the books every single day for a couple of weeks4. You can even download sample data from microsoft Then when interview came I was honest like rob says but at least I was familiar with what they were going to ask me.That was 4 years ago.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
|
|
Advice Needed Regarding SSIS, SSAS, and SSRS