Caboodle

admin



  1. Caboodle is a digital product studio. We design and build products people love to use. Our expertise lies in fintech and storytelling with data.
  2. Caboodles offers a variety of makeup cases to fit in with any style to make you shine wherever you go. View all of the hard and soft makeup cases Caboodles has to offer.

Was created in response to the COVID-19 crisis to offer K-12 students creative learning experiences both in school and out. Puts the learner in charge of their own learning paths in a creative, collaborative, and experiential way.

Discover a world of imagination, creativity and fun! Little ones can explore their interests through soft play, dress-up, themed crafts and many other activities designed to promote physical, social and cognitive development.

PLAY

Caboodle’s expansive indoor play park offers children a wholesome and active environment to learn, explore and have fun. Ideal for children aged 6 months to 12 years of age, our facilities include soft play, mini city, climbing pit, jungle gym, arts & crafts, and so much more! Learn more.

EVENTS & CLASSES

Mark your calendar for fun and interactive mom & tot events. In addition toweekly play themes, our inspired monthly events are great for play dates. Follow us onsocial media,subscribe to our newsletter, or visit ourevents pagefor the latest news and updates.

CHILDREN’S SALON

Caboodle’s experienced stylists know everything about kids and their hair, so parents can breathe a sigh of relief. Kids love Caboodle because they can choose to sit in a car chair or big kid chair, watch videos, read a book, or just sit back and relax.Learn more.

FOOD & DRINK

Caboodle’s cozy and casual café overlooks the play area so children are always within view. Created for comfort and convenience, a variety of meals, snacks and beverages are available, so tummies of all ages are always happy when visiting!View our menu.

DROP ‘N SHOP

For children aged 18 months and above, enjoy some respite while our qualified and experienced staff babysit your little one with dedicated one-on-one care. Group Drop ‘n Shop options are also available for children 3 years and up.Learn more.

Now Open!

A new water-inspired play concept for young children

THE GALLERIA

Caboodleai

Al Maryah Island
The Luxury Collection,
North Wing Court L2

Contact

Phone: +971 2 679 8019
Email: thegalleria@caboodle.ae

Hours

Sat to Wed: 10am – 11pm
Thurs to Fri: 10am – 12am

Timings may vary on special holidays. Please contact the branch for details.

THE GALLERIA

Al Maryah Island
The Luxury Collection,
North Wing Court L2

Phone: +971 2 679 8019
Email: thegalleria@caboodle.ae

Opening hours:
Sat to Wed: 10am – 10pm
Thurs to Fri: 10am – 12am

Timings may vary on special holidays. Please contact the branch for details.

For many who work in Epic-focused analytics, Caboodle has become a go-to source for analyzing large volumes of data.

Caboodle was designed by Epic to work well with data visualization tools such as Tableau or Power BI. As such, it’s a dimensionally modeled version of Clarity that can be used to speed up report design and produce reusable development for similar requests.

Clarity contains the data recorded in your EMR, extracted and transformed from a hierarchical representation to a relational data model. Every field, button click, datetime, edit… it’s available for storing and reporting. This breadth of data creates endless possibilities for analysis, but its data models lack prioritization based on relative importance or frequency of use.

Caboodle has a curated data model, designed to surface data elements most commonly needed for reporting. Reports such as patient counts, procedure volumes, and medication totals usually require less time for analysis and use fewer tables than an identical report built in Clarity.

[Related: What is “DataOps” and why will it be so important in 2021?]

Caboodle and extensions

Compared to Clarity, Caboodle is simpler. There’s less confusion over which datetime field to use because there are fewer fields overall. Also, healthcare organizations can extend Caboodle to add tables or columns. If your organization has decided, through a data governance process, that surgical cases start at ‘wheels across the threshold’ or at ‘anesthesia start,’ that definition can be integrated in a custom ‘SurgeryStart’ column to ensure the policy is represented in reporting.

One organization I’ve worked with has an entire research-focused department working out of Caboodle instead of Clarity. Any requests for non-Caboodle data are sent to the Clarity reporting team or requested as additional tables in Caboodle if they are expected to be requested frequently.

