Scribd
Upload
93 views1 page

Finance: Understanding The Framework of A Financial Model

The document discusses financial modeling and data analysis techniques. It covers forecasting financial statements like the income statement, balance sheet, and cash flow statement using good practices like building financial ratios and merging graphs. It also discusses handling large data through cleaning, using macros for automation, and SQL. For marketing, it covers using pivot tables to analyze and consolidate data from multiple sheets and files with slicers. It introduces macros, Power Pivot for relationships among tables, and using macros to automate analytics procedures.

Uploaded by

Prasad Krishnamurthy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
93 views1 page

Finance: Understanding The Framework of A Financial Model

The document discusses financial modeling and data analysis techniques. It covers forecasting financial statements like the income statement, balance sheet, and cash flow statement using good practices like building financial ratios and merging graphs. It also discusses handling large data through cleaning, using macros for automation, and SQL. For marketing, it covers using pivot tables to analyze and consolidate data from multiple sheets and files with slicers. It introduces macros, Power Pivot for relationships among tables, and using macros to automate analytics procedures.

Uploaded by

Prasad Krishnamurthy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Finance

Understanding the framework of a financial model


Good financial modeling practices, organizing the historical (financial statements), building financial
ratios for trend analysis & forecasting, Forecasting the P& L, Balance sheet forecasting and validating,
Forecasting cash flow statement, Sales projections & merging of graphs
Handling Huge data
Data cleaning, Using macros to automate data cleansing and data analysis, SQL handling huge data
using SQL

Marketing
Data Analysis
Pivot tables, creating subtotals, multiple-level subtotals, consolidating data from multiple sheets and
files using pivot tables, viewing subtotal under pivot, creating slicers
Macros
Relative & Absolute macros, Editing macros
Power pivot
Understanding data pattern through aggregation using pivot and power pivot, sort of building relation
among multiple tables
Introduction to macros
Automating the analytics process-procedures, methods, program and functions applications

You might also like