SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Beginner Has Questions re MS SQL 2008 Training Secifically BI Tools


Beginner Has Questions re MS SQL 2008 Training Secifically BI Tools

Author
Message
fakedon63
fakedon63
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 12
I am a Junior Data Analyst , and use primarily Excel 2010 . I would like to begin using BI Tools that came with MS SQL and have some questions about the training . I already use MySQL so I am already familiar with using SQL .

1) . Does it matter which Service I learn first Integration Service , Reporting Services or Analysis Service ? Or is there no prerequisite order in which to train ? ( I suspect it may depend on what tools you need but would like to be certain) .

2) Which would be better to learn first , T-SQL or Python for scripting in BI ?

3) I am deciding if I should use a MS SQL Hosting Service as opposed to adding a Virtual Drive to my Windows 7 machine and loading Application . If I do take this route , what should I look for in a Hosting Service ? Such as minimum memory , disk space , bandwidth , cost per month , and generally any real world pros and cons to be aware of .

Thanks for any info .
anthony.green
anthony.green
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25150 Visits: 6519
fakedon63 (8/7/2012)

I already use MySQL so I am already familiar with using SQL

Dont confuse MySQL with MSSQL, they are two very different products and somethings that work in MySQL dont work in MSSQL and the other way around


1) . Does it matter which Service I learn first Integration Service , Reporting Services or Analysis Service ? Or is there no prerequisite order in which to train ? ( I suspect it may depend on what tools you need but would like to be certain) .

Personally I would start with SSIS as that is the basis to get data from OLTP to OLAP.
Then I would do SSAS and then SSRS, but either way round will do.


2) Which would be better to learn first , T-SQL or Python for scripting in BI ?

T-SQL, MDX, DMX, XMLA are the languages which SQL server use for BI


3) I am deciding if I should use a MS SQL Hosting Service as opposed to adding a Virtual Drive to my Windows 7 machine and loading Application . If I do take this route , what should I look for in a Hosting Service ? Such as minimum memory , disk space , bandwidth , cost per month , and generally any real world pros and cons to be aware of .

What are you trying to acheive? Live environment? Test/Dev environment?
What do you do already for your existing MySQL / MSSQL servers?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Jayanth_Kurup
Jayanth_Kurup
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5793 Visits: 1351
As a data analyst i think you can also now use a different approach , or atleast one that i think will help you more in your job. Try looking at these featuers in 2012 , DAX , Powerview , DQS , MDS

These are some really good tools for the Data analyst in sql server. These are all part of MS self service BI where you no longer need to really learn SSIS , SSRS and SSAS in order to be a DA.

Jayanth Kurup
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search