Data Story: Uncovering Discrepancies in Global Sales Performance in Tableau 🌍
As a data analyst, my goal is to reveal the why behind the numbers.
I did the dashboard with Tableau and Wireframing in PowerPoint.
This dashboard tackles a critical business question: Are we
2
22
maximizing profit or volume?
🫴🏾By placing Sales figures and Quantity figures side-by-side, we can quickly spot strategic opportunities:
🫴🏾Which countries have high dollar sales but lower quantity (high-margin success)?
🫴🏾Which countries move high quantity but generate lower sales
14
📐 Stop Joining. Start Relating. The Power of Data Modeling in Tableau.
For years, connecting tables in Tableau meant wrestling with traditional SQL JOINs. That’s changed, thanks to Tableau’s modern data modeling.
The image attached shows how easy it is to set up a true Star
5
11
or have you fully switched to Relationships/Noodles for your data prep? Share your modeling tips below! 👇
#Tableau #DataModeling #DataAnalytics #StarSchema #BusinessIntelligence #FactAndDimension
4
Less need for complex Level of Detail (LOD) calculations to fix join errors.
The result? We spend less time modeling and debugging data duplication issues, and more time focusing on generating insights—the real job of a data analyst!
Are you still using old-school joins,
4
customer_dim or time_dim) don't duplicate records when relating to the fact_table.
🫴🏾Clean Analysis: You can easily drag fields from any table without worrying about which joins to use. Tableau figures out the correct relationship on the fly, leading to more accurate analysis and
6
the "noodles" in the model) keep tables separate internally. They only JOIN when fields are needed in a viz, and they intelligently handle measure aggregation.
🫴🏾Referential Integrity: It respects the cardinalities (one-to-many, many-to-one), ensuring your Dimension tables (like
7
Schema (Fact and Dimension Tables) right in the data pane.
Why this is a Game-Changer for Analysts:
🫴🏾Flexibility (No More Join Agony): Traditional INNER or LEFT JOINs pre-aggregate the data, potentially causing data duplication and invalid measures. 🫴🏾🫴🏾Tableau’s Relationships
8
What’s your favorite Tableau trick to instantly add context to a visualization? Let me know below! 👇
#DataAnalysis #Tableau #DataVisualization #BusinessIntelligence #Analytics #DataStorytelling
4
show a mini bar chart of that region's historical performance.
The result? Instead of interrupting their analysis to look up context, your user gets the full picture instantly. This moves the conversation from “What does this number mean?” to “What action should we take?”
4
the tooltip editor to create visual hierarchy. Key metrics should jump out immediately.
Embed a Viz-in-Tooltip (Optional, but Powerful): For a really advanced touch, you can insert an entire secondary worksheet into the tooltip. For example, hovering over a region on a map could
5
Contextual Statement: Use the logic of your viz to build a sentence, like: "For this product, 433,827 Units were Sold, and it generated $68,650,971 in Operating Profit, making it a top performer this quarter."
Use Markdown & Formatting: Use bolding, color, and line breaks within
6
Stop Showing Raw Numbers, Start Calculating Metrics: Don't just show "Units Sold." Instead, use calculated fields in the tooltip to show:
Unit Price: (Total Sales / Units Sold)
Operating Profit: (Operating Profit of Current Product / Total Operating Profit of All Products)
8
immediate context is right at the point of interaction.
I recently used a line chart to display sales trends by product, and instead of a simple number, I customized the tooltip to deliver a full "Product Health Report" on hover.
🔍 How to Transform Your Tooltip into a Narrative
9
Emphasizing Technical Skill and Creativite.
Recently, i was going through YouTube and i fell on Freedom Oboh 's video on a complete Excel project involving data modelling, dax. So i decided to do something new.
2
12
insights. This isn't just a spreadsheet; it's proof of concept.
Skills Used: Advanced Excel Formulas, Data Visualization, Data Modeling, Dashboard Design.
#Excel #DashboardDesign #DataAnalytics #BusinessIntelligence #LookWhatICanDo Microsoft Excel Training #Microsoft Excel
4







