The objective was to develop an analytical support system that would enhance ambiscale’s understanding of time management, identify pain points, and highlight areas for improvement.
(01) PROJECT OVERVIEW
The new system needed to be accessible through an intuitive dashboard.
In mid-2023, Jerzy Kozyra, CEO of ambiscale — a company specializing in web solutions such as web development, eCommerce development, cyber security, and more — found himself contemplating the influx of new projects. Three new projects in a pipeline raised critical questions about resource allocation.
details
Industry
Tech
Market
Polish
Time
28 days
Project Type
Full-time
Services
Data Visualisation
(02) Challenge
What can ambiscale improve to collect and analyze better data we have?
How to avoid overlaps in crucial moments of a project and days off of a team? The challenge was compounded by the need to coordinate across multiple time zones, regularly engaging with clients from the USA, Canada, and Western Europe.
(03) Goals
4 Layers Solution
Communication Layer
Integration with the time tracking system using APIs to ensure seamless data flow.
ETL Layer
A robust ETL (Extract, Transform, Load) layer to extract data, prepare it, and build a continuous data stream.
Storage Layer
A dedicated storage solution that securely stores data, is compliant with GDPR, and is accessible for BI tools.
Reporting Layer
A specialized reporting solution enabling the creation of dashboards using Looker, Tableau, or Power BI.
(04) BENEFITS
Data are up-to-date
Enhanced Accuracy
The system provides a more precise representation of work hours and project progress by considering human factors and historical data edits.
Improved Efficiency
Insightland’s automation of data updates and integrations significantly reduces administrative overhead and the potential for human error.
Real-Time Insights
Stakeholders can access up-to-date project status and progress information, at any time, facilitating informed decision-making and transparent communication.
Scalability
The system’s automated processes ensure consistent performance regardless of the volume of data or number of projects being managed.
(04) details
Key features
Our comprehensive solution includes a suite of automated scripts designed to enhance data accuracy, streamline reporting, and provide valuable insights into project management. Here is a breakdown of the key scripts we implemented:
Seamless Data Integration
Our software automatically updates and integrates the latest workload data into designated sheets, maintaining real-time synchronization between estimation and actual work data. This feature significantly reduces the need for manual updates, thereby saving valuable time and minimizing the risk of data entry errors.
Intelligent Data Extraction and Verification
The system employs sophisticated algorithms to regularly retrieve and analyze logged work time data, accounting for historical edits and potential human factors. This approach ensures a more accurate and realistic view of work hours, considering common issues such as delayed time logging or input errors.
Automated Execution and Reporting
Leveraging advanced scheduling capabilities, the system runs scripts at predetermined intervals, ensuring continuous data retrieval and updates without manual intervention. This automation guarantees that stakeholders, including internal team members and clients, always have access to the most current information through a user-friendly dashboard.
Client testimonial
“The analyses that the ClickUp tool provided were insufficient. I had too little information about the team’s performance. I needed deeper analysis, additional insights and more advanced reports, so I contacted Christopher from Insightland. As I expected, he knew straight away what could help..”
— Jerzy Kozyra, ambiscale
Jerzy Kozyra
CEO
(05) Results
The project started with one hesitation that led to a conversation with Krzysztof from Insightland.
Still, over time it evolved into something way bigger, which also helped even with the team’s profitability. An automated tool with eleven scripts isn’t finished yet and we can’t wait to tell you soon about further improvements that we hope will bring us the next discoveries. By focusing on automation, cost savings, data literacy, team efficiency, and management, Insightland ensured that ambiscale’s team could utilize these solutions daily, driving performance and productivity improvements.
The automated tool with eleven scripts is not a finished project and we look forward to telling you soon about further improvements, which we hope will bring further changes for the better.
