j
josh27_

Joshua

@josh27_

Data Analyst Python, Excel and Power BI Clean Data, Clear Dashboards

Panama
Spanisch, Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
I'm Joshua, a data analyst based in Panama. I help businesses clean messy datasets and build automated Excel reports that update themselves — no broken formulas, no manual work every month. Early on I learned that the hardest part isn't the technical side — it's making the output simple enough that the right person understands it immediately. That's what I focus on. What I work with: Python · pandas · Excel · Power Query · Power Pivot Not sure if I can help? Message me before ordering.... Mehr lesen

Kompetenzen

j
josh27_
Joshua
offline • 
Durchschnittliche Antwortzeit: 1 Stunde

Meine Dienstleistungen

Datenbereinigung
I will clean and prepare your excel data for analysis
Ab15 $ / ProjektWeitere Details
Datenbereinigung
I will perform data cleaning and analysis using python
Ab15 $ / ProjektWeitere Details

Portfolio

Arbeitserfahrung

Self_Employed

Self Employed

Vollzeit • 1 yr

Data Analyst

Jan 2026 - Present • 5 mos

Working as a Data Analyst at Riba Smith, a retail chain in Panama. Built a customer segmentation model in Python classifying over 150,000 clients into behavioral segments using RFM analysis Designed a segment transition report that enabled the team to track customer movement across segments month over month for the first time Automated monthly sales reporting pipeline using Python and SQL Server, reducing manual processing time Built a Power BI dashboard revealing product consumption patterns by customer generation, enabling category-level decisions based on age demographics Developed an Excel automated dashboard using Power Query and Power Pivot to track retail store performance across product categories and time periods

Business Analyst

May 2025 - Dec 2025 • 7 mos

Cleaned and structured sales datasets to support upper management reporting and decision-making Automated recurring reports reducing manual processing time across the data team Built a loyalty rewards tracking report providing clear visibility into gift distribution tied to brand partnership purchases