Are Your Reports Telling the Right Story?

At Mosaic Consulting Group, we believe data is only as powerful as the way it’s presented. A well-designed report doesn’t just display numbers—it answers questions, supports decisions, and helps your team take action. But too often, we see reports that are either overwhelming, underwhelming, or just plain hard to read.

The good news? It doesn’t take a total overhaul to improve your reporting experience. Sometimes, it just takes a shift in perspective—and a few smarter design choices.

Reporting Isn’t Just About the Data

Many organizations rely on standard UKG Pro reports for day-to-day tracking. But when the business needs evolve—especially when leadership is asking deeper questions—those default reports can fall short.

That’s where Business Intelligence (BI) comes in. UKG Pro’s BI tools (also known as People Analytics or Cognos Analytics) offer the flexibility to design reports that are visual, interactive, and personalized. Whether you’re monitoring labor costs, reviewing benefits usage, or running a pre-payroll check, custom BI reports give you the clarity and depth you need.

How Design Shapes Decision-Making

Good reporting design is less about technical complexity and more about intentional structure. The way information flows—where headers are placed, how data is grouped, when summaries are shown—can dramatically affect how the report is understood.

For instance, having both summary and detail in the same report allows users at different levels of the organization to access the data they need without having to request a separate version. Adding elements like prompt selections, timestamps, and clear labels ensures every report can be traced, validated, and trusted.

As Robin Hoelscher, one of our reporting experts, says:
“The best reports don’t make you think. They just make sense.”

One Report, Many Perspectives

Pages, when used thoughtfully, help create those “makes sense” moments. They allow you to structure a single report for multiple audiences. A payroll report might include a clean summary for leadership, followed by audit-ready pages for the finance team. A headcount report could show trends by department on one page and regional breakdowns on another.

But we don’t stop at layout. We also help clients bring in real-time logic: fields that update based on the latest data, calculations that flag anomalies, and visuals that show trends at a glance. This is what elevates a report from being a static document to a true decision-support tool.

Real Use Cases, Real Impact

Here’s how we’ve seen organizations benefit from better BI report design:

  • Faster audits: When pre-check reports are broken down clearly by issue (like missing direct deposit info or zero net pays), problems get fixed before they reach payroll.

  • Simpler compliance tracking: One of our clients reduced their manual audit process by 60% after switching to a multi-page employee change report built around status changes, terminations, and leave activity.

  • Leadership visibility: High-level metrics, paired with contextual detail, give executives what they need to make faster, data-driven decisions—without digging.

It’s Not About Fancy Reports—It’s About Functional Ones

We’re not here to make flashy dashboards no one uses. We’re here to help you build reports that matter—ones that support your goals, reflect your processes, and make your job easier.

So if you’ve ever felt like your reports aren’t quite telling the whole story, or you’re constantly pulling from multiple sources to get a complete view, it might be time for a better approach.

At Mosaic Consulting Group, we specialize in BI report design that’s clear, efficient, and built to scale with your business. Let’s make your reports work harder—so you don’t have to.


Contact us today to get started.

The Power of Pages: Enhancing Your Reporting Capabilities

During our recent webinar, Robin Hoelscher discussed the power of using pages within report. Click here to view the full tutorial and follow along with the information shared below.

What Are Pages?

Pages are a crucial element in designing the layout of your report, functioning much like blueprints for building a house. They allow you to structure your design work in the background, giving your reports a clean and organized appearance.

When starting with a blank page, you’ll notice several key components:

  • Navigation: Found at the top left.
  • Display and Property Section: Located at the top right. As a visual person, I often switch to page preview mode while building to see a live preview of my work. This can be easily toggled from the page design settings.
  • Toolbox Icon: Positioned on the left, this is where you find all the tools to aid in designing your reports.
  • Main Layout: The central canvas where you bring your report design to life.

Designing Your Page

Let’s delve into designing a page. Transforming a blank canvas into a fully laid-out report includes several elements:

  1. Headers and Footers:
    – Add headers through the top editing menu by clicking on the more icon and selecting the option to add headers and footers.
  2. Tables:
    – Tables help organize your report layout, making it easier to read. They can be found in your toolbox.
  3. Plain Text:
    – Use the text feature in your toolbox to add titles or list out prompts in your report.
  4. Run Date and Time:
    – This is a calculated field that updates automatically when the report is run, showing the most recent timestamp. This is especially useful for reports that are run multiple times.
  5. Prompt Selections:
    – This feature displays the prompt selections made when running a report. Drag and drop the layout Calculation option from your toolbox into your layout and configure it to show the selected prompts.

