business intelligence Archives - PK: An Excel Expert

Power BI Templates

ERP Systems Dashboard in Power BI

September 15, 2026September 15, 2026 PKComments Off

An ERP rollout generates an enormous amount of reportable activity - budget committed against budget spent, licences bought against licences actually used, transactions flowing, tickets piling up - and almost

Dashboard Templates

Exoskeleton Tech Firms Dashboard in Excel

September 15, 2026September 15, 2026 PKComments Off

The Exoskeleton Tech Firms Dashboard in Excel covers 500 sample exoskeleton programmes across 5 interactive pages, carrying 5 KPI cards, 20 charts and 4 slicers. Its sample data table runs

Templates

School Bus Route Calendar in Excel

September 14, 2026September 14, 2026 PKComments Off

The School Bus Route Calendar in Excel brings yearly planning, monthly detail, date-range review, and event maintenance into one organized Excel file. It is designed for school transport administrators, route

Templates VBA

Toy Shop Inventory Data Entry System in Excel

September 14, 2026September 14, 2026 PKComments Off

Toy Shop Inventory Data Entry System in Excel gives toy shops, toy retailers, stock assistants, and small-store managers a structured way to add, update, delete, and review toy inventory records

Power BI Templates

Electric Vehicle Charging Dashboard in Power BI

September 14, 2026September 14, 2026 PKComments Off

Electric Vehicle Charging Dashboard in Power BI turns entered charging-session, energy, revenue, hub, tariff, customer, and payment data into five connected analytical pages. The package contains a PBIX report, Data.xlsx

Templates

Mental Health Session Calendar in Excel: 5 Planning Views

September 13, 2026September 13, 2026 PKComments Off

A busy service calendar becomes difficult to scan when annual plans, monthly schedules, and day-level details live in separate files. The Mental Health Session Calendar in Excel addresses that administrative

Templates

Fire Safety Services KPI Scorecard in Excel – 10 KPIs

September 13, 2026September 13, 2026 PKComments Off

The Fire Safety Services KPI Scorecard in Excel helps teams compare monthly actuals with targets and prior-year values across 10 KPI cards. Its connected analysis and trend pages make a

Dashboard Templates

Fire Safety Services KPI Dashboard in Excel

September 13, 2026September 13, 2026 PKComments Off

The Fire Safety Services KPI Dashboard in Excel is a formula-driven monthly reporting workbook for fire protection contractors, inspection teams, compliance managers and HSE leads. You type your own figures

Templates VBA

Electronics Sales Log Data Entry System in Excel

September 13, 2026September 13, 2026 PKComments Off

Electronics Sales Log Data Entry System in Excel gives electronics shops, device retailers, sales assistants, and small-store managers a structured way to add, update, delete, and review electronics sales records

Power BI Templates

CCTV Installation KPI Dashboard in Power BI

September 13, 2026September 13, 2026 PKComments Off

The CCTV Installation KPI Dashboard in Power BI scores 14 installation, commissioning, video-availability, network, service and commercial KPIs against monthly targets across three interactive report pages and two hover tooltip