Course Outline

Introduction to Databricks and Financial Use Cases

  • Understanding the Databricks ecosystem
  • Overview of financial data analysis workflows
  • Use case examples: risk modeling, financial reporting, audit logs

Getting Started with Databricks Notebooks

  • Creating and navigating notebooks
  • Using Python and SQL in Databricks
  • Collaborating with comments and version history

Data Ingestion and Cleaning

  • Importing financial data from CSV, databases, and APIs
  • Using Spark DataFrames for cleaning and preparation
  • Handling missing values and outliers

Transforming and Aggregating Financial Data

  • Calculating KPIs and financial ratios
  • Filtering, grouping, and pivoting datasets
  • Time series manipulation and resampling

Visualizing Financial Insights

  • Creating dashboards with Databricks visual tools
  • Customizing charts for finance reporting
  • Exporting visuals for presentations or regulatory review

Optimizing Queries and Using Delta Lake

  • Introduction to Delta Lake architecture
  • ACID transactions and data reliability
  • Improving performance with data partitioning

Collaboration, Scheduling, and Sharing

  • Managing access and permissions for finance teams
  • Scheduling jobs for automated reporting
  • Exporting data and results securely

Summary and Next Steps

Requirements

  • An understanding of data analysis concepts
  • Experience with Python or SQL
  • Familiarity with financial data types and reporting

Audience

  • Financial analysts and business intelligence professionals
  • Data analysts working in the finance sector
  • Data engineers supporting financial teams
 14 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Provisonal Upcoming Courses (Contact Us For More Information)

Related Categories