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
Practicing my Excel formulas today — this one covers IF, COUNTA, COUNTIFS and PRODUCT logic on a simple inventory sheet (qty × rate = amount, then flagging items as Expensive/Cheap based on amount).
Nothing fancy, just clean formula work:
=Qty*Rate for amount
=IF(Amount>100000,"Expensive","Cheap") for grading
=COUNTA() to count items in the list
=COUNTIFS() to filter qty in a range
I do this kind of stuff for actual work too — cleaning up messy spreadsheets, building formulas that don't break when someone adds a row, dashboards, the works. If you've got an Excel headache (inventory sheets, budget trackers, reports that need automating), send me a message. I'll sort it out.
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
Challenges
View all
Related posts
ARTHADṚṢṬI — Amazon Sales Intelligence & Business Performance System
What started as an analytics project became an opportunity to build something closer to a real-world business reporting system.
I worked with Amazon sales data and took it through an end-to-end analytics workflow:
Raw Data → Data Cleaning → Transformation → Data Modeling → DAX → Power BI → Business Insights
What I worked on
• Data profiling and quality checks
• Cleaning & transformation using Power Query
• Handling missing and inconsistent data
• Business KPI development
• Data modeling
• DAX measures
• Interactive dashboard design
• Sales, product, fulfilment & geographic analysis
The final system provides visibility into:
→ Sales & revenue performance
→ Orders and units
→ Category & SKU performance
→ Fulfilment operations
→ Monthly trends
→ Geographic distribution
→ Interactive filtering & drill-down analysis
But the biggest lesson from this project was simple:
A dashboard shouldn't just look good. It should make the underlying data easier to understand and act upon.
I’m also available for dashboard projects.
If you have Excel, CSV, or other business data that is difficult to analyze, I can help transform it into a clean, professional and interactive dashboard.
Services I can provide:
→ Power BI Dashboard Development
→ Excel Dashboard Development
→ Data Cleaning & Transformation
→ Power Query Automation
→ DAX & KPI Development
→ Business / Sales Analytics
→ Interactive Reporting Systems
Check the github Repo
https://github.com/lokeshyadavalli001-star/ARTHADRSTI
Whether you need a dashboard built from scratch, an existing report improved, or messy data transformed into something usable, I'm open to working on it.
Have a dataset or reporting problem?
Send me a message. Let's turn the data into something useful.
#PowerBI #DataAnalytics #BusinessIntelligence #PowerQuery #DAX #Excel #DashboardDesign #DataVisualization #DataCleaning #FreelanceDataAnalyst
Any Suggestions and improvements is Sincerely Appreciated
Git hub Repo
https://github.com/lokeshyadavalli001-star/ARTHADRSTI
github.com
GitHub - lokeshyadavalli001-star/ARTHADRSTI: Amazon Sales Intelligence & Business Performance System
Amazon Sales Intelligence & Business Performance System - lokeshyadavalli001-star/ARTHADRSTI
Excel Formulas & Assignment Help — Fast, Accurate, Ready to Use
Need help with Excel formulas, data tables, or MS Office assignments? I solve them quickly and accurately using proper formula logic — no shortcuts, no guesswork.
This sample shows a formula-based assignment solved using:
✅ SUM — totals across columns
✅ Nested IF — automatic grade assignment (A/B/C based on average)
✅ COUNTA — counting entries
✅ COUNTIF — conditional counting
✅ SUMIF — conditional summing
✅ VLOOKUP — pulling matched values across a table
Whether it's a college assignment, a workplace report, or a personal spreadsheet you're stuck on, I can build clean, working formulas that actually explain themselves — plus a quick breakdown of the logic so you understand exactly how it works.
📊 Turnaround: Fast
🎯 Accuracy: Formula-verified, not hardcoded
💬 DM me your sheet or assignment and I'll quote it right away
Your business is generating data every day.
But can you quickly answer:
📦 Which products are at risk of stockouts?
🚚 Where are delivery and fulfillment problems happening?
💰 Which products or processes are affecting revenue?
📊 Which numbers actually need your attention?
That’s where I come in.
I help e-commerce and operations businesses clean, analyze, and visualize their data using Excel, Power Query, SQL, and Power BI.
The goal isn't just another dashboard.
It’s clearer answers, better visibility, and insights you can act on.
If your business has data but you're struggling to turn it into decisions, let's talk.
#Ecommerce #Operations #DataAnalytics #PowerBI #SQL #Excel #BusinessIntelligence
