• >
  • >
  • >
  • >
  • >
Microsoft Azure (Microsoft) > 实例探究 > Analytics SaaS Provider Scales Instantly, Delivers Faster and More Cost-Efficient Service to Customers

Analytics SaaS Provider Scales Instantly, Delivers Faster and More Cost-Efficient Service to Customers

Microsoft Azure (Microsoft) Logo
公司规模
Startup
地区
  • America
国家
  • Canada
产品
  • Azure SQL Database
  • Azure Data Factory
  • Azure Functions
  • Power BI
技术栈
  • Serverless Computing
  • APIs
  • Business Intelligence
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Customer Satisfaction
  • Productivity Improvements
技术
  • 平台即服务 (PaaS) - 数据管理平台
  • 分析与建模 - 大数据分析
适用行业
  • Professional Service
适用功能
  • 商业运营
服务
  • 云规划/设计/实施服务
  • 软件设计与工程服务
关于客户
Inlitix is a small Canadian company providing software as a service (SaaS) business intelligence solutions, primarily targeting the small and medium business market. Founded in 2017, the company aims to offer affordable, scalable, and easy-to-use BI services. Inlitix focuses on interoperability across various enterprise resource planning (ERP) systems, providing out-of-the-box reporting and analytics solutions. The company leverages Microsoft Azure's serverless compute tier to automatically scale compute for its databases, ensuring quick performance response for 'bursty' workloads while maintaining cost efficiency. This approach allows Inlitix to refresh data faster, creating opportunities for more business insights and higher value for its customers. The company uses Azure Data Factory, Azure Functions, and Power BI to pull raw data, transform it into a common data model, and provide high-quality BI across a variety of business scenarios. Inlitix's innovative use of serverless computing enables it to balance cost and performance effectively, ensuring that it can meet the evolving data needs of its customers.
挑战
Most businesses generate a lot of data, but that data isn’t valuable for decision making if it’s not structured and analyzed. Analytics aren’t as effective if they are slow and expensive to produce. Inlitix was founded to offer a timely, easy-to-use, affordable BI as a service for small and medium-size businesses. They focused on interoperability across different ERP systems with different datasets and offered out-of-the-box reporting and analytics solutions. However, Inlitix found that it only needed more compute power at certain times, such as when it spins up development and QA environments or when production data is refreshed. It didn’t make sense to pay for a constant high level of compute resources during the times when they weren’t needed. To minimize the company’s compute requirements and maintain affordability, staff would manually adjust and optimize queries, which took time away from focusing on more strategic tasks and adding value to their application. Inlitix wanted to optimize the balance between cost and performance of its databases while ensuring it could quickly process data from customer ERP systems and refresh Power BI reports more frequently.
解决方案
Inlitix adopted SQL Database serverless to automatically scale the company’s compute capacity for its development, QA, and production workloads. This decision was based on the seamless interoperation that it could achieve between SQL Database serverless and its existing environment, which includes Azure Data Factory and Azure Functions. The company uses Data Factory to push raw data into SQL Database serverless, where it transforms the data to create well-structured, high-quality warehouse tables. Azure Functions are then used to launch a Power BI refresh from the data in SQL Database. By combining Azure and Power BI, Inlitix has created an end-to-end environment that works together well, and it’s easy to monitor performance and manage security. The serverless approach allows Inlitix to pay only for the compute it needs, as SQL Database serverless automatically scales compute based on workload demand and bills only for the amount of compute used per second. This has significantly reduced the company's development and QA environment costs and increased efficiencies by reducing manual database management. The serverless databases are configured to automatically pause when not in use, further optimizing cost savings.
运营影响
  • Inlitix can now automatically scale compute capacity for its development, QA, and production workloads, allowing for more efficient use of resources.
  • The company has created an end-to-end environment using Azure and Power BI, which is easy to monitor for performance and manage for security.
  • Inlitix has significantly reduced manual database management, allowing the team to focus on more strategic tasks and adding value to their application.
  • The serverless approach allows Inlitix to maintain development and QA environments even if a project is paused, optimizing resource use.
  • Inlitix can now meet changing customer needs more easily, providing near real-time analytics for customers who require fresher data for better decision-making.
数量效益
  • Reduced development and QA environment costs by 10 times.
  • Cost savings for production workloads can be as high as 15 times.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 Asia Growth Partners 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 Asia Growth Partners 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。