The Kolotti Group can assist with working on a specific project or by serving as a part-time “as needed” Chief Information Officer—our CIO+prn SM service. Our ideal CIO+prn SM client is one that is using spreadsheets and/or a database manager but is finding that maintaining and updating them requires considerable time and effort and producing actionable reports is a challenge. We serve as a bridge between business requirements and the “nuts and bolts” of information technology.
Quite often, smaller organizations do not have the IT resources to have full-scale analytic/business intelligence operations and/or dedicated staff. They rely on existing staff to organize and interpret data, typically using spreadsheets. The skills of the staff developing and using the spreadsheet solutions may run the gamut from expert to novice. This often results in reports being produced in a “hand-o-matic” fashion, basically reproducing formulas and reports every time they are needed. This results in with little to no consistency or reproducibility from person-to-person or from month-to-month.
• Optimizing existing spreadsheet solutions and automating them so that you are not recreating them every time new data are available
• Designing prototype data structures and reports that can be used to create reports within more robust business intelligence (BI) solutions such as Crystal Reports, IBM Cognos, MS Power BI, etc. that you may be considering or implementing.
• Structuring your data flow to improve reliability and timeliness
• Optimizing and automating existing spreadsheet solutions
• Visualizing your data so you can instantly see what’s important
• Comparative analyses of clinical and business metrics
• Forecasting trends
• Geo-mapping analyses
• Dashboards & Report Cards
Copyright © 2019 The Kolotti Group - All Rights Reserved.