SQL Masterclass for Financial Analysis & Financial Reporting
What you'll 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
Requirements
- Basic knowledge of Financial Reports
Description
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.
Who this course is for:
- Financial Analysts
- Business Analysts
- Data Analysts
- Accounting professionals
- Finance professionals
Instructor
- 4.5 Instructor Rating
- 17,036 Reviews
- 291,939 Students
- 11 Courses
Chartered Accountant with 16 years experience in Accounting, Finance, and Business Intelligence.
I am a Chartered Accountant from ICAEW (Institute of Chartered Accountants of England and Wales) and a Chartered Certified Accountant from ACCA (Association of Chartered Certified Accountants in England) . I also have a Bachelors degree in Commerce.
I started my professional career with PwC as a Functional Consultant, later moved to at FTSE 100 FMCG as a Finance Manager, then working a General Manager developed an outsourcing hub 'Excelsious' for US and UK accounting firms, and finally cofounded Receipt Bot - an accounting automation company which is automating some tedious aspects of Accounting for clients from 21 countries.
Right from the beginning of my career, my role has been to improve the Accounting and Reporting systems. From automating data entry and bookkeeping to the preparation of interactive business analysis dashboards for the senior management, I have led multiple assignments.
Over my professional career of 16 years, I have been teaching several programs of Accounting and BI at some reputed institutes. Over this time, I have trained 20,000+ students from 50+ countries.
I am absolutely delighted to share my skills and experience with you on the Udemy platform!