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

BI Business Analyst

  • Requirements management

  • User Stories creation & prioritization

  • Pre-UAT

  • User story sign off

ETL  Developer

ETL Developer​

  • Develop and unit test ETL  jobs / transformations using selected ETL Tool.

  • Peer review ETL jobs created by other developers.

  • Working approach

  • Tool set

BI Quality Analyst

BI Quality Analyst

  • Analyze requirements / user stories and create test scenarios.

  • Set up test data.

  • Test all deliverables in the test envrionment. 

Report  Developer

Report Developer​

  • Design reporting layer.

  • Create, modify and test reports based on requirements.

  • Peer test reports

BI Module Lead

Module Lead

  • Lead a Data Mart team and take ownership.

  • Should have at least 2 Data mart project experience.

BI Administrator

BI Administrator

  • Administer ETL, DB and Reporting applications.

  • Ensure that only  high quality deliverables are deployed on production. 

Dimensional  Modeler

Dimensional Modeler

  • Create and maintain the dimension models.

  • Choose the right Fact and Dimension types for satisfying requirements.

BI Analyst

BI Analyst

  • Learn in depth about Business segment. 

  • Use BI Solution to create reports, dashboards etc.

  • Provide requirements.

Data Analyst

Data Analyst

  • Research Data various areas.

  • Analyze trends/patterns from all possible data sources in the test environment. 

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