About the Client
Yokohama Rubber Company is a globally renowned tire manufacturer, headquartered in Japan, with a legacy of over a century in delivering cutting-edge mobility solutions. Known for its strong commitment to quality, innovation, and sustainability, Yokohama has built a reputation as one of the most trusted brands in the automotive industry. In India, Yokohama Off-Highway Tires (YOHT) and Yokohama India have established a strong presence, serving diverse segments including passenger vehicles, trucks, buses, construction equipment, and agricultural machinery. With advanced manufacturing facilities, a wide dealer network, and a focus on customer-centric innovation, Yokohama continues to contribute to safer, more efficient, and sustainable mobility across geographies.
Workshop Objective
The Power Query in Finance Training was designed to upskill Yokohama’s finance professionals on leveraging Excel’s Power Query to:
- Automate repetitive data-cleaning and reporting tasks.
- Connect and combine data from multiple sources with accuracy.
- Build finance-ready datasets for reconciliation, analysis, and dashboarding.
- Strengthen Excel-to-Power BI integration for future scalability.
Workshop Summary
The training was a hands-on, tool-focused program, blending guided demos, exercises, and finance-specific use cases. Participants explored how to transform raw financial data into clean, structured, and analysis-ready formats.
Key highlights included:
- Understanding the Power Query interface and query editor.
- Importing and transforming finance data from multiple sources.
- Applying functions for cleaning, merging, appending, and unpivoting datasets.
- Creating reusable queries for monthly and quarterly reporting cycles.
- Using conditional columns, data types, and advanced editor logic.
- Exploring how Power Query outputs feed into Power BI dashboards for financial insights.
By the end of the program, participants were able to automate key parts of their reporting workflows, reducing manual errors and saving hours of effort during closing cycles.
Workshop Details
- Mode: On-Site
- Audience: Finance Teams
- Batch Size: 30 Participants
- Duration: 2-day Workshop
- Customized Training Modules
- Certificates for all participants
Trainer (Speaker) Profile
- Over 100,000 learners trained and 50,000+ training hours delivered.
- Expert in Excel, Power Query, Power BI, and financial analytics.
- Creator of the Power BI Mastery Framework – a step-by-step roadmap for professionals to move from Excel to certified Power BI analysts.
- Recognized for simplifying complexity into clarity and enabling professionals to become confident, job-ready analysts.
- Specializes in real-world dashboards, PL-300 certification prep, AI-driven storytelling with tools like ChatGPT, and portfolio building.
