At Chameleon BI, we are passionate about the achievement and success of our clients. Our solutions empower customers to own their data, take control of their enterprise, track performance, and this is demonstrated in the case studies below.

CASE STUDY 2

Challenge

Our client needed a solution to assist with a complex Data Warehousing project.

Solution

Provided a process for developing business-class applications and creating highly visible and enterprise-level reports for stakeholders to gain insight into the business.

Key Deliverables

  • Partnered with IT and business leaders to develop applications for internal use.
  • Aligned with BI team members to define development specifications and created data loads and reports that were high quality while ensuring their ability to automatically refresh the report more easily.
  • Created the necessary SQL objects/models to support a range of ad-hoc and standard-reports/dashboard in Power BI, Tableau and Excel.
  • Frequently responded to customer/stakeholder’s feature requests and feedback.
  • Responsible for all the ETL (Extract, Transform, and Load) Process from various data sources using SSIS packages.

CASE STUDY 3

Challenge

Our client needed a solution that could effectively and efficiently operate company systems by ensuring a robust and sustainable data architecture.

Solution

Created and maintained a data architecture that supports warehouse requirements which provide for expansion given budgetary constraints and availability of data and skilled resources. We also led the creating, enforced standards and procedures for bringing in application sources to ensure integration of system through data-warehouse design.

Key Deliverables

  • Ensure that each application database system data-load into the data-warehouse is operating properly and meets the company processing requirements.
  • Worked to minimize database ETL jobs downtime, monitor, fine-tunes, creating new processes to audit the job performance.
  • Ensure the integrity and accuracy of the data on Genesys, LDR/Guidewire, PDR/mainframe DB2 and warehouse tables.

CASE STUDY 4

Challenge

Our client, a dental practice’s current way of assessing lab costs requires manually finding data points in QuickBooks and reviewing P&L statements to find the necessary information. Our client pulls paper invoices from Paychex and does manual calculations to isolate these expenditures. This process was said to be time-consuming and lead to errors and loss of information.

Solution

Create a report that accurately tracks lab costs, supplies overhead and labor costs. This report would also provide a collections comparison (comparing actual income in QuickBooks to Dentrix “collections”).

Key Deliverables

  • To ease the process of reviewing financials for our client by creating a custom-made dashboard based on data from their dental practice.
  • Provided the client with the ability to view and examine their lab costs, procedure costs, budgeted versus actual costs, patient data, and more regularly.
  • Provided the ability to allow the client to look at their data weekly, monthly, quarterly and annually, allowing them to truly manage and maximize their profits.
  • Eliminated the need for our client to manually calculate or report on their financials.

CASE STUDY 5

Challenge

Our client was unable to see how many leads/candidates they were staffing were being placed into companies. Their data source did not have the ability to view this visually or in report form.

Solution

To extract their data by creating and developing an API connector for their data source, Bullhorn, allowing us entrance to then be able to examine, analyze, break down, and create a report on their data.

Key Deliverables

  • To ease the process of viewing their staffing placemen record in a single custom-made dashboard.
  • Created and developed our own API connector to extract their staffing data from their data source.
  • Enabled our client with the ability to interact, refresh, and be up-to-date with their staffing metrics.

CASE STUDY 6

Challenge

Our client’s current way of viewing their staffing data and reporting did not show them how long the process took from receiving a job order to finding the candidate to placing them in a company. Their internal staffing process and status changes within their data source were not reported.

Solution

Used our API connector to extract data from our client’s data source and implement hourly resolution pulls. We provided the ability for the client to see the status changes of a job order as well as the candidate’s statuses (includes phone screens, interviews, etc.) and where the candidate was placed.

Key Deliverables

  • Enhanced and developed our own API connector to extract their staffing data from their data source.
  • Enabled our client with the ability to interact, refresh, and be up-to-date with their staffing metrics.
  • Specifically created a funnel visual so the client was able to see how long their internal staffing process took from the job order to the placement.

CASE STUDY 7

Challenge

Our client needed a solution to assist with a complex Data Warehouse project in manufacturing, where the data was coming from many sources and formats in several geographic regions and needed to be assimilated into one reporting “source of truth”.

Solution

We created innovative tools for data acquisition and monitoring, which transformed the disparate data sources into one standardized data stream, and then built highly visible and enterprise level reports for stakeholders to watch key performance indicators (KPIs) of their manufacturing output.

