
Farian
Excel Expert

See my services

Portfolio
Work experience
Data Analyst & Excel Specialist
Self Employed • Freelance
Nov 2025 - Jan 2026 • 2 mos
As a Data Analyst and Excel Specialist, I help businesses transform messy, unformatted, and chaotic data into structured, clean, and actionable databases. I specialize in data parsing, formatting standardization, and creating intuitive executive dashboards. Key Responsibilities & Achievements: • Data Cleaning & Cleansing: Successfully handled large, unformatted raw system text logs, splitting complex concatenated text strings using advanced custom delimiter logic, Power Query, and Text-to-Columns. • Text & Numeric Standardization: Cleaned, normalized, and isolated mixed fields (e.g., separating pure monetary/numeric transaction costs from embedded tax notes, currency codes, and trailing characters). • Database Organization: Restructured broken or poorly formatted data layouts into fully filterable, scalable, and normalized relational tables ready for immediate business use. • Business Intelligence & Summarization: Leveraged Excel Pivot Tables and advanced aggregation techniques to synthesize hundreds of operational tracking rows into concise performance metrics. • Data Visualization: Designed custom, presentation-ready charts and visual dashboards (such as dark-themed data visualizations) to provide stakeholders with quick, executive-level insights into product demand and inventory sales trends. I focus on accuracy, structural integrity, and deliver 100% error-free data sheets that allow business owners to make informed, data-driven decisions instantly.