Hi! I'm Lorie Ruiz

I help people make sense of data — whether it’s cleaning up spreadsheets, building dashboards, or digging into insights that drive better decisions. If it involves numbers, patterns, or a bit of Excel magic, I’m probably into it.

Projects

Listed below are some of the most representative projects I've worked on. They range from basic Excel reports to Power BI dashboard to visualize key data stories.

Downtime Analysis

Soda Manufacturing Analysis - Power BI Dashboard
Employee Analytics

HR Department's Workforce Overview with Excel
Excel Automations

Automated formulas and macros of repetitive tasks

What I Do

Whether it’s working through complex spreadsheets or creating dashboards, here’s what I can help you with:

Data Cleaning & Transformation

Clean and prepare messy datasets using tools like Power Query — ensuring accuracy and structure before any analysis begins. Whether you're working with customer data, sales reports, or product logs, let's make sense of it.

Dynamic Dashboards in POWER BI

Build interactive dashboards that make insights easier to explore and understand. Use Power Query for data transformation and DAX for creating meaningful metrics and KPIs.

Automated Reporting in Excel

Repetitive, manual tasks? Setup Excel automations using nested formulas, Macros, and VBA to streamline processes, generate reports, and reduce time spent on routine works.

About Me

I'm an analyst who enjoys turning messy, complex data into clear, meaningful insights. I've always been curious about patterns and stories hidden behind numbers — and interested in solving problems backed with data. With a background in Business Economics, I’ve built strong analytical skills that help me look at challenges from both in technical and business perspective. For me, working with data isn’t just a job — it’s a way to explore possibilities and help others make smarter decisions.

Professional Experience
Analyst – Marketing Department
JG Superstore
March 2024 - June 2025

Heavily utilized Power Query, Excel nested formulas, and VBA/Macro to analyze data for pricing and reports.

Technical Skills
  • Create Power Query scripts for ETL processes and write DAX for dashboards.
  • Skilled in Excel nested formulas and automation using VBA/Macros.
alternative alternative

Frequent questions

The best way to reach me is through the contact form of by messaging me on my social media accounts. For a fast quote make sure your provide many project details
The best way to reach me is through the contact form of by messaging me on my social media accounts. For a fast quote make sure your provide many project details
The best way to reach me is through the contact form of by messaging me on my social media accounts. For a fast quote make sure your provide many project details
The best way to reach me is through the contact form of by messaging me on my social media accounts. For a fast quote make sure your provide many project details

Contact details

You have a project that I can help with? Don't hesitate to reach out to me at ruizplorie@gmail.com

Distributed By Themewagon