Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Berkeley, CA
Apress L. P.
2023
|
| Ausgabe: | 1st ed |
| Online-Zugang: | DE-2070s |
| Beschreibung: | Description based on publisher supplied metadata and other sources |
| Beschreibung: | 1 Online-Ressource (511 Seiten) |
| ISBN: | 9781484292396 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV049876086 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240919s2023 |||| o||u| ||||||eng d | ||
| 020 | |a 9781484292396 |9 978-1-4842-9239-6 | ||
| 035 | |a (ZDB-30-PQE)EBC7244264 | ||
| 035 | |a (ZDB-30-PAD)EBC7244264 | ||
| 035 | |a (ZDB-89-EBL)EBL7244264 | ||
| 035 | |a (OCoLC)1378392006 | ||
| 035 | |a (DE-599)BVBBV049876086 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 658.4038011 | |
| 100 | 1 | |a Ding, David |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Transitioning to Microsoft Power Platform |b An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| 250 | |a 1st ed | ||
| 264 | 1 | |a Berkeley, CA |b Apress L. P. |c 2023 | |
| 264 | 4 | |c ©2023 | |
| 300 | |a 1 Online-Ressource (511 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 Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Introduction -- Chapter 1: Power BI First Report -- Business Scenario -- Power BI Software Licensing -- Build Your First Power BI Report -- Data and Requirements -- Install Power BI Desktop -- Report Building -- Add a Text Box -- Add Slicers -- Add a Pie Chart -- Add a Matrix Table -- Add a Line Chart -- Clean up the Report -- Conclusion -- Chapter 2: Power BI Core Components -- Build a Report with Power Query -- Business Scenario -- Data Processing Automation -- Create a New Query -- Combine Power Query Tables -- Add a New Column -- Seamless Data Integration -- Add a New Report Page -- Power Query Summary -- Building a Report with a Data Model -- Why a Data Model? -- Minimize Data Redundancy -- Facilitate Data Reuse -- Filter Across Multiple Fact Tables -- Implement the Data Model -- Create a Basic Data Model -- Reduce Data Redundancy -- Customized Calendar Table -- Use Common Filter Table on Multiple Fact Tables -- Data Model Summary -- DAX: Data Analysis Expression -- Create a Basic Measure in DAX -- Filter Context in DAX -- Row Context in DAX -- Create a Calendar Table Using DAX -- The Calculate Function in DAX -- Ignore the Filter Context -- Add a Filter Context -- Update the Filter Context -- Date Intelligence with CALCULATE -- Variables in DAX -- Organize DAX Measures -- DAX Summary -- Conclusion -- Chapter 3: Power BI Service -- Publishing and Sharing Reports -- Business Scenario -- Sharing Risks -- My Workspace -- Sharing Links -- Share with Others in Your Organization -- A Better Way of Sharing -- Local Power BI Support -- Get Power BI Pro License -- Determine Sharing Method -- Publish into Non-Personal Workspace -- Sharing via Direct Access -- User Access Approval and Review Processes -- Report-Sharing Summary -- Automation -- Data Connection | |
| 505 | 8 | |a Export Flat Files in a Shared Folder -- Data Transformation -- Scheduling with Power BI Gateways -- Power BI Gateway -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 4: Data Visualization -- Chart Selection -- Pie and Donut Charts -- Column and Bar Charts -- Line Charts -- Table vs. Matrix Visuals -- Scatter Charts -- Sunburst Diagrams -- Summary -- Data Explanation vs. Exploration -- Data Exploration -- Export Underlying Data -- Setting 1: Power BI Desktop Options -- Setting 2: Power BI Service Options -- Data Explanation -- Summary -- Report Design -- Business Scenario -- Structure the Reports -- Report Navigation -- Power BI Dashboard -- Design Template for Exploration Reports -- Color Selection -- The 60-30-10 Color Rule -- Color Association -- RAG Colors -- Color Blindness -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 5: Power BI Governance -- Why Governance? -- A Business Scenario -- Adoption-Driven Governance Framework -- Usage Data -- Workspace Usage Report -- PowerShell cmdlet and API -- Drive User Adoption -- Identify a New Usage Process -- Identify Consolidation Process -- Track Benefits -- Effort Saved -- Value Adds -- Improve Development Efficiency -- Report Prioritization -- Report Standardization -- Navigation Method -- Data Connection -- Standardized Data Model -- Standardize DAX Measures -- Colors and Background Image -- Development Standardization -- Agile MVP Approach -- Jira for Report Development and Maintenance -- Report Documentation -- Whole-Life Cost and Optimization Steps -- Workspace Structure -- Support Framework -- Support Levels -- Data Gateway -- Data Security -- Access Points Analysis -- Data Source Connection Process -- User Access Management -- Workspace Access Register -- Report Access Register -- Conclusion | |
| 505 | 8 | |a Chapter 6: SQL for Power BI -- Set up a SQL Server for Practice -- Set up a Free Azure Account -- Set up a Sample SQL Database -- Log in to Azure Query Editor -- Load SQL Query in Power BI -- SQL Query Basics -- Query Construction Process -- Identify the Core Table(s) -- Review the Table Columns -- Search for Additional Tables -- Apply Filter Logic -- SQL Query Syntax -- SELECT -- WHERE -- TOP and ORDER BY -- JOIN -- SQL Functions -- Data Types -- Common Scalar Functions -- Group By and Aggregate Function -- Aggregate Function -- Group By -- SQL Basics Summary -- Predefined Variables and Tables -- Create Variables -- Create Variables from Data -- Create Table from Data (WITH) -- Conclusion -- Mini-Hackathon -- Objective -- Objective 1 -- Objective 2 -- Time Limit -- Chapter 7: SharePoint Lists -- Business Scenario -- Create a SharePoint List -- Create a SharePoint Site -- Create a SharePoint List -- Create a New List -- Add Columns -- Column Property Guideline -- Add Columns for a Ticketing System -- Edit a SharePoint List -- Standard Edit -- Bulk Edit -- Edit in Grid View -- Edit Using Microsoft Access -- User Access and Security -- Permission Level -- Groups -- List Permissions -- Share the List with Users -- List Views -- Columns Selection -- Sort Options -- Filter Options -- Connection with Power BI -- Difference in Content -- Improve Speed with Default View -- Conclusion -- Chapter 8: First Power Apps -- Business Scenario -- Power Apps Licensing -- Check Access to Power Apps -- Power Apps Connectors -- Premium Connectors -- Cost and Licensing Strategies -- Power Apps with a SharePoint List -- Build the First Power Apps -- Create an App from a SharePoint List -- Understanding Power Apps Studio -- Understanding the Default App -- Browse Screen -- Detail Screen -- Edit Screen -- Share the Default App -- Build the App from a Blank Canvas | |
| 505 | 8 | |a Create a Blank Canvas App -- Agile Mindset for App Development -- Typical Approach -- Agile Approach -- Establish the Initial Requirements -- Add Data -- Main Screen -- Gallery -- Create a Blank Vertical Gallery -- Gallery and Data Table Relationship -- Organize a Gallery -- Edit Screen -- Edit to Display Switch -- Add a New Record Button -- Save to a SharePoint List -- Use Patch to Add New Data -- Use Patch to Modify Data -- Conclusion -- Chapter 9: Improve Power Apps -- The Business Scenario -- Variables and Delegation -- Variables in Power Apps -- Local Variable -- Global Variable -- Collection -- Create Variables -- Delegation -- Reason for Row Limit -- Warning and Error Messages -- User Level Filter -- Color Palette -- Apply Naming Standards -- Additional UI Features -- Drop-down Filter -- Single Drop-down Filter -- Multiple Drop-down Filters -- Create a Drop-down List from Data -- Sorting the Gallery -- Search Bar -- Dynamic Calculation -- Basic Calculations -- Calculation in a Gallery -- Aggregation Calculations -- Calculation in Collection -- User Experience -- Have a Clear Purpose -- Add Interaction Feedback -- Hover Effect in Gallery -- Pop-up Window -- Input Validation -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Chapter 10: Power Automate -- Business Scenario -- Power Automate Licensing -- Power Automate Flows -- Cloud Flow Overview -- Email Notification -- Create a Backup -- Prepare a Backup Excel File -- Create the Backup Process -- Test the Backup Process -- Fix Issues -- OData Filter -- Streamline Approval Processes -- Prepare the Approver Email -- Build the Approval Flow -- Integrate with Power Apps -- Approvals Customization Options -- Custom Responses in Approval Flow -- Add Conditional Actions After the Approval Flow -- Conclusion -- Mini-Hackathon -- Objectives -- Objective 1 -- Objective 2 -- Time Limit | |
| 505 | 8 | |a Chapter 11: Integrated Solutions -- Business Scenario -- Power Apps Visual in Power BI -- Limitation of Power Apps Visual -- Integrated Architecture -- Application Design -- Implement the Same Page Layout -- Underlying Data -- Use Scatter Plot for Strategic Categorization -- Create an Embedded App -- Include Decisions Back into the App -- Include Decisions Back into the Report -- Improving the Integrated Application -- Add Email Notification -- Add Action Status Tracker -- Access Management -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Final Thoughts -- Index | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Ding, David |t Transitioning to Microsoft Power Platform |d Berkeley, CA : Apress L. P.,c2023 |z 9781484292389 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035215536 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=7244264 |l DE-2070s |p ZDB-30-PQE |q HWR_PDA_PQE |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1810687471253454848 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Ding, David |
| author_facet | Ding, David |
| author_role | aut |
| author_sort | Ding, David |
| author_variant | d d dd |
| building | Verbundindex |
| bvnumber | BV049876086 |
| collection | ZDB-30-PQE |
| contents | Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Introduction -- Chapter 1: Power BI First Report -- Business Scenario -- Power BI Software Licensing -- Build Your First Power BI Report -- Data and Requirements -- Install Power BI Desktop -- Report Building -- Add a Text Box -- Add Slicers -- Add a Pie Chart -- Add a Matrix Table -- Add a Line Chart -- Clean up the Report -- Conclusion -- Chapter 2: Power BI Core Components -- Build a Report with Power Query -- Business Scenario -- Data Processing Automation -- Create a New Query -- Combine Power Query Tables -- Add a New Column -- Seamless Data Integration -- Add a New Report Page -- Power Query Summary -- Building a Report with a Data Model -- Why a Data Model? -- Minimize Data Redundancy -- Facilitate Data Reuse -- Filter Across Multiple Fact Tables -- Implement the Data Model -- Create a Basic Data Model -- Reduce Data Redundancy -- Customized Calendar Table -- Use Common Filter Table on Multiple Fact Tables -- Data Model Summary -- DAX: Data Analysis Expression -- Create a Basic Measure in DAX -- Filter Context in DAX -- Row Context in DAX -- Create a Calendar Table Using DAX -- The Calculate Function in DAX -- Ignore the Filter Context -- Add a Filter Context -- Update the Filter Context -- Date Intelligence with CALCULATE -- Variables in DAX -- Organize DAX Measures -- DAX Summary -- Conclusion -- Chapter 3: Power BI Service -- Publishing and Sharing Reports -- Business Scenario -- Sharing Risks -- My Workspace -- Sharing Links -- Share with Others in Your Organization -- A Better Way of Sharing -- Local Power BI Support -- Get Power BI Pro License -- Determine Sharing Method -- Publish into Non-Personal Workspace -- Sharing via Direct Access -- User Access Approval and Review Processes -- Report-Sharing Summary -- Automation -- Data Connection Export Flat Files in a Shared Folder -- Data Transformation -- Scheduling with Power BI Gateways -- Power BI Gateway -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 4: Data Visualization -- Chart Selection -- Pie and Donut Charts -- Column and Bar Charts -- Line Charts -- Table vs. Matrix Visuals -- Scatter Charts -- Sunburst Diagrams -- Summary -- Data Explanation vs. Exploration -- Data Exploration -- Export Underlying Data -- Setting 1: Power BI Desktop Options -- Setting 2: Power BI Service Options -- Data Explanation -- Summary -- Report Design -- Business Scenario -- Structure the Reports -- Report Navigation -- Power BI Dashboard -- Design Template for Exploration Reports -- Color Selection -- The 60-30-10 Color Rule -- Color Association -- RAG Colors -- Color Blindness -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 5: Power BI Governance -- Why Governance? -- A Business Scenario -- Adoption-Driven Governance Framework -- Usage Data -- Workspace Usage Report -- PowerShell cmdlet and API -- Drive User Adoption -- Identify a New Usage Process -- Identify Consolidation Process -- Track Benefits -- Effort Saved -- Value Adds -- Improve Development Efficiency -- Report Prioritization -- Report Standardization -- Navigation Method -- Data Connection -- Standardized Data Model -- Standardize DAX Measures -- Colors and Background Image -- Development Standardization -- Agile MVP Approach -- Jira for Report Development and Maintenance -- Report Documentation -- Whole-Life Cost and Optimization Steps -- Workspace Structure -- Support Framework -- Support Levels -- Data Gateway -- Data Security -- Access Points Analysis -- Data Source Connection Process -- User Access Management -- Workspace Access Register -- Report Access Register -- Conclusion Chapter 6: SQL for Power BI -- Set up a SQL Server for Practice -- Set up a Free Azure Account -- Set up a Sample SQL Database -- Log in to Azure Query Editor -- Load SQL Query in Power BI -- SQL Query Basics -- Query Construction Process -- Identify the Core Table(s) -- Review the Table Columns -- Search for Additional Tables -- Apply Filter Logic -- SQL Query Syntax -- SELECT -- WHERE -- TOP and ORDER BY -- JOIN -- SQL Functions -- Data Types -- Common Scalar Functions -- Group By and Aggregate Function -- Aggregate Function -- Group By -- SQL Basics Summary -- Predefined Variables and Tables -- Create Variables -- Create Variables from Data -- Create Table from Data (WITH) -- Conclusion -- Mini-Hackathon -- Objective -- Objective 1 -- Objective 2 -- Time Limit -- Chapter 7: SharePoint Lists -- Business Scenario -- Create a SharePoint List -- Create a SharePoint Site -- Create a SharePoint List -- Create a New List -- Add Columns -- Column Property Guideline -- Add Columns for a Ticketing System -- Edit a SharePoint List -- Standard Edit -- Bulk Edit -- Edit in Grid View -- Edit Using Microsoft Access -- User Access and Security -- Permission Level -- Groups -- List Permissions -- Share the List with Users -- List Views -- Columns Selection -- Sort Options -- Filter Options -- Connection with Power BI -- Difference in Content -- Improve Speed with Default View -- Conclusion -- Chapter 8: First Power Apps -- Business Scenario -- Power Apps Licensing -- Check Access to Power Apps -- Power Apps Connectors -- Premium Connectors -- Cost and Licensing Strategies -- Power Apps with a SharePoint List -- Build the First Power Apps -- Create an App from a SharePoint List -- Understanding Power Apps Studio -- Understanding the Default App -- Browse Screen -- Detail Screen -- Edit Screen -- Share the Default App -- Build the App from a Blank Canvas Create a Blank Canvas App -- Agile Mindset for App Development -- Typical Approach -- Agile Approach -- Establish the Initial Requirements -- Add Data -- Main Screen -- Gallery -- Create a Blank Vertical Gallery -- Gallery and Data Table Relationship -- Organize a Gallery -- Edit Screen -- Edit to Display Switch -- Add a New Record Button -- Save to a SharePoint List -- Use Patch to Add New Data -- Use Patch to Modify Data -- Conclusion -- Chapter 9: Improve Power Apps -- The Business Scenario -- Variables and Delegation -- Variables in Power Apps -- Local Variable -- Global Variable -- Collection -- Create Variables -- Delegation -- Reason for Row Limit -- Warning and Error Messages -- User Level Filter -- Color Palette -- Apply Naming Standards -- Additional UI Features -- Drop-down Filter -- Single Drop-down Filter -- Multiple Drop-down Filters -- Create a Drop-down List from Data -- Sorting the Gallery -- Search Bar -- Dynamic Calculation -- Basic Calculations -- Calculation in a Gallery -- Aggregation Calculations -- Calculation in Collection -- User Experience -- Have a Clear Purpose -- Add Interaction Feedback -- Hover Effect in Gallery -- Pop-up Window -- Input Validation -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Chapter 10: Power Automate -- Business Scenario -- Power Automate Licensing -- Power Automate Flows -- Cloud Flow Overview -- Email Notification -- Create a Backup -- Prepare a Backup Excel File -- Create the Backup Process -- Test the Backup Process -- Fix Issues -- OData Filter -- Streamline Approval Processes -- Prepare the Approver Email -- Build the Approval Flow -- Integrate with Power Apps -- Approvals Customization Options -- Custom Responses in Approval Flow -- Add Conditional Actions After the Approval Flow -- Conclusion -- Mini-Hackathon -- Objectives -- Objective 1 -- Objective 2 -- Time Limit Chapter 11: Integrated Solutions -- Business Scenario -- Power Apps Visual in Power BI -- Limitation of Power Apps Visual -- Integrated Architecture -- Application Design -- Implement the Same Page Layout -- Underlying Data -- Use Scatter Plot for Strategic Categorization -- Create an Embedded App -- Include Decisions Back into the App -- Include Decisions Back into the Report -- Improving the Integrated Application -- Add Email Notification -- Add Action Status Tracker -- Access Management -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Final Thoughts -- Index |
| ctrlnum | (ZDB-30-PQE)EBC7244264 (ZDB-30-PAD)EBC7244264 (ZDB-89-EBL)EBL7244264 (OCoLC)1378392006 (DE-599)BVBBV049876086 |
| 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>00000nmm a2200000zc 4500</leader><controlfield tag="001">BV049876086</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240919s2023 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484292396</subfield><subfield code="9">978-1-4842-9239-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC7244264</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC7244264</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL7244264</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1378392006</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049876086</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">Ding, David</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Transitioning to Microsoft Power Platform</subfield><subfield code="b">An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Apress L. P.</subfield><subfield code="c">2023</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2023</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (511 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">Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Introduction -- Chapter 1: Power BI First Report -- Business Scenario -- Power BI Software Licensing -- Build Your First Power BI Report -- Data and Requirements -- Install Power BI Desktop -- Report Building -- Add a Text Box -- Add Slicers -- Add a Pie Chart -- Add a Matrix Table -- Add a Line Chart -- Clean up the Report -- Conclusion -- Chapter 2: Power BI Core Components -- Build a Report with Power Query -- Business Scenario -- Data Processing Automation -- Create a New Query -- Combine Power Query Tables -- Add a New Column -- Seamless Data Integration -- Add a New Report Page -- Power Query Summary -- Building a Report with a Data Model -- Why a Data Model? -- Minimize Data Redundancy -- Facilitate Data Reuse -- Filter Across Multiple Fact Tables -- Implement the Data Model -- Create a Basic Data Model -- Reduce Data Redundancy -- Customized Calendar Table -- Use Common Filter Table on Multiple Fact Tables -- Data Model Summary -- DAX: Data Analysis Expression -- Create a Basic Measure in DAX -- Filter Context in DAX -- Row Context in DAX -- Create a Calendar Table Using DAX -- The Calculate Function in DAX -- Ignore the Filter Context -- Add a Filter Context -- Update the Filter Context -- Date Intelligence with CALCULATE -- Variables in DAX -- Organize DAX Measures -- DAX Summary -- Conclusion -- Chapter 3: Power BI Service -- Publishing and Sharing Reports -- Business Scenario -- Sharing Risks -- My Workspace -- Sharing Links -- Share with Others in Your Organization -- A Better Way of Sharing -- Local Power BI Support -- Get Power BI Pro License -- Determine Sharing Method -- Publish into Non-Personal Workspace -- Sharing via Direct Access -- User Access Approval and Review Processes -- Report-Sharing Summary -- Automation -- Data Connection</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Export Flat Files in a Shared Folder -- Data Transformation -- Scheduling with Power BI Gateways -- Power BI Gateway -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 4: Data Visualization -- Chart Selection -- Pie and Donut Charts -- Column and Bar Charts -- Line Charts -- Table vs. Matrix Visuals -- Scatter Charts -- Sunburst Diagrams -- Summary -- Data Explanation vs. Exploration -- Data Exploration -- Export Underlying Data -- Setting 1: Power BI Desktop Options -- Setting 2: Power BI Service Options -- Data Explanation -- Summary -- Report Design -- Business Scenario -- Structure the Reports -- Report Navigation -- Power BI Dashboard -- Design Template for Exploration Reports -- Color Selection -- The 60-30-10 Color Rule -- Color Association -- RAG Colors -- Color Blindness -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 5: Power BI Governance -- Why Governance? -- A Business Scenario -- Adoption-Driven Governance Framework -- Usage Data -- Workspace Usage Report -- PowerShell cmdlet and API -- Drive User Adoption -- Identify a New Usage Process -- Identify Consolidation Process -- Track Benefits -- Effort Saved -- Value Adds -- Improve Development Efficiency -- Report Prioritization -- Report Standardization -- Navigation Method -- Data Connection -- Standardized Data Model -- Standardize DAX Measures -- Colors and Background Image -- Development Standardization -- Agile MVP Approach -- Jira for Report Development and Maintenance -- Report Documentation -- Whole-Life Cost and Optimization Steps -- Workspace Structure -- Support Framework -- Support Levels -- Data Gateway -- Data Security -- Access Points Analysis -- Data Source Connection Process -- User Access Management -- Workspace Access Register -- Report Access Register -- Conclusion</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 6: SQL for Power BI -- Set up a SQL Server for Practice -- Set up a Free Azure Account -- Set up a Sample SQL Database -- Log in to Azure Query Editor -- Load SQL Query in Power BI -- SQL Query Basics -- Query Construction Process -- Identify the Core Table(s) -- Review the Table Columns -- Search for Additional Tables -- Apply Filter Logic -- SQL Query Syntax -- SELECT -- WHERE -- TOP and ORDER BY -- JOIN -- SQL Functions -- Data Types -- Common Scalar Functions -- Group By and Aggregate Function -- Aggregate Function -- Group By -- SQL Basics Summary -- Predefined Variables and Tables -- Create Variables -- Create Variables from Data -- Create Table from Data (WITH) -- Conclusion -- Mini-Hackathon -- Objective -- Objective 1 -- Objective 2 -- Time Limit -- Chapter 7: SharePoint Lists -- Business Scenario -- Create a SharePoint List -- Create a SharePoint Site -- Create a SharePoint List -- Create a New List -- Add Columns -- Column Property Guideline -- Add Columns for a Ticketing System -- Edit a SharePoint List -- Standard Edit -- Bulk Edit -- Edit in Grid View -- Edit Using Microsoft Access -- User Access and Security -- Permission Level -- Groups -- List Permissions -- Share the List with Users -- List Views -- Columns Selection -- Sort Options -- Filter Options -- Connection with Power BI -- Difference in Content -- Improve Speed with Default View -- Conclusion -- Chapter 8: First Power Apps -- Business Scenario -- Power Apps Licensing -- Check Access to Power Apps -- Power Apps Connectors -- Premium Connectors -- Cost and Licensing Strategies -- Power Apps with a SharePoint List -- Build the First Power Apps -- Create an App from a SharePoint List -- Understanding Power Apps Studio -- Understanding the Default App -- Browse Screen -- Detail Screen -- Edit Screen -- Share the Default App -- Build the App from a Blank Canvas</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Create a Blank Canvas App -- Agile Mindset for App Development -- Typical Approach -- Agile Approach -- Establish the Initial Requirements -- Add Data -- Main Screen -- Gallery -- Create a Blank Vertical Gallery -- Gallery and Data Table Relationship -- Organize a Gallery -- Edit Screen -- Edit to Display Switch -- Add a New Record Button -- Save to a SharePoint List -- Use Patch to Add New Data -- Use Patch to Modify Data -- Conclusion -- Chapter 9: Improve Power Apps -- The Business Scenario -- Variables and Delegation -- Variables in Power Apps -- Local Variable -- Global Variable -- Collection -- Create Variables -- Delegation -- Reason for Row Limit -- Warning and Error Messages -- User Level Filter -- Color Palette -- Apply Naming Standards -- Additional UI Features -- Drop-down Filter -- Single Drop-down Filter -- Multiple Drop-down Filters -- Create a Drop-down List from Data -- Sorting the Gallery -- Search Bar -- Dynamic Calculation -- Basic Calculations -- Calculation in a Gallery -- Aggregation Calculations -- Calculation in Collection -- User Experience -- Have a Clear Purpose -- Add Interaction Feedback -- Hover Effect in Gallery -- Pop-up Window -- Input Validation -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Chapter 10: Power Automate -- Business Scenario -- Power Automate Licensing -- Power Automate Flows -- Cloud Flow Overview -- Email Notification -- Create a Backup -- Prepare a Backup Excel File -- Create the Backup Process -- Test the Backup Process -- Fix Issues -- OData Filter -- Streamline Approval Processes -- Prepare the Approver Email -- Build the Approval Flow -- Integrate with Power Apps -- Approvals Customization Options -- Custom Responses in Approval Flow -- Add Conditional Actions After the Approval Flow -- Conclusion -- Mini-Hackathon -- Objectives -- Objective 1 -- Objective 2 -- Time Limit</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 11: Integrated Solutions -- Business Scenario -- Power Apps Visual in Power BI -- Limitation of Power Apps Visual -- Integrated Architecture -- Application Design -- Implement the Same Page Layout -- Underlying Data -- Use Scatter Plot for Strategic Categorization -- Create an Embedded App -- Include Decisions Back into the App -- Include Decisions Back into the Report -- Improving the Integrated Application -- Add Email Notification -- Add Action Status Tracker -- Access Management -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Final Thoughts -- Index</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">Ding, David</subfield><subfield code="t">Transitioning to Microsoft Power Platform</subfield><subfield code="d">Berkeley, CA : Apress L. P.,c2023</subfield><subfield code="z">9781484292389</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-035215536</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=7244264</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.BV049876086 |
| illustrated | Not Illustrated |
| indexdate | 2024-09-20T04:22:16Z |
| institution | BVB |
| isbn | 9781484292396 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035215536 |
| oclc_num | 1378392006 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | 1 Online-Ressource (511 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE HWR_PDA_PQE |
| publishDate | 2023 |
| publishDateSearch | 2023 |
| publishDateSort | 2023 |
| publisher | Apress L. P. |
| record_format | marc |
| spelling | Ding, David Verfasser aut Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate 1st ed Berkeley, CA Apress L. P. 2023 ©2023 1 Online-Ressource (511 Seiten) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Introduction -- Chapter 1: Power BI First Report -- Business Scenario -- Power BI Software Licensing -- Build Your First Power BI Report -- Data and Requirements -- Install Power BI Desktop -- Report Building -- Add a Text Box -- Add Slicers -- Add a Pie Chart -- Add a Matrix Table -- Add a Line Chart -- Clean up the Report -- Conclusion -- Chapter 2: Power BI Core Components -- Build a Report with Power Query -- Business Scenario -- Data Processing Automation -- Create a New Query -- Combine Power Query Tables -- Add a New Column -- Seamless Data Integration -- Add a New Report Page -- Power Query Summary -- Building a Report with a Data Model -- Why a Data Model? -- Minimize Data Redundancy -- Facilitate Data Reuse -- Filter Across Multiple Fact Tables -- Implement the Data Model -- Create a Basic Data Model -- Reduce Data Redundancy -- Customized Calendar Table -- Use Common Filter Table on Multiple Fact Tables -- Data Model Summary -- DAX: Data Analysis Expression -- Create a Basic Measure in DAX -- Filter Context in DAX -- Row Context in DAX -- Create a Calendar Table Using DAX -- The Calculate Function in DAX -- Ignore the Filter Context -- Add a Filter Context -- Update the Filter Context -- Date Intelligence with CALCULATE -- Variables in DAX -- Organize DAX Measures -- DAX Summary -- Conclusion -- Chapter 3: Power BI Service -- Publishing and Sharing Reports -- Business Scenario -- Sharing Risks -- My Workspace -- Sharing Links -- Share with Others in Your Organization -- A Better Way of Sharing -- Local Power BI Support -- Get Power BI Pro License -- Determine Sharing Method -- Publish into Non-Personal Workspace -- Sharing via Direct Access -- User Access Approval and Review Processes -- Report-Sharing Summary -- Automation -- Data Connection Export Flat Files in a Shared Folder -- Data Transformation -- Scheduling with Power BI Gateways -- Power BI Gateway -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 4: Data Visualization -- Chart Selection -- Pie and Donut Charts -- Column and Bar Charts -- Line Charts -- Table vs. Matrix Visuals -- Scatter Charts -- Sunburst Diagrams -- Summary -- Data Explanation vs. Exploration -- Data Exploration -- Export Underlying Data -- Setting 1: Power BI Desktop Options -- Setting 2: Power BI Service Options -- Data Explanation -- Summary -- Report Design -- Business Scenario -- Structure the Reports -- Report Navigation -- Power BI Dashboard -- Design Template for Exploration Reports -- Color Selection -- The 60-30-10 Color Rule -- Color Association -- RAG Colors -- Color Blindness -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 5: Power BI Governance -- Why Governance? -- A Business Scenario -- Adoption-Driven Governance Framework -- Usage Data -- Workspace Usage Report -- PowerShell cmdlet and API -- Drive User Adoption -- Identify a New Usage Process -- Identify Consolidation Process -- Track Benefits -- Effort Saved -- Value Adds -- Improve Development Efficiency -- Report Prioritization -- Report Standardization -- Navigation Method -- Data Connection -- Standardized Data Model -- Standardize DAX Measures -- Colors and Background Image -- Development Standardization -- Agile MVP Approach -- Jira for Report Development and Maintenance -- Report Documentation -- Whole-Life Cost and Optimization Steps -- Workspace Structure -- Support Framework -- Support Levels -- Data Gateway -- Data Security -- Access Points Analysis -- Data Source Connection Process -- User Access Management -- Workspace Access Register -- Report Access Register -- Conclusion Chapter 6: SQL for Power BI -- Set up a SQL Server for Practice -- Set up a Free Azure Account -- Set up a Sample SQL Database -- Log in to Azure Query Editor -- Load SQL Query in Power BI -- SQL Query Basics -- Query Construction Process -- Identify the Core Table(s) -- Review the Table Columns -- Search for Additional Tables -- Apply Filter Logic -- SQL Query Syntax -- SELECT -- WHERE -- TOP and ORDER BY -- JOIN -- SQL Functions -- Data Types -- Common Scalar Functions -- Group By and Aggregate Function -- Aggregate Function -- Group By -- SQL Basics Summary -- Predefined Variables and Tables -- Create Variables -- Create Variables from Data -- Create Table from Data (WITH) -- Conclusion -- Mini-Hackathon -- Objective -- Objective 1 -- Objective 2 -- Time Limit -- Chapter 7: SharePoint Lists -- Business Scenario -- Create a SharePoint List -- Create a SharePoint Site -- Create a SharePoint List -- Create a New List -- Add Columns -- Column Property Guideline -- Add Columns for a Ticketing System -- Edit a SharePoint List -- Standard Edit -- Bulk Edit -- Edit in Grid View -- Edit Using Microsoft Access -- User Access and Security -- Permission Level -- Groups -- List Permissions -- Share the List with Users -- List Views -- Columns Selection -- Sort Options -- Filter Options -- Connection with Power BI -- Difference in Content -- Improve Speed with Default View -- Conclusion -- Chapter 8: First Power Apps -- Business Scenario -- Power Apps Licensing -- Check Access to Power Apps -- Power Apps Connectors -- Premium Connectors -- Cost and Licensing Strategies -- Power Apps with a SharePoint List -- Build the First Power Apps -- Create an App from a SharePoint List -- Understanding Power Apps Studio -- Understanding the Default App -- Browse Screen -- Detail Screen -- Edit Screen -- Share the Default App -- Build the App from a Blank Canvas Create a Blank Canvas App -- Agile Mindset for App Development -- Typical Approach -- Agile Approach -- Establish the Initial Requirements -- Add Data -- Main Screen -- Gallery -- Create a Blank Vertical Gallery -- Gallery and Data Table Relationship -- Organize a Gallery -- Edit Screen -- Edit to Display Switch -- Add a New Record Button -- Save to a SharePoint List -- Use Patch to Add New Data -- Use Patch to Modify Data -- Conclusion -- Chapter 9: Improve Power Apps -- The Business Scenario -- Variables and Delegation -- Variables in Power Apps -- Local Variable -- Global Variable -- Collection -- Create Variables -- Delegation -- Reason for Row Limit -- Warning and Error Messages -- User Level Filter -- Color Palette -- Apply Naming Standards -- Additional UI Features -- Drop-down Filter -- Single Drop-down Filter -- Multiple Drop-down Filters -- Create a Drop-down List from Data -- Sorting the Gallery -- Search Bar -- Dynamic Calculation -- Basic Calculations -- Calculation in a Gallery -- Aggregation Calculations -- Calculation in Collection -- User Experience -- Have a Clear Purpose -- Add Interaction Feedback -- Hover Effect in Gallery -- Pop-up Window -- Input Validation -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Chapter 10: Power Automate -- Business Scenario -- Power Automate Licensing -- Power Automate Flows -- Cloud Flow Overview -- Email Notification -- Create a Backup -- Prepare a Backup Excel File -- Create the Backup Process -- Test the Backup Process -- Fix Issues -- OData Filter -- Streamline Approval Processes -- Prepare the Approver Email -- Build the Approval Flow -- Integrate with Power Apps -- Approvals Customization Options -- Custom Responses in Approval Flow -- Add Conditional Actions After the Approval Flow -- Conclusion -- Mini-Hackathon -- Objectives -- Objective 1 -- Objective 2 -- Time Limit Chapter 11: Integrated Solutions -- Business Scenario -- Power Apps Visual in Power BI -- Limitation of Power Apps Visual -- Integrated Architecture -- Application Design -- Implement the Same Page Layout -- Underlying Data -- Use Scatter Plot for Strategic Categorization -- Create an Embedded App -- Include Decisions Back into the App -- Include Decisions Back into the Report -- Improving the Integrated Application -- Add Email Notification -- Add Action Status Tracker -- Access Management -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Final Thoughts -- Index Erscheint auch als Druck-Ausgabe Ding, David Transitioning to Microsoft Power Platform Berkeley, CA : Apress L. P.,c2023 9781484292389 |
| spellingShingle | Ding, David Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Introduction -- Chapter 1: Power BI First Report -- Business Scenario -- Power BI Software Licensing -- Build Your First Power BI Report -- Data and Requirements -- Install Power BI Desktop -- Report Building -- Add a Text Box -- Add Slicers -- Add a Pie Chart -- Add a Matrix Table -- Add a Line Chart -- Clean up the Report -- Conclusion -- Chapter 2: Power BI Core Components -- Build a Report with Power Query -- Business Scenario -- Data Processing Automation -- Create a New Query -- Combine Power Query Tables -- Add a New Column -- Seamless Data Integration -- Add a New Report Page -- Power Query Summary -- Building a Report with a Data Model -- Why a Data Model? -- Minimize Data Redundancy -- Facilitate Data Reuse -- Filter Across Multiple Fact Tables -- Implement the Data Model -- Create a Basic Data Model -- Reduce Data Redundancy -- Customized Calendar Table -- Use Common Filter Table on Multiple Fact Tables -- Data Model Summary -- DAX: Data Analysis Expression -- Create a Basic Measure in DAX -- Filter Context in DAX -- Row Context in DAX -- Create a Calendar Table Using DAX -- The Calculate Function in DAX -- Ignore the Filter Context -- Add a Filter Context -- Update the Filter Context -- Date Intelligence with CALCULATE -- Variables in DAX -- Organize DAX Measures -- DAX Summary -- Conclusion -- Chapter 3: Power BI Service -- Publishing and Sharing Reports -- Business Scenario -- Sharing Risks -- My Workspace -- Sharing Links -- Share with Others in Your Organization -- A Better Way of Sharing -- Local Power BI Support -- Get Power BI Pro License -- Determine Sharing Method -- Publish into Non-Personal Workspace -- Sharing via Direct Access -- User Access Approval and Review Processes -- Report-Sharing Summary -- Automation -- Data Connection Export Flat Files in a Shared Folder -- Data Transformation -- Scheduling with Power BI Gateways -- Power BI Gateway -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 4: Data Visualization -- Chart Selection -- Pie and Donut Charts -- Column and Bar Charts -- Line Charts -- Table vs. Matrix Visuals -- Scatter Charts -- Sunburst Diagrams -- Summary -- Data Explanation vs. Exploration -- Data Exploration -- Export Underlying Data -- Setting 1: Power BI Desktop Options -- Setting 2: Power BI Service Options -- Data Explanation -- Summary -- Report Design -- Business Scenario -- Structure the Reports -- Report Navigation -- Power BI Dashboard -- Design Template for Exploration Reports -- Color Selection -- The 60-30-10 Color Rule -- Color Association -- RAG Colors -- Color Blindness -- Conclusion -- Mini-Hackathon -- Hackathon Data -- Objectives -- Time Limit -- Chapter 5: Power BI Governance -- Why Governance? -- A Business Scenario -- Adoption-Driven Governance Framework -- Usage Data -- Workspace Usage Report -- PowerShell cmdlet and API -- Drive User Adoption -- Identify a New Usage Process -- Identify Consolidation Process -- Track Benefits -- Effort Saved -- Value Adds -- Improve Development Efficiency -- Report Prioritization -- Report Standardization -- Navigation Method -- Data Connection -- Standardized Data Model -- Standardize DAX Measures -- Colors and Background Image -- Development Standardization -- Agile MVP Approach -- Jira for Report Development and Maintenance -- Report Documentation -- Whole-Life Cost and Optimization Steps -- Workspace Structure -- Support Framework -- Support Levels -- Data Gateway -- Data Security -- Access Points Analysis -- Data Source Connection Process -- User Access Management -- Workspace Access Register -- Report Access Register -- Conclusion Chapter 6: SQL for Power BI -- Set up a SQL Server for Practice -- Set up a Free Azure Account -- Set up a Sample SQL Database -- Log in to Azure Query Editor -- Load SQL Query in Power BI -- SQL Query Basics -- Query Construction Process -- Identify the Core Table(s) -- Review the Table Columns -- Search for Additional Tables -- Apply Filter Logic -- SQL Query Syntax -- SELECT -- WHERE -- TOP and ORDER BY -- JOIN -- SQL Functions -- Data Types -- Common Scalar Functions -- Group By and Aggregate Function -- Aggregate Function -- Group By -- SQL Basics Summary -- Predefined Variables and Tables -- Create Variables -- Create Variables from Data -- Create Table from Data (WITH) -- Conclusion -- Mini-Hackathon -- Objective -- Objective 1 -- Objective 2 -- Time Limit -- Chapter 7: SharePoint Lists -- Business Scenario -- Create a SharePoint List -- Create a SharePoint Site -- Create a SharePoint List -- Create a New List -- Add Columns -- Column Property Guideline -- Add Columns for a Ticketing System -- Edit a SharePoint List -- Standard Edit -- Bulk Edit -- Edit in Grid View -- Edit Using Microsoft Access -- User Access and Security -- Permission Level -- Groups -- List Permissions -- Share the List with Users -- List Views -- Columns Selection -- Sort Options -- Filter Options -- Connection with Power BI -- Difference in Content -- Improve Speed with Default View -- Conclusion -- Chapter 8: First Power Apps -- Business Scenario -- Power Apps Licensing -- Check Access to Power Apps -- Power Apps Connectors -- Premium Connectors -- Cost and Licensing Strategies -- Power Apps with a SharePoint List -- Build the First Power Apps -- Create an App from a SharePoint List -- Understanding Power Apps Studio -- Understanding the Default App -- Browse Screen -- Detail Screen -- Edit Screen -- Share the Default App -- Build the App from a Blank Canvas Create a Blank Canvas App -- Agile Mindset for App Development -- Typical Approach -- Agile Approach -- Establish the Initial Requirements -- Add Data -- Main Screen -- Gallery -- Create a Blank Vertical Gallery -- Gallery and Data Table Relationship -- Organize a Gallery -- Edit Screen -- Edit to Display Switch -- Add a New Record Button -- Save to a SharePoint List -- Use Patch to Add New Data -- Use Patch to Modify Data -- Conclusion -- Chapter 9: Improve Power Apps -- The Business Scenario -- Variables and Delegation -- Variables in Power Apps -- Local Variable -- Global Variable -- Collection -- Create Variables -- Delegation -- Reason for Row Limit -- Warning and Error Messages -- User Level Filter -- Color Palette -- Apply Naming Standards -- Additional UI Features -- Drop-down Filter -- Single Drop-down Filter -- Multiple Drop-down Filters -- Create a Drop-down List from Data -- Sorting the Gallery -- Search Bar -- Dynamic Calculation -- Basic Calculations -- Calculation in a Gallery -- Aggregation Calculations -- Calculation in Collection -- User Experience -- Have a Clear Purpose -- Add Interaction Feedback -- Hover Effect in Gallery -- Pop-up Window -- Input Validation -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Chapter 10: Power Automate -- Business Scenario -- Power Automate Licensing -- Power Automate Flows -- Cloud Flow Overview -- Email Notification -- Create a Backup -- Prepare a Backup Excel File -- Create the Backup Process -- Test the Backup Process -- Fix Issues -- OData Filter -- Streamline Approval Processes -- Prepare the Approver Email -- Build the Approval Flow -- Integrate with Power Apps -- Approvals Customization Options -- Custom Responses in Approval Flow -- Add Conditional Actions After the Approval Flow -- Conclusion -- Mini-Hackathon -- Objectives -- Objective 1 -- Objective 2 -- Time Limit Chapter 11: Integrated Solutions -- Business Scenario -- Power Apps Visual in Power BI -- Limitation of Power Apps Visual -- Integrated Architecture -- Application Design -- Implement the Same Page Layout -- Underlying Data -- Use Scatter Plot for Strategic Categorization -- Create an Embedded App -- Include Decisions Back into the App -- Include Decisions Back into the Report -- Improving the Integrated Application -- Add Email Notification -- Add Action Status Tracker -- Access Management -- Conclusion -- Mini-Hackathon -- Objective -- Time Limit -- Final Thoughts -- Index |
| title | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_auth | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_exact_search | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_full | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_fullStr | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_full_unstemmed | Transitioning to Microsoft Power Platform An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| title_short | Transitioning to Microsoft Power Platform |
| title_sort | transitioning to microsoft power platform an excel user guide to building integrated cloud applications in power bi power apps and power automate |
| title_sub | An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate |
| work_keys_str_mv | AT dingdavid transitioningtomicrosoftpowerplatformanexceluserguidetobuildingintegratedcloudapplicationsinpowerbipowerappsandpowerautomate |