BI Architects develops Business Intelligence solutions for its customers. Furthermore it has developed BI solutions for managing its own business processes, such as the solution that helps the project managers monitor, track and report project progress (including KPI's and earned values), the finance department enable swift and correct detailed invoicing and the management team gaining direct insight in the performance/profitability of projects.
BI Architects has chosen the Clarizen's online project management software for the registration of customers, projects, milestones, tasks and writing time. The Clarizen tool takes care of the complete project administration/resource management/and much plus it gives basic insight in performance via reporting. What it lacks is giving a more detailed insight in the performance of project phases over projects (for comparing project performances and quality improvement), earned values (current status and expected outcome) of projects and more figures needed for project management that are available without starting reports, setting parameters, running the report and opening the result in MS Excel.
What we have done is developing a standard Microsoft SQL Server Integrated Services/SQL Server Analysis Services (SSIS/SSAS) solution that adds what we miss in the Project Management tooling. SSIS is used for the extraction, transformation and loading of data from the Clarizen database into a staging environment (dimension tables), while SSAS delivers actionable insights (cubes and its dimensions) and made available via a pivot table in Microsoft Excel.
All information is now available via MS Excel and on the fly customizable serving several purposes within the BI Architects (project) organization.
For more information on our project management BI solution please contact me via H.O.Israel@bi-architects.nl . For more information on Clarizen's online project management software go to Clarizen.com .
Hermann-Otto Israel
BI Architects project manager
