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
Case Study: Preserving Manual Updates While Automating Excel with Power Query
One of our clients faced a frustrating challenge.
Every week, new transaction data was imported into Excel using Power Query. The automation worked perfectly—until the finance team added manual notes, corrections, and operational comments.
Each refresh erased those manual changes.
The result?
❌ Lost notes
❌ Repeated manual work
❌ Inconsistent reporting
❌ Frustrated users who no longer trusted the automation
Our Solution
At Intersect Analytics, we redesigned the entire workflow instead of relying on a basic Power Query refresh.
We implemented a self-referencing Power Query architecture that:
✅ Preserved all manual notes and adjustments after every refresh
✅ Automatically appended only new transactions using unique IDs
✅ Eliminated duplicate records and accidental overwrites
✅ Maintained a clean, accountant-ready audit trail
✅ Reduced manual intervention while keeping the flexibility users needed
The finance team now refreshes their reports with confidence, knowing their operational notes and historical adjustments remain intact.
The Business Impact
✔ Hours of repetitive work eliminated every month
✔ Improved reporting accuracy and data integrity
✔ Increased confidence in automated reporting
✔ Faster month-end reporting and reconciliation
✔ A scalable solution that grows with the business
Technology Used
• Microsoft Excel
• Power Query (M Language)
• Self-Referencing Queries
• Data Transformation & Automation
• Business Process Optimization
Many organizations invest in automation but still struggle because critical business processes aren't designed correctly.
At Intersect Analytics, we don't just automate spreadsheets—we engineer reliable, scalable reporting systems that work the way your business actually operates.
📊 Our Services
• Excel & Power Query Automation
• Power BI Dashboard Development
• Financial Reporting & Analytics
• SQL & Data Integration
• Business Intelligence Solutions
• Workflow Optimization & Process Automation
• Executive KPI Dashboards
Stop rebuilding reports. Start building systems that last.
Intersect Analytics
Decisions Backed by Data. Growth Driven by Insight.
📱 WhatsApp: +254 723 632 207
#Excel #PowerQuery #ExcelAutomation #BusinessIntelligence #PowerBI #FinancialReporting #DataAnalytics #WorkflowAutomation #BusinessProcessImprovement #IntersectAnalytics
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
Related posts
This dashboard takes raw workforce and inventory data and automatically surfaces the metrics that matter no manual pivot tables or chart configuration needed.
What it includes:
KPI summary cards (Total Salary, Average Salary, Record Count) with period-over-period change indicators
A plain-English insights panel that surfaces the standout patterns in the data peak values, leading categories, and distribution shifts instead of leaving the reader to interpret raw numbers
A Reorder Level vs. Stock scatter plot to visualize the relationship between two variables at a glance
Time-series and categorical comparison charts (metric trends over time, comparison by employee ID) that respond to clicks for on-the-fly filtering
This is a budget tracking dashboard built entirely in Excel, designed to replace the typical cluttered "totals + pie charts" layout most budget templates default to.
Instead of static tables, the dashboard uses KPI cards (Total Planned, Total Actual, Variance, % of Budget Used) with sparkline trends, a Planned → Actual → Balance waterfall chart to show variance at a glance, and slicers that let the user filter by category or time period, with everything on the sheet updating live.
What it includes:
KPI summary cards with month-over-month sparklines
A waterfall-style variance chart replacing traditional bar/pie combinations
Category and period slicers connected to PivotTables for real interactivity, not just static charts
Conditional formatting on the variance table (over/under budget flagged automatically)
A plain-English insights panel summarizing what the numbers mean
A simple linear forecast projecting year-end spend based on current burn rate
Design approach: clean, minimal styling inspired by modern product dashboards (Linear, Notion) muted color palette, no gridlines, consistent typography built to look like a tool someone would actually want to open, not a default Excel export.
Excel Dashboard — Sales Analysis & Profit Tracking
Business Problem: A business owner needed a self-updating sales report to replace hours of manual monthly reporting.
Tools Used: Microsoft Excel, Pivot Tables, Data Visualization
KPIs Tracked: Total Sales ($2.29M), Total Profit ($286K), Units Sold (37,873)
Insights Discovered:
• Top Customers: Top 5 customers by sales identified for account management priority
• Product Performance: Top 5 products by profit revealed inventory focus areas
• Regional Trends: Sales by region and segment breakdown supported strategic planning
#Excel #MicrosoftExcel #DataAnalyst #SalesAnalysis #ExcelDashboard #BusinessIntelligence #DataVisualization #PivotTables #RemoteWork #DashboardDevelopment
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
fifaworldcup2026
The World Cup is here and the whole world's watching. How are you designing for the world stage?
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?