This post is a live example of my career as a developer in Business Intelligence (BI). I started BI with no knowledge at hand, and it took me lots of time to understand several areas of business intelligence. This blog will help you to give a smooth start to your career in BI.
Start by following any book or, materials online where you can get the knowledge on What, Why and How. “How” part can be explored later, but we should start with “What” and “Why” to understand the basics of BI.
Following are some areas where you need basic knowledge to understand the overall picture and once you are clear on the actual picture, you can expertise yourself in any of the area to start with:
- The description/definitions of BI, what is it exactly and why we need it for our business to grow.
- Life cycle of a BI/Data Warehouse projects
- Difference between OLTP and OLAP
- Multidimensional Modeling
- Extraction Transform Load (ETL)
- BI Architecture
- Data Mining
- Reporting techniques
- KPI, etc.
Please find below some online links and information on books, which will help you to acquire knowledge on above areas:
By: Elizabeth Vitt; Michael Luckevich; Stacia Misner
Publisher: Microsoft Press
Dimensional Modeling: In a Business Intelligence Environment
By: Chuck Ballard; Daniel M. Farrell; Amit Gupta; Carlos Mazuela; Stanislav Vohnik
Publisher: IBM Redbooks
The different careers in BI:
- ETL Engineer
- BI Engineer (Reports analysis, design and development)
- BI Engineer (Presentations -Dashboard, KPI, charts, etc.)
- Business Analysts (BI)
- TL/Project Manager (BI)
- QA/Testing (BI)
You would need to work on some tools to develop your solutions, I would suggest you to start with some open source if you want to understand the basics properly or, you can choose any paid tool if you want to ease your development.
Please find below some tools which we follow as our development, I would suggest starting with these tools:
- Talend Studio (ETL Tool), Open Source
- SpagoBI, Open source, It includes external engines such as Birt, Jasper, JPivot, Jpalo, JPXMLA, Geo, Geo Report, QbE, Weka, R(1), CommonJ, etc. It is a complete solution for BI projects.
- Schema-Workbench for Mondrian Schema development
Some other tools in the market:
- Open Source Tools
- Birt Project
- Paid Tools
- Tableau Public Desktop (Basic version is free)
- Pentaho (Basic version is free)
- Yurbi, community version is free http://www.yurbi.com/pricing/
- Cognos, IBM
- Omniscope, http://www.visokio.com/download/galapagos
- ElegantJ BI, http://www.elegantjbi.com/
- Visdash, http://www.visdash.com/
- Dynamic AI, http://www.dynamicai.nl/
- Precision BI, for healthcare domain, http://www.precisionbi.com/
SuperSTAR provides a unique solution to the challenge of fast, confidential data tabulation, analysis, visualization and dissemination of large amounts of organizational data. SuperSTAR uses a unique approach to analytical processing and reporting through the application of column-based analytical technology and web-based dissemination in one integrated environment. Users manipulate and analyze data at any level of aggregation, from unit record or micro data to aggregated cubes of data.
GoodData is more than just dashboards. It’s a powerful tool with a robust analytical engine built on a platform that’s revolutionizing BI.
- ElegantJ BI
Please let me know in case you need my help to understand any particular area/subject in details, I am there to help you always.