Excel BI and Dashboards in 7 Days: Build interactive dashboards for powerful data visualization and insights

Chapter 1: Getting Started with Data Management Techniques – It begins by setting out the basic understanding of using a spreadsheet for data manipulation and some core techniques behind Excel navigation and use.
 
Chapter 2: Aggregating and Summarizing Data – It deepens the understanding of Excel for data manipulation, explaining how to take our large data sheets and turn that unintelligible grid into some meaningful summaries.
 
Chapter 3: Using Charts to Visualize Data – It introduces taking our consolidated figures and demonstrating how they can be visualized differently to communicate information, gaining a basic understanding of Excel\'s charting tools.
 
Chapter 4: Organizing and Customizing Your Excel Dashboard – It takes the reader through setting up the controls and interactions a user will make when interacting with our dashboards.
 
Chapter 5: Refining the Component Look – It will take what we have learned thus far and add some consistency to the visual elements, covering other enhancements we can make that will add appeal and ease of use to our layouts.
 
Chapter 6: Designing the Dashboard – It takes the principles of visuals, interactions, and other design components and brings them together concerning layout and content, thinking about how our content will sit on a page.
 
Chapter 7: Maintaining and Refreshing Your Dashboard – It finishes the learning by bookending the development and wrapping things up with documentation and refresh techniques.
 
Chapter 8: Dashboard Case Studies - We will dive into a few worked examples of dashboards from data and see how we can use the skills developed in this book to convert a data spreadsheet into a dashboard conveying meaningful and usable information