Key Deliverables

  • Partnered with IT and business leaders to understand the target data sources at a deep level, and the KPIs that they were most interested in.
  • Built several innovative tools to extract data from disparate sources into Azure storage areas, transform the data into a standardized schema, and load it into the Data Warehouse.
  • Created a “Freshness” report so that any user could always know the freshness of any particular data source.
  • Aligned with BI team members to define consolidated report solutions that captured the most important KPIs, to replace data-specific reporting in silos of each individual data source.
  • Once the reports were delivered, provided training, documentation and videos of how the data as assembled, so that users of one of the source data systems could trace the lineage of data in the Data Warehouse
  • Created the necessary SQL objects and views to support a range of ad-hoc and standard reports/dashboard in Power BI data sets.
  • Continuously responded to customer/stakeholder’s feature requests and feedback.

Hear from our clients…

"The team at Chameleon has been a pleasure to work with. They have great technical ability to implement any custom metrics and visuals, and are always enthusiastic, friendly and happy to take time to communicate. The reporting service from Chameleon is very valuable to us, and provides many insights into our operations. Would definitely recommend!"

Mark Nishikawa
Data Engineer

"I appreciate how the staff at Chameleon listens to our requests and is proactive in finding solutions! Shout out to Jason and Prab - keep up the good work."

Carol Darling
Controller

Chameleon has been fantastic to work with! They helped us make a custom solution that fit our needs and even allowed us to expand on top of it on our own. Everyone on their team is very helpful and a delight to work with! I would highly recommend!

Daniel Hollis
Client Project Analyst

"The team at Chameleon has been so responsive to our questions, resolving any issues in a fast and efficient manner. They have truly partnered with our Talent Acquisition team to ensure the reports we received were meaningful to the business. Thank you for your amazing customer service! You rock!"

Jennifer Hegener
Sr. Technical Recruiter

"I love our financial report; I think it's fabulous. It’s been really good to be able to pull that report up to see how we're trending. We rely on these reports tremendously."

Anastasia Valentine
President/Managing Partner

"Now through the power of Chameleon BI reporting solutions, small and mid-sized staffing firms can affordably bring together data from all different sources within their organization. This is something we haven't been able to do before.

Maurice Fuller
Founder

"The Chameleon team and staff are technically strong and accommodating!"

Keith Echols
Executive Vice President

"Chameleon BI has constructed a tool that gives you the ability to look at KPI’s in near real time, to share that view with your organization, and to change your view on the fly, to perform ‘what-if’ analysis or to zero into an issue or question. I can’t think of a more useful and essential tool for a business manager, or an organization."

David Lawrence
I.T. Staffing Consultant

"I felt like I had no idea what was going on with the finances around my spending and advertising. Now I can see how much money I'm spending on job boards, how many placements I'm making with each job, and clearly see what my recruiters are doing. I can't believe how much time this saves me."

Lacey Clark
CEO

"I've been a strong supporter of the reports and tell everyone that the [Chameleon BI] reports are the correct numbers. 99.9% time, I'm right and that makes me feel good."

Crystal Black
Accounting/Business Operations Manager

"So excited to have this in our office! We have been playing around with QuickBooks and cross-referencing with numbers on there versus the BI portal just to be safe and everything is great. The tool has made my life so much easier!"

Megan Brown
Office Manager

"Working with Chameleon Technologies was an absolute pleasure. The staff and leadership really made it a point to ask targeted questions which led to better than expected results. The reporting and analytics sample [they] put together has been very helpful in the storytelling process [with customers and investors]!"

Scott Ware
CEO & Founder

"The reports were a big hit during our annual meeting and everyone was very impressed by the detailed measurement capabilities!"

Kathryn Shaughnessy
Marketing/Technology Specialist

CASE STUDY 1

Challenge

Our staffing client was unable to create monthly financial reports showcasing daily hours worked by their consultants.

Our Solution

To provide an automated and custom-made dashboard linked to their data sources (Bullhorn and BBO), enabling us to extract and clean-up the data using advanced DAX calculations. This process allowed for the client to have a visual representation of their financials, giving them insight into their business.

Key Deliverables

  • Created and developed an API connector to connect to the client’s data source.
  • Aligned with BI team members to define development specifications based on the client’s feature requests.
  • Completed data acquisition on two data sources used in staffing, merging the data to produce a complete profile of the client’s financials.
  • Created the necessary SQL objects/models to support a range of ad-hoc and standard-reports/dashboard in Power BI, Tableau and Excel.
  • Frequently responded to the client for feature requests and feedback.

CASE STUDY 2

Challenge

Our client needed a solution to assist with a complex Data Warehousing project.

Our Solution

Provided a process for developing business-class applications and creating highly visible and enterprise-level reports for stakeholders to gain insight into the business.

