Learning by Doing Series — A practical course from synthetic accounting data to executive financial dashboards.
Serie Learning by Doing — Un curso práctico desde data contable sintética hasta dashboards financieros ejecutivos.
This course starts with a simple idea: learn financial analysis by building the model from zero.
We do not start with a polished dashboard. We start from the foundation: synthetic companies, fiscal periods, chart of accounts, trial balance, financial statements, ratios, validations, SQL Server, Power BI, DAX and finally an executive dashboard.
The central method is Learning by Doing: build, validate, interpret and convert financial data into useful decision-making information.
Este curso nace con una idea muy simple: aprender análisis financiero construyendo el modelo desde cero.
No empezamos con un dashboard bonito. Empezamos desde la base: compañías sintéticas, períodos fiscales, catálogo contable, trial balance, estados financieros, ratios, validaciones, SQL Server, Power BI, DAX y finalmente un dashboard ejecutivo.
La idea central es Learning by Doing: hacer, validar, interpretar y convertir datos financieros en información útil para la toma de decisiones.
The objective of this training is to teach students how to build a complete financial ratio analysis model in BI, starting from synthetic accounting data and ending with an executive dashboard.
El objetivo de este training es enseñar a construir un modelo completo de análisis de ratios financieros en BI, comenzando con data contable sintética y terminando con un dashboard ejecutivo.
Create synthetic companies, industries, fiscal years and quarters. The first dimensions of the BI model are created: Dim_Company.csv and Dim_Period.csv. This topic defines the business entities and time structure that support the full model.
Create the accounting language of the model with Dim_Account.csv. The chart of accounts includes assets, liabilities, equity, revenue, expenses, cash flow items and market data items. This classification supports all statements and ratios.
Generate a synthetic trial balance by company, period and account. Fact_Trial_Balance.csv becomes the raw accounting source used to build financial statements and downstream BI analysis.
Focus on financial data quality. Validate whether the trial balance is balanced, consistent and usable for analysis. The output is Trial_Balance_Validation_Report.csv.
Create the bridge between account-level detail and executive financial reporting by mapping accounts to Balance Sheet, Income Statement and Cash Flow Statement lines.
Calculate revenue, COGS, gross profit, operating expenses, operating income, interest expense, tax expense and net income. Output: Fact_Income_Statement.csv.
Calculate current assets, non-current assets, total assets, current liabilities, long-term liabilities, total liabilities, equity and working capital. Output: Fact_Balance_Sheet.csv.
Create operating cash flow, capital expenditures, free cash flow, cash flow to debt and cash flow coverage. Output: Fact_Cash_Flow.csv.
Add synthetic market data for valuation analysis: share price, shares outstanding, market capitalization, enterprise value, dividends paid, EPS and book value per share. Output: Fact_Market_Data.csv.
Calculate current ratio, quick ratio, cash ratio, working capital and cash conversion cycle. This topic answers whether a company can meet short-term obligations.
Calculate profit margin, gross margin, effective tax rate, ROA, ROE and ROCE. This topic evaluates whether the company generates profit efficiently.
Analyze leverage and financial risk with debt ratio, debt-to-equity, capitalization ratio, interest coverage and cash flow to debt. Output: Fact_Debt_Ratios.csv.
Calculate fixed asset turnover, revenue per employee, inventory days, receivable days, payable days and operating cycle. This topic connects financial performance with operations.
Evaluate cash quality with operating cash flow to sales, free cash flow to operating cash flow, cash flow coverage ratio and dividend payout ratio.
Introduce valuation metrics: price/book, price/earnings, price/sales, PEG ratio, dividend yield and enterprise value multiple.
Introduce controlled data problems such as missing values, duplicate records, unmapped accounts, negative revenue, unbalanced periods, missing market data and outliers.
Move the project into SQL Server. Create tables, load CSV files, build validation queries and prepare analytical views.
Design the Power BI model with dimensions, facts, relationships, date table, financial statement hierarchy and ratio categories.
Create DAX measures such as total revenue, net income, current ratio, ROA, ROE, debt ratio, P/E ratio, dividend yield and financial health score.
Build the final executive dashboard with company comparison, trends, liquidity, profitability, debt, cash flow, valuation, risk indicators and financial health score.
Financial analysis is not only about formulas. It is about understanding the story behind the numbers.
A ratio by itself is just a number. A ratio inside a BI model becomes a signal. A trend becomes a pattern. A comparison becomes a benchmark. A dashboard becomes a decision tool.
This course is designed to help students move from raw data to real financial interpretation.
El análisis financiero no es solamente fórmulas. Es entender la historia detrás de los números.
Un ratio solo es un número. Un ratio dentro de un modelo BI se convierte en una señal. Una tendencia se convierte en un patrón. Una comparación se convierte en un benchmark. Un dashboard se convierte en una herramienta de decisión.
Este curso está diseñado para ayudar al estudiante a pasar de data cruda a interpretación financiera real.
This is not a theoretical finance course.
This is a practical BI training where students build the entire financial analysis workflow step by step.
From synthetic accounting data to trial balance, financial statements, ratios, SQL Server, Power BI, DAX and an executive dashboard.
Learn finance by building it. Learn BI by doing it. Learn data quality by validating it. Learn decision-making by interpreting it.
Financial Ratios Analysis in BI — Learning by Doing Series
A practical training path for finance, accounting, data analytics and business intelligence.
Este no es un curso teórico de finanzas.
Es un training práctico de BI donde el estudiante construye paso a paso todo el flujo de análisis financiero.
Desde data contable sintética hasta trial balance, estados financieros, ratios, SQL Server, Power BI, DAX y un dashboard ejecutivo.
Aprender finanzas construyéndolas. Aprender BI haciéndolo. Aprender calidad de datos validando. Aprender toma de decisiones interpretando.
Financial Ratios Analysis in BI — Learning by Doing Series
Una ruta práctica de entrenamiento para finanzas, contabilidad, analítica de datos y business intelligence.