skills.rest
reason-machines
reason-machinesOFFICIAL
Explore all skills by this author →
Website𝕏@reasonmachinesGitHub

logifleet-pulse-supply-chain-analytics

Deploys a SQL Server and Power BI data warehouse for logistics and fleet analytics.

5|1|Updated May 16, 2026
Search Tags:#data warehouse#sql server#supply chain#star schema#dax#power bi#fleet analytics
One-click install
npx skills add https://github.com/reason-machines/data-skills --skill logifleet-pulse-supply-chain-analytics-reason-machines
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: logifleet-pulse-supply-chain-analytics
Source: https://github.com/reason-machines/data-skills/tree/main/skills/logifleet-pulse-supply-chain-analytics
Command: npx skills add https://github.com/reason-machines/data-skills --skill logifleet-pulse-supply-chain-analytics-reason-machines

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Organizations running warehouse and fleet operations struggle to correlate inventory, picking, and vehicle telemetry data scattered across WMS, TMS, and telematics systems, making it hard to detect bottlenecks and optimize costs. ## Core Features & Use Cases - Multi-Fact Star Schema: Deploys fact tables for warehouse operations and fleet trips with time-phased dimensions at 15-minute granularity in MS SQL Server. - Predictive Bottleneck Detection: Stored procedures analyze 90-day historical patterns to forecast dwell-time risks by day, hour, and gravity zone. - Power BI Dashboards: DAX measures compute fleet idle cost, warehouse efficiency scores, and cross-fact correlations between dwell time and idle time. - Use Case: A 3PL operator deploys the schema, connects WMS and telematics feeds, and uses the Power BI template to monitor fuel-per-pick efficiency and receive email alerts when idle time or dwell time exceeds thresholds. ## Quick Start Set up the LogiFleet Pulse supply chain analytics warehouse on my SQL Server and configure the Power BI fleet optimization dashboard.

Frequently Asked Questions about logifleet-pulse-supply-chain-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up a supply chain analytics data warehouse in SQL Server?▼

Run the deploy_schema.sql script in SSMS to create fact and dimension tables, then populate the time dimension with sp_PopulateTimeDimension. Configure your WMS and telemetry connections in the JSON config file before loading data.

How to connect Power BI to a SQL Server logistics database?▼

Open the LogiFleet_Pulse_Master.pbit template in Power BI Desktop and update the Sql.Database connection string with your server host and database name. Publish to Power BI Service and configure scheduled refresh with a gateway.

What is a multi-fact star schema for warehouse and fleet data?▼

It uses separate fact tables, FactWarehouseOperations and FactFleetTrips, sharing conformed dimensions like DimTime and DimGeography. This enables cross-fact KPIs such as fuel consumed per pick by joining summaries on warehouse keys.

Why are my Power BI logistics dashboards loading slowly?▼

Slow dashboards usually indicate columnstore index fragmentation on fact tables. Query sys.dm_db_column_store_row_group_physical_stats and rebuild indexes when fragmentation exceeds 20 percent.

Does this warehouse support real-time fleet telemetry data?▼

Yes, the sp_PollFleetTelemetry procedure polls a REST API endpoint, parses JSON responses with OPENJSON, and inserts trip records into FactFleetTrips. It requires a telemetry API endpoint and bearer token configured as environment variables.

What are the limitations of predictive bottleneck detection in SQL Server?▼

The sp_PredictBottlenecks procedure relies on 90 days of historical dwell-time patterns and percentile thresholds, so it cannot account for unprecedented events. Accuracy depends on sufficient historical data volume per day-of-week and hour bucket.

Related Skills

Explore More Data & Analytics Skills→
Sake-TeamSake-Team

logistics-exception-management

Classify logistics exceptions and manage carrier dispute resolution workflows.

Official
Advanced
AradotsoAradotso
5

logifleet-pulse-supply-chain-analytics

Analyze supply chain operations with MS SQL Server and Power BI.

Official
Advanced
kishorkukrejakishorkukreja
56

prescriptive-analytics

Generates actionable recommendations for inventory replenishment, route optimization, and supplier selection in supply chains.

Community
Advanced
dbt-labsdbt-labs
699

using-dbt-state

Configure and troubleshoot dbt State server-backed node reuse across dbt Core and Fusion.

Official
Intermediate