1 / 16

DATA ACCESSIBILITY

Learn about data access strategies, including reporting databases, data warehouses, data replication, and APIs, to prioritize product and development efforts for effective problem-solving in your business.

turnere
Download Presentation

DATA ACCESSIBILITY

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA ACCESSIBILITY

  2. DJ Bouchier Nishad Amin Chief Architect Sr. Director - Data Dustin Amesbury Product Manager

  3. Problem Statement How can I access my data to be most effective in solving the problems facing my business? Goal Understand and help prioritize Product and Development efforts surrounding Data Accessibility.

  4. Data Access Strategies Reporting Database • Separate database designed for reporting and custom queries • Index optimization for querying • Data synced at regular intervals from transaction database Data Warehouse • Different schema designed for business intelligence • Data optimized for analytical purposes • Data synced at regular intervals from transaction database

  5. Data Access Strategies Data Restore • Copy of the database is restored on a nightly basis • Database schema and indexes are identical to the transactional database Data Replication • Data changes are synced to the reporting database on regular intervals • Data is much more up to date then restore • Only data changes are moved

  6. Data Access Strategies Do I want a reporting database or data warehouse? Reporting database provides: Detailed transactional data Data warehouse provides: Analytical data

  7. Application Programming Interface (API) • APIs allow applications (“apps”) to communicate with one another • An API is the layer that governs the access points to a server

  8. API – Data Representation • XML – eXtensible Markup Language • JSON – JavaScript Object Notation ✅ ❌

  9. API Avionte API • Enables development of integrations by Partners, Customers, and Avionté • Provides data access for the following domains today: • Talent • Company • Order • Assignment

  10. API – What does this mean for me?

  11. Business Intelligence – Technology Data Warehouse - Sisense • Different schema designed for business intelligence • Data optimized for analytical purposes • Data synced at regular intervals from transaction database

  12. Business Intelligence – Use Cases Data Driven Recruiting • Funnel Analytics • Coaching Sales and Recruiters with ratios backed by real data Client Engagement • Using analytics to show value to existing clients • Using analytics to  show value to prospective clients

  13. Business Intelligence – Use Cases Forecasting • Contractor Forecasting and Gross Profit • Analyzing weekly falloffs and impact to GP • Predictive Analytics • Using current Win/Fill rates, Open Orders to predict Gross Profit

  14. What’s Next Back Office BI Data • In progress Go beyond APIs with Events • Delivered with our April and July releases

  15. Rate this session! • Open the Bizzabo app • Select the Agenda tab from the main screen • Locate this session by Name, Date and Time • “Rate” the session (0-5 hearts) • Scroll to the bottom & click Take Poll to leave more commentary THANK YOU FOR YOUR FEEDBACK!

  16. Questions?

More Related