Caboodle can also accept external data sources. Do you have non-Epic billing software? Export it into Caboodle and report on it there! Is there a data sharing agreement with another organization? Use Caboodle to merge the two data streams into a single combined data repository.

Next, I’ll discuss common scenarios for extending Caboodle and best practice recommendations. Many of these ideas are applicable to any enterprise data warehouse, so even if you aren’t using Caboodle, read on!

Adding columns to an existing table

The most straightforward method of adding additional data to Caboodle is to add new columns to existing tables. You will need to work with Epic support if you intend to modify the core Caboodle tables without limiting your ability to implement future Caboodle updates.

Creating a new load for an existing table

Sometimes a table needs to be repurposed and new records need to be added. Your DispenseMedFactExt was originally for internal dispenses, but now you want to include external pharmacy dispenses.

Make sure you have the same granularity in your new code. Is it one row per dispense, per attempted dispense, or per ordered dispense?

Be careful that your new code doesn’t pull in records that have been loaded by other ETLs or create a plan for merging two data sources. When possible, match your identification scheme with the original loads to the table. This will make it difficult to identify which load added the records but will make linking to the table much simpler. Epic’s documentation has details on how to set this up or your organization’s Bluetree Analytics Specialist will be happy to help.

Create an extended table

Creating a companion table is the most common form of extension. If your reporting requires additional fields using the same grain as existing table, then a companion table is a good choice. In this scenario, you can create a Dimension table extension or a Fact table extension to go along with the original.

The new table should have companion records for each record in the original table, but the new table contains different attribute columns. Matching the records helps with validation/documentation.

Over the past year, I worked on extensions for adding a phone number to a patient demographics table, including social worker in surgical case table and adding a claim submission count column to a financial transaction table.

Creating a new table

Suppose that your Caboodle database is working well, but now you want to add more functionality. Let’s say that there’s an influx of report requests for oncology treatment plans and that information is not in Caboodle. Like any data warehouse, it’s possible to build entirely new data models and include relationships to existing tables to seamlessly integrate the additional data.

Caboodles Animal Print

Prioritize the important fields and try to keep your data model simple while meeting the needs of the report. Focus on ease of use instead of database normalization: consolidate external tables as they come into Caboodle in order to reduce reporting complexity. It’s ok to anticipate future requests for a few fields, but don’t bring in entire Clarity tables ‘just in case.’

Table Design Workflow

The most effective tool that I’ve used for Caboodle extension design was created in house at an HCO. It contains all the information for the table and can be referenced by the database architect to build the table. Future modifications to a table are easier to handle with a design document as a trusted reference.

The design document contains details such as:

Caboodle Meaning

  • Table name
  • Table type (Type 1 or Type 2)
  • Column names
  • Data type
  • Clarity column(s) that generate the column
  • Foreign keys
  • Column descriptions for yourdata dictionary
  • An ERD showing how the new table fits with current tables
  • SQL code for the Clarity extract

Design Documents and SQL Code

A good way to explain your new table to future developers is to generate an entity-relationship diagram that shows how the new tables link to each other and the existing structure.

Caboodle Box

In this example, PatientDimension is an existing table with a new column being added. LocationDimension is an existing table with a new load added for infused departments. AppointmentFactExt is an extension if an existing table (AppointmentFact) and TreatmentPlanFactExt is a completely new table.

A few considerations for Clarity to Caboodle query development:

Caboodle

Caboodle Target

  • Brush up on CTEs (common table expressions). Many extract queries will require them.
  • Queries should be written without using temporary tables.
  • SQL performance is important. Your new table will probably be loaded nightly amongst many other processes, and we recommend carefully reviewing execution plans and monitoring extract times.

Summary

Caboodles Walmart

Caboodle is a useful tool for improving developer efficiency when creating reports. By extending Caboodle strategically, your organization can fulfill many data requests using Caboodle and still have the option to report from Clarity as needed.

—

Caboodles Makeup Organizer

If you’d like help extending Caboodle, reach out to us at communications@bluetreenetwork.com to see how we can help.