Prashant Panchal

Chief Data Transformer


I am an Experienced Finance Professional (Chartered Accountant) with varied experience in the field of Finance, Accounting, Auditing and Operations having worked with many (diversified) industries throughout my career

I have hands-on and thorough practical knowledge and experience in routine accounting challenges that every accountant comes across (gained through tons of trials and errors with practical accounting issues faced and solved during my career)

Being an Excel, Data analysis, BI and ETL enthusiast, I love report automation while keeping accuracy and reliability of any accounting or management report at 100%. I have automated and enhanced daily accounting reporting tasks and improved reporting styles which have saved tons of hours of work for my colleagues and organisations

I have substantial experience gained throughout my career to improve and automate reports using Microsoft Excel, I use following techniques and tools routinely :

 

♦ Advanced Formulas and Functions

♦ Data Transformation and Data Cleaning

♦ Report Automation: Source file to Final Report

♦ Excel VBA

♦ Pivot Tables, Power BI

♦ Power Query (Get & Transform)

♦ Power Pivots and DAX