Data Warehousing & Analytics
Our core expertise lies in this area and we have been helping our clients in the design & implementation of their in-house custom-built Enterprise Data Warehouse (EDW). Keeping in view our experience, we have divided these implementations into the following phases
- Requirement Gathering, ETL architecture &framework
- Source system analysis
- ETL architecture& Logical Data Model (LDM)
- Reporting architecture & Physical Data Model (PDM)
- Implementation
- ETL workflows using automated tools
- Analytical Reporting
- Operational Reporting
- Data Visualization (in tools like tableau, Power BI, OBIEE, Microstrategy, etc)
- Exploratory Data Analysis using open source tools like R, Python, etc.