Nitin Shukla
Advanced Excel & AI Automation Expert | Saving 10+ Hours/Wee
New to Contra
Nitin is building their profile!
"This project showcases my ability to architect clean, scalable, and high-performance relational databases directly inside Excel's Power Pivot engine. I structured an enterprise-grade retail dataset into an optimized Star Schema to enable seamless business intelligence reporting.
0
6
"This project demonstrates my proficiency in transforming raw business data into actionable visual insights using Microsoft Excel. I designed a fully dynamic, user-friendly Executive Sales Dashboard utilizing interconnected Pivot Tables and visual charts.
0
11
"This project highlights my skills in data modeling and business intelligence using the Excel Power Pivot engine (https://support.microsoft.com/en-us/excel/get-started-with-power-pivot-in-microsoft-excel). Working with a large-scale e-commerce/retail dataset ('Superstore' and 'Calendar' tables), I established relationships between tables and built custom business metrics using DAX formulas.
0
10
"This project demonstrates my expertise in data preprocessing, cleaning, and transformation using Power Query Editor (https://www.sporthorizon.co.uk/blog/power-query-editor-a-game-changer-for-non-coders). I handled a raw sales dataset that contained inconsistencies, missing values, and formatting errors.
0
14