Building Interactive Dashboards in Microsoft 365 Excel: Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham
Packt Publishing, Limited
2024
|
| Edition: | 1st ed |
| Subjects: | |
| Online Access: | DE-2070s |
| Item Description: | Description based on publisher supplied metadata and other sources |
| Physical Description: | 1 Online-Ressource (420 Seiten) |
| ISBN: | 9781803247472 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV049873687 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240919s2024 xx o|||| 00||| eng d | ||
| 020 | |a 9781803247472 |9 978-1-80324-747-2 | ||
| 035 | |a (ZDB-30-PQE)EBC31137935 | ||
| 035 | |a (ZDB-30-PAD)EBC31137935 | ||
| 035 | |a (ZDB-89-EBL)EBL31137935 | ||
| 035 | |a (OCoLC)1420920116 | ||
| 035 | |a (DE-599)BVBBV049873687 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 658.4038011 | |
| 100 | 1 | |a Olafusi, Michael |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Building Interactive Dashboards in Microsoft 365 Excel |b Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| 250 | |a 1st ed | ||
| 264 | 1 | |a Birmingham |b Packt Publishing, Limited |c 2024 | |
| 264 | 4 | |c ©2024 | |
| 300 | |a 1 Online-Ressource (420 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close & -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables | |
| 505 | 8 | |a Power Pivot and Data Models -- DAX -- Summary -- Chapter 6: Must-Know Legacy Excel Functions -- Math and statistical functions -- SUM -- SUMIFS -- COUNT -- COUNTIFS -- MIN -- MAX -- AVERAGE -- Logical functions -- IF -- IFS -- IFERROR -- SWITCH -- OR -- AND -- Text manipulation functions -- LEFT -- MID -- RIGHT -- SEARCH -- SUBSTITUTE -- TEXT -- LEN -- Date manipulation functions -- TODAY -- DATE -- YEAR -- MONTH -- DAY -- EDATE -- EOMONTH -- WEEKNUM -- Lookup and reference functions -- VLOOKUP -- HLOOKUP -- INDEX -- MATCH -- OFFSET -- INDIRECT -- CHOOSE -- Summary -- Chapter 7: Dynamic Array Functions and Lambda Functions -- Dynamic array functions -- UNIQUE -- FILTER -- SEQUENCE -- SORT -- SORTBY -- Lambda functions -- LAMBDA -- BYCOL -- BYROW -- MAKEARRAY -- MAP -- REDUCE -- SCAN -- Summary -- Part 3 - Getting the Visualization Right -- Chapter 8: Getting Comfortable with the 19 Excel Charts -- Column chart -- Bar chart -- Line chart -- Area chart -- Pie chart -- Doughnut chart -- XY (scatter) chart -- Bubble chart -- Stock chart -- Surface chart -- Radar chart -- Treemap chart -- Sunburst chart -- Histogram chart -- Box and whisker chart -- Waterfall chart -- Funnel chart -- Filled map chart -- Combo chart -- Summary -- Chapter 9: Non-Chart Visuals -- Conditional formatting -- Highlight Cells Rules -- Top/Bottom Rules -- Data bars -- Color scales -- Icon sets -- Custom formula conditional formatting -- Shapes -- SmartArt -- Sparkline -- Images -- Symbols -- Summary -- Chapter 10: Setting Up the Dashboard's Data Model -- Adventure Works Cycle Limited -- HR schema -- Sales schema -- Purchasing schema -- Production schema -- Person schema -- Building business-relevant dashboards -- Data transformation in Power Query -- Summary -- Chapter 11: Perfecting the Dashboard -- Building the HR manpower dashboard -- Inserting PivotTables | |
| 505 | 8 | |a Inserting PivotCharts -- Inserting picture, shapes, and icons -- Building the sales performance dashboard -- Creating measures -- Inserting slicers and timelines -- Inserting a PivotTable and a PivotChart -- Inserting shapes and a picture -- Connecting slicers to the PivotTables and PivotCharts -- Building the supply chain inventory dashboard -- Summary -- Chapter 12: Best Practices for Real-World Dashboard Building -- Gathering the dashboard requirements -- Existing established analysis dashboards -- Newly established analysis dashboards -- Ad hoc analysis dashboards -- An overview of different data professionals -- Data analyst -- Business intelligence analyst -- Data engineer -- Data scientist -- Database administrator -- Advantages and limitations of Excel dashboards -- Summary -- Index -- Other Books You May Enjoy | |
| 650 | 4 | |a Dashboards (Management information systems) | |
| 700 | 1 | |a Oyinbooke, Olanrewaju |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Olafusi, Michael |t Building Interactive Dashboards in Microsoft 365 Excel |d Birmingham : Packt Publishing, Limited,c2024 |z 9781803237299 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035213145 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=31137935 |l DE-2070s |p ZDB-30-PQE |q HWR_PDA_PQE |x Aggregator |3 Volltext | |
Record in the Search Index
| _version_ | 1817704728027463680 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Olafusi, Michael |
| author_facet | Olafusi, Michael |
| author_role | aut |
| author_sort | Olafusi, Michael |
| author_variant | m o mo |
| building | Verbundindex |
| bvnumber | BV049873687 |
| collection | ZDB-30-PQE |
| contents | Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close & -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables Power Pivot and Data Models -- DAX -- Summary -- Chapter 6: Must-Know Legacy Excel Functions -- Math and statistical functions -- SUM -- SUMIFS -- COUNT -- COUNTIFS -- MIN -- MAX -- AVERAGE -- Logical functions -- IF -- IFS -- IFERROR -- SWITCH -- OR -- AND -- Text manipulation functions -- LEFT -- MID -- RIGHT -- SEARCH -- SUBSTITUTE -- TEXT -- LEN -- Date manipulation functions -- TODAY -- DATE -- YEAR -- MONTH -- DAY -- EDATE -- EOMONTH -- WEEKNUM -- Lookup and reference functions -- VLOOKUP -- HLOOKUP -- INDEX -- MATCH -- OFFSET -- INDIRECT -- CHOOSE -- Summary -- Chapter 7: Dynamic Array Functions and Lambda Functions -- Dynamic array functions -- UNIQUE -- FILTER -- SEQUENCE -- SORT -- SORTBY -- Lambda functions -- LAMBDA -- BYCOL -- BYROW -- MAKEARRAY -- MAP -- REDUCE -- SCAN -- Summary -- Part 3 - Getting the Visualization Right -- Chapter 8: Getting Comfortable with the 19 Excel Charts -- Column chart -- Bar chart -- Line chart -- Area chart -- Pie chart -- Doughnut chart -- XY (scatter) chart -- Bubble chart -- Stock chart -- Surface chart -- Radar chart -- Treemap chart -- Sunburst chart -- Histogram chart -- Box and whisker chart -- Waterfall chart -- Funnel chart -- Filled map chart -- Combo chart -- Summary -- Chapter 9: Non-Chart Visuals -- Conditional formatting -- Highlight Cells Rules -- Top/Bottom Rules -- Data bars -- Color scales -- Icon sets -- Custom formula conditional formatting -- Shapes -- SmartArt -- Sparkline -- Images -- Symbols -- Summary -- Chapter 10: Setting Up the Dashboard's Data Model -- Adventure Works Cycle Limited -- HR schema -- Sales schema -- Purchasing schema -- Production schema -- Person schema -- Building business-relevant dashboards -- Data transformation in Power Query -- Summary -- Chapter 11: Perfecting the Dashboard -- Building the HR manpower dashboard -- Inserting PivotTables Inserting PivotCharts -- Inserting picture, shapes, and icons -- Building the sales performance dashboard -- Creating measures -- Inserting slicers and timelines -- Inserting a PivotTable and a PivotChart -- Inserting shapes and a picture -- Connecting slicers to the PivotTables and PivotCharts -- Building the supply chain inventory dashboard -- Summary -- Chapter 12: Best Practices for Real-World Dashboard Building -- Gathering the dashboard requirements -- Existing established analysis dashboards -- Newly established analysis dashboards -- Ad hoc analysis dashboards -- An overview of different data professionals -- Data analyst -- Business intelligence analyst -- Data engineer -- Data scientist -- Database administrator -- Advantages and limitations of Excel dashboards -- Summary -- Index -- Other Books You May Enjoy |
| ctrlnum | (ZDB-30-PQE)EBC31137935 (ZDB-30-PAD)EBC31137935 (ZDB-89-EBL)EBL31137935 (OCoLC)1420920116 (DE-599)BVBBV049873687 |
| dewey-full | 658.4038011 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.4038011 |
| dewey-search | 658.4038011 |
| dewey-sort | 3658.4038011 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| edition | 1st ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000zc 4500</leader><controlfield tag="001">BV049873687</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240919s2024 xx o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781803247472</subfield><subfield code="9">978-1-80324-747-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC31137935</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC31137935</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL31137935</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1420920116</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049873687</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-2070s</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.4038011</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Olafusi, Michael</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Building Interactive Dashboards in Microsoft 365 Excel</subfield><subfield code="b">Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham</subfield><subfield code="b">Packt Publishing, Limited</subfield><subfield code="c">2024</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (420 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close &amp -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Power Pivot and Data Models -- DAX -- Summary -- Chapter 6: Must-Know Legacy Excel Functions -- Math and statistical functions -- SUM -- SUMIFS -- COUNT -- COUNTIFS -- MIN -- MAX -- AVERAGE -- Logical functions -- IF -- IFS -- IFERROR -- SWITCH -- OR -- AND -- Text manipulation functions -- LEFT -- MID -- RIGHT -- SEARCH -- SUBSTITUTE -- TEXT -- LEN -- Date manipulation functions -- TODAY -- DATE -- YEAR -- MONTH -- DAY -- EDATE -- EOMONTH -- WEEKNUM -- Lookup and reference functions -- VLOOKUP -- HLOOKUP -- INDEX -- MATCH -- OFFSET -- INDIRECT -- CHOOSE -- Summary -- Chapter 7: Dynamic Array Functions and Lambda Functions -- Dynamic array functions -- UNIQUE -- FILTER -- SEQUENCE -- SORT -- SORTBY -- Lambda functions -- LAMBDA -- BYCOL -- BYROW -- MAKEARRAY -- MAP -- REDUCE -- SCAN -- Summary -- Part 3 - Getting the Visualization Right -- Chapter 8: Getting Comfortable with the 19 Excel Charts -- Column chart -- Bar chart -- Line chart -- Area chart -- Pie chart -- Doughnut chart -- XY (scatter) chart -- Bubble chart -- Stock chart -- Surface chart -- Radar chart -- Treemap chart -- Sunburst chart -- Histogram chart -- Box and whisker chart -- Waterfall chart -- Funnel chart -- Filled map chart -- Combo chart -- Summary -- Chapter 9: Non-Chart Visuals -- Conditional formatting -- Highlight Cells Rules -- Top/Bottom Rules -- Data bars -- Color scales -- Icon sets -- Custom formula conditional formatting -- Shapes -- SmartArt -- Sparkline -- Images -- Symbols -- Summary -- Chapter 10: Setting Up the Dashboard's Data Model -- Adventure Works Cycle Limited -- HR schema -- Sales schema -- Purchasing schema -- Production schema -- Person schema -- Building business-relevant dashboards -- Data transformation in Power Query -- Summary -- Chapter 11: Perfecting the Dashboard -- Building the HR manpower dashboard -- Inserting PivotTables</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Inserting PivotCharts -- Inserting picture, shapes, and icons -- Building the sales performance dashboard -- Creating measures -- Inserting slicers and timelines -- Inserting a PivotTable and a PivotChart -- Inserting shapes and a picture -- Connecting slicers to the PivotTables and PivotCharts -- Building the supply chain inventory dashboard -- Summary -- Chapter 12: Best Practices for Real-World Dashboard Building -- Gathering the dashboard requirements -- Existing established analysis dashboards -- Newly established analysis dashboards -- Ad hoc analysis dashboards -- An overview of different data professionals -- Data analyst -- Business intelligence analyst -- Data engineer -- Data scientist -- Database administrator -- Advantages and limitations of Excel dashboards -- Summary -- Index -- Other Books You May Enjoy</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Dashboards (Management information systems)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Oyinbooke, Olanrewaju</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Olafusi, Michael</subfield><subfield code="t">Building Interactive Dashboards in Microsoft 365 Excel</subfield><subfield code="d">Birmingham : Packt Publishing, Limited,c2024</subfield><subfield code="z">9781803237299</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-035213145</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=31137935</subfield><subfield code="l">DE-2070s</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">HWR_PDA_PQE</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049873687 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-06T15:18:33Z |
| institution | BVB |
| isbn | 9781803247472 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035213145 |
| oclc_num | 1420920116 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | 1 Online-Ressource (420 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE HWR_PDA_PQE |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Packt Publishing, Limited |
| record_format | marc |
| spelling | Olafusi, Michael Verfasser aut Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards 1st ed Birmingham Packt Publishing, Limited 2024 ©2024 1 Online-Ressource (420 Seiten) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close & -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables Power Pivot and Data Models -- DAX -- Summary -- Chapter 6: Must-Know Legacy Excel Functions -- Math and statistical functions -- SUM -- SUMIFS -- COUNT -- COUNTIFS -- MIN -- MAX -- AVERAGE -- Logical functions -- IF -- IFS -- IFERROR -- SWITCH -- OR -- AND -- Text manipulation functions -- LEFT -- MID -- RIGHT -- SEARCH -- SUBSTITUTE -- TEXT -- LEN -- Date manipulation functions -- TODAY -- DATE -- YEAR -- MONTH -- DAY -- EDATE -- EOMONTH -- WEEKNUM -- Lookup and reference functions -- VLOOKUP -- HLOOKUP -- INDEX -- MATCH -- OFFSET -- INDIRECT -- CHOOSE -- Summary -- Chapter 7: Dynamic Array Functions and Lambda Functions -- Dynamic array functions -- UNIQUE -- FILTER -- SEQUENCE -- SORT -- SORTBY -- Lambda functions -- LAMBDA -- BYCOL -- BYROW -- MAKEARRAY -- MAP -- REDUCE -- SCAN -- Summary -- Part 3 - Getting the Visualization Right -- Chapter 8: Getting Comfortable with the 19 Excel Charts -- Column chart -- Bar chart -- Line chart -- Area chart -- Pie chart -- Doughnut chart -- XY (scatter) chart -- Bubble chart -- Stock chart -- Surface chart -- Radar chart -- Treemap chart -- Sunburst chart -- Histogram chart -- Box and whisker chart -- Waterfall chart -- Funnel chart -- Filled map chart -- Combo chart -- Summary -- Chapter 9: Non-Chart Visuals -- Conditional formatting -- Highlight Cells Rules -- Top/Bottom Rules -- Data bars -- Color scales -- Icon sets -- Custom formula conditional formatting -- Shapes -- SmartArt -- Sparkline -- Images -- Symbols -- Summary -- Chapter 10: Setting Up the Dashboard's Data Model -- Adventure Works Cycle Limited -- HR schema -- Sales schema -- Purchasing schema -- Production schema -- Person schema -- Building business-relevant dashboards -- Data transformation in Power Query -- Summary -- Chapter 11: Perfecting the Dashboard -- Building the HR manpower dashboard -- Inserting PivotTables Inserting PivotCharts -- Inserting picture, shapes, and icons -- Building the sales performance dashboard -- Creating measures -- Inserting slicers and timelines -- Inserting a PivotTable and a PivotChart -- Inserting shapes and a picture -- Connecting slicers to the PivotTables and PivotCharts -- Building the supply chain inventory dashboard -- Summary -- Chapter 12: Best Practices for Real-World Dashboard Building -- Gathering the dashboard requirements -- Existing established analysis dashboards -- Newly established analysis dashboards -- Ad hoc analysis dashboards -- An overview of different data professionals -- Data analyst -- Business intelligence analyst -- Data engineer -- Data scientist -- Database administrator -- Advantages and limitations of Excel dashboards -- Summary -- Index -- Other Books You May Enjoy Dashboards (Management information systems) Oyinbooke, Olanrewaju Sonstige oth Erscheint auch als Druck-Ausgabe Olafusi, Michael Building Interactive Dashboards in Microsoft 365 Excel Birmingham : Packt Publishing, Limited,c2024 9781803237299 |
| spellingShingle | Olafusi, Michael Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards Cover -- Title page -- Copyright and credit -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1 - Dashboards and Reports in Modern Excel -- Chapter 1: Dashboards, Reports, and M365 Excel -- Introducing dashboards and reports -- Meeting modern business needs -- The characteristics of a dashboard -- The different versions of Microsoft Excel -- Excel 365 -- Excel 2021 -- Older versions of Excel -- Summary -- Further reading -- Chapter 2: Common Dashboards in Large Companies -- Major types of dashboards -- Understanding the sales dashboard -- Understanding the financial analysis dashboard -- Understanding the HR dashboard -- Understanding the supply chain and logistics dashboard -- Understanding the marketing dashboard -- Summary -- Part 2 - Keeping Your Eyes on Automation -- Chapter 3: The Importance of Connecting Directly to the Primary Data Sources -- The different ways to bring data into Excel -- Copying and pasting data into Excel -- Importing data from flat files -- Importing data from databases -- Importing data from cloud platforms -- Connecting directly to the primary data source -- Common issues and how to overcome them -- Summary -- Chapter 4: Power Query: the Ultimate Data Transformation Tool -- Introduction to Power Query -- Connecting to over 100 different data sources -- Transforming data in Power Query -- Appending data from multiple sources in one data table -- Merging data from two tables into one table -- Common data transformations -- Choose Columns -- Keep Rows and Remove Rows -- Unpivot Columns and Pivot Columns -- Group By -- Fill Series and Remove Empty -- Replace Values -- Important tips -- Understanding Close & -- Load To -- Demystifying the underlying M code -- Summary -- Chapter 5: PivotTable and Power Pivot -- Mastering Pivot Tables -- The role of Slicers -- Dynamic reports with PivotTables Power Pivot and Data Models -- DAX -- Summary -- Chapter 6: Must-Know Legacy Excel Functions -- Math and statistical functions -- SUM -- SUMIFS -- COUNT -- COUNTIFS -- MIN -- MAX -- AVERAGE -- Logical functions -- IF -- IFS -- IFERROR -- SWITCH -- OR -- AND -- Text manipulation functions -- LEFT -- MID -- RIGHT -- SEARCH -- SUBSTITUTE -- TEXT -- LEN -- Date manipulation functions -- TODAY -- DATE -- YEAR -- MONTH -- DAY -- EDATE -- EOMONTH -- WEEKNUM -- Lookup and reference functions -- VLOOKUP -- HLOOKUP -- INDEX -- MATCH -- OFFSET -- INDIRECT -- CHOOSE -- Summary -- Chapter 7: Dynamic Array Functions and Lambda Functions -- Dynamic array functions -- UNIQUE -- FILTER -- SEQUENCE -- SORT -- SORTBY -- Lambda functions -- LAMBDA -- BYCOL -- BYROW -- MAKEARRAY -- MAP -- REDUCE -- SCAN -- Summary -- Part 3 - Getting the Visualization Right -- Chapter 8: Getting Comfortable with the 19 Excel Charts -- Column chart -- Bar chart -- Line chart -- Area chart -- Pie chart -- Doughnut chart -- XY (scatter) chart -- Bubble chart -- Stock chart -- Surface chart -- Radar chart -- Treemap chart -- Sunburst chart -- Histogram chart -- Box and whisker chart -- Waterfall chart -- Funnel chart -- Filled map chart -- Combo chart -- Summary -- Chapter 9: Non-Chart Visuals -- Conditional formatting -- Highlight Cells Rules -- Top/Bottom Rules -- Data bars -- Color scales -- Icon sets -- Custom formula conditional formatting -- Shapes -- SmartArt -- Sparkline -- Images -- Symbols -- Summary -- Chapter 10: Setting Up the Dashboard's Data Model -- Adventure Works Cycle Limited -- HR schema -- Sales schema -- Purchasing schema -- Production schema -- Person schema -- Building business-relevant dashboards -- Data transformation in Power Query -- Summary -- Chapter 11: Perfecting the Dashboard -- Building the HR manpower dashboard -- Inserting PivotTables Inserting PivotCharts -- Inserting picture, shapes, and icons -- Building the sales performance dashboard -- Creating measures -- Inserting slicers and timelines -- Inserting a PivotTable and a PivotChart -- Inserting shapes and a picture -- Connecting slicers to the PivotTables and PivotCharts -- Building the supply chain inventory dashboard -- Summary -- Chapter 12: Best Practices for Real-World Dashboard Building -- Gathering the dashboard requirements -- Existing established analysis dashboards -- Newly established analysis dashboards -- Ad hoc analysis dashboards -- An overview of different data professionals -- Data analyst -- Business intelligence analyst -- Data engineer -- Data scientist -- Database administrator -- Advantages and limitations of Excel dashboards -- Summary -- Index -- Other Books You May Enjoy Dashboards (Management information systems) |
| title | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_auth | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_exact_search | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_full | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_fullStr | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_full_unstemmed | Building Interactive Dashboards in Microsoft 365 Excel Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| title_short | Building Interactive Dashboards in Microsoft 365 Excel |
| title_sort | building interactive dashboards in microsoft 365 excel harness the new features and formulae in m365 excel to create dynamic automated dashboards |
| title_sub | Harness the New Features and Formulae in M365 Excel to Create Dynamic, Automated Dashboards |
| topic | Dashboards (Management information systems) |
| topic_facet | Dashboards (Management information systems) |
| work_keys_str_mv | AT olafusimichael buildinginteractivedashboardsinmicrosoft365excelharnessthenewfeaturesandformulaeinm365exceltocreatedynamicautomateddashboards AT oyinbookeolanrewaju buildinginteractivedashboardsinmicrosoft365excelharnessthenewfeaturesandformulaeinm365exceltocreatedynamicautomateddashboards |