I'm Elta Dessyembra, an education and operations professional developing practical data analytics capability with Power BI, Power Query, DAX, Excel, data modelling and business analysis.
Portfolio case studies use synthetic data for demonstration. They are designed to show the analytical workflow and reporting approach.
Three end-to-end portfolio projects showing how I approach raw business data: prepare it, model it, create measures, build an interactive report and turn the results into business insights.
Executive view of revenue, profit, products, regions and customer performance.
Demonstrates KPI design, time intelligence, profitability analysis and interactive business reporting.
View case study →Candidate performance, pass rates, attendance and centre analysis.
Connects analytics with an education environment and demonstrates performance storytelling.
View case study →Capacity, productivity, completion, cancellations and satisfaction.
Shows how operational data can be converted into actionable management information.
View case study →Business question: How are revenue and profitability performing across products, customers, regions and time?
Total Revenue = SUM(Sales[Revenue])Total Profit = SUM(Sales[Profit])Profit Margin = DIVIDE([Total Profit],[Total Revenue])
Use product, region and time filters to isolate where revenue growth is coming from and where profitability is under pressure.
Illustrative dashboard values — synthetic portfolio dataset.
Business question: Which factors and locations are associated with stronger examination outcomes?
Pass Rate = DIVIDE([Passed Candidates],[Total Candidates])Average Score = AVERAGE(Results[Score])
Identify centres or subjects with unusual changes in pass rate, then investigate the operational context rather than reporting the number alone.
Illustrative dashboard values — synthetic portfolio dataset.
Business question: Where are capacity and service delivery performing well, and where are bottlenecks appearing?
Completion Rate = DIVIDE([Completed Services],[Total Services])Utilization = DIVIDE([Billable Hours],[Available Hours])
The dashboard is designed to help managers identify capacity gaps, recurring cancellations and service-quality patterns.
Illustrative dashboard values — synthetic portfolio dataset.
A recruiter can see the full workflow behind each dashboard — not just the final visual. The same approach can be applied to a company's own Excel or other structured business data.
I combine structured data preparation, Power BI reporting and real-world education and operations experience to make dashboards useful to the people who act on them.
“My strength is combining professional experience in education and operations with a growing data analytics skill set.”
I'm open to Data Analyst opportunities and practical analytics projects. If your team has raw Excel or structured business data, we can start with the business question, define the KPIs and shape the reporting approach.