Before this I have expose in system development skill especially in software development phase and database also.
But in BI more to how analysis data from existing data. So I must have knowledge in OLAP, Data warehouse, ETL and many more term in database area.
So challenging for me. Why I say that:
- We need know the various DBMS.
- The data integrity is very importance.
- Data cleaning.
- How to make sure metadata follow the format. Especially data in excel.
- Integrate date from various terminal.
- Etc
But, I will take as challenging..and now I think my head have overload..my head feel fluffy.
Now I want to solve this first:
- Install MS SQL Server 2008 at mock up server.
- Explore BI development area.
- Macro in Excel.
- And many think coming..
omg..what should I do first..