Agent skill · data analytics · aradotso
logifleet-pulse-supply-chain-analytics
MS SQL Server & Power BI data warehousing solution for logistics intelligence with multi-fact star schema and fleet optimization
Why this skill is useful
Provides specific SQL schema and Power BI integration patterns for logistics analytics that the AI wouldn't reliably generate on its own.
What it needs
Requires mssql-server, power-bi, sql-server-management-studio installed locally. About 8k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
LogiFleet Pulse Supply Chain Analytics Skill Skill by ara.so — Data Skills collection Overview LogiFleet Pulse is a comprehensive logistics intelligence platform combining MS SQL Server data warehousing with Power BI visualization. It provides: Multi-fact star schema linking warehouse operations, fleet trips, and cross-dock activities Time-phased dimensions with 15-minute granularity Warehouse Gravity Zones for spatial optimization based on pick frequency and item value Fleet triage engine prioritizing maintenance by revenue impact Cross-fact KPI harmonization correlating inventory turnover with fuel consumption Predictive bottleneck detection using historical pattern analysis Primary use cases: 3PL operators, retail chains, food distributors, any organization managing warehouse + fleet operations. Installation Prerequisites MS SQL Server 2019+ (Standard or Enterprise edition recommended) Power BI Desktop (latest version) SQL Server Management Studio (SSMS) or Azure Data Studio Access to data sources: WMS, TMS, telematics APIs Step 1: Deploy SQL Schema Clone the repository and navigate to the SQL scripts directory: Execute the schema deployment script in SSMS: Step 2: Configure Data Sources Update the configuration file with your environment details: Step 3: Import Power BI Template Open LogiFleetPulseMaster.pbit in Power BI Desktop and configure the connection: Core Database Schema Fact Tables FactWarehouseOperations - Tracks all warehouse activities: FactFleetTrips - Fleet telemetry and route data: Dimension Tables DimTime - Time intelligence with 15-minute buckets: DimProductGravity - Product classification with gravity scoring: Key Stored Procedures Cross-Fact KPI Query Predictive Bottleneck Detection Power BI DAX Measures Fleet Idle Cost Calculation Warehouse Efficiency Score Cross-Fact Correlation Measure Data Ingestion Patterns Incremental Load from WMS Real-Time Telemetry via REST API Alert Configuration SQL Server Agent Job for Proactive Alerts Power BI Dep …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/logifleet-pulse-supply-chain-analytics