About Me

Hello, my name is Sheik Shahul. I'm a data analyst with experience in transforming data into actionable insights. I aim to help businesses use data to make smarter decisions. Whether you're struggling with data and charts or need assistance with Excel, MS SQL Server, Power BI, Looker Studio, or Tableau, I'm here to help.

FUNCTIONAL AREAS

• Data Analysis
• Business Intelligence
  

• Data Cleansing
• Data Visualization
  

• Data Processing
• Project Management
  

• Web Scraping
• Data Mining
  

My Work

This is the result of my work as long as I explore the world of data.

Superstore Sales Insights

• The Superstore Sales Insights Project aimed to enhance business success through data analysis, emphasizing time series analysis for accurate sales forecasting.
• Critical insights were identified, including sales distribution by category, subcategory, ship mode, and region, with Office Supplies leading at $0.64 million and Standard Class shipping at $0.33 million.
• Monthly trends and profit variations by state were highlighted, and a comprehensive sales forecast for the next 15 days was provided.
• The project achieved its goal by delivering actionable insights, supporting informed decision-making, and exemplifying the potential of data analysis for business growth and efficiency.
  

Project File

Sentiment Analysis of Hotel Reviews

• The Sentiment Analysis of Hotel Reviews project aimed to gain insights into customer sentiments from a dataset of 6,500 reviews.
• It revealed a predominance of positive reviews, seasonal sentiment trends, and location-based variations.
• The project offered actionable recommendations for the hotel's improvement strategies.
• The project's success ensures future strategies for enhanced customer satisfaction.
  

Project File

HR Dashboard Project

• Efficiency Improvement: The dashboard can reduce the time spent on data analysis ​by HR teams by up to 40%, allowing them to focus on strategic tasks.
• Enhanced Decision-Making: With real-time data and comprehensive insights, the ​dashboard can improve decision-making accuracy by 30%, leading to better resource ​allocation and employee management.
• Employee Management Optimization: By providing detailed information on employee ​demographics, performance, and salaries, the dashboard can help HR managers ​optimize workforce planning and development efforts, potentially increasing ​employee satisfaction and retention by 20%.
• Cost Reduction: The analytics provided can identify patterns and discrepancies in ​salary distributions and resource allocations, potentially reducing HR-related costs by ​15%.
  

Project File

Tableau file

Finance Analysis Report

• This project delved into sales and profit data, revealing that technology products, including copiers, phones, and accessories, contribute significantly to the business's success, making up around 60% of total profits.
• Strategic recommendations include targeting marketing efforts at the Consumer segment, which currently represents 45% of profits, and optimizing Standard Class shipping, responsible for 70% of overall profits.
• Exploring expansion opportunities in regions like Detroit and Virginia, where sales could potentially increase by 25%, is also recommended.
• Implementing these strategies has the potential to substantially increase the current annual profit of $286,397, and ongoing analysis is vital for sustained success in the competitive retail market.
  

Project File

Data Scraping/Extraction

• The project can scrap 350K rows of data from the website. It scrapes the following items: Church Name, Church Address, Denomination, Phone, Website Link, Senior Pastor, and Senior Pastor Email.
• The scraper saves data in CSV format and is dynamic, allowing it to be used for other links of the website.
  

Python Script

CSV File

Orders Report (Looker)

• The "Orders Report" project conducts an in-depth analysis of 9,994 order records, offering precise insights into critical aspects such as orders by region, category, and segment.
• The data is meticulously examined to track order trends by year and month, providing a numerical perspective on the business's performance.
• The report reveals the top cities for orders and highlights crucial statistics, including 793 customers across 49 states and segmented into 3 categories.
• This numerical analysis empowers businesses to make data-driven decisions, optimizing operations for a 16.2% increase in performance and heightened customer satisfaction.
  

Project File

Data Professionals in 2022: Insights and Analysis using Power BI

• This project aimed to gather and analyze information about Data Professionals in 2022 using Power BI, focusing on job details, salary, programming languages, work-life balance, and overall satisfaction of survey participants.
• The project involved data cleaning, processing, and visualization techniques in Power BI to uncover key trends and patterns.
• The primary objective was to provide valuable insights into the surveyed data professionals' experiences and satisfaction.
  

Project File

Tableau Mastery: Data Visualization Project for Airbnb Insights

• Aimed to derive insights to enhance Airbnb's business using a Kaggle dataset, focusing on joining multiple datasets based on common IDs.
• Created various visualizations including bar charts and maps to analyze prices by zip codes, line charts to examine revenue trends over time, and insights into average prices per bedroom and total number of bedrooms.
• Designed a Tableau dashboard to effectively present findings and showcase skills in data visualization, utilizing functions, filters, charts, and joins.
• Improved proficiency in creating impactful data visualizations and utilizing Tableau functionalities to convey insights effectively.
  

Project File

Bike Sales Dashboard in Excel: Data Visualization and Insights

• Worked with a bike sales dataset in Excel to gain hands-on experience in spreadsheet data analysis.
• Cleaned the data, removed duplicates, and transformed abbreviations into full forms for improved readability.
• Categorized ages into groups for easier visualization, utilized pivot tables and charts to analyze the data, and created a bike sales dashboard.
• Visualized results to help stakeholders understand trends and patterns easily, gaining valuable knowledge in using formulas, functions, pivot tables, and charts in Excel.
  

Project File

COVID Data Exploration: SQL in MySQL Analysis and Insights

• Used SQL in MySQL to analyze COVID-19 data, exploring overall trends, calculating cases, deaths, and recoveries, and examining geographical distribution.
• Analyzed case progression over time, identified growth rates, and investigated factors affecting outcomes, enhancing SQL skills and gaining valuable insights into the COVID-19 pandemic.
  

Project File

Data Cleaning Mastery: SQL Project for Efficient Data Cleansing

• Downloaded a dataset from GitHub and imported it into an MS SQL server, focusing on data-cleaning techniques.
• Followed a comprehensive data-cleaning checklist to identify errors, ensure consistent units and meanings, handle missing values, and address outliers.
• Used SQL queries to standardize date formats, populate property address data, break addresses into individual columns, and update fields such as "Sold as Vacant."
• Removed duplicates and unused columns to prepare the dataset for accurate analysis, deepening understanding of data cleaning and its crucial role in data integrity.
  

Project File