SQL for Financial Data Analysis & Reporting – Zero to Pro

SQL for Financial Data Analysis & Reporting – Zero to Pro, available at $19.99, has an average rating of 4.17, with 52 lectures, based on 56 reviews, and has 321 subscribers.

You will learn about Downloading and installing database Fundamentals of Database and SQL Querying database with SQL Extracting and summarizing data with SQL Preparing Profit & Loss Statement Preparing Balance Sheet Preparing Cash Flow Statement Preparing Key Ratios and Analytics This course is ideal for individuals who are Financial Analysts or Business Analysts or Data Analysts or Accounting professionals or Finance professionals It is particularly useful for Financial Analysts or Business Analysts or Data Analysts or Accounting professionals or Finance professionals.

Enroll now: SQL for Financial Data Analysis & Reporting – Zero to Pro

Summary

Title: SQL for Financial Data Analysis & Reporting – Zero to Pro

Price: $19.99

Average Rating: 4.17

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Downloading and installing database
Fundamentals of Database and SQL
Querying database with SQL
Extracting and summarizing data with SQL
Preparing Profit & Loss Statement
Preparing Balance Sheet
Preparing Cash Flow Statement
Preparing Key Ratios and Analytics

Who Should Attend

Financial Analysts
Business Analysts
Data Analysts
Accounting professionals
Finance professionals

Target Audiences

Financial Analysts
Business Analysts
Data Analysts
Accounting professionals
Finance professionals

Unlock the power of financial data with this comprehensive course designed for non-tech professionals.

All the financial data of an organization is stored in the database. Now to extract the data back for reporting and analysis is usually not considered easy by non-tech people. Most professionals are dependent on the reports that are available in the system. The best bet, you can connect a BI tool like Power BI and extract the data for analysis. However, this too has a lot of limitations.

What is SQL:

A database query tool with which you can extract any broader or specific data from the database just by writing small super-easy lines of code. No programming knowledge or database technical knowledge is required for this. Almost anyone can do that and it will empower you in the reporting and analytics like nothing else can.

What you will learn in this course:

Introduction to databases
Basic ways to query a database
Sorting and filtering data
Grouping data
Splitting data on multiple parameters
Drilling up and drilling down data
Preparing Financial Reports

Profit & Loss Statement
Balance Sheet
Cash Flow Statement

Preparing Financial Analytics
Profitability ratios
Efficiency ratios
Liquidity ratios
Risk management ratios

Who this course is for:

Financial Analysts
Business Analysts
Financial Controllers
Finance Managers
Accountants
Bookkeepers
Data Analysts

Money back guarantee:

This course comes with a 30 days money back guarantee. So, sign up risk free and if for any reason you are not satisfied with the course, you will get the full refund.

About instructor:

I am a Chartered Accountant from the UK with 14 years of experience. My major work has been in the accounting and finance transformation of organizations with tools like SAP and Oracle. So, I have been using SQL for quite some time. Now I run an accounting automation company.

Course Curriculum

Chapter 1: Getting our PC ready to run SQL

Lecture 1: Downloading Database

Lecture 2: Downloading & Connecting Azure Data Studio

Lecture 3: CSV files for Database tables

Lecture 4: Creating our Database project & uploading data

Chapter 2: Getting started with SQL

Lecture 1: Understanding our Project Data

Lecture 2: ChatGPT Prompt

Lecture 3: Getting started with SQL – SELECT *

Lecture 4: SELECT specific Columns and Rows

Lecture 5: Selecting WHERE Part 2

Lecture 6: Time Intelligence – Date | Month

Lecture 7: Time Intelligence Part 2 – DATEPART

Lecture 8: Time Intelligence in Action – Basic Example

Lecture 9: SUM and Group

Lecture 10: Making and Using SubQuery

Lecture 11: PIVOT data into Columns

Lecture 12: Practice: SubQuery & PIVOT

Lecture 13: Create VIEW

Lecture 14: JOIN Tables

Lecture 15: JOIN Tables – Part 2

Lecture 16: RIGHT JOIN & LEFT JOIN

Lecture 17: JOINs Practice – Joining 4 Tables together

Lecture 18: FORMAT numbers

Chapter 3: Preparing Profit & Loss Statement

Lecture 1: Preparing Profit & Loss Statement – Part 1

Lecture 2: Profit & Loss Statement – Part 2

Lecture 3: Profit & Loss Statement Part 3

Lecture 4: Preparing Balance Sheet – Understanding the problem

Lecture 5: SQL for Cumulative SUM

Lecture 6: Cumulative SUM Part 2

Lecture 7: Cumulative SUM Part 3

Lecture 8: Balance Sheet Part 1

Lecture 9: Balance Sheet – Final

Chapter 4: Ratio Analysis with SQL

Lecture 1: Learning the CASE WHEN statement

Lecture 2: Calculating Sales

Lecture 3: Calculating Gross Profit and Net Profit

Lecture 4: Calculating EBITDA, Operating Profit and PBIT

Lecture 5: Calculating Gross Profit Margin – Demo

Lecture 6: Breaking down values by Country

Lecture 7: Calculating Ratios

Lecture 8: Calculating Balance Sheet Related Values

Lecture 9: Compiling all key values in one VIEW

Lecture 10: Calculating Ratios

Lecture 11: Calculating further values for Ratios and updating VIEWs

Lecture 12: Calculating Receivables and Payables and updating VIEW BSValues

Lecture 13: Updating VIEW FinValues

Lecture 14: Calculating Interest Cover, Inventory | Receivables | Payables Turnover Period

Lecture 15: Slicing Ratios for Country

Chapter 5: Cash Flow Statement

Lecture 1: Introduction and foundation

Lecture 2: Uploading CF Table to our Database

Lecture 3: Calculating Values for Cash Flow Statement – Part 1

Lecture 4: Calculating Cash & Cash Equivalents at the end of the Year

Lecture 5: Calculating Cash & Cash Equivalents at the start of the year

Lecture 6: Compiling Cash Flow Statement

Instructors

Irfan Sharif ACA ACCA | #1 Best Selling Instructor of Accounting & Bookkeeping
Bestselling Trainer | Chartered Accountant | PwC Alumni

Rating Distribution

1 stars: 2 votes
2 stars: 0 votes
3 stars: 7 votes
4 stars: 22 votes
5 stars: 25 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu