About

About Me

I'm an entry-level Data Analyst with hands-on experience in solving real-world problems through data. I specialize in Excel, SQL, Python, and Power BI for ETL, data wrangling, visualization, and statistical analysis. My academic background in Information and Communication Engineering from BUP has given me a strong foundation in analytics, machine learning, and database systems.
I’ve worked on various portfolio projects, including fraud detection logic, customer segmentation, cohort analysis, RFM Segmentation and dashboard design — all focused on driving actionable insights. I'm also experienced in mentoring others as a Power BI Instructor, which helped me build strong communication and analytical thinking skills.
I'm eager to join a data-driven team where I can contribute, grow, and turn complex data into impactful business decisions.

  • Profile: Entry-Level Data Analyst
  • Domain: E-commerce, Banking, Hotel and Tourism Management, Public Health, Education
  • Education: BSc. in Information and Communication Engineering, BUP
  • Language: English, Bengali
  • BI Tools: Microsoft Power BI, Excel, Google Sheets
  • Cloud Platforms: Supabase, Google Big Query
  • Other Skills: SQL, Python (Pandas, Numpy, Matplotlib, Seaborn, SQL Alchemy, DLT), Git, ETL Pipeline, A/B Testing, Hypothesis Testing, Machine Learning
  • Interest: Data Storytelling, Mentorship, Learning New Tech, Reading Books, Watching Anime

0 +   Projects completed

LinkedIn

Resume

Resume

Aspiring Data Analyst with hands-on experience in real-world data projects, including business dashboards, customer segmentation, and fraud detection logic. Skilled in SQL, Python, Power BI, and ETL, statistical analysis. Strong foundation in machine learning concepts, with a passion for transforming data into actionable insights.

Experience


March 2025 – Present

Interactive Cares Logo Power BI Support Instructor

Interactive Cares

  • Provided one-on-one guidance to learners in Power BI for Business Intelligence.
  • Helped simplify complex workflows and troubleshoot data issues in Power BI and Excel.
  • Mentored students and professionals to confidently apply data analytics in real-world scenarios.

Nov 2023 – Dec 2023

Selise Logo Intern Software Engineer

Selise Digital Platforms, Dhaka

  • Developed an e-commerce platform using the MEAN stack (MongoDB, Express, Angular, Node.js).
  • Handled backend database operations and built scalable logic for product and customer data.
  • Gained hands-on experience in system design, debugging, and data-driven app development.

Jan 2023 – Mar 2024

BUP Logo President

BUP InfoTech Club

  • Led the university’s tech club and mentored members in data analysis, Python, and SQL.
  • Hosted data challenges and collaborated with companies like Daraz, Grameenphone, and Creative IT.
  • Strengthened leadership, planning, and technical mentoring experience through strategic events.



Education


2020 – 2024

BUP Logo BSc. in Information and Communication Engineering

Bangladesh University of Professionals (BUP)

CGPA: 3.26 / 4.00

2017 – 2019

Dhaka College Logo Higher Secondary Certificate (Science)

Dhaka College

GPA: 5.00 / 5.00

2007 – 2017

Govt Lab Logo Secondary School Certificate (Science)

Government Laboratory High School, Dhaka

GPA: 5.00 / 5.00

Projects

Projects

Below are the sample Data Analytics projects on Excel, Power BI, SQL, Python, ML.

HSBC Bank PoC Group Analysis Project in Power BI

Built an end-to-end interactive banking dashboard as group project using synthetic data to simulate real operations. Applied fraud detection, customer segmentation, and KPI analysis to support digital transformation at HSBC Bank Bangladesh.

Adventure Works Bike Shop Analysis with RFM Segmentation and Cohort Analysis

Created an interactive Power BI dashboard featuring cohort analysis and RFM segmentation to explore sales performance and customer retention trends. Integrated advanced DAX, custom visuals, and dynamic filtering for deep business insights.

Hotel Chain Management Dashboard in Power BI

Designed an interactive dashboard to analyze hotel revenue, booking trends, and customer ratings. Leveraged advanced DAX, RevPAR/ADR metrics, and drillthrough features to deliver actionable business insights.


Customer Cohort Analysis Dashboard in Power BI

Built a Power BI dashboard to analyze customer retention, churn, and revenue trends using cohort modeling. Applied advanced DAX, KPIs, and conditional formatting to uncover actionable insights for customer segmentation and growth.

Dhaka Dengue Outbreak Analysis (Excel-Based)

Conducted a comprehensive analysis of seasonal dengue outbreaks in Dhaka using Excel to identify infection patterns, demographic risk factors, and high-risk age groups. Visualized key trends to support targeted public health interventions.

TechnoHub Electronics Retail SQL Case Study

Executed a detailed SQL-based analysis for TechnoHub, exploring customer spending behavior, sales trends, and inventory control. Applied advanced MySQL techniques like CTEs, joins, subqueries, and window functions. Insights supported revenue growth strategies, stock optimization, and customer retention planning.


SK Mart MySQL Case Study Analysis

Conducted end-to-end SQL analysis on a retail dataset, including data modeling (ERD), sales trend analysis, customer behavior tracking, and campaign effectiveness using window functions, CTEs, and scheduled triggers. Generated business insights on daily revenue, product performance, and buyer patterns, with classification logic (NTILE, CASE) to identify high-value orders and marketing impact.

Spotify Streaming Behavior Dashboard (Excel)

Analyzed over 300,000 Spotify streaming records to uncover user listening patterns, platform preferences, and artist rankings. Utilized Excel's Power Query, PowerPivot, and Pivot Tables to transform raw data into an interactive dashboard. Key insights include peak streaming times and shuffle play behaviors.

0 Achievements
0 Projects
0 Mentored Students
0 Cups of coffee

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

Contact Number

+88 01980414186

Email Address

tanvirpial9961@gmail.com

Download Resume

Resume Link



Have a Question? Click Here