What You Will Build
The finished dashboard has three sheets side by side. Sheet one is a horizontal bar chart showing total Sales for each of the four regions: Central, East, South, and West. In Superstore the West region leads with roughly $725,000 in sales. Sheet two is a line chart of monthly Profit across Order Date. Sheet three is a filled map of the United States shaded by Sales per State. A single Region filter at the top drives all three, so selecting 'West' redraws every view. This is the kind of small, clean dashboard hiring managers expect from a junior analyst.
Launch Tableau Public and on the start page click 'Open' then 'Sample - Superstore'. The data source pane shows two tables: Orders and People. We only need Orders for this dashboard. The Orders table lists 9,994 rows, one per customer order.
In the data pane, confirm you have Order Date (a date), Ship Mode, Region, State, Category, Sub-Category, Sales (a green measure), Quantity, Discount, and Profit. These column names are what you will type inside any calculated field, so learn the exact spelling now.
Connect and Prepare the Data
Superstore is already clean, so you do not need heavy prep. Still, get in the habit of checking the data type of each field before you build, because a mis-typed date column is the number one reason a time chart comes out as a single bar.
In the data pane, the Order Date field should show a calendar icon. If it shows ABC, right-click it, choose 'Change Data Type', then 'Date'. This will break your line chart into one point if left as text.
Region should appear blue (discrete dimension) in the data pane. Drag it to Columns later to create one bar per region. If it is green, Tableau treats it as continuous and draws an axis instead of categories.
Right-click the data pane, choose 'Create Calculated Field', name it Profit Ratio, and type SUM([Profit])/SUM([Sales]). This gives the margin per view. Use it later as a color on the map to show which states are least profitable.
Build the Sales by Region Bar Chart
This is the simplest sheet and the one reviewers look at first. Drag Region to Columns and Sales to Rows. Tableau aggregates Sales with SUM automatically, so each bar is the total sales for that region. The full dataset totals about $2,297,201 in Sales.
Drag Region to the Columns shelf and Sales to the Rows shelf. You get four bars. Click the 'Sort descending' icon so West sits at the top, since it holds the highest regional sales in Superstore.
Drag Profit to the Label mark. Each bar now shows both Sales and Profit. In West, Sales are high but Discount cuts into Profit, a detail interviewers like to hear you notice.
Double-click the sheet tab and name it 'Sales by Region'. I recommend plain, descriptive names so the dashboard view stays readable. Avoid cute names a recruiter will not understand.
Build the Profit Trend Line
The second sheet shows whether profit is growing over time. Because Order Date is a date, Tableau builds a natural time hierarchy of Year, Quarter, and Month. You will plot the monthly profit line and add a trend line to read direction at a glance.
Drag Order Date to Columns. Tableau expands it to YEAR(Order Date). Click the plus sign on the field to drill into QUARTER then MONTH. You now have a time axis across the bottom.
Drag Profit to Rows. Tableau draws a line of monthly profit. Notice the December spikes each year, a real seasonality pattern in Superstore that makes a good talking point in a portfolio.
Right-click the chart, choose 'Trend Lines', then 'Show Trend Lines'. The straight line tells you the slope direction. A common mistake is reading a single December spike as the trend instead of the full slope.
Build the Sales by State Map
Maps are the fastest way to make a dashboard look professional. Tableau recognizes State as a geographic field automatically, so you rarely need to configure anything. Shade each state by Sales and add Profit Ratio as color to surface weak margins.
Double-click State in the data pane. Tableau draws a US map with one mark per state. If the map is blank, the field is not typed as a geographic role, fix it by right-clicking State and choosing 'Geographic Role' then 'State'.
Drag Sales to Size and Profit Ratio to Color. Bigger, greener states sell more at healthy margins. California and New York show high Sales but watch their Discount, some Sub-Categories drop below zero profit.
Add a Region Filter That Drives Everything
On the Sales by Region sheet, drag Region to the Filters shelf and select all four regions. Right-click the filter and choose 'Apply to Worksheets', then 'All using this data source'. Now the filter appears on every sheet.
On the dashboard, right-click the Region filter and tick 'Show Filter'. Set it to a single-select dropdown or a set of buttons. Clicking 'West' now redraws the bar, the line, and the map together, that is the interactivity reviewers want.
I recommend you filter on the data source, not per sheet, when every view shares the same table. In my experience a per-sheet filter that one view forgot to inherit is the most common reason a dashboard shows mismatched numbers.
Arrange the Dashboard Canvas
Switch to a new Dashboard tab. Tableau snaps sheets into a tiled or floating layout. Start tiled, it keeps everything aligned on different screen sizes and avoids the overlap mess floating objects create.
Before you publish, add a dashboard title that states the headline number, for example 'Superstore: $2,297,201 in total Sales, with the West region leading at about $725,000'. Tableau can pull these figures live from your sheets, so the title updates when the Region filter changes. A titled dashboard reads as finished and stops the viewer hunting for the takeaway. I also recommend hiding the toolbar for a cleaner share link, then exporting a PNG as a portfolio snapshot.
Drag 'Sales by Region', the Profit trend, and the State map onto the dashboard. Tableau places them top to bottom. Use the layout panel on the left to reposition into a clean grid.
In the dashboard pane, set 'Size' to a fixed width like 1000 x 800. This will break your layout on a phone if left 'Automatic', because sheets reflow and the map drops below the fold.
Make It Interactive With Actions
From the top menu choose Dashboard, then 'Actions', then 'Add Highlight'. Set it to highlight on hover. Now mousing over a region bar highlights the same region on the map, a small touch that reads as polished.
Under Actions, add a Filter action triggered by the Sales by Region sheet. Selecting a bar filters the trend and map to that region, giving viewers click-driven control beyond the dropdown.
Avoid piling on five actions at once. A common mistake is layering hover highlight and click filter that fight each other, which this will break the user's mental model and confuse the person reviewing your work.
Common Mistakes on a First Dashboard
If Order Date stays text, your trend line collapses to a single mark. Always confirm the calendar icon before building any time chart, this is the error I see most in student portfolios.
Dragging Sales (default SUM) next to a field you averaged creates a misleading axis. Keep one aggregation per measure unless you deliberately relabel it. Reviewers notice mixed aggregations immediately.
A dashboard on Superstore is fine for learning, but avoid submitting it as 'real world' work. Pair it with one dashboard from your own or open data so the portfolio shows range, not just the textbook set.
Next Steps After Your First Dashboard
Publish the workbook to Tableau Public and copy the link into your portfolio and LinkedIn. Then build a second dashboard from a different dataset, for example a SQL-exported business report, to practice the full connect-to-clean-to-share loop. From here, the Tableau Desktop Specialist cert is a natural next milestone, and the Excel dashboard route teaches the same logic with pivot tables if you prefer spreadsheets.
