I'm passionate about using data to solve problems and tell meaningful stories—it's the reason I created this site. I believe learning is a lifelong journey, especially in a fast-evolving field like technology. Regardless of age or background, growth is always possible. I approach every challenge with a can-do attitude and live by the motto: "I do what I love and love what I do

Below is my curated collection of data-driven projects that demonstrate how I transform raw data into actionable insights and compelling data stories.

Data Insights for Large, Complex Datasets

This project highlights a data-driven approach to analyzing donor behavior and forecasting contributions for a not-for-profit. Using Microsoft Fabric and Power BI, I built an ELT pipeline to process and visualize over 1 million donation records from Microsoft Dynamics CRM. Key insights include donor profiling, RFM segmentation, and donation mapping with LINZ data. I also implemented predictive models—Prophet, linear regression, and average-based methods—to support fundraising and outreach with actionable insights. Read more...

New Zealand International Trade

This study analyzes New Zealand’s international trade from 2015 to 2022 using Excel, Access, and Power BI. It explores top trading partners, key commodities, and the impact of inflation. Drawing on data from Stats NZ and the IMF, the analysis links CPI changes to trade volumes and applies both manual and automated forecasting to predict future trends. . Read more or download the full report.

GLOBAL TEMPERATURE

This project provides a comprehensive analysis of global temperature trends from 1961 to 2020. Built using publicly available datasets, it visualises annual and seasonal temperature changes across continents and countries. Key insights highlight rising global temperatures, regional disparities in warming, and decade-by-decade comparisons. Developed with Google BigQuery and Looker Studio, the project delivers a clear, data-driven perspective on climate trends to support awareness and further exploration. Clicking “Read more” will open the interactive dashboards in Looker Studio, which may require users to sign in. Read more...

USING KPI FOR SALE PERFORMANCE REVIEW

This project features an Excel-based KPI dashboard built with Power Pivot, DAX, and PivotTables to track sales performance, delivery rates, and customer complaints. It leverages embedded KPI tools in Power Pivot to automate indicators and create interactive visuals that deliver clear, actionable business insights. Read more...

COVID-19 DATA INSIGHTS

This study examines COVID-19 prevalence and mortality across countries and continents, using publicly available data from the European Centre for Disease Prevention and Control (ECDC). I utilized Microsoft Excel’s database features—including Power Pivot, data modeling, and DAX—to generate meaningful insights. Read more...

CLIENT INFORMATION MANAGEMENT

A simple, centralized client tracking solution built in Excel. Completed in 3 months, the project replaced fragmented workflows with a scalable system featuring data consolidation, automation, and standardization—boosting accuracy and team efficiency. Read more...

Car Sale Report Dashboard

This project highlights two key features: (1) a search functionality built using advanced techniques such as Data Validation and filter formulas, and (2) an interactive dashboard that enables users to explore sales data through dynamic visualizations—revealing trends, identifying top-performing brands, and analyzing regional performance. Download project file...

CUSTOMER SERVICE DESK SUMMARY

Part of my personal learning journey, this project uses advanced VLOOKUP and conditional formatting to turn monthly sales data into an interactive summary. Some features may not display fully in Google Sheets due to format limitations. Read more...

Em 2016 The Study of Supporting Services for Children with Disability in Cambodia.pdf

The Study of Supporting Services for Children with Disabilities in Cambodia

This research project, completed during my internship at the Nossal Institute for Global Health, investigates the availability, distribution, and quality of services for children with disabilities in Cambodia. Through policy review, service mapping, and analysis of institutional frameworks, the study highlights critical gaps in service coverage—especially in rural areas—and identifies key barriers to inclusion, such as inconsistent disability definitions, limited awareness, and reliance on external support. The report offers evidence-based recommendations to improve service accessibility, coordination, and community engagement through strategies like Community-Based Rehabilitation (CBR) and strengthened referral systems. This work reflects my commitment to using data and policy analysis to promote social equity and inclusive development. ...

Questions?

Contact Kagna @kganaem@gmail.com to get more information on the projects

Page updated

Google Sites

Report abuse