Benefits of Multiple-Page Reports

Think of multiple-page reports as packages, each page serving a specific function like different rooms in a house. Here are the key benefits:

  • Displaying the Same Data in Multiple Layouts:
    – You can have different layouts within a single report, such as headcount by supervisor or by location, eliminating the need for multiple reports.
  • Summary and Detail:
    – Have pages dedicated to summaries and others to details. This is particularly useful for benefits and census data, ensuring you have a comprehensive view in one report.
  • Separate Sets of Data in a Single Report:
    – For example, combining payroll history and year-end audits in one report to automatically reconcile totals.
  • Increased Efficiency and Organization:
    – Consolidate multiple reports into a single package, making it easier to share and audit data.

Examples of Multi-Page Reports

Here are some practical applications of multi-page reports:

  • Post-Payroll Report Package:
    – A comprehensive package containing all necessary data for payroll reconciliation.
  • Pre-Check Reports:
    – Customize reports to include specific audit points like zero net pays, enhancing your pre-check process.
  • Employee Change Audit Package:
    – Track new hires, terminations, leaves, and other job changes in one comprehensive report.

Additional Page Options

To work more efficiently with multiple-page reports, consider these options:

  • Pages as Tabs:
    – Display reports as tabs in HTML by selecting “view pages as tabs” in the report properties. This makes navigation between pages seamless.
  • Running a Single Page:
    – Run only the page you are currently working on by selecting the page and using the run icon to choose the format. This saves time and resources.

Harness the power of pages to create organized, efficient, and visually appealing reports that cater to all your data needs. Whether you need a comprehensive overview or detailed insights, pages offer the flexibility and functionality to elevate your reporting capabilities.

The Essence of UKG Pro BI Reporting

BI reporting is the heartbeat of modern businesses, and UKG Pro (formerly UltiPro) stands as a beacon in the realm of cloud-based human capital management software. It offers a suite of tools that empowers users to craft custom reports and dashboards effortlessly. The system boasts a user-friendly interface, complete with drag-and-drop tools and a library of visualizations that transcend technical barriers.

Unlocking the Benefits

1. Informed Decision-Making: BI reporting accelerates the identification of trends, empowering users to make informed decisions on hiring, retention, compensation, and benefits.

2. Customizable Dashboards: Tailor your dashboards to display the metrics and Key Performance Indicators (KPIs) that matter most to you. It’s about putting the information you need at your fingertips.

3. Improved Data Accuracy: Bid farewell to manual data entry. UKG Pro BI reporting extracts real-time data directly from the system, ensuring accuracy and reducing the risk of errors.

4. Streamlined Workflows: Automate routine tasks effortlessly, from sharing reports with stakeholders to updating dashboards. This efficiency frees up time for more strategic tasks.

Maximizing Results with UKG BI Reports

• Present Key Metrics: Showcase crucial metrics to your leadership teams.
• Cost Reduction and Productivity Boost: Identify gaps and new efficiencies to reduce costs and increase productivity.
• Regulatory Compliance: Manage and automate regulatory compliance and government reporting effortlessly.
• Fraud Prevention: Detect and prevent fraud and abuse within your organization.

Client-Ready Reports Crafted with Love

Our BI reports are not just reports; they are crafted with love to cover various aspects of your business. Here’s a sneak peek into what we offer:

• EEO-1 Report: Dive into a demographic breakdown of your workforce by race and sex, essential for the annual EEO-1 Joint Reporting Committee submission.

• Headcount Dashboard: Visualize the dynamic headcount within your component companies, organization levels, and age groups of your workforce.

• Leave of Absence: Get detailed insights into the number of employees on leave and juicy details about their absence.

• Location Changes: Track work location changes seamlessly within a specified timeframe.

• Pre-Check vs. Payroll History: Compare your current payroll with historical data from the past year effortlessly.

Embarking on Your BI Reporting Journey

Getting started with BI reporting in UKG Pro is a breeze. Armed with system access and permissions, users can choose from pre-built report templates or create custom reports using intuitive drag-and-drop tools. The interface is designed for exploration, encouraging users to unleash their creativity and discover the full spectrum of reports they can create.

Mosaic’s Expert Touch

For those delving into more complex reporting territories, Mosaic is your guide. Our expert assistance is just a click away. Explore the possibilities and elevate your data-driven decision-making with BI reporting in UKG Pro.

Ready to embark on a journey of informed decision-making? Dive into the realm of BI reporting with UKG Pro. Learn more about our expert assistance here. Your data-driven future awaits!

Supercharge Your Business with Mosaic’s UKG® BI Reports!

