- Basic understanding of statistics
- Familiarity with spreadsheets and data entry
- No prior programming experience required
Audience
- Financial analysts
- Compliance officers
- Professionals in banking and financial supervision
- Beginners in data analysis
Python, R, Power Query, and Power BI are essential tools for modern data analysis and visualization.
This instructor-led, live training (online or onsite) is aimed at beginner-level professionals in financial supervision and inspection who wish to learn how to clean, analyze, and project data using these tools while interrelating information from different sources to support decision-making and oversight.
By the end of this training, participants will be able to:
- Understand the basics of Python, R, Power Query, and Power BI for data analysis.
- Clean and prepare databases for analysis using Python and Power Query.
- Analyze datasets with R for statistical insights and projections.
- Create visualizations and dashboards using Power BI for effective reporting.
- Integrate data from multiple sources for comprehensive analysis.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Introduction to Data Analysis Tools
- Overview of Python, R, Power Query, and Power BI
- Applications of data analysis in financial oversight
- Setting up the tools and environment
Data Cleaning and Preparation
- Using Python libraries (Pandas) for cleaning and transforming data
- Data cleaning techniques with Power Query
- Handling missing data and formatting inconsistencies
Statistical Analysis and Projections with R
- Basic statistical functions and data manipulation in R
- Exploratory data analysis
- Creating statistical models for projections
Data Integration and Transformation
- Combining data from multiple sources with Power Query
- Integrating Python and R workflows with Power BI
- Best practices for managing large datasets
Visualizing Data with Power BI
- Creating interactive dashboards and reports
- Using visuals to identify trends and insights
- Sharing and collaborating with Power BI
Practical Applications and Case Studies
- Case studies in financial data analysis and projections
- Building a workflow from data cleaning to reporting
- Real-world applications in financial supervision
Summary and Next Steps