What we do

With over 20 years of rg1 experience our consultants can pretty much do anything.

  1. Data Cleaning & Matching
  2. Data Quality with easy to read dashboards
  3. Data Integrations from or to external systems
  4. Advanced Data Warehousing 
  5. Data visualization
  6. Data Connectors to external systems
  7. Data Migration from or to external systems
  8. 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 rg1, 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

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.

e-commerce
data migration

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.

golden records
political campaigns

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.

healthcare
vacation rentals

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.

real estate
reusable components

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

databases