Igli Ferati

Data Analyst

Purchasing Director with a passion for Data Analysis | Data Analyst | SQL, Tableau, R, Python | Visualization

About Me

Passionate Purchasing Manager with a proven track record of driving successful product strategies and delivering impactful solutions.

Experienced in leading cross-functional teams, conducting market research, and leveraging user insights to inform product development decisions. Currently expanding my skill set in Data Analysis to enhance my ability to extract actionable insights and drive data-informed decision-making.

Excited to combine my Purchasing Management expertise with Data Analytics skills to create innovative solutions and drive business growth. I have completed several online courses and projects on SQL, Python, Tableau, Excel, and R, and I am eager to apply my skills in real-world scenarios.

I have been working in data cleaning, manipulation, visualization, and analysis, and I can work with different types of data sources and formats. I am qualified in using SQL to query databases, Tableau to create interactive dashboards and reports, Excel to perform calculations and analysis, and Python to perform various data analysis tasks.

Looking forward for opportunities to join a data-driven organization where I can learn from experienced professionals and contribute to solving business problems with data.

Projects

Sales Data using RFM Analysis in SQL

The project aims to explore a sales dataset and generate various analytics and insights from customers' past purchase behavior. By analyzing sales revenue, customer segmentation using the RFM technique, and utilizing SQL and Tableau, the project delves into understanding and deriving valuable information from the dataset.

Show Project

Project Name: Movie Correlation Project

The project involves several steps, starting with the preparation of the data. The necessary libraries, including pandas, numpy, seaborn, and matplotlib, are imported. The dataset is then read from a CSV file into a pandas DataFrame. Initial data exploration is performed to check for missing values and data types.

Show Project

Helicopter Prison Break - Finding the Prison Escape Patterns

In this project, we analyse the dataset of helicopter escapes (1971 - 2020) obtained from Wikipedia to find the patterns of helicopter prison breaks. The result of our analysis is based on the dataset being analysed at that very moment; therefore, the conclusion can differ from the most updated data on the Wikipedia article.

Show Project

Analyzing the Global Impact of COVID-19: A Project on SQL and Tableau

In the midst of the unprecedented COVID-19 pandemic, data analysis has become crucial in understanding the magnitude of its impact worldwide. As a passionate data enthusiast, I embarked on a project that involved harnessing the power of SQL and Tableau to create insightful reports on COVID-19 data.

Show Project

Skills

Data Analytics

Microsoft Office

Tableau

BigQuery

Python

SQL

Education

Bachelor in Banking & Finance

European University of Tirana

2011-2014

Google Data Analytics Certificate

Coursera

2023

Experience

Purchasing Director

Bestseller Shpk

Jul. 2023 - Present

Purchasing Coordinator

Bestseller Shpk

Nov. 2020 - Jul 2023

Igli Ferati

Data Analyst

About Me

Projects

Skills

Education

Experience

Certifications