I have total 2.6 years experienced in ssis,ssrs,ssas.still I don't feel I have enough experience on these tools.
even though I have knowledge I didn't worked on many features of ssis,ssas.
I am working in small company where we worked using a limited features available in ssis ans ssas.
some of colleagues put fake exp and got jobs.I don't want do like that.
I want to know is career change a option ? will msbi have good future?.
I have two Indian friends who I do BI with. They moved here from India within the last few years. They say the BI market in India is comparable to America (where I'm from). The BI market I America is very good.
2.6 years is enough experience to get a BI Developer job. SSAS skills are in very high demand. If you know MDX, even better. The future is bright for BI professionals.
Needless to say, fake experience is terrible to put on your resume/CV.
-- Alan Burstein
Helpful links:Best practices for getting help on SQLServerCentral -- Jeff ModenHow to Post Performance Problems -- Gail ShawNasty fast set-based string manipulation functions:For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)To split strings based on patterns try PatternSplitCMNeed to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8KI cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. -- Itzik Ben-Gan 2001