Overview
A luxury hospitality group in Southeast Asia struggled to combine data coming from many systems and file types. Reports took days and delayed decisions. Krish Services Group built a modern analytics platform on Microsoft Azure. Leaders could view key business metrics within hours, helping teams act faster and manage properties more effectively.
Client Background
The client operates large number of hotels, resorts, and serviced apartments across Southeast Asia. Each property tracks occupancy, revenue, costs, and guest satisfaction using different tools and local systems. Data was spread across countries, languages, and formats, making it hard for leadership to get a single, clear view of business performance.
Challenges
- Data Silos Across Systems: Critical data was stored in flat files, SharePoint lists, and SQL databases, resulting in slow and error-prone reporting.
- Manual ETL Pipelines: Data was cleansed and combined manually in Excel, with no automation or lineage tracking.
- Delayed Access to Insights: Reports were refreshed weekly, which limited the ability to respond to performance changes in real-time.
Solutions
- Azure Synapse Implementation: We built a centralized SQL pool using Azure Synapse Analytics to ingest and manage data from multiple sources.
- Data Factory Pipelines and Cleansing: ADF and mapping data flows were used to automate transformations, deduplication, and quality checks.
- Power BI Dashboards: Visual dashboards enabled daily tracking of revenue, bookings, occupancy, and customer satisfaction metrics.
Technology in Use
Azure Data Lake
Azure Synapse Analytics
Azure Data Factory
Power BI
Business Value Propositions
- Faster Reporting Cycles: Reduced report refresh time from hours to a few hours, enabling same-day business reviews.
- Improved Data Governance: Established clear data controls and audit trails, improving trust and accountability for leadership teams.
- Wider Data Visibility: Enabled consistent access to key metrics across departments through centralized dashboards and reporting.
- AI-Ready Data Foundation: Created a structured data platform that supports future forecasting and advanced analytics initiatives.
Final Perspective
To facilitate quicker, data-driven operational and financial choices, Krish Services Group provided a scalable Azure analytics platform that unified complicated hospitality data, increased reporting speed, and offered leadership across hotels and resorts with timely, dependable insights.
Overview
A global energy services company collaborates with large facilities to utilize IoT sensors and track energy usage. As data volumes grew, their systems struggled to provide timely insights. They partnered with Krish Services to build an Azure-based analytics platform that turned sensor data into clear signals, enabling early action, lower costs, and better energy efficiency.
Client Background
The client is a global provider of smart energy services for industrial customers. They deploy sensors across buildings and equipment to track energy usage, improve performance, and support sustainability goals. Their focus is on helping organizations lower energy costs, reduce waste, and operate more efficiently across large, distributed environments.
Challenges
- Disconnected IoT Data Sources: Unreliable analysis and a lack of a trusted operational view due to sensor data arriving in different formats across sites.
- Delayed Real-Time Monitoring: Delayed visibility into energy spikes and device failures due to batch processing, causing higher costs, slower responses, and missed efficiency opportunities daily.
- Inability to Scale Data Processing: Legacy infrastructure could not handle growing IoT data volumes, restricting expansion, increasing risk, and limiting future analytics capabilities for the business.
Solutions
- Centralized IoT Data Platform: Built an Azure data lake with Databricks to ingest, clean, and analyze sensor data, enabling reliable anomaly detection at scale.
- Real-Time Operational Dashboards: Delivered Power BI dashboards showing live energy metrics across sites, helping teams spot issues faster and act quickly and confidently.
- Scalable Streaming Architecture: Designed a scalable Azure architecture to process millions of records daily, supporting alerts, growth, and future sensor expansion reliably and securely.
Technology in Use
Azure Data Lake
Azure Databricks
Azure Synapse Analytics
Azure Event Hub
Power BI
Business Value Propositions
- Predictive Maintenance Enablement: Early anomaly detection helped teams address equipment issues before failures, reducing unplanned outages and maintenance surprises.
- Lower Energy Waste and Downtime: Real-time monitoring reduced energy spikes and downtime, improving operational efficiency and controlling ongoing operational costs.
- Sustainability Visibility: Clear dashboards gave leaders visibility into energy usage patterns, supporting sustainability targets and carbon reduction initiatives.
- Future-Ready Data Platform: A flexible architecture allows easy onboarding of new sensors without redesigning systems or disrupting operations.
Final Perspective
We unified IoT data on Azure, enabling predictive maintenance and energy savings today, while preparing scalable analytics that will improve sustainability, reliability, and faster decision-making across future operations globally.
Overview
A leading bank based in Singapore wanted to run an innovation event where people could try prompt writing and see how well their prompts performed in real time using a live Copilot setup.
The bank needed a smooth, quick, and reliable implementation. Our team stepped in to design a complete Copilot implementation using Microsoft 365 tools and Copilot Agent Flow. They needed a simple implementation that combined automation, quick scoring, and centralized reporting to support their internal teams and event visitors.
Client Background
The client was one of Asia’s leading financial institutions, known for its focus on digital and customer-first services. For its innovation event, the bank joined hands with us to show how prompt quality can impact real AI results. They wanted an experience that would guide attendees, give them real results instantly, and help the bank collect clean insights without any manual effort.
Challenges
- Slow and manual scoring: Event teams struggled to review prompts quickly as each assessment took time and impacted the quality of engagement during live sessions.
- Scattered event data: Prompt submissions, user details, and accuracy results were stored across multiple locations. Hence, it was difficult for teams to analyze patterns, compare inputs, or create a complete view after the event.
- Uneven participant experience: Attendees wanted instant scoring, but manual processes could not support it.
- Limited visibility for event staff: Teams had no clear way to monitor submission volume or prompt quality. Without a live dashboard, they could not see trends or understand how users interacted with the activity.
Solutions
- Automated Copilot Agent Flow: The entire scoring process was powered by a structured Copilot Agent Flow, hence, the manual scoring was removed and gave consistent results for every participant.
- QR-based submission process: Implemented a QR code that captured basic details and the user’s prompt, then stored everything in Excel automatically which reduced turn over time and provided event teams accurate data without any manual handling.
- Instant scoring and email delivery: New entry and triggers were automated after form submission through Power Automate. Each participant received a personalized score with improvement suggestions within moments.
- Centralized SharePoint and Excel logging: The data was stored in a connected Excel file and SharePoint list. It also created a clean audit trail for future use.
Tech Stack
- Microsoft 365 Copilot Agent Flow
Business Values
- Speed and efficiency: Processing time dropped from around 5 minutes to 10–15 seconds, and manual effort was reduced by over 90%.
- Scalability: The system can manage more than 1000 submissions with around a 99% success rate, running each flow in seconds while supporting multiple users at the same time.
- AI Analysis Quality: Prompts averaged a score of 82, with strong performance in intent and goal setting.
- Reusable Setup: The same model can support future events or internal teams with minimal changes.
Future Scope
This setup gives the bank a strong base to build richer AI-driven experiences. The project opened doors for broader AI services adoption across the bank. The next steps include adding real-time Power BI dashboards so teams can see live activity and trends during events. With these additions, the bank plans to support more events, internal programs, and customer interactions, making AI feedback a natural part of daily operations across the bank.
Overview
A financial data consulting company needed to update its old reporting setup and moving to a Power BI environment that supports real-time data, secure access, and better visuals. The client partnered with us to modernize the reporting experience, make faster decisions, and enable simpler access for thousands of finance brokers.
Client Background
The client creates analytical platforms and app-based financial tools. These help businesses check performance, compare with industry benchmarks, and make smart decisions. Businesses use their data solutions to check financial outcomes and improve growth plans.
Challenges
- The existing SSRS reports were basic, with limited interactive capabilities and limited visualization options.
- KPIs and filters were fixed and not dynamic; hence, users were unable to explore or modify views to examine business metrics from various perspectives.
- The report design and layout were outdated and did not support real-time data updates.
Solutions
- Built Power BI reports with direct, live connections to SQL Server data sources for real-time data visibility and up-to-date insights.
- Added industry benchmarks and top performer comparisons to dashboards. This helps users compare their performance with market leaders.
- Facilitated secure collaboration through Power BI license management and guest user access, ensuring proper stakeholder engagement with controlled data security.
- Designed modern, outcome-focused dashboards that prioritize visual clarity and intuitive usage to enhance the effectiveness of decision-making.
Tech Stack
The project used a combination of modern Microsoft technologies to ensure scalability, performance, and security.
- SQL Server 2014 and SQL Server 2022
- Power BI and Power BI Admin Portal
Business Values
- The company was able to update its financial reporting into a usable business asset through the new Power BI-based solution.
- Assisted the Bank of New Zealand with the organization’s successful Data Mining App services.
- Lifted collaboration across 17,000+ finance brokers through a robust license management framework utilizing Azure AD.
- Improved the report usability and visualization with Power BI’s dynamic data modeling.
Future Scope
We plan to help the client move toward a broader intelligent analytics framework. The next steps include forecasting models, automated data refresh using Power BI Service and Azure, and role-based dashboards for executives, analysts, and brokers.
