The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
I designed and developed this Microsoft Excel manufacturing operations system as a self-initiated Nomika Studio project.
The workbook brings several operational areas into one structured system, including inventory, bill of materials (BOM), production planning, purchases, sales and dashboard reporting.
Key features include a Production Flow Board, production planning with material-readiness and BOM coverage checks, purchase and vendor tracking, structured input tables, dropdowns, data validation, automated formulas, KPI cards, charts and clear workbook navigation.
The main challenge was connecting multiple operational workflows while keeping the workbook practical and understandable for everyday use.
This project demonstrates my ability to build larger Excel business systems, not just individual dashboards or simple trackers.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
I designed a Business Intelligence and financial reporting solution that transforms scattered data from multiple sources into centralized, validated, and decision-ready information.
The solution automates the complete reporting workflow: connecting and consolidating data, cleaning and standardizing information, applying business rules, building a structured data model, calculating financial KPIs, and generating executive dashboards and recurring reports.
Instead of manually combining spreadsheets and preparing reports every reporting period, the workflow creates a repeatable data pipeline that reduces manual work while improving consistency, traceability, and visibility.
Key capabilities include:
Multi-source data consolidation
Automated ETL and data transformation
Data validation and quality controls
Power Pivot data modeling
Financial KPI calculations
Interactive executive dashboards
Automated and scheduled reporting
Exception and duplicate detection
Audit trails and process traceability
Technologies: Excel, Power Query, Power Pivot, VBA, DAX, SQL/CSV data sources and automated reporting workflows.
The goal of the project is not simply to create a dashboard, but to build the automated data process behind it — turning raw information into reliable insights that can support faster business decisions.
All information, companies and metrics displayed in this case study are fictional demo data created exclusively for portfolio purposes.
Recently completed a Call Centre 2023 analysis project using Excel, where I explored call trends, customer ratings, representative performance, and city-wise insights.
🔹 Built an Excel Data Model & DAX measures
🔹 Created interactive PivotTables, KPIs & slicers
🔹 Analyzed monthly trends, ratings, caller demographics & representative performance
🔹 Converted raw data into meaningful business insights
🛠️ Tools: Excel | PivotTables | Data Model | DAX | Data Visualization
Another step forward in my journey of becoming a stronger Data Analyst. 🚀
#DataAnalytics #DataAnalyst #Excel #DAX #Dashboard #DataVisualization #PortfolioProject
Researched and qualified founders of early-stage startups using verified sources. I analyzed founder roles, buyer authority, startup background, persona and segment fit, and organized the results into a structured Excel database with supporting evidence.
