Data Visualization with Excel Dashboards and Reports
Read More
Found a better price? Request a price match
Data Visualization with Excel Dashboards and Reports
Book Hero Magic created this recommendation. While it's new and still learning, it may not be perfect - your feedback is welcome! IS THIS YOUR NEXT READ?
Latest News
New Releases to add to your TBR (11th August)
There's a new release for everyone this week - here's your TBR roundup! Lizzy shares...
Book Briefing - 11th August
New Zealand books are recognized internationally, AI continues to cause drama, exciting new books are...
Exciting New Tonies - Minecraft / Chronicles of Narnia
New Tonies up for pre-order including Minecraft, Chronicles of Narnia, Tom Fletcher & Enid Blyton.
Remembering Sir Sam Neill
I was so saddened when I heard of the passing of Sam Neill. I've enjoyed...
Book Briefing - 5th August
Welcome to this week's Book Briefing where we round up the news for the week!
See moreLarge corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are turning to these tools to cut costs for budgetary reasons. An effective analyst not only needs the technical skills to use Excel productively but must also be able to synthesise data into a story and present that story in the most impactful way. Microsoft acknowledges this with Excel, focusing significantly on business intelligence and visualisation. Data Visualization with Excel Dashboards and Reports bridges the gap between handling data and synthesising it into meaningful reports, guiding readers to think about their data beyond columns and rows.
Most Excel books adequately discuss the individual functions and tools that can be used to create an "Excel Report." Titles on Excel charts, Excel pivot tables, and books focused on "Tips and Tricks" are useful; however, they often miss the mark for most data analysts. The primary reason these titles fall short is their focus on the mechanical aspects of building charts, creating pivot tables, or other functionalities, without offering an overarching view of presenting and reporting data effectively.
What are the most meaningful ways to show trending? How do you show relationships in data? When is showing variances more valuable than showing actual data values? How do you deal with outliers? How do you bucket data most meaningfully? How do you present vast amounts of data without overwhelming your audience? In Data Visualization with Excel Dashboards and Reports, readers will find answers to all these questions. Part technical manual, part analytical guidebook, this title will help Excel users evolve from reporting data with simple tables of dull numbers to creating impactful reports and dashboards that visually and substantively impress management. The book offers a comprehensive review of an array of technical and analytical concepts essential for creating meaningful reports and dashboards.
After reading this book, the reader will be able to:
- Analyse large amounts of data and report their data meaningfully
- Gain better visibility into data from various perspectives
- Quickly slice data into different views instantly
- Automate redundant reporting and analyses
- Create impressive dashboards and What-If analyses
- Understand the fundamentals of effective visualisation
- Visualise performance comparisons
- Visualise changes and trends over time
Book Details
INFORMATION
ISBN: 9781119698722
Publisher: John Wiley & Sons Inc
Format: Paperback / softback
Date Published: 01 April 2021
Country: United States
Imprint: John Wiley & Sons Inc
Audience: Professional and scholarly
DIMENSIONS
Spine width: 23.0mm
Width: 185.0mm
Height: 229.0mm
Weight: 590g
Pages: 352
About the Author
DICK KUSLEIKA is a 12-year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel Blog.
Also by Dick Kusleika
View allMore from Science & Nature
View allWhy buy from us?
Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!
Service & Delivery
Our warehouse in Auckland holds over 100,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.
Auckland Bookstore
We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.
Our Gifting Service
Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.
