HOT

SQL for Financial Data Analysis & Reporting – Zero to Pro

Business

Rating4.2
Enroll Now

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

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!

You may also like

Google Shopping Ads Digital Marketing Course

Complete Copywriting System : write to sell with ease

Product Positioning Masterclass: Unlock Market Traction