Description
The dashboard is the part of the job everyone sees, and it is the part nobody taught you. You can write the query. You can get the rows. Then you drag a field onto a shelf, pick a chart because it looked right in the gallery, and ship a dashboard that is slow, that filters wrong, and that shows a total nobody can reconcile with the number in the finance deck. So it gets opened once and never again, and quietly you become the person who makes charts instead of the person leadership acts on. The gap is not SQL and it is not clicking. It is knowing whether to extract or query live, how to build a data model so the joins do not silently double your revenue, which mark answers the question actually being asked, how to make a dashboard that a director can interrogate without you in the room, and how to write a calculation so its number matches the source of truth to the cent. Nobody warned you that the hard part of a dashboard is trust, and that a beautiful dashboard nobody believes is worth nothing.
This book takes you from someone who can make a chart in Tableau to the analyst whose dashboards leadership opens every morning and acts on. It starts where the fear starts, with the dashboard that was wrong in the room, and builds the thing that stops it from happening again: numbers you can trace, a model that does not lie, and a view a director can use without you standing behind them. You will build one set of dashboards across the whole book, a real one for a SaaS company called Lumen, and take it from a pile of exported tables to the source of truth the leadership team plans against. You will connect to the data and decide, with reasons, when to extract and when to query it live, and build the data model so orders never fan out and inflate the totals. You will learn to pick the mark that answers the question instead of spinning the chart-picker roulette, and to build a dashboard that answers back, with filters, actions, and drill-down, so the director finds their own answer instead of messaging you. You will write calculations and level-of-detail expressions whose numbers reconcile with the source of truth to the cent, so the meeting where two dashboards disagree stops happening. And you will publish it to Server or Cloud, make it fast enough that nobody abandons it, and get it in front of the people who decide, with subscriptions that land the number in their inbox before they ask. By the end the dashboard is trusted, the numbers reconcile, it loads before anyone gives up on it, and when a decision is on the line the room turns to your view. For the analyst who has to build the dashboards the company runs on, and wants to be the reason it can run on them.
Who this book is for
This book is for: the analyst who can already pull the data and has just been told to build the dashboards the company runs on, who has clicked around Tableau enough to make a chart but never enough to trust one in front of a VP, and who is quietly afraid of the meeting where someone asks why the dashboard says one thing and the finance report says another.
What makes this one different
The 5 Steps to Becoming the Analyst Leadership Turns To When a Decision Is on the Line. The method that turns someone who can make a chart into the analyst whose dashboards leadership opens every morning and acts on. A dashboard the company runs on is a trust problem, not a click problem: the numbers have to match the source of truth, the model has to not lie, the view has to answer questions without you in the room, and it has to load before anyone gives up on it. You build one real set of dashboards from a pile of exported tables to the view the leadership team plans against, and learn when to extract or query live, which mark answers the question, how to make a calculation reconcile to the cent, and how to get it in front of the people who decide.
- Connect and shape the data so the totals never lie
- Pick the mark that answers the actual question
- Build a dashboard a director can interrogate alone
- Write calculations whose numbers match the source of truth
- Publish it fast and land it in the decider’s inbox
What you’ll walk away with
- Chapter 1: The dashboard that was wrong in the room
- Chapter 2: I exported the tables. Why does my revenue come out double?
- Chapter 3: I have the data. Which chart actually makes them see it?
- Chapter 4: How do I build a dashboard a director can use without me in the room?
- Chapter 5: My total says one thing, finance says another. Who is right?
- Chapter 6: It is built and nobody opens it. How do I get it in front of the people who decide?
- Chapter 7: The morning leadership stopped asking me and just acted
