Transitioning to Microsoft Power Platform : an Excel user guide to building integrated cloud applications in Power BI, Power Apps, and Power Automate

Transitioning to Microsoft Power Platform : an Excel user guide to building integrated cloud applications in Power BI, Power Apps, and Power Automate / David Ding.

Welcome to this step-by-step guide for Excel users, data analysts, and finance specialists. It is designed to take you through practical report and development scenarios, including both the approach and the technical challenges. This book will equip you with an understanding of the overall Power Pla...

Full description

Saved in:
Bibliographic Details
Main Author: Ding, David (Author)
Format: eBook
Language:English
Published: Berkeley, CA : Apress L. P., 2023.
Subjects:
Microsoft Power BI (Computer file)
Dashboards (Management information systems) > Software.
Dashboards (Management information systems)
Electronic books.
Software
Online Access:Click for online access
Table of 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

Similar Items