Financial Modeling & Data Analytics Expert
Big Data promises a host of new opportunities for companies, but it is also changing the demands on management, on the analysis of this data, and on the people who operate these tools. Finance professionals will deal less and less with manual process steps and non-value-adding transactional tasks. Rather, skills in the context of using, processing, preparing and visualizing financial and operational data will be in demand in the future.
In this course you will learn how to clean raw data efficiently and automatically via automatic queries and how to visualize this data in Power BI independently of heterogeneous data sources and pre-systems for well-founded decision templates. Furthermore, you will learn in practice how to automate processes in the Microsoft environment with Power Queries and Power Automate. In addition, we specifically address best practices in creating an integrated and dynamic financial model. With what you learn, you will work in a completely new level of efficiency and effectiveness.
4
Seminar Days
ISM Campus
Munich, Frankfurt, and Berlin
2
Modules
Target Group
Finance Professionals, Finance Executives, Financiers, Private Equity Portfolio Managers, Management Consultants, Interim Managers
3,490€
(excl. VAT)
Certificate
“Financial Modeling & Analytics Expert” by International School of Management
Module 1 – Financial Modeling (2 days)
- Excel Financial Modeling
- Excel Dashboards
- Excel VBA
Module 2 – Data Analytics (2 days)
- Performance Measurement
- Reporting
- Microsoft Tools
- Power Query
- Power BI
- Power Automate
Your Benefit
- You will raise your profile as a finance professional with the data analytics skills needed today, increasing your value in the business or marketplace.
- You will be empowered to build the best integrated financial models with ease and fun.
- You will be empowered to work with Microsoft tools such as Power Queries, Power BI and Power Automate and use them effectively in your day-to-day work.
- You’ll learn hands-on how to use Big Data and how to automate processes without new software.
- As a private equity portfolio manager, management consultant or interim manager, you will be able to start “hands on” with financial transformation and increase your revenue opportunities.