Skip to content
View Ruthinsights's full-sized avatar
2 followers · 0 following

Block or report Ruthinsights

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
Ruthinsights/README.md

👋Hi, I'm Ruth

Data Analyst | Turning Data into Business Insights

Based in Lagos, Nigeria

About Me

I'm a data analyst passionate about turning raw data into meaning insights and building dashboards that tell clear stories. I help organizations make sense of complex datasets and translate them into actionable insights. What I Do:

  • Transforming raw and messy datasets into structured, actionable information using Excel, SQL and Python.
  • Extracting, manipulating and analyzing data efficiently with SQL.
  • Building interactive, insightful dashboards using Power BI.
  • Translating data into clear insights that support decision making.
  • Automating task, analyzing trends and implementing data driven solutions.

Skills Snapshot

Microsoft Excel

  • Advanced data cleaning and formatting
  • Pivot tables, formulas, functions and and pivot charts for summary analysis
  • conditional formatting and data validation
  • Creating interactive dashboards and reports
  • Automating repetitive tasks with macros

SQL

  • Writing complex queries for data extraction
  • Creating analysis ready for visualization and reporting
  • Data cleaning and preprocessing large datasets
  • Creating joins, Cte, views, stored procedures and aggregating data

Python

  • Data cleaning, transformation and manipulation using pandas
  • Data visualization with Matplotlib, seaborn and Plotly
  • Automating tasks and workflows using python scripts
  • Statistical analysis and trend detection

Power BI

  • Designing interactive dashboards and reports
  • Creatng KPI, key metrics and visual storytelling
  • Creating calculated columns and measures using DAX
  • Identifying insights to support business decisions

Tools and Skills

  • Languages: SQL(PostgreSQL, MYSQL), Python, DAX
  • Tools: Excel, Power BI, Google Sheets, Canva
  • Soft skills: Detailed Oriented, Problem Solving, Storytelling, Statistical Analysis, Customer Communication

Let's Connect

"Data tells stories; my job is to find them and make them impossible to ignore"

Thanks for dropping by

Popular repositories Loading

  1. Ruthinsights Ruthinsights Public

    Hi, I'm Ruth

  2. Inventory-Risk-and-Capital-Exposure-Analysis Inventory-Risk-and-Capital-Exposure-Analysis Public

    A Data Analysis Project Using Excel. This report analyses inventory and sales data.

  3. Fashion-Retail-Sales-Analysis Fashion-Retail-Sales-Analysis Public

    This project is a Power BI project that analyzes sales performance, customer spending behavior and product performance.

  4. Healthcare-Analysis Healthcare-Analysis Public

    This is a Data Analysis Project using Excel, MYSQL and Power BI

  5. Customer-Behavior-and-Sales-Analysis-with-MySQL Customer-Behavior-and-Sales-Analysis-with-MySQL Public

    This Project focuses on analyzing customer behavior and sales trends using MySQL.

  6. ruthinsights2.github.io ruthinsights2.github.io Public

    CSS