DATA ANALYTICS Traineeship

Financial Analysts with SQL

KEY SKILLS: Ms Excel 1, Advance Ms Excel 2, Power Pivot, Transact SQL RDBMS & Querying, KCL’s Work Experience Project, CV and Interview Preparation

4.7 (253 user ratings)

Rated 4.7 out of 5

What You’ll Learn:

Delegates to this course will learn financial analysis and modelling portfolio and it involves analyzing large volumes of financial, operational and transaction data. As a finance analyst, you will be equipped to maintain daily cash flow spreadsheets for all bank accounts; prepayment and accruals, P&L, Reconcile relevant balance sheet accounts on a regular basis.

At the end of this course, you will know how to;

Deliver forecast and rolling variances to sales and marketing managers to highlight how well the business is doing to date as well as where sales are likely to end up at the end of the measuring period.
Effectively identify and use the right tools and techniques to create MI reports to drive strategic decisions for senior managers.
Extract data from databases in such a way as to aid delivery of business information to present within the business information report clearly and accurately.
Overlay multiple fields to create business and customer understanding.
Interpret reports and make recommendations on actions that need to be taken.
Automate business reporting templates (advanced level reporting).