Rose Njeru the Data Analyst

I love transforming raw data into actionable insights
to solve business problems and drive growth.I find soccer,music,nature and reading therapeutic.My linkedin page Here.

My datastack is,BigQuery,MySQL,SQL Server,PostgreSQL,Tableau,Excel,Spreedsheets,VBA,tidyverse.

Things I Can Do

  • Write SQL Querries
  • Data Cleaning
  • Data Transformation
  • Design Interactive Dashboards
  • Data Story-telling
  • Drink Coffee

Data Projects

These are some of my data projects in SQl,Excel and Tableau.

Social Media Ad Marketing Campaign

Social Media Ad Campaign marketing is a leading source of Sales Conversion; therefore, I performed descriptive data analysis in SQL for company XYZ to help the marketing team understand the demographic customers and people's interests and provide insights on the most effective campaign level and target group in Facebook and maximise Return on Investments(ROI).

Product Sales Analysis

It involved designing Interactive Tableau dashboard to generate insights from sales data, trends, and metrics.

Retail Analysis

Designed Excel Superstore Dashboard using formulas like INDEX&MATCH and COUNTIF,Conditional Formarting, and Pivot Tables to analyse sales & profit by segment, category and sub-category level across cities and States.