Business Intelligence Interview

Tsipras

Hi, I've an interview coming up for a junior dev role in a company that makes Business Intelligence software, It's an area I'm interested in but it's my first interview with this kind of company and I was wondering does anyone on here know what kind of questions they might ask me? Technologies used are C#, MS SQL, HTML5, XML, Web Services, JASON, Lucene.. should I just brush up on these??
Thanks!

Talisman

JASON -> JSON. Brushing up on technologies won't do you any harm.

D Hayes

I'm contracting with a company which has a BI department. I think they use SQL fairly heavily. MS SQL Server in particular. So things like stored procedures, t-sql etc.

Manach

Ask questions about the data. Where it comes from, how it is scrubbed and the timeliness of it.

Fate Amenable To Change

Tsipras wrote: »

Hi, I've an interview coming up for a junior dev role in a company that makes Business Intelligence software, It's an area I'm interested in but it's my first interview with this kind of company and I was wondering does anyone on here know what kind of questions they might ask me? Technologies used are C#, MS SQL, HTML5, XML, Web Services, JASON, Lucene.. should I just brush up on these??
Thanks!

If they have proprietary software know how it works would be my two cents.

DublinWriter

Read up a little on OLAP and prepare to talk about it.

stevenmu

OLAP is definitely good to look in to. If they're a MS shop they'll probably use SQL Server Analysis Services.

Also worth doing some research on ETL, and being at least a little familiar with SQL Server Integration Services.

Probably worth doing some reading about data visualisation as well.