Name: Rohanur Rahman Ontu

Job Role: Data Analyst

Experience: 1 Years +

Address: Dhaka, Bangladesh

Core Skills

SQL 99%

PYTHON 85%

DATA VISUALIZATION 99%

Statistical Analysis 85%

PROBLEM SOLVING 90%

About

About Me

I’m Rohanur Rahman, a data analyst passionate about transforming raw data into strategic insights that drive business growth—especially in the E-commerce and Retail space. With a strong foundation in SQL, Python, and data visualization tools, I specialize in uncovering trends, optimizing performance, and delivering actionable insights across marketing, operations, and sales funnels. My work focuses on turning complex datasets into clear, impactful stories that inform decision-making.

🔹 Core Technical Skills:
-SQL & BigQuery: Writing optimized, scalable queries for large datasets and cloud-based analytics
-Python: Experienced with Pandas, NumPy, BeautifulSoup, and statistical analysis packages
-Power BI, Looker Studio & Metabase: Designing interactive dashboards and automated reporting pipelines
-Google Analytics 4 (GA4): Analyzing customer behavior, traffic sources, and conversion paths
-Attribution Modeling: Evaluating marketing performance through data-driven attribution techniques
-Prompt Engineering: Utilizing LLMs (like ChatGPT) for automation, documentation, and ideation
-Excel: Advanced use of formulas, pivot tables, and dashboarding
-Visualization: Creating compelling, story-driven visuals with Matplotlib, Seaborn, and BI tools

📈 What I Do
I work on real-world analytics projects involving data cleaning, transformation, statistical analysis, and predictive modeling—delivering insights that improve decision-making across digital marketing, product performance, and supply chain operations.

💼 Why Work With Me
I bring a blend of technical expertise and business acumen to the table. Whether it's identifying revenue opportunities, optimizing attribution models, or tracking KPIs across marketing channels, I help businesses make confident, data-backed decisions.

Profile: Data Science & Analytics
Domain: E-commerce , Retail, Ed-tech & FMCG
Education: Bachelor of Computer Engineering
Language: English, Bengali
Programming Language: Python, Sql, c++
BI Tools: Microsoft Power BI & Looker Studio
Cloud Platform: Google BigQuery
Other Skills: Web Scrapping, Automotion, Excel, Ga4
Interest: Traveling, Self Development, Teaching

Projects

Case Study

Below are some case study, Solving real business problem through data combining most advance industry standard tools following best practice.

🛍️ SK Mart Retail Analytics Case Study

This project is a SQL-based data analysis case study focused on SK Mart, a growing retail chain operating in major areas of Dhaka, Bangladesh such as Gulshan, Dhanmondi, Banani, and Uttara. The goal of this project is to extract actionable business insights by analyzing customer behavior, sales performance, inventory data, and the impact of marketing campaigns.

SQL

Below are the Data Analytics projects on SQL

🛍️ E-Commerce Sales Data Analysis using SQL

This project involves an in-depth analysis of an e-commerce sales dataset using SQL. The objective was to uncover key business insights related to product performance, category trends, pricing, customer ratings, and more.

Movie Data Analysis with SQL

This repository contains a SQL-based data analysis project focused on exploring movie datasets. The project answers key business questions about movie ratings, industry trends, language distribution, and financial performance using PostgreSQL.

📊 Awesome Chocolates Sales Analysis

This project presents a comprehensive sales analysis for the fictional company Awesome Chocolates, utilizing SQL for data exploration, cleaning, and business intelligence. It’s a great example for SQL learners and data analysts who want to practice extracting insights from real-world-style datasets.

🎵 Music Store Analysis

This project analyzes a digital music store database using PostgreSQL, focusing on customer behavior, sales trends, and music popularity. The dataset includes customer details, invoices, tracks, and genres, providing valuable insights into business performance.

🧠 30-Day SQL Challenge

Welcome to the 30-Day SQL Challenge, a personal learning project by Rohanur Rahman to strengthen SQL skills through consistent daily practice. Each day, a new SQL problem is solved and documented using clear, beginner-friendly explanations. The focus is on real-world SQL use cases, clean code, and data analysis best practices.

☕ Maven Coffee Sales Analysis

