- Home
- Skills
- Data & Databases
- BI and Dashboards
More screenshots
Works with the AI Agents you already use
BI and Dashboards
Build dashboards in Power BI, Tableau, Looker, Metabase and Qlik. 10 ordered skills, starting with Business Intelligence, Power BI, Tableau.
Free
BI and Dashboards
Example session with this skill installed
I need a DAX measure for our Power BI sales report. It needs to show Year-over-Year growth for 'Total Sales', but it should ignore any filters on the 'Region' column while respecting 'Date'.
- Read your context and instructions
- Compiled the bi and dashboards
I have drafted the DAX measure to calculate Year-over-Year (YoY) growth while specifically overriding the filter context for the Region field.
DAX Measure: YoY Sales Growth (Excl. Region)
/*
Requirement: Calculate YoY Growth for Total Sales.
Constraints: Ignore 'Region' filters, respect 'Date' filters.
Assumes: A marked Date table named 'Date' and a base measure [Total Sales].
*/
YoY Sales Growth =
VAR CurrentSales =
CALCULATE(
[Total Sales],
REMOVEFILTERS('Sales'[Region])
)
VAR PriorYearSales =
CALCULATE(
[Total Sales],
SAMEPERIODLASTYEAR('Date'[Date]),
REMOVEFILTERS('Sales'[Region])
)
RETURN
DIVIDE(
CurrentSales - PriorYearSales,
PriorYearSales,
0
)
Technical Notes
Base Measure Dependency: This formula relies on [Total Sales] = SUM(Sales[Amount]). Always build on base measures to ensure logic is centralized.
2.
Context Transition: The REMOVEFILTERS function is explicitly applied to the Region column within CALCULATE, ensuring that even if a user selects a region in a slicer, the growth percentage remains relative to the total geography.
3.
Time Intelligence: SAMEPERIODLASTYEAR requires a contiguous date range in your Date table to function correctly.
Next steps
- Verify that your 'Date' table is marked as a Date Table in Power BI Desktop.
- Place this measure in a Trend Line visual with
Date[Month]on the X-axis to confirm the calculation behaves as expected across years. - Add a Card visual to test the
REMOVEFILTERSlogic by toggling a Region slicer.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
BI analysts and consultants often need a repeatable process, not a one-off prompt. This pack targets: Build dashboards in Power BI, Tableau, Looker, Metabase and Qlik.
What's inside (10 skills, suggested learning order)
- Business Intelligence — Build management dashboards and reports.
- Power BI — Modeling and dashboards in the Microsoft ecosystem.
- Tableau — Interactive data visualization.
- Looker and Looker Studio — Dashboards and semantic layer.
- DAX and Tabular Modeling — Measures and semantic models.
- Data Visualization and Storytelling — Communicate data with clarity and narrative.
- Executive Dashboards — Design KPIs for leadership.
- Metabase and Open-Source BI — Self-service data.
- Qlik — Associative analytics.
- Real-Time Operational Dashboards — Operations dashboards with continuous refresh.
Why a skill pack instead of a one-off prompt
Each skill gives the agent a defined trigger, step-by-step procedure and output format, so results are consistent across sessions and easier to review.
How to use
- Install the pack in your SKILL.md-compatible agent.
- Ask for the task in plain language (for example: "build management dashboards and reports").
- Review the output against the skill's quality checks before using it.
Known limitations
- Outputs are drafts that need human review; they are not professional, legal or financial advice.
- Tools, APIs and prices change; check current vendor documentation before relying on version-specific details.
- Quality depends on the context you give the agent (data, requirements, constraints).
- Tested only where stated in the Compatibility note.
Also by Rodrigo Santos
Data Annotation and Labeling; Cloud Data Platforms and Data for AI; Customer and Sales Analytics
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
Focuses on logic, modeling, and design. Does not handle server-side DevOps, database infrastructure upgrades, or certified legal accessibility audits.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 4 days ago
- Free with an Agensi account
Nothing to install. It runs in your AI agent.
Instruction-only skills. No network access, shell commands or file writes are required; each skill reads the context you provide and returns a document.