Hey there, business enthusiasts! We’ve got some exciting news to share – Mosaic is thrilled to introduce our brand-new client-ready UKG® BI reports! Say farewell to the headache of pulling reports yourself in UKG and get ready to embrace a suite designed to effortlessly empower you with key metrics.

Our UKG BI reports are not just your regular data – they’re the key to unlocking insights that can transform your business. Here are five fantastic ways Mosaic can help you level up:

1. Show off key metrics to your leadership teams: Impress your leadership with insights that drive informed decision-making.

2. Cut costs and boost productivity: Identify areas where costs can be minimized, and productivity can soar.

3. Discover gaps and new efficiencies: Find opportunities for improvement and keep your organization agile and responsive.

4. Manage and automate regulatory compliance and government reporting: Stay ahead of the compliance game with our automated reporting features.

5. Detect and prevent fraud and abuse: Be the superhero who identifies irregularities in payroll and nips potential issues in the bud.

Ready-to-Roll Reports

Our client-ready reports are crafted with love to cover various aspects of your business. Here’s a sneak peek at what they offer:

• EEO-1 REPORT
This report gives you a cool demographic breakdown of your workforce by race and sex, assisting in the annual submission filed with the EEO-1 Joint Reporting Committee.

• HEADCOUNT DASHBOARD
Imagine a dashboard that gives you a dynamic view of the headcount within your component companies, organization levels, and the range of your workforce’s age groups. Well, that’s exactly what we’ve got for you!

• LEAVE OF ABSENCE
This report spills the beans on the number of employees on leave, along with all the juicy details about their absence.

• LOCATION CHANGES
Track work location changes like a pro within a specified time frame, making managing your workforce a breeze.

• PRE-CHECK VS PAYROLL HISTORY
Ever wondered how your current payroll compares with historical data from the past year? Wonder no more – our report has got you covered!

Discover the joy of data-driven decision-making with Mosaic’s UKG® BI reports. Ready to unlock insights that’ll redefine the way you do business? Head over to our website for more info and take that exciting first step towards a future filled with empowerment and knowledge.

Boosting HR Efficiency: Dive into BI Reporting with Mosaic

Are you ready to embark on a data-driven adventure that will take your HR strategies to the next level? Look no further because Mosaic is here to help you unravel the power of BI Reporting, and it’s going to be a game-changer!

Why BI Reporting Matters

In the fast-paced realm of modern business, information is your most potent weapon. But what good is data if you can’t turn it into actionable insights? That’s where Business Intelligence (BI) Reporting comes in, and UKG Pro has just the tool to turbocharge your HR endeavors.

UKG Pro’s BI Reporting: Your Secret Weapon

So, you’ve been using those standard reports, but they’re not quite hitting the mark, right? It’s time to turn to the superhero of data analysis – BI Reporting. With UKG Pro’s BI tool, also known as People Analytics or Cognos Analytics, you can access a treasure trove of operational insights that are pure gold for decision-making.

What Can You Do with BI Reporting?

With Mosaic’s expert guidance and UKG Pro’s BI report building services, you’ll unlock a world of possibilities. Imagine having a bird’s eye view of crucial workforce metrics like employee demographics, benefits, time and attendance, labor costs, and employee performance – all at your fingertips! Our consultants will be your trusty sidekicks, guiding you through the maze of data analysis.

Why You Should Dive into UKG BI Reports

Still not convinced? Here’s what awaits you on this epic BI Reporting journey:

1. Impress Your Leadership Teams: Say goodbye to the days of uninspiring presentations. With UKG BI Reports, you’ll dazzle your leadership teams with compelling key metrics that drive your HR strategies forward.

2. Slash Costs and Boost Productivity: Uncover hidden cost-saving gems and watch your productivity soar to new heights. Efficiency is the name of the game, and BI Reporting is your cheat code.

3. Discover Hidden Efficiencies: BI Reporting isn’t just about numbers; it’s about finding those elusive gaps and inefficiencies in your HR processes. Prepare to be the efficiency detective your organization needs!

4. Stay Compliant Effortlessly: Managing regulatory compliance and government reporting can be a real headache. But fear not! BI Reporting can automate these tasks, saving you time and stress.

5. Fight Fraud and Abuse: The forces of fraud and abuse don’t stand a chance against your newfound BI Reporting superpowers. Detect and prevent issues like never before.

Are you ready to embark on this data-driven quest? Your journey begins right here: Get started today

Join Mosaic, and let’s transform your HR strategies into something truly magical with the power of BI Reporting! 🚀🌟