Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Introduction to Databricks and Financial Applications
- Exploring the Databricks ecosystem
- An overview of financial data analysis workflows
- Case studies: risk modeling, financial reporting, and audit logs
Getting Started with Databricks Notebooks
- Creating and navigating notebooks
- Implementing Python and SQL within Databricks
- Collaborating via comments and version history
Data Ingestion and Cleaning
- Importing financial data from CSV files, databases, and APIs
- Leveraging Spark DataFrames for data cleaning and preparation
- Managing missing values and outliers
Transforming and Aggregating Financial Data
- Computing KPIs and financial ratios
- Filtering, grouping, and pivoting datasets
- Handling time series data and resampling
Visualizing Financial Insights
- Building dashboards using Databricks visualization tools
- Customizing charts for financial reporting
- Exporting visuals for presentations or regulatory compliance
Optimizing Queries and Using Delta Lake
- An introduction to Delta Lake architecture
- ACID transactions and ensuring data integrity
- Enhancing performance through data partitioning
Collaboration, Scheduling, and Sharing
- Managing access controls and permissions for finance teams
- Scheduling jobs for automated reporting
- Securely exporting data and results
Summary and Next Steps
Requirements
- A solid grasp of data analysis principles
- Practical experience with Python or SQL
- Knowledge of financial data structures and reporting standards
Target Audience
- Financial analysts and business intelligence specialists
- Data analysts operating within the finance sector
- Data engineers providing support to financial teams
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