The goal of this project is to perform a comprehensive Exploratory Data Analysis (EDA) on a transactional dataset to extract valuable business insights that can inform strategic retail decisions

PowerBI

Below are the Data Analytics projects on Power BI

E-commerce Sales Analysis & Forecasting

This Power BI project focuses on sales performance analysis and forecasting. It includes interactive dashboards to explore data at various levels.

Pizza Sales Report

This Power BI report provides an interactive and data-driven analysis of pizza sales, helping to uncover key business insights. The report transforms raw data into meaningful visualizations, enabling better decision-making.

Healthcare Provider Analysis

This Power BI dashboard provides an analytical view of healthcare provider data, offering insights into billing amounts, treatment costs, insurance coverage, and various healthcare services.

🎬 Maven Pixar Challenge - Insights & Impact

This Power BI dashboard provides an interactive and visually compelling analysis of Pixar movies, focusing on revenue, budget, profitability, ratings, and other key performance indicators.

E-commerce Sales Analysis Dashboard

This E-commerce Sales Dashboard is built using Power BI to analyze key business metrics, providing valuable insights into sales performance, customer trends, and product profitability.

🌍 CO₂ Emissions Analysis (1995–2018)

This project presents a comprehensive analysis of CO₂ emissions in the Accommodation & Food Services sector across different countries between 1995 and 2018.

🛒 AtliQ Mart Promotional Sales Analysis (FMCG Domain)

This project is part of a data analysis challenge by Codebasics aimed at helping AtliQ Mart, a prominent FMCG retail chain in southern India, analyze the effectiveness of its promotional campaigns during Diwali 2023 and Sankranti 2024.

Excel

Below are the sample Data Analytics projects on Excel

HR Attrition Analysis Project

This project focuses on analyzing HR attrition data using Microsoft Excel. The goal is to identify key factors contributing to employee attrition and derive actionable insights that can help organizations improve employee retention.

Coffee Sales Dashboard

The Coffee Sales Dashboard is an interactive Excel-based project designed to visualize and analyze coffee sales data. This dashboard provides insights into sales trends, customer behavior, and product performance, enabling stakeholders to make informed decisions based on comprehensive data analysis.

Road Accident Analysis

This Road Accident Analysis project is built using Microsoft Excel to analyze accident trends, casualties, and affected areas. It features an interactive dashboard with KPIs, filters, and visualizations to provide valuable insights.

Tea Store Sales Analysis

This project provides an in-depth analysis of retail transaction data for a tea store chain. By leveraging Excel's capabilities, the analysis focuses on uncovering sales trends, customer behaviors, and actionable insights to optimize business performance.

🛒Ferns and Petals (FNP) Gift Store Sales Analysis

This project involves an in-depth sales analysis of Ferns and Petals (FNP) — a company specializing in gifting products for various occasions such as Diwali, Raksha Bandhan, Holi, Valentine’s Day, Birthdays, and Anniversaries. The goal is to derive actionable business insights by analyzing sales data from 2023 to help the company optimize its sales strategy and enhance customer satisfaction. Business Problem Statement

Looker Studio

Below are the Data Analytics projects on Looker Studio

🛍️ Product Sales & Profitability Overview Dashboard

Developed an interactive dashboard to visualize and analyze product sales, profit margins, and regional performance across multiple countries and cities. The report features dynamic filters for product categories and promotions, along with clear visual trends for monthly sales, profit, and cost of sales. Designed to support strategic decision-making for retail and e-commerce stakeholders.

Customer Order Analysis

Developed an interactive dashboard to visualize and analyze customer orders across different locations. The report features dynamic filters for product categories and promotions, along with clear visual trends for monthly sales, profit, and cost of sales. Designed to support strategic decision-making for retail and e-commerce stakeholders.

0 Achievements

0 Projects

0 Cups of tea

More projects on Github

I love to solve business problems & uncover hidden data stories

GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Dhaka, Bangladesh

I'm Rohanur Rahman

Data Analyst | Solving Business Problems with Data

About

About Me

Education

Major: Bachelor of Computer Engineering

Higher Secondary Certificate

Projects

Projects

Case Study

SQL

PowerBI

Excel

Looker Studio

More projects on Github

I love to solve business problems & uncover hidden data stories

Contact

Contact Me

Address

Contact Number

Email Address

Resume

Have a Question? Click Here