Key Deliverables

  • Partnered with IT and business leaders to develop applications for internal use.
  • Aligned with BI team members to define development specifications and created data loads and reports that were high quality while ensuring their ability to automatically refresh the report more easily.
  • Created the necessary SQL objects/models to support a range of ad-hoc and standard-reports/dashboard in Power BI, Tableau and Excel.
  • Frequently responded to customer/stakeholder’s feature requests and feedback.
  • Responsible for all the ETL (Extract, Transform, and Load) Process from various data sources using SSIS packages.

CASE STUDY 3

Challenge

Needed a solution that could effectively and efficiently operate company systems by ensuring a robust and sustainable data architecture.

Our Solution

Created and maintained a data architecture that supports warehouse requirements which provide for expansion given budgetary constraints and availability of data and skilled resources. We also led the creating, enforced standards and procedures for bringing in application sources to ensure integration of system through data-warehouse design.

Key Deliverables

  • Ensure that each application database system data-load into the data-warehouse is operating properly and meets the company processing requirements.
  • Worked to minimize database ETL jobs downtime, monitor, fine tunes, creating new processes to audit the job performance.
  • Ensure the integrity and accuracy of the data on Genesys, LDR/Guidewire, PDR/mainframe DB2 and warehouse tables.

CASE STUDY 4

Challenge

Our client, a dental practice's current way of assessing lab costs requires manually finding data points in QuickBooks and reviewing P&L statements to find the necessary information. Our client pulls paper invoices from Paychex and does manual calculations to isolate these expenditures. This process was said to be time-consuming and lead to errors and loss of information.

Our Solution

Create a report that accurately tracks lab costs, supplies overhead and labor costs. This report would also provide a collections comparison (comparing actual income in QuickBooks to Dentrix “collections”).

Key Deliverables

  • To ease the process of reviewing financials for our client by creating a custom-made dashboard based on data from their dental practice.
  • Provided the client with the ability to view and examine their lab costs, procedure costs, budgeted versus actual costs, patient data, and more regularly.
  • Provided the ability to allow the client to look at their data weekly, monthly, quarterly and annually, allowing them to truly manage and maximize their profits.
  • Eliminated the need for our client to manually calculate or report on their financials.

CASE STUDY 5

Challenge

Our client was unable to see how many leads/candidates they were staffing were being placed into companies. Their data source did not have the ability to view this visually or in report form.

Our Solution

To extract their data by creating and developing an API connector for their data source, Bullhorn, allowing us entrance to then be able to examine, analyze, break down, and create a report on their data.

Key Deliverables

  • To ease the process of viewing their staffing placemen record in a single custom-made dashboard.
  • Created and developed our own API connector to extract their staffing data from their data source.
  • Enabled our client with the ability to interact, refresh, and be up-to-date with their staffing metrics.

CASE STUDY 6

Challenge

Our client’s current way of viewing their staffing data and reporting did not show them how long the process took from receiving a job order to finding the candidate to placing them in a company. Their internal staffing process and status changes within their data source were not reported.

Our Solution

Used our API connector to extract data from our client’s data source and implement hourly resolution pulls. We provided the ability for the client to see the status changes of a job order as well as the candidate’s statuses (includes phone screens, interviews, etc.) and where the candidate was placed.

Key Deliverables

  • Enhanced and developed our own API connector to extract their staffing data from their data source.
  • Enabled our client with the ability to interact, refresh, and be up-to-date with their staffing metrics.
  • Specifically created a funnel visual so the client was able to see how long their internal staffing process took from the job order to the placement.

CASE STUDY 7

Challenge

Our client needed a solution to assist with a complex Data Warehouse project in manufacturing, where the data was coming from many sources and formats in several geographic regions and needed to be assimilated into one reporting “source of truth”.

Our Solution

We created innovative tools for data acquisition and monitoring, which transformed the disparate data sources into one standardized data stream, and then built highly visible and enterprise level reports for stakeholders to watch key performance indicators (KPIs) of their manufacturing output.

Key Deliverables

  • Partnered with IT and business leaders to understand the target data sources at a deep level, and the KPIs that they were most interested in.
  • Built several innovative tools to extract data from disparate sources into Azure storage areas, transform the data into a standardized schema, and load it into the Data Warehouse.
  • Created a “Freshness” report so that any user could always know the freshness of any particular data source.
  • Aligned with BI team members to define consolidated report solutions that captured the most important KPIs, to replace data-specific reporting in silos of each individual data source.
  • Once the reports were delivered, provided training, documentation and videos of how the data as assembled, so that users of one of the source data systems could trace the lineage of data in the Data Warehouse
  • Created the necessary SQL objects and views to support a range of ad-hoc and standard reports/dashboard in Power BI data sets.
  • Continuously responded to customer/stakeholder’s feature requests and feedback.

Got Questions?
We've got answers!

Have a Question?