Skill UI

This comprehensive skill simulates an expert business analyst, specializing in transforming complex raw data into actionable, strategic insights. The scope covers modern Business Intelligence (BI) platforms (Tableau, Power BI), AI-powered predictive modeling, designing robust KPI/OKR frameworks, advanced financial modeling, and optimizing business processes. It is designed for users needing to drive data-driven decision-making and create executive-level reports.

This skill simulates the role of a quantitative analyst, providing comprehensive tools for building complex financial models, backtesting trading strategies, and analyzing market data. It covers advanced topics like portfolio optimization (Markowitz, Black-Litterman), calculating risk metrics (VaR, Sharpe ratio), and performing statistical arbitrage. Ideal for quantitative finance professionals needing rigorous data analysis, robust backtesting, and risk-adjusted performance evaluation.

This expert skill acts as a dedicated business analyst for early-stage companies (pre-seed to Series A). It provides comprehensive, actionable analysis covering market sizing (TAM/SAM/SOM), rigorous financial modeling (LTV, CAC, cash flow), competitive strategy, and organizational planning. Use it to develop investor-ready reports and guide critical strategic decisions for founders and entrepreneurs.

Build comprehensive 3-5 year financial models essential for startup planning and fundraising. This skill meticulously projects revenue using cohort-based methods, details cost structures (COGS, S&M, R&D, G&A), plans headcount, and performs detailed cash flow analysis. It calculates critical metrics like LTV, CAC, and burn rate, providing three scenarios (conservative, base, optimistic) for robust strategic decision-making.

Build comprehensive 3-5 year financial models crucial for early-stage startups. This guide covers revenue projections using cohort-based methods, detailed cost structuring (COGS, S&M, R&D, G&A), robust cash flow analysis, and multi-scenario planning (Conservative, Base, Optimistic). It provides the quantitative foundation needed for fundraising, strategic planning, and investor presentations.

Guidance for creating, editing, and analyzing .xlsx workbooks while preserving formulas, formatting, and assumptions, leveraging pandas/openpyxl for data work and LibreOffice recalc to ensure error-free financial models.

This skill provides programmatic access to comprehensive global financial market data via the Alpha Vantage API. Users can retrieve time-series data, including historical prices (OHLCV) for equities, options, forex, commodities, and crypto. It also provides access to fundamental metrics (e.g., P/E ratio, market capitalization), economic indicators (e.g., GDP, CPI), and over 40 technical indicators (e.g., RSI, MACD), making it ideal for quantitative analysis and financial modeling.

This specialized coach provides comprehensive guidance for finance professionals, covering diverse fields such as investment banking, private equity, asset management, and fintech. It teaches core technical skills (DCF, LBO, 3-statement modeling) and prepares users for rigorous industry recruiting, including case studies and technical interviews. It addresses both Chinese and global financial markets, helping users strategically navigate career barriers and build professional expertise.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.

This skill provides deep, cross-border financial analysis and valuation metrics for stocks across multiple markets (e.g., US, HK). Users can access detailed income statements, balance sheets, cash flow data, analyze business segments, compare valuation multiples (PE, PB), run sophisticated DCF models, and perform value screening. It is an essential tool for fundamental research, investment modeling, and corporate analysis.

A comprehensive guide for establishing rigorous identification strategies in monetary, banking, and macro-financial modeling. It details the standards required for publishing causal claims in top-tier journals (like JMCB), covering three branches: macro shock identification (SVAR), structural parameter identification, and micro-banking causal designs (e.g., staggered regulations). Learn how to defend against information effects, address endogeneity, and ensure policy relevance.

This guide helps authors frame their academic contributions within highly specialized fields like monetary policy, DSGE modeling, and financial intermediation. It teaches how to precisely define the novel element (shock, mechanism, or counterfactual) relative to the closest prior work, ensuring the manuscript is viewed as an advance, not a mere survey. Ideal for preparing submissions to top-tier economics journals.