Automation in Finance and Accounting

Automation in Finance and Accounting Bootcamp, is your gateway to simplifying complex challenges in your professional domain. Break free from traditional constraints and embrace modern tools and automation, where tech knowledge is no longer a barrier. This bootcamp is designed for Finance and Accounting Professionals seeking to go beyond traditional Excel skills. If you’re ready to enhance your performance, automate routine tasks, and implement modern tools in your profession, this program is tailored for you.

Provided by: Gresys Hub

Date and application:

There is currently no dates added.

Apply now

Bookmark

1. Excel – Power Query – Power BI (12.5H)

Introduction
Optimization of Excel reports
Power Query: importing and transforming data
Power Query: power pivot and data model
Data visualization with Power BI
Creating automated reports with Excel-Power Query-Power BI bundle
Connecting Power BI visualisation to Python data processing
Q&A mentoring session

2. Databases and SQL (5H)

Databases fundamentals, cloud fundamentals, BigQuery
SQL fundamentals
Connecting Database to the dashboard

3. Python automations (33.5H)

Introduction to programming with Python: setting up environment, first coding practice
Pandas, dataframes, data input and output
Fundamentals of version control system – Git
Conditional statements in Python
Iterations and data structures in Python
Google Sheets automation with Python
Visualisation in Looker Studio
Functions and modules in Python
Python scripts deployment to cloud (Google Cloud), dependencies, Docker basics
Python and SQL, importing data from database and exporting results to database
Creating Customized visualisations with Dash library
Q&A mentoring session

Deep tech fields

Artificial Intelligence & Machine Learning (including Big Data)
Advanced Computing / Quantum Computing

Course language

English

Fee

Course fee

Duration (hours)

51

Certificate provided

Yes

Skills addressed

Finance and Accounting
Financial reporting
Financial analysis
Budgeting and forecasting
Data Management
Database querying
Data integration
Data warehousing
Software Development
Software scripting
Software integration
Business Intelligence
Business analytics
Decision support systems
Information Technology
IT system management
Cloud solutions
Cybersecurity basics
Additional Relevant Keywords:
Financial Technology (FinTech)
Digital Transformation
Business Process Optimization
Big Data Analytics
Data Governance
Operational Efficiency
Data-driven Decision Making

Course format

Online

Target group

Undergraduate-level learners, Postgraduate-level learners

Quality check

Approved

Current no dates scheduled

Gresys Hub

Gresys Hub is more than a tech and entrepreneurship company, we are a community that challenges conventional teaching methods. At the core of Gresys Hub’s philosophy lies a groundbreaking concept: “coLive, coLearn, coWork.”

Ready to take the next step in your journey? Apply now and embark on a transformative learning experience. Whether you’re pursuing a passion or advancing your career, we’re here to help you succeed. Don’t wait any longer – seize the opportunity and apply today!

Apply to course