The Quantified Mechanix Blog
The following is an overview of the platform architecture used to facilitate the process of ingesting data into the Snowflake platform and transforming it into data models to facilitate a wide variety of reporting and analytics. I recently developed this with a client and felt that the general information would be useful to others going down the path of exploring and adopting tools and platforms like Snowflake, Fiveran and dbt.
The range of reporting and analytics that you need from UKG Autotime is broad enough to cause fits. You need real-time reporting to manage operations and more sophisticated analytics in order to manage performance and improve operations over time. In the past, this meant compromise. Operational reporting and analytics were separate and disconnected, performance was lousy, and lacked the detail needed to understand what was happening with confidence to make changes. Here is one solution based on a new approach enabled by the modern data stack.
A good design and approach to Cognos security can really help make your life easier. A well run and efficient model can make a software license audit a breeze, and can make day to day administration a task you don’t even notice. We have helped many clients implement security in Cognos and this is what we have learned. This will result in a Cognos implementation that performs well, is simple and intuitive to use for a variety of user profiles, and as a result maximizes user adoption and is easier to administer and maintain.
I have been a practitioner of the “Kimball Methodology” for more than 20 years, so naturally, when I received this provocative email, I had to go and read the “ebook”. Those who know me know I am opinionated, and when something fires me up, I like to offer my opinion, so here it is.
I’ve seen my share of missed opportunities. However, given the right approach, Analytics can be very effective, and very successful. I want to share this insight with you. It is only very rarely the profound and dramatic insight leading to massive change and impact we dream it should be. It starts with the business and it’s usually pretty simple. What are the key drivers of the performance you’re trying to manage and how can you manage them? Because this seems so boring, it seldom inspires the effort to get started and stick with it. It also starts with the business, not some new tool or technology that will solve every problem. And management talent seems hard to find some days.
Many organizations, of all sizes, struggle to use analytics to improve their operations because of information “silos”. Silos occur when the applications that run different parts of your operations can’t communicate with each other. You know you have a silo problem when you are unable to answer simple questions behind the reports. In some ways, the rise of cloud applications has made this worse because access to the data is different than it used to be.
Skilled nursing facilities operate in a challenging environment where changes are forcing operators to gather and use new data and use new tools. The cost and risks of these challenges in a declining market drives consolidation and stiff competition. But, analytics can make a difference.
CMS created the Five-Star Quality Rating System to help consumers compare skilled nursing facilities when choosing care providers. Has it worked? I think the results speak for themselves. SNF with 4 and 5 star ratings have: A favorable payer and patient mix Higher...
The cloud has delivered significant value – cost savings, speed to market and new capabilities, but getting access to data for analytics is a challenge. Here is an approach and toolset that brings those benefits to analytics.
A well designed analytics environment, built with modern tools and applications enables a virtuous cycle that creates a sustained competitive advantage.
Quantified Mechanix operates at the place where business, technology and data meet. We are equally talented, and exceptionally competent working with business leaders and IT to use technology to create real opportunities for the business. We turn data into...
The cloud has so much appeal: Low capital expense, easy implementation, reliability, and performance. Updates, new features, security and patching are managed by experts. But there are critical gaps. One of them is reporting. Many applications have limited reporting and analytical capabilities and few if any are integrated with other applications to provide key metrics to manage your business. Here is a solution.
"Quantified Mechanix had insight beyond just doing the job. They were careful to make sure I understood things I hadn’t thought of before we got into the project. Target received great value for the money."
Joanne Franer, Target Corporation
"Quantified Mechanix is technically very knowledgeable but more importantly they care about clients and want them to be successful. They have a unique ability to see the big picture and at the same time drill down into the details."
Rhett Lamoreaux, Graco
"Quantified Mechanix delivered MDS Assessment data into the hands of people who could use it. This created a new capability for our Assessment Coordinators, helping us manage compliance risks, identify missed reimbursement opportunities and drive faster, better decisions through new information-driven analytical tools."
Nate Ovenden, Director of Compliance
"Quantified Mechanix developed capabilities to link and analyze vast amounts of information, providing financial and operational insights—not just data—to our front-line operators. Instead of being buried in data, our operators now are able to make critical decisions more quickly and accurately. This saved my team hundreds of hours every month, and freed my team up to focus on things that could change business outcomes."
John Tranberg, Director of Finance