Relational Solutions, are experts data warehousing, business intelligence, data integration and demand signal repositories. We have specialized in these areas since our inception in 1996. Our consulting services have provided customers with a proven, results-based methodology for architecting, designing and deploying small to very large scale solutions that have stood the test of time. Our demand signal repositories, data warehouses and business intelligence solutions are designed in a way that allows the solution to grow with the company. As new sources need to be integrated, our infrastructure will support and leverage that new data to support on-going and growing business user needs. We hire only the best. Our consultants are well known industry experts who have extensive experience in the skills required to develop a solid architecture. We hold our consultants to high standards and they do not fail us. They are the best.
Our Consulting Services and expertise in data integration, data modeling, data warehousing, business intelligence and database design keeps our customers coming back. No other consulting company has a longer history with ETL (extraction, transformation, load) processes than Relational Solutions. We were the first company in the country to implement Informatica and the first to implement DataStage, now Infosphere from IBM. Our POSmart product is designed for the consumer goods industry and our solutions in this space streamline the implementation process for our customers. However our consulting services are used across all industries. We have built some of the counties largest scale data warehouses including for Chase Manhattan Bank, Chrysler, Xerox, Timken Industries and many others. Our expertise in ETL, data warehousing, data cleansing, data integration, business intelligence and tools surrounding these areas is unsurpassed. We can also help you with your big data needs. We implemented the first click stream analysis project back in the late 90′s and we are one of the first to integrate big data with internal data sources. Please contact us at 440-899-3296 x225 for information on how we can help.
** NOW OFFERING **
Analytics as a Service.
The market is seeing a severe shortage of data scientists and business analysts in the areas of sales, marketing, supply chain and financial analytics.
Mindtree has recognized the need in this area and in the past year, since the Relational Solutions acquisition, we have put together a program to address this need. Cleveland is now Mindtree’s COE, Center of Excellence, for analytics. We have hired more people and doubled the size of our office.
In addition to offering the integration services and report set up that we have offered for over 20 years, we will now be offering analytics as a service that not only gives insights, but also provides predictive outcomes and prescriptive recommendations. Analytics will be provided across all industries. For consumer goods manufacturers we will offer several levels of analytical services.
Level 1: “Standard Analytics Services” will include Retailer Scorecards, Retailer OOS (using Retailer on hand data), Velocity Trends, New Item Tracking, Store Rankings and YOY Sales Trend Analysis.
Level 2: “Advanced, Predictive Analytics Services” will include the above reports plus OSA (On-shelf Availability), Replenishment, Supply Chain, SOQ (Suggested Order Quantity), OOS (Out of Stock). OOS will use Mindtree’s Algorithm for cases where the Retailer Inventory isn’t used, is non-existent, or unreliable. ESR (Estimated Sales Rate), and Cross Retailer analysis is also included in Level 2.
Level 3: “Advanced, Prescriptive Analytics Services” will include Alerts & Recommendations, Cross Selling, Root Cause Analysis, In Store Execution, The Perfect Store (What was suggested vs. What they did). Post Promotion Analytics (PPA) using current data, highlighting analytics such as Spike in Sales (lift) and Reduction in Price.
Level 4: “Other Analytics Services” will include VMI (Vendor Managed Inventory), CAO (Computer Assisted Ordering & Monitoring), Planogram Analysis and Retailer Key Initiative reporting. We will also leverage our TradeSmart Model which integrates TPM plan data for Advanced Promotion Analytics, Integration of Competitive data, and Cannibalization models. PromoPro will be offered to give users the ability to group tactics into a single event as well as an interface to correct misaligned data such as ship dates, quantity, etc.
Companies secure successful projects by taking short-term advantage of industry experts. Relational Solutions has been building Business Intelligence systems for over a decade. We have worked with some of the largest, most successful companies in the world such as J.M Smucker, Sara Lee, Coke, Pfizer, Chrysler, Johnson & Johnson, GlaxoSmithKline, Timken Industries, First Quality, and many more. This experience has given us a huge base of knowledge, not only from a technical standpoint, but from a business standpoint as well. After all, how can you sell Business Intelligence products without understanding business?
To deliver actionable Business Intelligence to end users on time and within budget, to implement manageable solutions that do not render our clients dependent on our services, to maximize our clients return on investment and to develop the reputation as the premier data warehouse experts in the country.
Contact us at 440-899-3296 x225 or [email protected] for more information. We would love to hear about your project and help lead you down the path of success!