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
Still using manual filters and calculations in Excel every day? š
In this short video, I demonstrated how the DSUM() formula can help automate category-based calculations dynamically without creating Pivot Tables again and again.
This is especially useful for:
ā
Sales Reports
ā
Inventory Tracking
ā
Financial Summaries
ā
Dynamic Office Reports
ā
Conditional Data Analysis
Instead of manually filtering datasets, DSUM allows Excel to calculate results automatically based on selected criteria ā saving both time and effort in daily work.
Small Excel functions like this can make a huge difference in productivity and reporting efficiency.
š„ Check out the quick walkthrough below š
#Excel #ExcelTips #DataAnalytics #DataAnalysis #BusinessIntelligence #DSUM #ExcelFormula #Dashboard #DataVisualization #OfficeProductivity #Analytics #DataAnalyst
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
The machine had seen invention, war, fame, and gravity.
Music was the first thing it did not understand.
@CapCut x @Contra HQ
ā¢ Jun 1
there's something so hauntingly beautiful & poignant about incorporating the nirvana unplugged performance in this, definitely evocative of what power music holds & asks the viewer to really sit with the idea of art in all forms to think about preservation of humanity's true essence in the future. great stuff!
They thought it was a dance.
It was the first successful motion test.
š Built an Automated Power BI Dashboard with Real-Time File Refresh Workflow
Recently, I worked on a complete Power BI automation project where I transformed messy raw CSV data into a fully interactive business dashboard.
This project included:
ā
Data Cleaning with Power Query
ā
Handling messy and mixed date formats
ā
Data transformation & automation
ā
KPI Dashboard Creation
ā
Sales & Revenue Analysis
ā
Dynamic Visualizations
ā
Folder-Based Automated Refresh System
ā
Bangladesh Regional Map Integration
The most exciting part of this project was the automation workflow.
Instead of manually rebuilding reports every time new data arrives, I configured Power BI to automatically detect updated files from a folder source. Once new CSV files are added, the dashboard can refresh and update business insights instantly.
During the project, I also solved several real-world data problems like:
inconsistent date formats
null values
mixed discount scales
data type issues
automation refresh errors
This project helped me strengthen my skills in:
š Power BI
š Data Visualization
š§¹ Data Cleaning
ā” Automation Workflow
š Power Query
š Data Analytics
As a Data Analyst, I enjoy building dashboards that are not only visually appealing but also practical for real business decision-making.
If you need help with:
Power BI Dashboards
Data Cleaning
Automated Reporting
Business Insights
Excel & CSV Data Processing
feel free to connect with me or knock me anytime.
#PowerBI #DataAnalytics #BusinessIntelligence #Dashboard #DataVisualization #PowerQuery #Automation #DataCleaning #Analytics #DataAnalyst #DataScience #CSV #Excel #Reporting #BusinessAnalytics
Data Systems DesignGrowth MarketingBusiness Workflow AutomationMicrosoft Power BIGoogle GeminiChatGPT
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.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
portfolioreview
The best portfolios tell a story, not just show a grid.Ā Share yours for feedback.
freelancerlife
Freelancer life is wins, pivots, and everything in between. Whatās yours right now?