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.
Course Outline
Introduction to Databricks and Its Applications in Finance
- Exploring the Databricks ecosystem
- Overview of workflows for financial data analysis
- Examples of use cases: risk modeling, financial reporting, and audit logs
Getting Started with Databricks Notebooks
- Creating and navigating through notebooks
- Integrating Python and SQL within Databricks
- Facilitating collaboration via comments and version history
Data Ingestion and Cleaning
- Importing financial data from CSV files, databases, and APIs
- Leveraging Spark DataFrames for data preparation and cleaning
- Managing missing values and identifying outliers
Transforming and Aggregating Financial Data
- Computing KPIs and financial ratios
- Filtering, grouping, and pivoting datasets
- Performing time series manipulation and resampling
Visualizing Financial Insights
- Building dashboards using Databricks visual tools
- Customizing charts specifically for financial reporting
- Exporting visuals for presentations or regulatory review
Optimizing Queries and Leveraging Delta Lake
- Introduction to Delta Lake architecture
- Understanding ACID transactions and data reliability
- Enhancing performance through data partitioning
Collaboration, Scheduling, and Sharing
- Managing access and permissions for finance teams
- Scheduling jobs to automate reporting processes
- Securely exporting data and results
Summary and Next Steps
Requirements
- Foundational knowledge of data analysis concepts
- Hands-on experience with Python or SQL
- Familiarity with financial data types and reporting standards
Target Audience
- Financial analysts and business intelligence specialists
- Data analysts operating within the finance industry
- Data engineers providing support to financial teams
14 Hours
Testimonials (1)
All the topics covered, although many were very quick, give us an idea of what we will need to delve into further. Additionally, I liked that we got to do some hands-on practice, although I still believe the course deserves more.
Sandra Mariela Lopez Bernal - Kueski
Course - Databricks
Machine Translated
