|
I know only MySQL and do web application programming and Linux system administration. I have also started learning AI and machine learning. I want to go into data analysis. Do I need to know MS SQL Server or Oracle in depth to go in data analysis/Business Intelligence type of field. |
||||
|
Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
|
A BI Analyst is a person who works with BI tools to perform analysis. Generally speaking they would be a person who is somewhat educated on data warehousing and understands how a star schema is modeled. They can also serve as the middleman between business and IT when creating new BI functionality. Basically will work more with the technology and business users as opposed to trying to play that single role. It is not required of you to specialize in MS SQL/Oracle to go in data analyst / Business Intelligence. |
||||
|
|
|
If you just want to do in some data analysis in your free times it does not matter if you know some mainstream tools. If you want to get a job then look at job offers for data analys position and you will see if Oracle/MS SQL is needed. In depth knowledge is not required but is well seen. |
|||
|
|
