Understanding different fields in business, where analytics is being used

Understanding between Data Driven Finance & Traditional Finance

Understanding the different types of data we encounter in finance

How do I clean and unify inconsistent data from multiple sources?

How do I automate reports and dashboards for recurring business needs?

Can I use Excel to model business scenarios and make data-backed decisions?

Logical functions: IF, IFS, AND, OR

Lookup functions: VLOOKUP, INDEX, MATCH, XLOOKUP

Text & Date handling: TEXTJOIN, LEFT/RIGHT, DATEDIF

Create dynamic summaries using PivotTables & Pivot Charts

Apply business logic through Conditional Formatting and Data Validation

Build an interactive performance dashboard

Use What-If Analysis (Goal Seek, Data Tables, Scenario Manager) for forecasting

Optimize resource allocation using Solver Add-in

Data Cleaning & Preparation in Excel

Sales Analysis Dashboard

Advanced Data Filtering

Bank Marketing Campaign Report

Human Resource Dashboard

Project Management Analysis

How do I retrieve and analyse data directly from a company’s database?

How do I rank, compare, and group business metrics using SQL?

How can I join multiple tables to build a complete picture of customer behaviour?

Understand relational database structure: Tables, Keys, Relationships

Query essentials: SELECT, WHERE, ORDER BY, IN, BETWEEN

Group-level analysis with GROUP BY, HAVING

Combine datasets using INNER JOIN, LEFT JOIN, RIGHT JOIN

Business use cases: Revenue by category, high-spend customers

Multi-step logic with Subqueries and CTEs

Perform comparisons over time using Window Functions

Conditional business logic using CASE statements

How can I create a real-time dashboard that tracks sales performance?

How do I build a scalable reporting system for business leaders?

How do I apply business rules to create dynamic KPIs?

Power BI Ecosystem (Desktop, Service, Mobile)

Connect to Excel, CSV, and SQL Server data

Clean, merge, and structure data using Power Query Editor

Formatting, themes, and report layout.

Choosing the right visuals for your data.

Interactivity: Slicers, filters, bookmarks, and drill-through.

Calculated Columns vs. Measures

DAX Functions: SUM, AVERAGE, COUNT, DISTINCTCOUNT

Date, Time & Text based DAX Functions

Telecom Industry Churn Analysis

OLA Cabs Analysis Report

BLINKIT Analysis Report

Bike Buyer Report in Power BI

Company Cost Calculation

Employee HR Dashboard

AI for Data-Driven Decision-Making

From Data to Decisions: Data Cleaning and Analysis With AI

Generating structured reports for decision-making

Data Detective: Using AI for Exploratory Data Analysis (EDA)

From Data to Story: Tailoring Your Narrative

From Data to Story: Visual Storytelling

AI for Problem Solving: The SOLVE Framework

Presenting Your Data Story: From Report to Impact

Learners analyse sales performance data for a toy company to uncover regional and seasonal trends. The project focuses on identifying topperforming products, understanding demand fluctuations, and supporting strategic decisions in inventory management and targeted marketing.

This project involves exploring hotel booking data to identify guest behaviour patterns, cancellation trends, and booking lead times. The analysis supports data-driven strategies for improving occupancy rates, reducing cancellations, and enhancing customer segmentation.

Learners work with data from a streaming platform to examine user engagement, content consumption habits, and churn behaviour. The project aims to generate actionable insights that inform content recommendations, user retention efforts, and platform growth strategies.

In this project, learners analyze historical loan application data to predict approval outcomes and assess borrower risk. The focus is on uncovering key factors that influence approval decisions and building data-backed profiles to support risk management in lending.