Abdullah Al Noman | Data and Business Intelligence Analyst

Abdullah Al Noman

Data and Business Intelligence Analyst

Based in Bangladesh

About

Dynamic BBA graduate with a specialization in Finance and a strong aptitude for data analytics. Currently, pursuing an MBA for enhanced strategic decision-making. Skilled in several data analytics tools, I bring a unique blend of business acumen and technical proficiency to help organizations analyze data from both a technical and business perspective.

Skills

Projects

Adventure Works - Data Analysis using Microsoft Power BI

Analyzed AW data with Power BI, transforming via Power Query, and using DAX for dynamic measures. Efficient modelling enabled seamless integration. Visualizations revealed insights on sales, products, and customers, showcasing expertise in data analysis and visualization for informed decisions.

Northwind Traders - Data Analysis using Microsoft Power BI

Used Power BI for the Northwind Traders data analysis and visualization. Transformed data using PowerQuery and used DAX for building dynamic columns and measures for the analysis. Tried to answer necessary questions the dataset arose. Used proper visualization for better understanding.

Student Engagement Analysis in Microsoft Excel

I used Excel to analyze the student engagement dataset and gained valuable insights on how much students are engaged in lessons, exams, and quizzes. In addition to that, most and least registered courses, top 10 countries by students, students registered by month, pattern in students' exam results.

Data Analysis using SQL

Created a random database using two data tables in MySQL. Implemented several SQL queries to find out specific answers to some questions like highest salary, second highest salary, distinct records, remove duplicates, count of duplicates and many more.

Universities of Bangladesh

I have analyzed and obtained results about the Universities of Bangladesh. The main queries were - the number of universities by - total, private and public criteria, Ph. D granting, divisions, specialization and the year of establishment.

Customer and Revenue Analysis in MySQL

Used MySQL and analyzed a dataset consists of four tables (customers, orders, products, and categories). I have included all the questions, I wanted to solve, with the queries

Bangladesh Food Security Analysis in Excel

Food 'Availability' and 'Quality and Safety' have improved significantly over the year. Since Food 'Quality and Safety' has improved than earlier, 'Affordability' has decreased from 60.4 to 52.1.

Superstore Data Analysis in Excel

I've performed a comprehensive analysis of the Superstore dataset in Excel, unearthing valuable insights for informed decision-making and operational optimization. This analysis unveils trends, cost-saving opportunities, and profit-focused strategies for sustainable growth.

Experience

25-7-2023

Data Analyst

It was a one-time project of a USA company. I had to clean, analyze and visualize the data using Excel. I had to analyze its cost-expense data. The dataset was very messy. That is why, I had to spend some time cleaning it. I used several data-cleaning techniques like Text-to-Column, Left, Right, Index-Match, Xlookup, Trim, Replace etc. I had to check the data types as well. For data visualization, I had to focus on the optimum charts and graphs for a better understanding of the result. I gave equal importance to the colour combination. My client was quite happy with the outcome. It was one time project but I have learnt a lot from this.

Education

2017-2021

Bachelor's in Finance at University of Chittagong

- Comprehensive understanding of Financial Principles, Investment Analysis, Risk Management, Financial Markets, and Corporate Finance. - Proficient in Statistics, using data analysis to drive financial decision-making and derive valuable insights. - Acquired expertise in Accounting Principles and Financial Reporting Standards for accurate financial analysis. - Honed analytical skills and mathematical proficiency, enabling precise financial analysis and forecasting. - Experienced in Project Management, successfully executing financial initiatives to achieve organizational goals.

2022 - Present

Master's in Finance at University of Chittagong

- Currently pursuing a Master's in Finance with a focus on advanced financial concepts, accounting, and data analysis. - Exploring financial data analytics, accounting principles, and financial reporting standards. - Acquiring skills to analyze business data precisely and make data-driven business decisions. - Combining accounting proficiency and data analysis skills to contribute to strategic financial planning and optimize investments for organizations.