OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on Analysis Services cubes and of the Excel Data Model (Power Pivot)
-
Updated
Sep 14, 2022 - Inno Setup
OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on Analysis Services cubes and of the Excel Data Model (Power Pivot)
Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.
Using Excel Power Query and PowerPivot, reorganise the data into a star schema and showcasing reports that can be created by data analysts using DAX formulae and PowerPivot
The folder of my work with Excel, VBA, and PowerBI for Data Analysis & Visualization.
Content: Import & Direct query, Data Modelling (Power Pivot), Star & Snowflake Schema, Normalisation & Cardinalities, Cross-filter direction and Sync Slicers
Data-driven project aiding University of Leicester students in finding affordable housing through Python scraping, Excel analysis, and PowerPoint visualisation. Insights on rental prices, property types, and optimal locations.
Movie Data Analysis using Advanced Excel
Developed an interactive dashboard for analyzing Netflix content, highlighting strong data analysis skills through insightful visualizations.
Engineered Excel reports for sales analysis and Profit & Loss evaluation by country, year, month, and product
Sales Data Analysis using Advanced Excel
Expense analysis in households with Microsoft excel using kaggle dataset.
Add a description, image, and links to the power-pivot topic page so that developers can more easily learn about it.
To associate your repository with the power-pivot topic, visit your repo's landing page and select "manage topics."