With over 20 years of redpoint data management experience our consultants can pretty much do anything.
Data Cleaning & Matching
Data Quality with easy to read dashboards
Data Integrations from or to external systems
Advanced Data Warehousing
Data visualization
Data Connectors to external systems
Data Migration from or to external systems
Creation and hosting of intuitive dashboards using your data
We can also augment your internal team that may not have as much experience and hands-on mentor them through a project.
We have integrated over 100 different systems over the years through direct data connections, APIs, file exports, even screen scraping. We have logged tens of thousands of hours in redpoint data management, written hundreds of components, created 20+ data warehouse solutions and implemented many complex migrations.
We're highly pragmatic and our ultimate goal is to deliver solutions that meet your needs. At the core of our approach lies reusability and usability. By creating reusable data transformation objects and utilities we can save ourselves and the customer a lot of time in the long run. High usability is a key principle because your team should be able to continue adding to the solution.
Experience
Automotive Industry
Implemented a platform that powered the data of a popular US automotive sales portal.
E-commerce
Implemented a data warehouse solution for a large publicly traded E-commerce platform.
Migrations
Performed several complex migration between systems. No data structure is too complicated.
Golden Records
Created components to consolidate marketing data to a customer “Golden Record” for a large US retailer.
Politics
Implemented a platform that integrated many public and private political data sources to assist political campaigns during election cycles. We even were approached by a Candidate for the US presidency to lead his campaign from a data perspective.
Healthcare
We are HIPAA compliant and have implemented a platform to join, clean and analyze patient data from more than 18 different data sources.
Vacation Rental Properties
Integrated data from many short term rental property management systems into a consolidated data store to create advanced dashboards for occupancy trends, price optimization, and more.
Commercial and Residential Real Estate
Integrated data from commercial real estate property management systems and accounting programs into a consolidated data store to enable advanced reporting on occupancy, lettable areas, repurposing of areas, price optimisation, renovation planning, etc.
Reusable Utilities
We have created hundreds of reusable rg1 utilities. This is a key ingredient to our speed. We take a programming approach to data management. Redundant work is our worst enemy, and we believe that most data scenarios can be standardised down to neat little reusable components.
Integrations
Integrated with hundreds of different systems both public and private. Here is a sampling of some external systems:
Google Analyctis, Google AdWords, Twitter, SalesForce, QuickBooks, Slack, Discord, Google Sheets, Google Docs, Mandrill, Microsoft Dynamics, Unit4 Business World Accounting, Visma Accounting, BestNotes Electronic Health Records, Advanced MD Healthcare System, Kipu Healthcare System, Sigmund Healthcare, Zencharts Electronic Health Records, MyOutcomes healthcare feedback, OutcomeTools healthcare feedback, Avaya, Ring central, Call Tracking Metrics, Booking.com, BookingSync, Guesty, Kigo, PropertyPlus, Propertyware, TrackHS, Unik, Rently, Vreasy, Disruptive Technologies Sensors, Fenistra Property Management, AS400 based accounting system, Vitec, Yardi, SiSense Redpoint Logging
