Is thorough SQL server knowledge required for Business Intelligence career??

mrxlsx

Board Regular
Joined
Dec 15, 2012
Messages
95
Hi All,

Happy New Year to all of you..

I am an Excel Power user, Excel trainer, BI enthusiast slowly getting into teaching Business Intelligence using Microsoft Excel's PowerPivot. A few years back I was bitten by a bug called Power-BI. I am not a person too good at programming languages. But I am in the business of teaching and consulting of Microsoft Excel.

Here is the problem.. For the last few years.. I was trying hard to enter into BI world. My goal is to learn BI using Excel's PowerPivot. But when I started looking at it..things are not so easy for me as I thought..ie. there are some concepts related to cubes, DBA concepts, running reports and queries to access data from different sources, tabular modeling..etc. It's a big mountain which is very steep for me. Now my question is..

To teach or to become a hardcore Power BI Analyst (using PowerPivot, Power Query, Power Maps, PowerView etc), shall I have to master all these Database concepts too deeply?? Shall I have to master concepts related SQL server's SSIS, SSAS, SSRS services. Why because we need to master DAX code in PowerPivot which will slowly take you to SQL environment in some other way. But If I take this SQL path I will become Database guy and moreover I do not like it and I can not fit myself there. If the answer is Yes, to what extent I have to learn these database concepts. You can ask me any questions to understand my situation more clearer.

Thanks in advance.
Arjun M Shetty
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

mrxlsx

Board Regular
Joined
Dec 15, 2012
Messages
95
Hi Everyone,

Please answer this question as I have been waiting to be clarified for the last couple of years. Is something wrong with the question i.e. posting etiquette and rules not followed or it just not attracted anyone's interest. Please let me know. Thank you so much all.

Arjun
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
I know this does not answer your question (nor could I), it is just an observation...
I have been waiting to be clarified for the last couple of years.
- you posted this 4 days ago - hardly a couple of years lol?
- I see nothing wrong with your post, nor it's etiquette, nor have you broken any rules (that I can see). It is probably just a case of the right people have not viewed your thread yet.
 

mrxlsx

Board Regular
Joined
Dec 15, 2012
Messages
95
Hi FDibbins,

What I mean is, I have this question un-answered in my mind for the last couple of years not the other way as you mentioned. Thank you.

Arjun
 

Watch MrExcel Video

Forum statistics

Threads
1,099,010
Messages
5,466,005
Members
406,460
Latest member
tryingtogoalone

This Week's Hot Topics

Top