Selected Case Studies
At Prologika, we are passionate about what we do. Our biggest reward is seeing
how our business intelligence solutions improve the reporting and analytics
needs of our clients. This page lists selected case studies with abstracts from some of our engagements.
Please contact us if you need more information.
Enterprise Data Warehouse
Industry: Record Management
Mobile BI Solution
Problem: With 80,000 customers around the globe, a document management company required an enterprise data warehouse
to consolidate data from its regional offices, as well as an analytical layer for historical and trend reporting.
Solution: Designed the dimensional schema of the data warehouse. Implemented a multidimensional cube for inventory management.
Microsoft published a case study "Records Management Firm Saves $1 Million, Gains Faster Data Access with Microsoft BI".
Technology: Analysis Services, Reporting Services, Integration Services, SharePoint
Industry: Record Management
Problem: A provider of records management solutions, needed to give its traveling salespeople mobile business intelligence (BI) tools to better serve customers and increase sales.
Prologika delivered a BI solution based on Microsoft SQL Server 2012 that gives sales professionals instant access to customer information from their mobile devices.
These employees now have better customer insight, which helps increase sales. The company also saved money by not having to develop a custom mobile BI solution.
Solution: Prologika implemented PerformancePoint Services in Microsoft SharePoint Server 2010, as well as scorecards and dashboards used for monitoring KPIs.
For mobile self-service BI, we created a URL that links to the new SharePoint site, so several hundred traveling sales professionals now have instant access to detailed customer information from their laptops, tablets, and smartphones. End users enjoyed Microsoft SQL Server 2012 Power View, a new interactive data-exploration and data-visualization feature in SQL Server Reporting Services that works within SharePoint Server 2010.
Microsoft published a case study "Records Management Company Gets Real-Time BI, Boosts Sales with Mobile Solution".
Technology: Analysis Services, Integration Services, Reporting Services, Integration Services, SharePoint, Power View
Enterprise Reporting System for Internal and External Users
Problem: A leading marketer and distributor of stored-value gift and prepaid products
needed an accurate and timely reporting system for internal users and external partners.
Solution: Implemented a multidimensional cube on top of a 1.5 TB data warehouse with security policies to provide trustworthy access to data.
Architected Active Directory and Kerberos-based security for external reporting. Developed ETL processes for
loading the data warehouse and cube processing.
Technology: Analysis Services, Reporting Services, Integration Services, Active Directory
"If you are a small, medium or large size corporation looking to set up any scale of
business intelligence I would personally vouch for Teo Lachev and Prologika as the place to go.
There is no other place to find a more comprehensive and well rounded BI Consultant"
Portfolio Monitoring Reporting Solution
Problem: A solution provider required a reporting platform for monitoring the credit rating of bank customers applying for loans.
The solution had to support both online and offline reporting. Flexible searching and filtering capabilities were required to allow a bank manager to search
Solution: Designed an Excel-based reporting system that integrated with SharePoint. The system supported report versioning, automatic data refresh,
and tracking server performance and utilization. The implementation cost was much lower than the initial budget estimates.
Technology: PowerPivot, SharePoint, SQL Server
Enterprise Data Warehouse
Problem: A global mining company with projects in 20 countries required a multidimensional layer for analysis of manufacturing and financial data.
Solution: Implemented cubes for measuring profitability and performance. Recommended best practices for cube design and reporting.
Integrated the cubes with SAP Business Objects.
Technology: Analysis Services, Business Objects
Decision Support System
Problem: A Specialty Provider (ISSP) focused on providing comprehensive management solutions to the oncology market required
a BI solution to analyze patient data and profitability.
Solution: Implemented a dimensional model from the company's MUMPS database for patient, provider, treatment, and other medical information,
as well as financial data from the Solomon accounting system. Implemented two multi-dimensional cubes and a set of Reporting Services standard reports.
Designed a PerformancePoint dashboard with key performance indicators.
Technology: Analysis Services, Integration Services, SharePoint, PerformancePoint
Ongoing BI Coaching and Implementation
Problem: A not-for-profit, state-chartered workers' compensation insurance company required an ongoing support support for implementing organization BI solutions.
Solution: Assisted this company with their Analysis Services and Reporting Services implementations.
This included implementing a cube for claims analysis.
Data was delivered through Excel PivotTable and Reporting Services reports.
Technology: Analysis Services, Integration Services, Reporting Services, SharePoint, SQL Server
"I have to say that I have worked with several consultants over the years and this has been my very best experience!
He is extremely knowledgeable about Reporting Services and Analysis Services and is great at explaining how to do things.
He is also very good at explaining different options and best practices."
Industry: Human Resources
Problem: A solution provider needed a flexible web-based report platform capable of generating reports based on end-user selection.
Solution: Implemented an ASP.NET application for auto-generating Reporting Services reports. Provided ongoing mentoring support to transfer technical expertise.
Technology: Reporting Services, SQL Server
"Teo has shared his expertise, taught us how to be self-reliant (when possible),
saved us in tight pinches, and has overall been a great, responsive support to our company. We have been able to take on bigger projects, upgrade our intellectual property,
and grow our company -- all due to his assistance."
A leading global provider of information management systems for the financial services industry envisioned business intelligence solution
to meet the reporting needs of banks and credit unions.
Solution: Implemented a financial dashboard to meet the multi-dimensional analysis and reporting needs of banks and credit unions.
Implemented coplex multidimensional cubes for analyzing financial and accounting data.
Analysis Services, Reporting Services, SharePoint
"Teo is the only professional who I met over long years of experience who has a full understanding of what he is doing - he has full "encyclopedic" understanding of Business Intelligence, SSAS, SSRS and SQL that is matching his working experience."