Ivars Krampis-Vanags — Data Analytics Instructor
Riga
Latvia-based instructor

Ivars Krampis-Vanags

Data Analytics Instructor & BI Consultant · SOFIUS SIA

I've spent over 25 years working with data — building financial models, automating reports, designing dashboards, and solving business problems with Excel and Power BI. Along the way, I discovered something I enjoy even more than the analysis itself: teaching others to do it.

Today, I help professionals and teams turn raw data into clear, confident decisions. Over 3,500 people have gone through my paid training programmes, and more than 20,000 have attended my live webinars and events.

Practitioner First, Trainer Second

I didn't start in a classroom. I spent nearly two decades in business — managing budgets, running operations, and building the reporting systems my teams relied on. Every course I teach today is built on problems I've solved in practice, not theory I've read about.

2 years
Finance Controller
Started my career in financial management after completing a BA at Concordia International University Estonia. Built my first serious Excel models here — reporting, budgeting, and analysis.
4 years
Management
Moved into a broader managerial role, overseeing teams and operations while continuing to rely on data-driven decision making.
2 years
Finance Manager & Factory Manager
Managed finances and then full factory operations at a production company in Liepāja. A hands-on role spanning manufacturing, logistics, and P&L responsibility — far from a desk-only career.
10+ years
IT-Based Finance Services
Joined Complete Payment Systems (CPS), where technology and finance intersected. Deepened expertise in data processing, financial systems, and the analytical tooling that would become my specialty.
10+ years · present
Founder — Excel Know How / SOFIUS SIA
Founded the training and consulting business that became Excel Know How. Now delivering courses, corporate training, and analytics projects for 200+ companies across Latvia and the Baltics.
Since 2024 · present
Founder — AI Master Lab
Founded AI Master Lab — helping companies adopt artificial intelligence in their workflows. Co-author of the "Artificial Intelligence in Career and Business" course.

How I Teach

I believe training should feel like a shortcut, not a chore. Every lesson I design starts with the same question: what will this person be able to do tomorrow that they couldn't do today? If the answer isn't clear, the lesson doesn't make the cut.

I don't teach abstract theory or walk through menus. I teach real techniques applied to real business scenarios — the same scenarios I've encountered across finance, manufacturing, services, and technology. When you finish a module, you leave with skills you can use immediately.

Practice First

Every concept is taught through hands-on exercises using real business data — not textbook examples.

Immediate Value

You should be able to use what you learned the same day. If it's not immediately useful, it doesn't belong in the course.

Built for Teams

My training scales from individual learners to enterprise departments — with materials that fit how teams actually work.

25 Years of Practice, Teaching, and Results

25+

Years in Excel

Working with spreadsheets since 1999 — from basic formulas to enterprise-grade financial models and automation.

10+

Years in Power BI

Designing interactive dashboards, building data models, and deploying cloud-based reporting for enterprise teams.

3,500+

Professionals Trained

Paid students across online courses and in-person workshops. Over 20,000 more through live webinars and events.

200+

Companies Served

Corporate training, consulting, and project work across finance, telecom, energy, pharma, retail, and public sector.

700+

Hours Delivered

Live training hours across in-person workshops, online sessions, and corporate programmes.

3

Years at Riga Technical University

Senior Power BI Consultant — designed and built the university's first Power BI analytics system for critical institutional KPIs.

Professional Certifications

Trusted by Leading Companies

I've delivered custom training programmes, consulting engagements, and analytics projects for organizations across Latvia and the Baltics — from telecoms and banks to energy companies and government agencies.

Each engagement starts with understanding the team's real workflows, data, and pain points. The result is training that's immediately relevant — not a generic seminar.

Atea LMT Grindeks Latvenergo Primum Swedbank Maxima Rimi Sadales Tīkls Rail Baltica NVD ACA Timber Caljan LSEZ
Riga Technical University
Senior Power BI Consultant — 3-year engagement building institutional analytics for critical KPIs
Riga Business School
Guest lecturer — Excel and data analytics programmes
Estonian Business School
Guest lecturer — data analytics with Excel and Power BI in MBA programme
University of Latvia
Instructor — Management and Entrepreneurship Learning Center, 2 Power BI course groups
AI Master Lab
Founder (since 2024) — co-author of "Artificial Intelligence in Career and Business" course
Ivars Krampis-Vanags — corporate training

Get in Touch

Whether you're looking for training, consulting, or just have a question about Excel or Power BI — I'd be happy to hear from you.