You're reading from Building Interactive Dashboards in Microsoft 365 Excel Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards

Product type Paperback

Published in Feb 2024

Publisher Packt

ISBN-13 9781803237299

Length 420 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Data Visualization

Author (1):

Michael Olafusi

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1 – Dashboards and Reports in Modern Excel FREE CHAPTER

2. Chapter 1: Dashboards, Reports, and M365 Excel

3. Chapter 2: Common Dashboards in Lsarge Companies

4. Part 2 – Keeping Your Eyes on Automation

5. Chapter 3: The Importance of Connecting Directly to the Primary Data Sources

6. Chapter 4: Power Query: the Ultimate Data Transformation Tool

7. Chapter 5: PivotTable and Power Pivot

8. Chapter 6: Must-Know Legacy Excel Functions

9. Chapter 7: Dynamic Array Functions and Lambda Functions

10. Part 3 – Getting the Visualization Right

11. Chapter 8: Getting Comfortable with the 19 Excel Charts

12. Chapter 9: Non-Chart Visuals

13. Chapter 10: Setting Up the Dashboard's Data Model

14. Chapter 11: Perfecting the Dashboard

15. Chapter 12: Best Practices for Real-World Dashboard Building

16. Index

Why subscribe?

17. Other Books You May Enjoy

Introduction to Power Query

Power Query was officially released by Microsoft in 2013 as an add-in that was installable in Excel 2010 and Excel 2013. It was originally designed to help Excel users connect to data directly, especially data not housed in an Excel file. Examples of such data are relational database tables, SharePoint lists, text files, and cloud data sources. It creates a pathway to connect to these types of data, transform the data, and then load the data into Excel sheets, tables, or PivotTables. In essence, Power Query is an Extract, Transform, and Load (ETL) tool.

Power Query has changed a lot since the first version. In Excel 2010 and Excel 2013, it had a dedicated menu and was a Component Object Model (COM) add-in that could be enabled or disabled after installing the Power Query add-in. The following screenshot shows what it was like in the early versions in Excel 2010 and Excel 2013:

Figure 4.1 – Power Query in Excel 2013

...

The rest of the chapter is locked

You're reading from Building Interactive Dashboards in Microsoft 365 Excel Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards

Table of Contents (18) Chapters

Introduction to Power Query

Authors (1)

Personalised recommendations for you

You're reading from Building Interactive Dashboards in Microsoft 365 Excel Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards

Table of Contents (18) Chapters

Introduction to Power Query

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you