Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Just starting first job - SSIS & SSAS Expand / Collapse
Author
Message
Posted Sunday, August 12, 2012 12:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:48 AM
Points: 35, Visits: 323
I graduated recently from college and will by starting my first job in Business Intelligence in October.

I'm currently going through orientation to learn more general information about the company and all of the different business groups.

I have very little experience in database work, I only took an Accounting Information Systems class that involved basic stuff with Access.

I emailed my manager asking if there was anything I could do to get a head start. She said they use the Microsoft BI stack (SSAS for cube development and SSIS for ETL).

What's the best way for me to get started in those areas? Any books or online tutorials you would recommend?



Thanks in advance.
Post #1343859
Posted Sunday, August 12, 2012 5:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 7,874, Visits: 9,613
With no previous database experience you should maybe expect your employer to provide some training.

However, there are some reasonable tutorials available online. But learning to handle BI related products from online tutorials when you don't have significant experience in the area is a rather heavy task unless your employer is going to provide someone to spend quite a lot of time acting as your mentor and helping you to learn.

A good place to start looking is the Microsoft on-line documentation, which includes on;ine tutorials. For SSAS you could start from http://msdn.microsoft.com/en-us/library/hh231701, for SSIS from http://msdn.microsoft.com/en-us/library/ms167031%28v=sql.105%29.aspx and also from http://msdn.microsoft.com/en-us/library/aa337424 and from http://msdn.microsoft.com/en-us/library/bb522859.aspx, but these do require some basic knowledge of SQL Server and MS's various development studios, plus access to a computer with the software you are learning about installed. The underlying database system on which SSAS, SSIS, and SSRS (you can't do really BI without SSRS) are founded has some tutorials starting from http://msdn.microsoft.com/en-us/library/jj590844.aspx and you may find that you have to look at some of this in order to understand the stuff I mentioned before.

The references I've given above are mostly for the 2012 versions - and I see you've posted in the 2008 forum; they pages referenced contain links to earlier versions, so you can follow those links and get the version you need.


Tom
Post #1343942
Posted Monday, August 13, 2012 7:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
Do you learn most easily from books, from hands-on, or from mentoring through examples? Different people learn differently, so that will matter. (Some can mix-and-match, too, of course.)

If books, I recommend going to a good bookstore or library. Before you go, write a list of questions you actually find you need answers to on the subject. Grab a stack of books, and try to find answers to your questions in each book. What you'll probably find is that one or two of the books will "resonate" best for you. The writing style, examples, narrative-sequence, etc., will allow you to get the most out of them. Then pick those.

If hands-on, get a copy of SQL Developer Edition, install it on your computer at work. The employer should provide it, not you. Then start building proof-of-concept work in it. Try something practical but easy. Perhaps the online tutorials, perhaps something more personal or more closely related to your employer's needs.

If mentoring, and there isn't someone in-person at work, then you'll probably spend a lot of time on SQL forums (like this one).

But the first thing to do is think back to your education, and experiences in other fields than just DBAing, and work out your best learning pattern. That's where you should start from.

Does that help?


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1344121
Posted Monday, August 13, 2012 9:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:48 AM
Points: 35, Visits: 323
Thank you both, that's very helpful information. My manager mentioned that she will set up some training when I first start but I'd still like to learn some basics.

I definitely learn best through hands-on work so the tutorials sound like a great idea.


Thanks again!
Post #1344516
Posted Thursday, August 16, 2012 2:26 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:37 AM
Points: 632, Visits: 2,952
Read, read, read: books online, a web page or blog...

Practice, practice, practice...

Microsoft E-learning, plenty of free stuff there. Go to products > SQL Server. There's tons of free stuff (intro to 2008, What's new in 2012, BI Blah-blah...)

Install SQL Server Express, it's free (on a computer you don't care about while you're learning). Play around with adventure works. Make a new DB. Back it up, export a table, create a view, etc..

Want a real headstart?!?! - Begin a code library. This really helped me - you get some practice and can use it... Start with TSQL, make some notes, etc..
-- string functions

--REPLICATE
DECLARE @str varchar(50) = 'xyz '
SELECT REPLICATE(@str, 2)

-- LEN (length)
SELECT LEN(@str)
SELECT LEN(REPLICATE(@str, 2))
SELECT LEN(NULL) .....

-- aggregate functions
SELECT COUNT(*) FROM sys.databases
SELECT SUM(a) FROM...

--useful system views
SElECT TOP 10 * FROM sys.all_views
SELECT TOP 10 * FROM sys.syslogins ...

... next go do one with MDX or whatever...


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001

My blog
Post #1346242
Posted Thursday, August 16, 2012 2:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 17, 2014 7:59 PM
Points: 395, Visits: 1,610
Try http://www.msbiacademy.com/ and http://pragmaticworks.com/. But I just have to ask, how in the world do you get a job in BI with no database experience?!?

MWise



Post #1346249
Posted Thursday, August 16, 2012 3:18 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 10:52 AM
Points: 496, Visits: 848
Hey, good luck with the job. I got my start as a Data Analyst right after I graduated. I didn't have much database experience(one DB class and 3 months as an intern, both not very in depth in SQL) but they were a smaller company and willing to train and have me learn on the job.

Anyways, I did the SSIS stairway(Look on the links on the left for Stairways) here on SQLServerCentral and I thought it was a pretty good intro. There's a Stairway to MDX that I haven't done that may be useful.

Post #1346267
Posted Thursday, August 16, 2012 9:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:48 AM
Points: 35, Visits: 323
Mhlewis (8/16/2012)
Try http://www.msbiacademy.com/ and http://pragmaticworks.com/. But I just have to ask, how in the world do you get a job in BI with no database experience?!?

MWise



Good question, I'm not sure. I'm scared out of my mind about it though. I made good grades in college and in the interview they asked me my interests and one thing I mentioned was database stuff so I guess that's why they put me in BI. We'll see if I can handle it.



Thanks for the info everyone.
Post #1346322
Posted Friday, August 17, 2012 1:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 13,570, Visits: 11,383
will.byrne (8/16/2012)
Mhlewis (8/16/2012)
...But I just have to ask, how in the world do you get a job in BI with no database experience?!?


Good question, I'm not sure. I'm scared out of my mind about it though. I made good grades in college and in the interview they asked me my interests and one thing I mentioned was database stuff so I guess that's why they put me in BI. We'll see if I can handle it.


Don't be scared. I started out in the BI field 3 years ago without any relevant experience and I couldn't write a decent SQL statement at the time. My new employer saw some opportunities in me and invested quite well in some SQL Server trainings. Then they put me on a project with some more senior colleagues, who mentored me in my first steps. And look where I am now: giving sessions about SQL Server BI at national conferences (Belgium that is, it's not a big country ) and I'm in the top 20 of SQLServerCentral (as if that's any reference )

My point is that you don't have to be scared. As long as your employer is willing to support you with training, mentoring et cetera, you shall be fine. You already show a good attitude by trying to tackle things upfront.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1346373
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse