π Project Spotlight: Upgrading Excel to an Executive Web-App UI πβ¨
Most corporate reporting falls into two traps: it is either a dense, unreadable wall of numbers, or a pretty graphic that has to be manually redrawn every single week.
I built this CL FY'2026 Market Performance Tracker to prove that you can achieve automated, heavy-duty backend engineering AND an immersive, software-like user experience entirely within native systems.
Here is the exact 3-tier workflow behind this build:
βοΈ Tier 1: The Automated Pipeline (Power Query)
No manual data entry. No copy-pasting. Raw transactional data is fed directly into Power Query, which acts as the automated data-cleaning engine. With a single click, the query automatically shapes, cleans, and runs ETL processes on thousands of rolling rows, refreshing the dashboard in seconds.
π Tier 2: The Core Logic Matrix (Dynamic Pivot Table & 3D Chart)
β’ The Grid: The transformed data consolidates seamlessly into a multi-period Pivot Table, mapping 15 distinct regional markets across an active 12-month calendar. It handles everything effortlessly, highlighting Market 5 as our heavy hitter with 2,936,685 in total volume.
β’ The Volumetric Display: The lower chart panel isn't a stagnant graphicβit is a live, native 3D Pivot Chart configured into cylinder metrics. As new numbers hit the backend table, the liquid fill-levels automatically rise or drop in real time to show progress against a 6,299,300 Grand Total.
π¨ Tier 3: The Premium UI Skin (Photopea Enhancement)
To lift the dashboard completely out of the standard "spreadsheet look," I engineered a high-fidelity background framework inside Photopea. Dropping the functional, live Excel components into this polished visual skin provides an immersive app environment, clean visual hierarchy, and polished title framing without compromising a single cell of live functionality.
The Takeaway: Spreadsheets don't have to be boring to be powerful. By treating data architecture like a product, you give clients and executive teams instant clarity at a single glance.
π οΈ Built with: Microsoft Excel (Power Query, Pivot Tables, 3D Charting) & Photopea (UI Layout Design).
0
73
Replicating Complex Industrial Dashboards in Microsoft Excel π οΈ
Check out this highly visual, gamified Chemical Recovery Performance Dashboard! It tracks multi-layered KPIs, rolling timelines, and budget variances across six different industrial chemical lines.
While this specific interface uses a custom graphic skin, a dashboard with this exact level of complexity can be built entirely within Microsoft Excel using advanced data modeling and native features.
If you are looking to build or optimize a tracking system like this, here is how we can replicate its core logic in Excel:
π Dynamic Time Slicing: Recreate the top control panel using Excel Slicers connected to a central Calendar Table. This allows users to filter the entire view by Month, Week Number, or a specific Production Date with a single click.
π Rolling Timelines (Yesterday, WTD, MTD, YTD): Build out the top metric rows using dynamic SUMIFS or DAX formulas (Power Pivot) that automatically calculate data across moving operational windows based on your slicer selection.
π§ͺ Gauge & Cylinder Progress Charts: Replicate the fluid container visual by customizing Stacked Column Charts. By using custom shape overlays or image-fill data series, we can make the charts look like filling liquid tanks that change color based on target thresholds.
π° Financial Variance & AOP Tracking: Link the bottom footer directly to variance calculation tables. This dynamically surfaces the Cost Impact To-Date and flags performance against the Annual Operating Plan (AOP) using conditional KPI indicators.
Whether your data is in manufacturing, logistics, or finance, you don't need expensive proprietary software to get highly engaging, interactive visuals.
If your team needs a clean, automated dashboard to monitor complex KPIs, let's connect! I can design tailored spreadsheet systems that turn raw operational data into actionable executive insights.
0
100
### π Fruit Sales Data Analysis β Interactive Power BI Dashboard
An interactive Power BI dashboard designed to analyze fruit sales performance and provide clear graphical insights into revenue, sales volume, product, size, and geographic performance.
The dashboard includes:
Sales Revenue β total revenue generated from fruit sales
Total Sales Quantity β total quantity of fruits sold
Sales by Fruit Name β compares sales performance across different fruits
Sales by Size β analyzes sales across different fruit sizes
Sales by City β identifies sales performance by city
Sales by Country β compares sales across countries
Sales per Month β monitors monthly sales performance
Revenue per Month β tracks monthly revenue trends
Sales Trend by Fruit β analyzes monthly sales trends by fruit name
Geographic Sales Analysis β identifies locations with the highest and lowest sales performance
The interactive dashboard allows users to explore product, size, time, and geographic sales patterns, helping identify top-performing fruits and markets while supporting data-driven sales and business decisions.
Key value:
Sales data β KPI analysis β Product & size analysis β Geographic analysis β Monthly trends β Graphical insights β Business decisions
π» What Do Employers Really Look For in a Remote Employee?
Having the right skills is importantβbut remote work requires more than just technical ability.
Here are some qualities that can make you stand out:
πΉ Communication
Can you communicate clearly, ask questions, and keep your team updated?
πΉ Reliability
Can your employer trust you to show up, meet deadlines, and complete your responsibilities?
πΉ Self-Discipline
Working remotely means no one is constantly watching over you. You need to manage your time and stay productive independently.
πΉ Adaptability
Remote teams work with different people, tools, processes, and time zones. Being willing to learn goes a long way.
πΉ Accountability
Mistakes happen. What matters is how you take responsibility, learn from them, and improve.
Your resume may get you the interview.
But your attitude, communication, and consistency can help you getβand keepβthe job.
π Remote work gives you flexibility.
Professionalism gives you longevity.
#RemoteWork #RemoteJobs #CareerTips #Hiring #JobSeekers #WorkFromHome #CareerGrowth #Recruitment
0
75
You can tell a lot about a person by how they treat people they donβt need anything from.
Professionalism isnβt only about how you speak to your boss, your client, or someone who can help your career.
It also shows in how you treat the applicant who didnβt get the job.
The new employee who is still learning.
The colleague who made a mistake.
The person who followed up twice because they were waiting for your response.
And even the people you may never work with again.
Because being respectful when thereβs something to gain is easy.
Character shows when there isnβt.
As I gain more experience working with different people, Iβm learning that professionalism and kindness donβt have to be separate.
You can set boundaries and still be respectful.
You can give honest feedback without making someone feel small.
You can say βnoβ without being rude.
And you can hold people accountable without forgetting that thereβs still a human being on the other side of the conversation.
At the end of the day, people may forget the exact words you said or the position you held.
But theyβll remember what it was like working with you.
Be professional, but never forget to be human.
#Professionalism (https://www.linkedin.com/search/results/all/?keywords=%23professionalism&origin=HASH_TAG_FROM_FEED) #WorkplaceCulture (https://www.linkedin.com/search/results/all/?keywords=%23workplaceculture&origin=HASH_TAG_FROM_FEED) #Leadership (https://www.linkedin.com/search/results/all/?keywords=%23leadership&origin=HASH_TAG_FROM_FEED) #CareerGrowth (https://www.linkedin.com/search/results/all/?keywords=%23careergrowth&origin=HASH_TAG_FROM_FEED) #HumanResources (https://www.linkedin.com/search/results/all/?keywords=%23humanresources&origin=HASH_TAG_FROM_FEED) #KindnessAtWork (https://www.linkedin.com/search/results/all/?keywords=%23kindnessatwork&origin=HASH_TAG_FROM_FEED) #Connections (https://www.linkedin.com/search/results/all/?keywords=%23connections&origin=HASH_TAG_FROM_FEED)
0
125
The best Executive Assistants don't just manage calendarsβthey create space for leaders to focus.
Behind every productive executive is a system that works.
An Executive Assistant isn't just someone who schedules meetings or replies to emails.
We:
βοΈ Keep priorities organized.
βοΈ Manage calendars and inboxes efficiently.
βοΈ Coordinate projects and follow-ups.
βοΈ Anticipate problems before they become emergencies.
βοΈ Give business owners back their most valuable assetβtime.
The goal isn't to stay busy.
The goal is to make your executive's day run smoother, faster, and with less stress.
When leaders have more time to focus on growth, everyone wins.
If you're a founder, business owner, or busy executive looking for reliable support, I'd love to help you stay organized and productive.
Let's connect.
#ExecutiveAssistant #VirtualAssistant #Operations #BusinessSupport #Productivity #RemoteWork #Startups #Contra #ExecutiveSupport #TimeManagement
1
162
Hiring is more than filling a role. It's about finding the right fit.
A great hire isn't always the candidate with the most impressive resume.
Sometimes it's the one who:
βοΈ Communicates clearly.
βοΈ Is willing to learn.
βοΈ Takes ownership.
βοΈ Shows up consistently.
Skills can be developed.
Attitude and commitment are much harder to teach.
As someone who works in recruitment and HR, I've learned that the best hiring decisions happen when we look beyond experience and focus on potential.
Whether you're building a remote team or looking for reliable support, investing time in the hiring process always pays off.
If you're looking for help with:
β’ Recruitment & Candidate Screening
β’ Interview Coordination
β’ Employee Onboarding
β’ HR Administration
β’ Executive Support
I'd be happy to connect.
#Contra #Recruitment #Hiring #HR #ExecutiveAssistant #RemoteWork #Startups #Operations #TalentAcquisition
AI Workflow Automation for IT Operations
Description
This project showcases an AI-powered workflow that automates repetitive IT operational tasks using AI, Microsoft Power Automate, Excel, Microsoft Teams, and ServiceNow. The workflow streamlines request processing, data validation, reporting, and team notifications while reducing manual effort and improving operational efficiency.
The solution enables faster response times, improved accuracy, and greater visibility across IT processes.
Skills
AI Automation
Microsoft Power Automate
ServiceNow
Microsoft Teams
Excel
Process Automation
0
32
AI Content Automation System with n8n
Description
This project demonstrates an end-to-end AI-powered content automation workflow built with n8n. The system automatically transforms content ideas into ready-to-publish marketing assets by integrating AI, design tools, cloud storage, and collaboration platforms into a single workflow.
The automation captures new content requests, generates AI-powered captions and copy, prepares design assets, routes content for approval, stores files in the cloud, and schedules publication. By eliminating repetitive manual tasks, the workflow helps creators and businesses produce content faster while maintaining consistency and quality.
This solution is designed for startups, agencies, e-commerce businesses, and content creators looking to streamline their content production process and scale their marketing efforts efficiently.
Key Features
AI-powered content generation
Automated workflow orchestration with n8n
Multi-platform integration
Content approval workflow
Automated notifications
Cloud file management
Content scheduling and publishing
Scalable, reusable automation
Tools & Technologies
n8n
OpenAI
Google Sheets
Canva
Google Drive
Slack
Google Calendar
Webhooks
APIs
Skills
AI Automation
Workflow Automation
n8n
API Integration
Process Optimization
Prompt Engineering
No-Code Automation
Business Process Automation
0
41
AI Business Process Automation using n8n
Description
This project demonstrates how I design intelligent workflows using n8n to automate repetitive business processes. The automation connects multiple applications, processes incoming data, uses AI for decision-making, and delivers results automatically without manual intervention.
The workflow is designed to reduce repetitive work, improve response time, and help businesses scale their operations through reliable automation.
Highlights
Built end-to-end automation workflows using n8n
Integrated multiple applications into a single workflow
Automated data processing and validation
Implemented AI-powered text generation and decision-making
Reduced manual effort through workflow automation
Created scalable and reusable automation processes
Skills
n8n
AI Automation
Workflow Automation
API Integration
Webhooks
OpenAI
JSON
Process Optimization
0
37
Graphic Design Portfolio
Description
This portfolio highlights my ability to create clean, engaging, and conversion-focused visual content for businesses and digital brands. It includes social media graphics, product advertisements, presentation materials, YouTube thumbnails, infographics, and branding assets designed to communicate ideas clearly while maintaining a professional and modern visual identity.
Every design is created with attention to detail, user engagement, and brand consistency.
Skills
Canva
Adobe Photoshop
Figma
Social Media Design
Branding
Presentation Design
Marketing Graphics