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
 

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
 

Forum statistics

Threads
1,082,305
Messages
5,364,401
Members
400,800
Latest member
germanpbv

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top