Skill UI

Provides comprehensive skills and references for writing, debugging, and optimizing DAX within semantic models. It guides users through systematic performance tuning using a tiered framework, covering engine internals, best practices, and profiling techniques for both local and remote models.

A comprehensive guide for authors and developers on managing, writing, and validating Power Query M expressions within semantic model partitions. Covers critical concepts such as Query Folding for performance optimization, best practices for filtering and type handling, and advanced techniques for testing M code using the Power Query API.

This guide details how to integrate R code, primarily using the powerful ggplot2 library, into Power BI reports. It enables the creation of advanced, static, and publication-quality statistical visualizations. The process covers the technical workflow, including setting up the JSON structure, writing the mandatory R script (e.g., using `print(p)`), handling data injection, and adhering to best practices for professional BI reporting.

Access comprehensive real-time and historical market data across major global exchanges, including HK, US, A-share, and Singapore. This skill provides quotes, K-line charts, order book depth, trade ticks, market sentiment indices, and sophisticated cross-market analysis tools like ADR premium and FX carry trade frameworks. Ideal for quantitative analysis, technical trading, and monitoring global financial movements.