{"product_id":"data-visualization-with-excel-dashboards-and-reports-by-dick-kusleika-9781119698722","title":"Data Visualization with Excel Dashboards and Reports","description":"\u003cdiv class=\"book-description\"\u003e\n\u003cp\u003eLarge 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. \u003cem\u003eData Visualization with Excel Dashboards and Reports\u003c\/em\u003e bridges the gap between handling data and synthesising it into meaningful reports, guiding readers to think about their data beyond columns and rows.\u003c\/p\u003e\n\n\u003cp\u003eMost 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.\u003c\/p\u003e\n\n\u003cp\u003eWhat 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 \u003cem\u003eData Visualization with Excel Dashboards and Reports\u003c\/em\u003e, 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.\u003c\/p\u003e\n\n\u003cp\u003eAfter reading this book, the reader will be able to:\u003c\/p\u003e\n\n\u003cul\u003e\n  \u003cli\u003eAnalyse large amounts of data and report their data meaningfully\u003c\/li\u003e\n  \u003cli\u003eGain better visibility into data from various perspectives\u003c\/li\u003e\n  \u003cli\u003eQuickly slice data into different views instantly\u003c\/li\u003e\n  \u003cli\u003eAutomate redundant reporting and analyses\u003c\/li\u003e\n  \u003cli\u003eCreate impressive dashboards and What-If analyses\u003c\/li\u003e\n  \u003cli\u003eUnderstand the fundamentals of effective visualisation\u003c\/li\u003e\n  \u003cli\u003eVisualise performance comparisons\u003c\/li\u003e\n  \u003cli\u003eVisualise changes and trends over time\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Unknown","offers":[{"title":"Default Title","offer_id":46854438650092,"sku":"9781119698722","price":79.99,"currency_code":"NZD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0705\/7784\/8556\/files\/abcdf1c2321cc36a6468cd9458f1aa48.jpg?v=1759270160","url":"https:\/\/bookhero.live\/products\/data-visualization-with-excel-dashboards-and-reports-by-dick-kusleika-9781119698722","provider":"Book Hero","version":"1.0","type":"link"}