nicolas.kesler (9/9/2015)
I have a BI Internship interview in the next few days and was looking for some help polishing my skills with some of the job requirements. Any advice on review material would be greatly appreciated! Here are some of the requirements I am trying to get more insight on actually what the interviewer is looking for:• Competency in T-SQL, working knowledge of MS SQL 2005, 2008 and 2012
• Understanding of Extensible Markup Language (XML)
• Experience in dimensional databases and OLAP Cubes
• Strong analytical and problem solving skills with attention to detail
• Must possess knowledge of database configuration, design and maintenance
If anyone could just better define what they are practically looking for on an internship level I would greatly appreciate it! Thank you!
All that for an internship? I'd expect that list of requirements for a BI developer with 2 years experience. How can an intern have worked with SQL Server editions that are up to 10 years old?
T-SQL: anything written by Itzik Ben-Gan.
Examples:
* Microsoft SQL Server 2012 T-SQL Fundamentals
* Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012
XML: just know the basics, google "xml tutorial" and you should be fine.
Dimensional modelling and OLAP (as if they let juniors model their data warehouse, but hey, let's roll with it :-))
* Star Schema The Complete Reference (dimensional modelling. The Kimball books are fine as well)
> Must possess knowledge of database configuration, design and maintenance
Most of this comes through experience.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP