Group your data visually.
-
Updated
Feb 10, 2023 - VBA
#
pivottables
Here are 15 public repositories matching this topic...
A dashboard that provides a dynamic slice-and-dice overview of an organization's workforce, including departments, absences, and educational credentials.
-
Updated
Oct 11, 2022
Excel assignment covering conditional formatting, formulas, PivotTables, and PivotCharts (Due: 03-06-2021)
excel pivot-tables pivot-chart excel-formulas pivotcharts excel-conditional-formatting excel-formula pivot-charts pivottables
-
Updated
Mar 24, 2021
Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.
visualisation data-visualization data-analysis msexcel datacleaning powerquerym pivottables vlookups
-
Updated
Dec 28, 2024
This project focuses on analyzing account sales performance over a five-year period to uncover trends, identify growth opportunities, and optimize sales strategies. The study examines sales data by account type, key account performance, and marketing campaign effectiveness.
-
Updated
Jul 9, 2025
Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.
-
Updated
Jul 9, 2024
Developed an interactive Excel dashboard to analyze global coffee shop sales across multiple regions. Leveraged Power Query for data transformation and Power Pivot for calculating key KPIs including sales, profit, and margin metrics. Designed a visually compelling dashboard with slicers, gradient formatting, and dynamic pivot charts.
dashboard-templates powerpivot powerquery pivotcharts slicers excelformulas pivottables excel-dashboard advancedexcel
-
Updated
Jun 14, 2025
HR Dashboard using Excel with power-query and powerpivot
-
Updated
May 25, 2023
This project is guided by Alex the Analyst
-
Updated
Jul 5, 2023
-
Updated
Feb 6, 2024
Shopper Spectrum: Streamlit app for customer segmentation (RFM + KMeans) and product recommendations (collaborative filtering) using e-commerce data.
numpy eda pandas machinelearning datavisualization datacleaning collaborativefiltering cosinesimilarity standardscaler featureengineering scikitlearn datatransformation kmeansclustering pivottables streamlitapp customersegmentation rfmanalysis realtimeprediction productrecommendation
-
Updated
Jul 27, 2025 - HTML
This project utilizes Excel tool like Pivot Tables to analyze sales data and generate insights. It provides actionable recommendations for optimizing sales, customer discounts, and market expansion, helping drive informed business decisions.
-
Updated
Sep 5, 2024
📦 Sales & Logistics Optimization: Analyzed sales, returns, and shipping costs to enhance profitability and operational efficiency. Identified trends, minimized losses, and optimized pricing strategies using Excel (Pivot Tables, Dashboards)
excel dashboards logistics returns sales-analysis dataanalysis pivottables customersegmentationanalysis supplychainanalysis
-
Updated
Feb 25, 2025
Improve this page
Add a description, image, and links to the pivottables topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the pivottables topic, visit your repo's landing page and select "manage topics."