Purna Duggirala

Purna Duggirala is a data analytics professional with extensive experience in Excel, Power BI, and business intelligence. He is best known as the founder of Chandoo.org, an award-winning Excel and Power BI educational website.1

Professional Experience

Purna has held several notable positions throughout his career:

Chief Excel Officer at Chandoo.org: Since July 2004, Purna has been running Chandoo.org, where he helps people become proficient in Excel and Power BI.1

Microsoft MVP: He has been recognized as a Microsoft MVP since 2009 for his contributions to the Excel and data analytics community.1

Senior HR Reporting Analyst at The Treasury - New Zealand: From September 2020 to May 2021, Purna worked at The Treasury in New Zealand. In this role, he:

• Revamped existing reporting processes using Power Query and Excel
• Developed best practices for working with data from Tech1 systems
• Built dashboards to monitor Gender Pay Gap, HR metrics, and Annual Remuneration Review
• Used Power BI to derive insights from People & well-being data1

Other Relevant Roles:

• Data Lead for Remuneration Modeling & Analytics at Te Kawa Mataaho Public Service Commission (August 2022 - June 2023)
• Remuneration Analyst & Modeler at Ministry of Business, Innovation and Employment (October 2018 - August 2022)
• Reporting Analyst at H2R Consulting (November 2016 - May 2021)1

Skills and Expertise

Purna is highly skilled in:

• Microsoft Excel
• Power BI
• Data analytics and visualization
• Remuneration modeling and analysis
• HR reporting and metrics

His expertise in Excel has been particularly impactful, with Purna once mentioning that he received a 94% salary increase due to his advanced Excel skills.3

Educational Approach

Purna is known for his ability to break down complex technical concepts. He advocates for using multiple sources when learning new technologies and emphasizes the importance of understanding the fundamentals before diving into advanced topics.2

In summary, Purna Duggirala is a respected figure in the data analytics community, known for his expertise in Excel and Power BI, as well as his contributions to education through Chandoo.org.