Discover why Power Query is the smarter alternative to Excel formulas for cleaning, transforming, and analyzing data ...
This project is an analysis of a sales dataset using Power Query and Power Pivot in Excel. The dataset includes a sales sheet with 6299 data and a dimension sheet. The sales sheet includes variables ...
Order Analysis by Day Type: A table differentiating between orders made on workdays vs. weekends. Dashboard.png: A screenshot of the Power BI dashboard. Data Files: Raw data files used for analysis.