Business Data Analyst:Excel/VBA/Macros/PowerQuery/PowerPivot

Editorial course preview

What the public course preview actually shows

These 4 complementary views highlight concrete, legible examples from the course presentation.

An Excel spreadsheet displaying a PivotTable with vehicle sales counts by year and location type (City vs Town), alongside a stacked area chart visualizing the same data trends. — Preview 1 of 4
This Excel dashboard demonstrates how to visualize business data using a PivotTable and a stacked area chart to compare vehicle sales trends between city and town locations.

Power Pivot Diagram View in Excel showing a one-to-many relationship line connecting the EV sales table to the Location Type table. — Preview 2 of 4
The Power Pivot Diagram View interface displays a data model with a relationship established between the EV sales and Location Type tables.

Excel interface showing a Value Field Settings dialog box with Count selected for summarizing vehicle data in a pivot table. — Preview 3 of 4
The Excel Value Field Settings dialog is open with the Count calculation highlighted to summarize vehicle primary use data within a PivotTable.

A screenshot of an Excel spreadsheet displaying a dataset with columns for Clean Alternative Fuel Vehicle Type, Model Year, Make, Model, Transaction Date, and Electric Vehicle Fee, — Preview 4 of 4
This view shows the raw data table in Excel containing vehicle transaction records, including make, model year, and dates, ready for analysis.