Technical Skills
BI and Analytics
- Data discovery
- Data visualization
- Data preparation, blending and wrangling
- Dashboards and storyboards
- Reporting
- Desktop, cloud and mobile deployments
Data Integration and ETL
- Database and file integration
- Big data integration
- Cloud integration
- Application integration
- Hybrid integration
- Data quality and cleansing
- On premise, cloud and hybrid deployments
Data Management and Quality
- Data governance
- Master Data Management (MDM)
- Enterprise information management
- Metadata management
Database
- Relational
- Columnar
- OLAP
- NoSQL (column, document, key value and graph)
- Hadoop
- Semi-structured data such as XML and JSON
Data Modeling and Database Design
- Dimensional modeling
- Hybrid/advanced dimensional modeling
- ER modeling
- Data profiling
- Reverse engineering
Data Source Systems for BI and Data Integration
We design BI and data integration solutions that access data from a wide variety of source systems.
- ERP applications
- CRM applications
- Supply chain management applications
- Financial budgeting, forecasting and planning applications
- Industry-specific applications in higher education, insurance, financial services, life sciences and healthcare
- Big data (data hubs and data lakes)
- Semi-structured data such as XML and JSON
Business Experience
We have designed solutions for a wide variety of business initiatives including:- Enterprise BI, dashboards, reporting and analysis
- Self-service BI and analytics
- Replacing spreadmarts and data shadow systems
- Operational BI and ERP reporting and analytics
- Predictive analytics
- Data governance
- Enterprise Data Warehouse (EDW)
- Modernizing BI and data warehousing
- Big data
- Revitalizing multiple data warehouses, data marts and other reporting databases
- Customer Data Integration (CDI) or "one view of the customer"
- Corporate Performance Management (CPM) and balanced scorecards
- Customer Relationship Management (CRM)
- Supply Chain Management (SCM)