Olafusi Building Interactive Dashboards in Microsoft 365 Excel

Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
1. Auflage 2024
ISBN: 978-1-80324-747-2
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, 420 Seiten

No detailed description available for "Building Interactive Dashboards in Microsoft 365 Excel".

Autoren/Hrsg.

Olafusi, Michael

Weitere Mitwirkende

Oyinbooke, Olanrewaju

Fachgebiete

• Mathematik | Informatik EDV | Informatik Informatik Mensch-Maschine-Interaktion Informationsarchitektur
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Automatische Datenerfassung, Datenanalyse
• Mathematik | Informatik EDV | Informatik Informatik Mensch-Maschine-Interaktion Informationsvisualisierung
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Datenbankdesign & Datenbanktheorie

Inhaltsverzeichnis

Table of Contents - Dashboards, Reports, and M365 Excel
- Common Dashboards in Large Companies
- The Importance of Connecting Directly to the Primary Data Sources
- Power Query: the Ultimate Data Transformation Tool
- PivotTable and Power Pivot
- Must-Know Legacy Excel Functions
- Dynamic Array Functions and Lambda Functions
- Getting Comfortable with the 19 Excel Charts
- Non-Chart Visuals
- Setting Up the Dashboard's Data Model
- Perfecting the Dashboard
- Best Practices for Real-World Dashboard Building

Über Autor(innen)

Olafusi Michael:

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.