Bank Statement Normalization

Defuse IF Workshop

Live Online with Francesco Cirillo
April 30 - May 01, 2025
Monday to Wednesday
08:30 AM EST - 12:00 PM EST (New York)
02:30 PM CEST - 06:00 PM CEST (Berlin)
04:30 PM GST - 08:00 PM GST (Dubai)
3 Days | 10.5 Hours Total | 3.5 Hours per Day

Register

Individual Enrollment

First 2 New Clients: $240 per participant
Next 3 New Clients: $255 per participant
Standard: $525 per participant

Group Enrollment

Small Team (2-4 participants): $315 per participant
Medium Team (more than 4 participants): $262.50 per participant

The Challenge

  • Are you tired of dealing with different bank statement formats from multiple accounts?
  • Struggling with complex, unwieldy code filled with IF statements to handle data validation and processing?
acme-bank.csv
Date,Description,Amount,Balance
2024-01-01,Opening Balance,,1000.00
2024-01-03,Coffee Shop,-5.00,995.00
2024-01-05,Salary,2000.00,2995.00
2024-01-10,Groceries,-150.00,2845.00
2024-01-15,Utility Bill,-100.00,2745.00
2024-01-20,Rent,-800.00,1945.00
2024-01-25,Transfer from Savings,500.00,2445.00
pioneer-savings.csv
Transaction ID,Date,Account Number,Type,Description,Amount,Currency
1,2024-01-01,12345678,Credit,Opening Balance,1000.00,USD
2,2024-01-03,12345678,Debit,Coffee Shop,-5.00,USD
3,2024-01-05,12345678,Credit,Salary,2000.00,USD
4,2024-01-10,12345678,Debit,Groceries,-150.00,USD
5,2024-01-15,12345678,Debit,Utility Bill,-100.00,USD
6,2024-01-20,12345678,Debit,Rent,-800.00,USD
7,2024-01-25,12345678,Credit,Transfer from Savings,500.00,USD

The Solution

This workshop will show you how to handle complexities effectively, leading to more adaptable and efficient software design.

  • Normalize Various Bank Statement Formats: Convert different formats into a single, uniform structure.
  • Eliminate Complex IF Statements: Reduce reliance on the IF strategy to simplify your code.
  • Enhance Data Consistency: Make dates, amounts, and text consistent across all statements.
  • Adapt Across Domains: Apply these techniques to any data domain, improving the versatility and efficiency of your programming skills.

Key Takeaways

  • Streamline Financial Data Processing: Master the art of normalization without extensive IF statements.
  • Improve Code Maintainability: Learn strategies that make your code easier to maintain and grow.
  • Boost Versatility: Discover methods that can be applied beyond banking to any data domain.

Additional Details

  • Recording Access: Participants will have access to the session recording for 30 days post-workshop.
  • Student Discounts: Students studying software architecture, computer science, or software engineering can email us for a chance to receive a voucher for a full discount on the workshop fee.
  • Limited Spaces: Secure your spot today and start transforming the way you develop software!

Join us to revolutionize your approach to programming and data handling!

Register

About the Workshop

Direct Interaction

Francesco will personally answer your questions, offering detailed explanations and tailored support.

Access to Recording

Receive access to the workshop recording for one month, allowing you to review the content at your convenience.

Platform: Zoom

Conducted on Zoom, ensuring easy access from anywhere and effective, interactive participation.

Certificate of Participation

Obtain a certificate at the end of the workshop, validating your participation and the skills acquired. Enroll today to transform your understanding of TDD and elevate your programming skills!

Register

Related Products

Bank Statement Explained Ebook

Dive deeper into the concepts taught in our workshop with this detailed guide. Packed with explanations and insights, it's the perfect companion for anyone serious about mastering TDD with the Diamond Kata. (Note: This ebook is sold separately and is not included in the workshop.)

Available from December 16, 2024

Bank Statement Diagrams Ebook

Visual learners will appreciate this diagrams-rich ebook that complements the textual explanations with clear, informative visuals. Enhance your understanding of complex concepts through engaging diagrams. (Note: This ebook is sold separately and is not included in the workshop.)

Available from December 16, 2024

Bank Statement Video Course

Prefer learning at your own pace? Our streaming video course covers similar topics to the workshop but allows you to revisit the content anytime. (Note: Access to this video course is sold separately and is not included in the workshop.)

Available from December 16, 2024

GitHub Repository with Source Code

Implement what you've learned by accessing all the source code used in our workshop and courses. Explore, modify, and test the code at your own pace. (Note: GitHub repository access is sold separately and is not included in the workshop.)

Available from December 16, 2024

Upcoming Events

TRAINER

Francesco Cirillo

Francesco’s journey in software spans over 30 years, influencing startups, corporates, and individual consultants.

A seasoned mentor, he has impacted countless professionals and teams. From his early days with Sun Microsystems to pioneering Agile Methods and creating XPLabs, Francesco's mark on the software industry is profound.

Notably, he's the creator of the groundbreaking Pomodoro Technique, a time management method embraced worldwide, as well as the visionary behind Defuse the IF Strategy, challenging conventional coding practices.

Testimonials

Carlo Garatti

"If your question is about how to write valuable software, this program is for you!! Through one-on-one lessons with Francesco you will learn how to fit the right techniques and tools in the exact phases of the software development cycle. You will fix and apply these ideas in real cases. And, last but not least, in an enjoyable way!"

Alessandro Ruzzon

"What did I like the most? In this workshop the theory part matches up with the practical part. You don't only hear WHAT TO DO but also HOW TO DO IT, and you start practicing it right away in the labs! That's really what the Workshop is about: real-life practice aimed at consolidating theoretical notions. This approach helps in understanding problems"

Break the Chains of Conditionals!