Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.
End-to-end bike-share data analysis project using Excel / Power Query, SQL, Python, and RStudio to compare usage behavior between casual riders and annual members, then generate data-driven marketing ...
PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change ...
Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday ...
Activity_01/ — Contains the Excel workbook containing the original dataset and 5 functional Pivot Tables addressing key HR and operational metrics. Activity_02/ — Contains the SQL script file (.sql) ...