Bundle Course - Financial Modeling & Business Intelligence
Master Financial Modeling, BI Tools, and Data Analytics to Drive Strategic Business DecisionsPreview Bundle Course - Financial Modeling & Business Intelligence course
Price Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate94% Started a new career BUY THIS COURSE (
GBP 27 GBP 49 )-
83% Got a pay increase and promotion
Students also bought -
-
- Financial Accounting & Reporting
- 75 Hours
- GBP 12
- 2666 Learners
-
- Business Finance and Financial Modeling
- 7 Hours
- GBP 12
- 519 Learners
-
- Business Intelligence and Data Analytics
- 50 Hours
- GBP 12
- 816 Learners

- Business Finance and Financial Modeling
- Business Intelligence and Data Analytics
- Microsoft Power BI
- Data Visualization with Tableau
- Google Sheets Basic to Advanced
Begin with Business Finance and Financial Modeling to build foundational knowledge of financial statements, valuation models, and forecasting techniques. Then proceed to Business Intelligence & Data Analytics to learn the principles of turning data into business value. The next step includes hands-on skill-building in top BI tools – Power BI for interactive dashboards, Tableau for visual storytelling, and Google Sheets for automated spreadsheet reporting.
- Analyze income statements, balance sheets, and cash flows
- Build 3-statement models, DCFs, and scenario analysis models
- Apply statistical techniques and business intelligence principles
- Use Power BI for creating dashboards, reports, and data models
- Design impactful visualizations using Tableau
- Perform spreadsheet automation with formulas, pivot tables, and scripting in Google Sheets
- Extract, transform, and load (ETL) data from various sources
- Interpret business KPIs and performance metrics using BI tools
- Forecast revenue, expenses, and business growth using live data
- Build end-to-end financial reports and models for business cases
-
Finance Professionals and Financial Analysts
-
Business Intelligence Analysts and Data Analysts
-
Startup Founders and Entrepreneurs
-
MBA Students and Corporate Professionals
-
Investment Banking, FP&A, and Valuation Roles
-
Business Managers and Decision Makers
Course/Topic 1 - Course access through Google Drive
-
Google Drive
-
Google Drive
Course/Topic 2 - Google Sheets course - all lectures
-
Lesson 1 - Introduction to Google Sheets
-
Lesson 2 - Menu Options - File
-
Lesson 3 - Menu Options - Edit
-
Lesson 4 - Menu Options - View
-
Lesson 5 - Menu Options - Insert
-
Lesson 6 - Menu Options - Format
-
Lesson 7 - Menu Options - Data and more
-
Lesson 8 - Entering Data and Editing
-
Lesson 9 - Functions - Numeric Function
-
Lesson 10 - Functions - Text Function
-
Lesson 11 - Functions - Date Functions
-
Lesson 12 - Charts and Conditional Formatting
-
Lesson 13 - Pivot Tables
-
Lesson 14 - Saving - Sharing
Course/Topic 3 - Business Finance and Financial Modeling - all lectures
-
We will learn Business Finance in 3 parts. In this first part of Business Finance we will see what is Business Finance and what is the meaning, nature and significance of Business Finance. Furthermore, we will learn why Business Finance is required to carry out various activities.
-
In this video we will cover the second part of Business Finance. We will learn about the classification of sources of finance and how we can get funds from the various sources. We will also learn about the characteristics of these sources.
-
In this video we will learn about the third part of Business Finance. In this video we will discuss International Financing. We will learn about the various avenues of an organization to get a finance, how to obtain finance and how to raise a finance, internationally.
-
In this video tutorial we will cover the first part of Financial Modelling. We will learn what is Financial Modelling and its use. Furthermore, we will also learn how to prepare financial model and the different types of Financial Models.
-
In this video we will cover part 2 of the Financial Modelling. In this video we will discuss of the different types of Financial Models in detail. How to use these models as per the Business? We will also see a list of 10 common Financial Models.
-
In this video we will see the final and last part of Financial Modelling. In this video course we will discuss all other Financial Models which are important and used by all other Financial organizations. These Financial Models are prepared by the organization on the basis of their business. Eg. IPO model , LBO model, IRR model.
Course/Topic 4 - Business Intelligence and Data Analytics - all lectures
-
In this lecture session we discuss about Bi concepts, examples and application of business intelligence and data analytics and also cover other concepts of BI.
-
In this lecture session we learn about basic concepts of BI and also cover factors of business intelligence in brief.
-
In this lecture session we learn about data warehouse data access and data dashboarding and also cover presentation in BI.
-
In this lecture session we learn about product database, advertise database and customer demographic database and also cover data analyst concepts.
-
In this lecture session we learn about basic introduction of business intelligence and also cover factors of business intelligence in brief.
-
In this lecture session we learn about introduction of predictive modeling and also cover functions of predictive modeling in brief.
-
In this lecture session we learn about data related to customer services and also talk about customer relation databases in brief.
-
In this lecture session we learn about introduction of NoSQL and also cover basic functions of NoSQL in business intelligence.
-
In this lecture session we learn about graph stores and also talk about the advantages and disadvantages of graph stores in BI.
-
In this lecture session we learn about hierarchical clustering in business intelligence and also talk about clustering factors in BI.
-
In this lecture session we learn about introduction of salesforce in business intelligence and also talk about some basic uses of salesforce.
-
In this lecture session we learn about introduction to NLP and also cover what is natural language processing in artificial intelligence.
-
In this lecture session we learn about natural language processing speech to text conversion and also cover the importance of natural language processing.
-
In this lecture session we learn about introduction of apache server in business intelligence and also talk about basics of apache server.
-
In this lecture session we learn about deep drive into business intelligence and also talk about factors or deep drive in business intelligence.
-
In this lecture session we learn about data warehousing in business intelligence and data analytics and also talk about factors and features of data warehousing.
-
In this lecture session we learn about types of data in business intelligence and also talk about different types of data in BI.
-
In this lecture session we learn about mobile BI and also talk about open source BI software replacing vendor offering.
-
In this lecture session we learn about real time BI in business intelligence and also talk about factors of real time BI in brief.
-
In this lecture session we learn about data analytics comprehensively and also talk about functions of data analytics.
-
In this lecture session we talk about data analytics vs business analytics and also talk about the importance of data analytics.
-
In this lecture session we learn about Embedded analytics and also talk about functions of Embedded analytics in data analytics.
-
In this lecture session we learn about collection analytics and also cover the importance of collection analytics.
-
In this lecture session we learn about survival analytics and also cover duration analytics in brief.
-
In this lecture session we learn about machine learning techniques and also cover the importance and factors of machine learning techniques in business intelligence.
-
In this lecture session we learn about geospatial predictive analytics and also talk about functions of geospatial predictive analytics in business intelligence.
-
In this lecture session we learn about cohort analysis in data analyst and we also cover functions and importance of cohort analysis.
-
In this lecture session we learn about data mining in business intelligence and also talk about data mining functions and why we need data mining in business intelligence.
-
In these lecture sessions we learn about anomaly detection and also talk about functions of anomaly detection in brief.
-
In these lecture sessions we learn about statistically sound association and also talk about factors of statistically sound association in business intelligence.
-
In this lecture session we learn about cluster analysis. We’ll cover all types of cluster analysis in brief and also cover the importance of cluster analysis in business analysis.
-
In this lecture session we learn about DBSCAN in business intelligence and also talk about DBSCAN functions and importance.
-
In this lecture session we learn about regression models in business intelligence and also talk about the function of regression models.
-
In this lecture session we learn about extraction based summarization in business intelligence and also cover all types of summarization in data analyst.
-
In this lecture session we learn about machine learning in BI and also talk about factors and importance of machine learning in brief.
-
In this lecture session we learn about machine learning vs BI we also discuss the basic difference between machine learning and business intelligence.
-
In this lecture session we learn about how ml can make BI better and also talk about ml basic functions.
-
In this lecture session we learn about data warehousing and also talk about how we manage data warehousing in business intelligence.
-
In this lecture session we learn about data warehousing in business intelligence and data analytics and also talk about factors and features of data warehousing.
-
In this lecture session we learn about data mart in business intelligence and also talk about data mart function.
-
In this lecture session we learn about data dimensions in business intelligence and also cover all types of data dimension in BI.
-
In this lecture session we learn about data dimension in business intelligence and also cover functions and importance of data dimension.
-
In this lecture session we learn about data vault modeling in business intelligence and also cover different types of vault modeling in brief.
-
In this lecture session we learn about links and satellites and also cover the importance and factors of links and satellites in business intelligence.
-
Build dynamic and accurate financial models from scratch
-
Analyze company performance using financial statements
-
Forecast revenue, profitability, and cash flows
-
Use Power BI for KPI reporting and interactive dashboards
-
Design compelling charts, maps, and dashboards in Tableau
-
Perform descriptive and diagnostic analytics using BI tools
-
Automate financial and business reports using Google Sheets
-
Gain hands-on skills in real-world data analysis projects
-
Prepare management dashboards and investor presentations
-
Strengthen their readiness for finance, analytics, and BI interviews
- Financial statements and ratio analysis
- Forecasting methods and assumptions
- 3-statement model building (IS, BS, CF)
- Valuation techniques: DCF, comparables, precedent transactions
- Scenario and sensitivity analysis
- Cap table and startup finance models
- Revenue modeling and KPI dashboards
- BI fundamentals and analytics lifecycle
- Data preparation, ETL, and cleansing
- Data modeling and relational joins
- Exploratory and diagnostic analytics
- KPIs, metrics, and dashboards
- BI project lifecycle and tools overview
- Data import and transformation using Power Query
- Data modeling and relationships
- DAX formulas and calculated columns
- Creating charts, cards, slicers, and filters
- Interactive dashboards and bookmarks
- Row-level security and Power BI Service
- Connecting data sources and preparing data
- Dimensions, measures, and calculated fields
- Charts, dashboards, and stories
- Filters, parameters, and actions
- Level of Detail (LOD) expressions
- Tableau Public and Tableau Server
-
Formulas, functions, and formatting
-
Charts, pivot tables, and data validation
-
Advanced formulas: ARRAYFORMULA, QUERY, INDEX/MATCH
-
Google Apps Script for automation
-
Importing data from APIs and live sources
-
Dashboard creation and conditional formatting
- Power BI PL-300 Certification
- Tableau Desktop Specialist
- Financial Modeling & Valuation Analyst (FMVA)
- Google Sheets Advanced Specialist
- Financial Analyst / FP&A Analyst
- Business Intelligence Analyst
- BI Developer / Dashboard Designer
- Valuation & Strategy Consultant
- Data-Driven Business Manager
- Excel and Power BI Reporting Specialist
A 3-statement model includes the Income Statement, Balance Sheet, and Cash Flow Statement, all dynamically linked.
DAX (Data Analysis Expressions) is a formula language used to create custom measures and calculated columns in Power BI.
Use error checks, consistent assumptions, formula auditing, and reconciliation with historical data.
It’s a tool used to summarize, group, and analyze large datasets based on dimensions and measures.
Parameters are dynamic values used to control filters, calculations, and dashboard interactivity.
A forecast is updated frequently based on actuals; a budget is a fixed plan for a defined period.
Through imputation, filtering, or marking as “Unknown” based on the context of the dataset.
ETL (Extract, Transform, Load) is the process of collecting, cleaning, and loading data into BI platforms for analysis.
Using formulas, triggers, and Google Apps Script to refresh and distribute reports automatically.
A KPI dashboard displays key performance indicators in a visual format to help stakeholders track goals and performance in real time.