Skip to content
View harianand-dataanalytics's full-sized avatar
๐Ÿ 
Working from home
๐Ÿ 
Working from home

Block or report harianand-dataanalytics

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse

Visitors ย  Status ย  Response ย  Location


Hey, I'm Hari ๐Ÿ‘‹

I'm not just a data analyst โ€” I'm the person managers call when they're drowning in spreadsheets and need a lifeline, fast.

Real results I've delivered:

๐Ÿ• Sales manager losing 3 hrs every Monday copy-pasting team data โ†’ got those 3 hours back with one dashboard

๐Ÿ’ฐ Business owner with no idea if he was profitable โ†’ built a live 3-statement model that told him the truth in real time

๐Ÿ“‹ HR team manually calculating payroll for 50 employees โ†’ fully automated in a single file

I take the work eating your Monday mornings and make it disappear.


Typing


๐Ÿ”ข By the Numbers


Excel & BI solutions built

Returned to clients per month

In data & financial systems

Client satisfaction rate

๐Ÿ”จ What I Build

Your Problem My Solution
๐Ÿ”ด No idea which employee is actually performing KPI Dashboard โ€” ranked, color-coded, automated
๐Ÿ”ด Hours lost every month on payroll calculations Payroll Automation โ€” enter attendance, salary done
๐Ÿ”ด Can't tell if your business is profitable right now 3-Statement Model โ€” P&L, Balance Sheet, Cash Flow linked
๐Ÿ”ด Sales team blind on targets vs actuals Sales Tracker โ€” live progress bars, top performer flags
๐Ÿ”ด Typing invoices manually every single time Auto Invoice Generator โ€” fill name, invoice ready
๐Ÿ”ด No system to track inventory or stock levels Inventory Manager โ€” low stock alerts, reorder flags
๐Ÿ”ด Making decisions on gut feeling Executive Dashboard โ€” KPIs, trends, forecasts on one screen

๐Ÿ’ฌ What Clients Say

"Hari built us a payroll system that used to take our HR team an entire day. Now it takes 10 minutes. Genuinely one of the best investments we've made."

โ€” Operations Manager, Trading Company โญโญโญโญโญ

"I sent him a messy spreadsheet on Monday. By Wednesday I had a fully automated dashboard I could actually use to run my business. Fast, clean, professional."

โ€” Business Owner, Retail โญโญโญโญโญ


๐Ÿ† Featured Projects

"3 hours of Monday work โ†’ 3 minutes"

  • Auto-ranks every employee by achievement
  • Flags underperformers in red โ€” no manual checking
  • Tracks attendance, tasks & customer scores
  • Leaderboard with zero manual sorting
  • Weekly trend โ€” is the team improving?

Excel Conditional Formatting AVERAGEIF Dynamic Charts

"Change one number. Everything updates."

  • P&L โ†’ Balance Sheet โ†’ Cash Flow, all linked
  • Stays balanced โ€” zero manual reconciliation
  • Replaces three separate spreadsheets with one model
  • Built for businesses that can't afford accounting software

Excel Formula Linking Financial Modeling Trial Balance

"No formulas to update โ€” ever."

  • Logs income & expenses as you enter them
  • Calculates net margin automatically
  • Flags months where costs exceeded revenue
  • Month-over-month comparison built in

Excel VBA Dynamic Ranges Automated Reporting

"4-week forecast. No plugins needed."

  • Triple exponential smoothing natively in Excel
  • Auto-adjusts as new sales data comes in
  • Upper & lower confidence bounds shown
  • Built for sales managers who need to plan ahead

Excel Time-Series Forecasting Statistical Modeling


โšก Before vs After

โŒ Before โœ… After
3 hours manually copying data every Monday Dashboard refreshes in 1 click
Payroll calculated by hand for 50 employees Enter attendance โ†’ salary auto-calculates
3 separate spreadsheets that never reconcile One linked model, always balanced
"Is the business profitable?" โ€” nobody knows Real-time P&L visible any time
Invoice typed from scratch every single time Fill name + items โ†’ professional invoice ready

๐Ÿ› ๏ธ My Toolkit

Core Tools

Excel Power BI Python SQL VBA Google Sheets

Formulas I Could Write in My Sleep

INDEX MATCH XLOOKUP SUMIFS Array Formulas Power Query Pivot Tables Financial Modeling VBA Automation


๐Ÿ“Š GitHub Activity






Snake animation

๐Ÿ’ฌ Got a Monday Morning Spreadsheet?

Is someone at your company spending 2+ hours on a file that should take 5 minutes?

That spreadsheet is my next project.

Send it to me โ€” I'll tell you exactly how long automation takes and what it costs. No sales pitch. No obligation. Just an honest answer.


ย ย  ย ย 



๐Ÿ“ Karachi, Pakistan ย |ย  ๐ŸŒ Working with clients worldwide ย |ย  โšก Usually replies within 2 hours


Popular repositories Loading

  1. Automate-Budget-Tracker Automate-Budget-Tracker Public

    A clean, dynamic Budget Tracking Suite for personal and corporate cash flows. Automates revenue streaming, categorical spending logs, and savings goal targets with conditional rule-mapping and overโ€ฆ

  2. Varinda-Store-Sales-Dashboard Varinda-Store-Sales-Dashboard Public

    An advanced, interactive Retail Analytics Solution built entirely in Microsoft Excel. Processes transactional POS records to map historical trends, inventory margins, and top-selling SKUs using linโ€ฆ

  3. Financial-Statements-Suite Financial-Statements-Suite Public

    A professional, integrated Three-Statement Financial Model built in Excel. Dynamically links the Income Statement, Balance Sheet, and Cash Flow Statement into a clean, formula-driven ecosystem for โ€ฆ

    Python

  4. Automate-Payroll-Trackor Automate-Payroll-Trackor Public

    A fully automated workforce management suite in Microsoft Excel. Dynamically links daily attendance logs (Present, WFH, Leave) with monthly basic salary structures to calculate earned payouts, statโ€ฆ

  5. Sales-Forecasting-Engine Sales-Forecasting-Engine Public

    Excel-based sales forecasting engine with seasonal decomposition, FORECAST.ETS projections, confidence intervals, and a live KPI dashboard โ€” no macros, no plugins.

  6. Automate-PL-Trackor Automate-PL-Trackor Public

    A fully formula-driven Monthly Profit & Loss (P&L) tracking suite in Excel. Automatically aggregates multi-channel revenues, maps categorical operating expenses, and computes real-time net margins โ€ฆ