How long does it take to generate a full report?

The analysis and report generation process typically takes between 1 and 2 minutes, regardless of the number of departments being analyzed.

Can I run this analysis for a single department?

Yes, you can use the --department argument to filter the analysis to a specific team, such as Engineering or Marketing, or leave it blank for a full organizational view.

What metrics are included in the generated reports?

The skill analyzes revenue, expenses, net contribution, budget vs. actual variance, headcount, per-employee metrics, and productivity indicators.

Can I customize the output file paths?

Yes, the skill allows you to specify custom paths for both Excel and PowerPoint outputs using the --output-xlsx and --output-pptx arguments.

What kind of branding does the output use?

The reports automatically apply Datarails' official styling, including Poppins fonts, a navy/pink/teal color palette, and specific Excel layouts with frozen panes and custom number formats.

Department Financial Analytics

Name: Department Financial Analytics
Author: Datarails

byDatarails

0•

Analytics & Monitoring

Analyzes departmental P&L and performance metrics to generate branded Excel and PowerPoint reports for management reviews.

The Department Financial Analytics skill provides a comprehensive view of organizational performance by breaking down P&L data across different departments. It automates the extraction of revenue and expense metrics, calculates budget vs. actual variances, and assesses operational efficiency through per-employee indicators. Designed for finance teams and department heads, it generates production-ready Excel workbooks and PowerPoint presentations styled with Datarails branding, streamlining the creation of monthly reviews, executive dashboards, and annual budget planning sessions.

Key Features

010 GitHub stars

02Automated P&L analysis by specific department or organization-wide

03Creates ready-to-present PowerPoint slides for executive management reviews

04Tracks operational efficiency metrics like cost per unit and productivity

05Generates branded Excel reports with professional financial formatting

06Calculates budget vs. actual variances and Year-over-Year comparisons

Use Cases

01Conducting monthly department-level financial reviews for team leads

02Preparing executive-level comparison dashboards of organizational performance

03Analyzing historical department data for annual budget planning and resource allocation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add datarails/dr-claude-code-plugins-re departments

For use in Claude.ai and ChatGPT

Key Features

010 GitHub stars

02Automated P&L analysis by specific department or organization-wide

03Creates ready-to-present PowerPoint slides for executive management reviews

04Tracks operational efficiency metrics like cost per unit and productivity

05Generates branded Excel reports with professional financial formatting

06Calculates budget vs. actual variances and Year-over-Year comparisons

Use Cases

01Conducting monthly department-level financial reviews for team leads

02Preparing executive-level comparison dashboards of organizational performance

03Analyzing historical department data for annual budget planning and resource allocation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add datarails/dr-claude-code-plugins-re departments

For use in Claude.ai and ChatGPT