AmirAli5 / Data-Analytics-in-Excel
This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:
☆17Updated 2 years ago
Alternatives and similar repositories for Data-Analytics-in-Excel:
Users that are interested in Data-Analytics-in-Excel are comparing it to the libraries listed below
- Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine f…☆14Updated 2 years ago
- Zomato Data Exploration and Analysis with SQL (SQL SERVER)☆22Updated 8 months ago
- iNeuron BusinessIntelligence Internship: End to End Project on Budget Sales Analysis☆17Updated 2 years ago
- Unlock actionable insights and boost customer retention with this Power BI project. Analyze and visualize risk factors to proactively pre…☆50Updated last year
- In this personal Superstore Sales SQL Data Analysis project, an exploratory data analysis was performed on the Superstore Sales Data avai…☆30Updated 2 years ago
- In this repo, I upload all-time series forecasting projects☆14Updated 3 years ago
- Sales insights project using Powerbi and SQL☆29Updated 2 years ago
- This repository contains a Power BI solution for AtliQ hardware, enabling comprehensive analysis of sales trends, informed decision-makin…☆15Updated last year
- ☆26Updated last year
- ☆16Updated 4 years ago
- A collection of data analysis and visualization projects designed to uncover insights from diverse datasets. These projects include analy…☆102Updated last year
- In this project, a RFM model is implemented to relate to customers in each segment. Assessed the Data Quality, performed EDA using Pytho…☆67Updated 3 years ago
- In this project I am Cleaning, Analysing and creating Visualizations to make data easily accessible of ease use.☆50Updated last year
- This is a project that utilizes Microsoft PowerBI to analyze personal financial data and visualize expenses through an interactive dashbo…☆36Updated 3 years ago
- Data Analysis Projects☆122Updated 5 years ago
- Portfolio including my data science projects for academic, self-learning, and hobby.☆42Updated 4 years ago
- Repository for files related to YouTube series on creating a Data Analyst Portoflio from scratch with SQL & Power BI.☆102Updated 2 years ago
- ☆59Updated last year
- Customers segmentation using clustering models to give products and services recommendations☆14Updated last year
- This documentation is like a quick snapshot of my project in the data field, showing off my skills and know-how in this area.☆48Updated last year
- Analyze Zomato restaurant data all the world and find the insights by using Python libaries and also visualize the dataset by using Power…☆18Updated last year
- Worked on various OTT Dataset. Used the Query Editor for data cleaning and preprocessing. Displayed the visuals using a variety of plots,…☆38Updated last year
- Data Analyst Path Guided Projects from DataQuest☆13Updated 7 years ago
- ☆46Updated 11 months ago
- collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence☆114Updated 8 months ago
- Sales forecasting using multiple models - Seasonal Naïve, Holt-Winters, ARIMA, SARIMA and Linear Regression Model☆11Updated last year
- As a part of my internship with iNeuron.ai, I worked independently on an end-to-end project "Heart Disease Diagnostic Analysis".☆45Updated 3 years ago
- Using a combination of Excel, SQL, and Tableau, I delved into the extensive datasets comprising over 82k rows of data from Netflix's show…☆51Updated last year
- ☆17Updated 2 years ago
- Sharing the solved Exercises & Project of Statistics for Data Science using Python course on Coursera by Ankit Gupta☆38Updated 2 years ago