BI Consulting Services
Prepared for Kidde Global Solutions

Kidde Global Solutions · FP&A reporting

Seven brands, four regions, one P&L read the same way every month.

As KGS stands up its own systems apart from Carrier, the brand P&L that once rolled into a larger parent now stands on its own, from a Kidde alarm on a retail shelf to an Edwards panel on a hospital project.

You're hiring a Sr Reporting & Analytics Analyst. Here's the kind of reporting that role would own, built the way our team would build it.

Public context: KGS was formed when Carrier sold its commercial and residential fire business, with brands including Kidde, Kidde Commercial, Edwards, GST, Badger, Gloria and Aritech, to an affiliate of Lone Star Funds in a transaction valued at about $3 billion. Source: Kidde Global Solutions / Business Wire press release, December 2024. Every other figure on this page is sample data.

Brand P&L and Forecast Accuracy

One report page an FP&A team could open on close day. Every slicer recalculates every tile, chart and note below. Click a brand on the alarm or a cell in the grid to filter.

KGS · Brand P&L
Illustrative sample data. Built by BICS to show the approach; not Kidde Global Solutions figures.
Region
Month (2026)
Net sales vs plan
 
 
Gross margin %
 
 
Forecast accuracy
 
 
Inventory days on hand
 
 

The alarm view: share of sales and forecast accuracy

Seen from below. Vent slot depth is each brand's share of net sales. The inner ring shows forecast accuracy by region. The LED reads variance to plan.

Ceiling alarm chart of brand share and forecast accuracy

Net sales: plan, actual and forecast by month

Forecast is the one-month-ahead view submitted before each month opened. $ in millions unless marked.

Monthly net sales, plan versus actual versus forecast

Gross margin bridge: plan to actual

Gross profit dollars. Volume, mix, price, material cost and freight add up to the actual.

Gross margin bridge from plan to actual

Forecast accuracy by brand and region

1 − weighted MAPE, measured at brand × region × channel × month. Follows the channel and month slicers; the selected brand and region are outlined.

What the sample says, read both ways

Each card pairs what is holding up with where an FP&A team would look next.

Portfolio view, all brands, regions and channels, January through August 2026. Illustrative sample data.

How we'd staff this

A report like this is only as dependable as the people who keep it running after close. We staff it so it never rests on one person.

A lead developer owns the build: the semantic model, the DAX behind forecast accuracy and the margin bridge, and the refresh.

A backup project manager who also develops in Power BI knows the same model, joins the weekly calls, and can ship a fix the week the lead is out.

Principal oversight from our founder keeps the work tied to what FP&A leadership needs to see.

Power BI is the deliverable. If some readers don't hold Power BI licenses, we can also publish the same report as a no-license custom web version.

About 15 developers Mostly US-based: Charlotte area, Texas, Kansas Weekly calls and show-and-tells Microsoft Partner MBE-certified
View the team profiles (PDF)

Jonathon Martin

Lead Power BI Consultant

Semantic modeling in DAX and Power Query with row-level security; SQL across SQL Server, Snowflake and Oracle; ETL/ELT and Python automation. Enterprise Analytics & Visualization Consultant at Duke Energy (2020–2024). Lead developer on a six-solution Power Platform modernization for a Florida state agency.

Brandon Atkins

Principal BI Developer, project manager

The backup PM who also builds. Power BI, Power Apps, Power Automate, SharePoint, SAP HANA/BusinessObjects and AWS Redshift. Certified Scrum Master and Certified Scrum Product Owner. Previously Product Owner and Visualization Consultant at Duke Energy; earlier Coca-Cola Consolidated and Tyson Foods.

Kelsey Summey

Sr. Analytics & Solutions Consultant, project manager

M.S. in Data Science & Business Analytics, UNC Charlotte. Built Power BI reporting for seven departments at Duke Energy (2020–2026). Python forecasting and Salesforce integration.

Nichole McKinney

Founder & CEO, principal oversight

About 10 years in automation, API integration, reporting and analytics at Duke Energy before founding BICS in 2018. Top Rated Plus and Expert-Vetted on Upwork. Runs a YouTube channel with 100K+ subscribers teaching the Microsoft data stack.

One hire or a team

The posting lists $119,050–$140,059 a year for one analyst. That hire may be exactly right. Many of our clients use us alongside their analyst, so the build moves faster and the knowledge sits with more than one person.

One analyst hire
BICS team (alone or alongside your hire)
PTO and turnover
Reporting pauses when the analyst is out, and a departure restarts the search.
A lead and a backup developer both know the model, so month-end still ships.
Time to first dashboard
Recruiting, onboarding and ramp come before the first build.
An existing team starts on data access and a first page in the opening weeks.
Breadth
Depends on one person's mix of Power BI, SQL and scripting.
Power BI, SQL, Power Automate, Python and Azure across the team, used as the work calls for them.
Who carries the knowledge
One person holds the model, the measures and the refresh logic.
Documented model and measures, shared across the team and handed to your staff.

If you hire the analyst, we can build the foundation with them and step back once they own it.

Talk it through with Nichole

Thirty minutes to walk this sample, hear how FP&A reads the brand P&L today, and decide whether a team, a hire, or both makes sense.

Book 30 minutes with Nichole