SQL for Financial Data Analysis & Reporting – Zero to Pro

سرفصل های دوره

Master SQL fundamentals and apply them to financial data for comprehensive analysis, reporting, and decision making.

1. Getting our PC ready to run SQL

1. Downloading Database

2. Downloading & Connecting Azure Data Studio

3. CSV files for Database tables.html

4. Creating our Database project & uploading data

2. Getting started with SQL

1. Understanding our Project Data

2. Getting started with SQL - SELECT

3. SELECT specific Columns and Rows

4. Selecting WHERE Part 2

5. Time Intelligence - Date Month

6. Time Intelligence Part 2 - DATEPART

7. Time Intelligence in Action - Basic Example

8. SUM and Group

9. Making and Using SubQuery

10. PIVOT data into Columns

11. Practice SubQuery & PIVOT

12. Create VIEW

13. JOIN Tables

14. JOIN Tables - Part 2

15. RIGHT JOIN & LEFT JOIN

16. JOINs Practice - Joining 4 Tables together

17. FORMAT numbers

3. Preparing Profit & Loss Statement

1. Preparing Profit & Loss Statement - Part 1

2. Profit & Loss Statement - Part 2

3. Profit & Loss Statement Part 3

4. Preparing Balance Sheet - Understanding the problem

5. SQL for Cumulative SUM

6. Cumulative SUM Part 2

7. Cumulative SUM Part 3

8. Balance Sheet Part 1

9. Balance Sheet - Final

4. Ratio Analysis with SQL

1. Learning the CASE WHEN statement

2. Calculating Sales

3. Calculating Gross Profit and Net Profit

4. Calculating EBITDA, Operating Profit and PBIT

5. Calculating Gross Profit Margin - Demo

6. Breaking down values by Country

7. Calculating Ratios

8. Calculating Balance Sheet Related Values

9. Compiling all key values in one VIEW

10. Calculating Ratios

11. Calculating further values for Ratios and updating VIEWs

12. Calculating Receivables and Payables and updating VIEW BSValues

13. Updating VIEW FinValues

14. Calculating Interest Cover, Inventory Receivables Payables Turnover Period

15. Slicing Ratios for Country

5. Cash Flow Statement

1.1 CF.csv

1. Introduction and foundation

2. Uploading CF Table to our Database

3. Calculating Values for Cash Flow Statement - Part 1

4. Calculating Cash & Cash Equivalents at the end of the Year

5. Calculating Cash & Cash Equivalents at the start of the year

6. Compiling Cash Flow Statement

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy