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

SSRS Study/Career Advice Expand / Collapse
Author
Message
Posted Tuesday, November 26, 2013 1:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 1:28 PM
Points: 4, Visits: 12
I am a newbie to SQL and currently learning T-SQL (MS-SQL 2008R2 version). I have been working as a Data Validator for past 2 years and would like my next career path to be a SSRS Report Developer. I feel once I get better at TQL and because I am used to creating reports in both Excel and Access this would be an easier transition for me career wise than the other BI Tools SSIS and SSAS.
I have some questions regarding my course of study though and I hope I can get some answers from all of them that I have listed below:

A). I will eventually learn the other BI Tools after SSRS but as I feel that a Report Builder/Writer will be an easier transition for me (this is what I hope but any thoughts on this are welcome). Which of the other BI tools should I learn next that will assist me better as a Report Developer SSIS or SSAS?

B). I have seen jobs for experienced SQL Developers with a request for knowledge of C# and sometimes XML . This will be later studying for me of course but as either Report Developer, or other BI Analyst how necessary will knowing either of these be ?

C) . Is it more crucial to master the T-SQL language or be better at utilizing the tools/services in SSRS when just starting out ?
Post #1517818
Posted Tuesday, November 26, 2013 2:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
Hello,

In my humble opinion I do not think you should focus on only one area of SQL. This limits you tremendously, plus you will have to write T-SQL code for SSRS anyway. I recommend picking up the following book and reading it cover to cover. I have been following this author since SQL 2000 and these books have really helped my SQL game.

Step 1: http://www.amazon.com/Beginning-Microsoft-Server-2008-Programming/dp/0470257016

Step 2: http://www.amazon.com/Professional-Microsoft-Server-2008-Programming/dp/0470257024

Post #1517834
Posted Tuesday, November 26, 2013 2:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:54 PM
Points: 12,170, Visits: 9,115
fakedon63 (11/26/2013)
I am a newbie to SQL and currently learning T-SQL (MS-SQL 2008R2 version). I have been working as a Data Validator for past 2 years and would like my next career path to be a SSRS Report Developer. I feel once I get better at TQL and because I am used to creating reports in both Excel and Access this would be an easier transition for me career wise than the other BI Tools SSIS and SSAS.
I have some questions regarding my course of study though and I hope I can get some answers from all of them that I have listed below:

A). I will eventually learn the other BI Tools after SSRS but as I feel that a Report Builder/Writer will be an easier transition for me (this is what I hope but any thoughts on this are welcome). Which of the other BI tools should I learn next that will assist me better as a Report Developer SSIS or SSAS?

B). I have seen jobs for experienced SQL Developers with a request for knowledge of C# and sometimes XML . This will be later studying for me of course but as either Report Developer, or other BI Analyst how necessary will knowing either of these be ?

C) . Is it more crucial to master the T-SQL language or be better at utilizing the tools/services in SSRS when just starting out ?


A. I would start with SSAS (and it's query language MDX) in favor of SSIS, because you might need to create reports on top of SSAS. DX ain't easy though...
B. XML is just asked because the report is basically an XML file. You don't need to lose any sleep over this. C# is weird, because SSRS uses Visual Basic for expressions and customization. Maybe they need you to do other development as well.
C. If you want fast running reports, you better write some decent TSQL. But you need to know both of course.




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 #1517838
Posted Wednesday, November 27, 2013 7:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
In addition to the great advice from Koen....

SSAS is tough because building and querying cubes is much different than querying a database. Data Warehousing requires you to "De-normalize" data when databases require you to "Normalize data". SSAS is a different animal indeed.

Again, I would read that beginners book as it covers all of these areas. It's good to be familiar with the entire SQL suite (SSAS, SSIS, SSRS). You do not need to be an expert, as you will get most of your experience when you are presented with projects. Make sure you at least understand the following...

1) SSIS: How to create/deploy a basic SSIS package.
2) SSRS: Create/deploy SSRS reports (report builder/report manager).
3) SSAS: Create Deploy basic cubes. Learn the basics of MDX as well. (MDX is very different from T-SQL).
4) T-SQL: This is essential to just about anything that you do in SQL. Focus on getting strong T-SQL skills.

I hope this helps

Dave
Post #1518082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse