Use Cases --- Data Warehousing and Reporting
Please be sure to visit the entire
Astir Family of Companies at :
This Astir Services LLC client needed a new data repository that housed extremely sensitive information on a number of individuals. The data needed to be as clean as possible, with no duplications, and would need to be maintained. Additional analytic capabilities were needed in order to provide in-depth reports based on the individuals within the system.
The sensitivity of the data being collected made it imperative that there be no redundancies within the system. The client needed an expert who could not only build this system, but maintain it and regularly generate detailed data analysis.
Astir Services LLC provided a data warehouse engineer who designed and implemented a brand new data repository with a very high level of data security. The extreme sensitivity of the collected data forced the implementation of multiple layers of data security, including access control and object level security. Compiling external data sources and cleaning that data provided timely information access for customized analytics. The Astir engineer regularly performs detailed data analysis, including list reports, nested crosstabs, discontinuous crosstabs, and multi-functional charts to provide a high level of visibility into the data.
The newly implemented data warehouse provided a clean and accurate dataset; something that was extremely important for the data queries needed by the client. Additionally, the client had a prominent need for a high level of security within this warehouse due to the sensitive data being stored.
Astir Services LLC works hand in hand with Astir IT Solutions and Astir Analytics to offer a comprehensive suite of services to our clients from the Astir Family of Companies.