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

power-bi-retail-analytics-salespulse360

Deploy and customize the SalesPulse 360 Power BI retail analytics dashboard.

5|1|Updated May 16, 2026
Search Tags:#data visualization#dashboard#forecasting#row-level security#dax#power bi#retail analytics
One-click install
npx skills add https://github.com/reason-machines/data-skills --skill power-bi-retail-analytics-salespulse360-reason-machines
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: power-bi-retail-analytics-salespulse360
Source: https://github.com/reason-machines/data-skills/tree/main/skills/power-bi-retail-analytics-salespulse360
Command: npx skills add https://github.com/reason-machines/data-skills --skill power-bi-retail-analytics-salespulse360-reason-machines

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Setting up a Power BI retail analytics dashboard involves many error-prone steps: configuring data sources, writing DAX measures, calibrating alert thresholds, applying row-level security, and troubleshooting refresh failures. This Skill guides AI agents through deploying and maintaining the SalesPulse 360 dashboard for Global Superstore sales data. ## Core Features & Use Cases - Dashboard Deployment: Clone the repository, extract the Global Superstore dataset, and open the SalesPulse360.pbix file with guided setup. - DAX Measures & Alerts: Configure profit margin, moving annual totals, period-over-period growth, and threshold-based alert measures. - Security & Publishing: Apply row-level security by region, publish to Power BI Service, and configure scheduled refresh with gateway connections. - Use Case: A retail analyst needs a multi-region profit dashboard with 12-month forecasting and email alerts when margins drop below 15%. The Skill walks through threshold calibration, RLS role creation, and Power Automate alert configuration. ## Quick Start Ask the agent to set up the SalesPulse 360 Power BI dashboard and configure profit margin alerts for the Global Superstore dataset.

Frequently Asked Questions about power-bi-retail-analytics-salespulse360

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

FAQPage Schema
How do I set up the SalesPulse 360 Power BI dashboard?▼

Clone the power-bi-retail-analytics-viz repository, extract the Global Superstore dataset from the data archive, and open SalesPulse360.pbix in Power BI Desktop 2.120 or higher. Initial load takes 2-3 minutes while Power Query runs the transformation pipeline.

How do I configure row-level security in Power BI by region?▼

Open Model View, select Manage Roles, and create roles with DAX filters like [Region] = "South". After publishing, assign Azure AD users or groups to roles in Power BI Service under Dataset Settings, Security.

Can the Power BI dashboard connect to SQL Server instead of CSV?▼

Yes, edit the Source step in Power Query Editor and replace the CSV connector with Sql.Database using your server and database names. The Skill provides M code examples for both local CSV and SQL Server connections.

Why does my Power BI data refresh fail in the Service?▼

Refresh failures usually stem from gateway connectivity, expired credentials, or firewall rules blocking Power BI Service IPs. Test the on-premises data gateway connection, re-enter data source credentials, and verify network rules allow Power BI endpoints.

Why is my Power BI dashboard slow to load visuals?▼

Slow performance typically comes from iterator DAX functions over large tables, unfiltered data models, or missing query folding. Replace SUMX patterns with pre-aggregated measures, filter rows early in Power Query, and use native SQL queries where possible.

What are the limitations of Power BI forecasting?▼

Native forecasting requires at least two data points per season, meaning 24 months of history for monthly forecasts. The date table must extend beyond the data range, and custom forecasting requires Python, R scripts, or Azure ML integration.

Related Skills

Explore More Data & Analytics Skills→
AradotsoAradotso
5

power-bi-retail-analytics-salespulse360

Deploy and customize the SalesPulse 360 Power BI dashboard for retail analytics.

Official
Advanced
data-goblindata-goblin
887

paginated-report

Author, validate, publish, and render Power BI paginated reports in RDL format.

Community
Advanced
AradotsoAradotso
5

power-bi-salespulse-dashboard

Implement and customize the SalesPulse 360 Power BI retail analytics dashboard.

Official
Advanced
SciMate-AISciMate-AI
1

gwas-database

Query GWAS Catalog SNP-trait associations via REST API with pagination.

Official
Advanced