ORBIT more details

This page provides details about the following points

 

Roles

  • The core responsibilities for each of these roles are provided below to give you an idea so that you can make an informed decision about which role suits you the best. 

  • The responsibilities mentioned are not exhaustive and not restrictive. There could also be certain level of overlap of responsibilities between the roles.

  • One person could do more than one role in a Datamart project. For example an ETL Developer or Report Developer could also perform the tasks of a Dimensional Modeler.  Even though not recommended, a student can switch between roles during the program

BI Business Analyst
ETL  Developer
BI Quality Analyst
Report  Developer
BI Module Lead
BI Administrator
Dimensional  Modeler
BI Analyst
Data Analyst

Working approach

 

Below points should provide a high level idea about our working approach.

  • Each team will work on one Datamart project at a time.  Versions of same Data mart could be built by two or more teams using same/different tools at the same time. 

  • Common sessions (webinars, online meetings, training session, etc) for all teams will be held on Saturdays ( Fridays or Thursdays if mutually agreed)

  • WDAS, read as WeeDAS or vDAS (Weekly Demo and Sync-up) will also be held on Saturdays. WDAS is derived based on DDAS (Daily Demo and Sync-up) from KABI. The activities that takes place in WDAS is same as DDAS except that it happens only once a week instead of Daily basis. 

  • Training and Mentoring sessions will happen on Thursdays and Fridays at mutually agreed times.  During these times, plans will be shared, tasks will be allocated and direction and guidance would be provided. 

  • Student is free to work on the tasks any day according to his/her convenience. Reviews by mentors will happen based on mentor's availability.  Support will be provided only on Thursdays, Fridays and Saturdays. 

 

Toolset

  • ETL Tools  - Pentaho Data Integration +  sponsored tools

  • Reporting platform  - Knowage (SpagoBI)+   sponsored tools

  • Data Visualizations - Microstrategy Desktop, Tableau Public, google sheets, IBM Watson Analytics  +   sponsored tools.

  • Datastore -  PostgreSQL, BigQuery +  sponsored datastores

  • Online chat and instant messaging - Atlassian Hipchat

  • Online meetings, WDAS and webinars -  YouTube, FCC and Skype

  • Code repository - Atlassian Bitbucket

  • Scheduling tool -  investigation in progress  + sponsored tools

  • Data Modeling tool  - Oracle Data Modeler + sponsored tools

  • Data Management tool - Oracle SQL Developer + sponsored tools

  • Agile Methodology KABI (Customized Kanban)​

  • Data Virtualization tool - None yet

  • Data catalogue - None yet

  • Monitoring Tool - None yet

  • Reporting portal - Reportpedia.com, World's Reporting Portal

Note - Only when a company sponsors a tool, will be able to use a sponsored tool, until then we will only use selected tools as mentioned below. Tools may be changed at any time if we find a better replacement. As mentioned earlier this training program is tools agnostic. We will focus on the concepts so that you are able to work with any of the tools. 

In the future ( not in current year (2018) scope)

  • Hadoop ecosystem

  • Statistical tools  like R  

  • Streaming technologies like Apache Kafka

 

Preparations

​These are recommended preparations before you start with the training.  Even if you are not able to understand all of the concepts just make an effort to read about these below listed topics. When we start with the training we will go in more detail. 

  • Understand the concept of Business Intelligence

    • Read BI Blog​

    • Read answers in Quora.com

    • Read the book "Data Warehousing fundamentals" by Paulraj Ponniah (search and you will find a pdf version)

    • Read BI Glossary ( to be updated shortly)

  • Understand Agile KABI

    • Read KABI post​

    • Watch KABI video ( to be added shortly)

Back to ORBIT main page