BI Requirments Gathering/Data Profiling
We will work with your business users to understand their business and their needs. We don’t assume that you know exactly what you need, that’s why you hired us. In addition to uncovering and documenting what you need, we can rummage through your data (with your permission) and help you understand your data assets and your possibilities.
Dimensional Data Modeling
The cornerstone of any great BI solution is a well-designed Kimball based dimensional data structure. While undoubtedly Kimball is the master, we’re a close second. Our data modelers live and breathe dimensional data structures. If you have data, we can make it dimensional.
OLAP Cubes
There isn’t a better way to put data in the hands of business users. If you want business users to be self-sufficient data expplorers then you need cubes. Celerus knows cubes; we’ve been building them for over 15 years.
Data Warehouse/ELT
Most BI solutions sit on top of some type of Data Warehouse/Data Mart. Of course any one that Celerus’ builds will be dimensionally based. We know how to build fully functioning Data Warehouse/Data Mart infrastructures complete with ETL (Extract, Transformation and Loading) code. This is the necessary plumbing to a great BI solution and we do it exceedingly well.
Reports/Dashboard/KPI/Searching
This is the visual portion of a BI solution and we can do it all. There are many ways to present data and we’ll work with you to determine the best fit for your needs.
Just because we haven’t listed a service doesn’t mean we don’t do it. Ask us, if we haven’t done it we’ll tell you so. Integrity underlines all that we do.