Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate

Table of Contents\nAbout the Author\nAbout the Technical Reviewer\nIntroduction\nChapter 1: Power BI First Report\n	Business Scenario\n	Power BI Software Licensing\n	Build Your First Power BI Report\n		Data and Requirements\n		Install Power BI Desktop\n		Report Building\n			Add a Text Box\n			Add Slicers\n			Add a Pie Chart\n			Add a Matrix Table\n			Add a Line Chart\n			Clean up the Report\n	Conclusion\nChapter 2: Power BI Core Components\n	Build a Report with Power Query\n		Business Scenario\n		Data Processing Automation\n		Create a New Query\n		Combine Power Query Tables\n		Add a New Column\n		Seamless Data Integration\n		Add a New Report Page\n		Power Query Summary\n	Building a Report with a Data Model\n		Why a Data Model?\n			Minimize Data Redundancy\n			Facilitate Data Reuse\n			Filter Across Multiple Fact Tables\n		Implement the Data Model\n			Create a Basic Data Model\n			Reduce Data Redundancy\n			Customized Calendar Table\n			Use Common Filter Table on Multiple Fact Tables\n		Data Model Summary\n	DAX: Data Analysis Expression\n		Create a Basic Measure in DAX\n		Filter Context in DAX\n		Row Context in DAX\n		Create a Calendar Table Using DAX\n		The Calculate Function in DAX\n			Ignore the Filter Context\n			Add a Filter Context\n			Update the Filter Context\n		Date Intelligence with CALCULATE\n		Variables in DAX\n		Organize DAX Measures\n		DAX Summary\n	Conclusion\nChapter 3: Power BI Service\n	Publishing and Sharing Reports\n		Business Scenario\n		Sharing Risks\n			My Workspace\n			Sharing Links\n			Share with Others in Your Organization\n		A Better Way of Sharing\n			Local Power BI Support\n			Get Power BI Pro License\n			Determine Sharing Method\n			Publish into Non-Personal Workspace\n			Sharing via Direct Access\n			User Access Approval and Review Processes\n		Report-Sharing Summary\n	Automation\n		Data Connection\n		Export Flat Files in a Shared Folder\n		Data Transformation\n		Scheduling with Power BI Gateways\n		Power BI Gateway\n	Conclusion\n	Mini-Hackathon\n		Hackathon Data\n		Objectives\n		Time Limit\nChapter 4: Data Visualization\n	Chart Selection\n		Pie and Donut Charts\n		Column and Bar Charts\n		Line Charts\n		Table vs. Matrix Visuals\n		Scatter Charts\n		Sunburst Diagrams\n		Summary\n	Data Explanation vs. Exploration\n		Data Exploration\n			Export Underlying Data\n				Setting 1: Power BI Desktop Options\n				Setting 2: Power BI Service Options\n		Data Explanation\n		Summary\n	Report Design\n		Business Scenario\n		Structure the Reports\n			Report Navigation\n			Power BI Dashboard\n		Design Template for Exploration Reports\n		Color Selection\n			The 60-30-10 Color Rule\n			Color Association\n			RAG Colors\n			Color Blindness\n	Conclusion\n	Mini-Hackathon\n		Hackathon Data\n		Objectives\n		Time Limit\nChapter 5: Power BI Governance\n	Why Governance?\n		A Business Scenario\n		Adoption-Driven Governance Framework\n	Usage Data\n		Workspace Usage Report\n		PowerShell cmdlet and API\n	Drive User Adoption\n		Identify a New Usage Process\n		Identify Consolidation Process\n	Track Benefits\n		Effort Saved\n		Value Adds\n	Improve Development Efficiency\n		Report Prioritization\n		Report Standardization\n			Navigation Method\n			Data Connection\n			Standardized Data Model\n			Standardize DAX Measures\n			Colors and Background Image\n		Development Standardization\n			Agile MVP Approach\n			Jira for Report Development and Maintenance\n			Report Documentation\n			Whole-Life Cost and Optimization Steps\n			Workspace Structure\n		Support Framework\n			Support Levels\n			Data Gateway\n	Data Security\n		Access Points Analysis\n		Data Source Connection Process\n		User Access Management\n			Workspace Access Register\n			Report Access Register\n	Conclusion\nChapter 6: SQL for Power BI\n	Set up a SQL Server for Practice\n		Set up a Free Azure Account\n		Set up a Sample SQL Database\n		Log in to Azure Query Editor\n	Load SQL Query in Power BI\n	SQL Query Basics\n		Query Construction Process\n			Identify the Core Table(s)\n			Review the Table Columns\n			Search for Additional Tables\n			Apply Filter Logic\n		SQL Query Syntax\n			SELECT\n			WHERE\n			TOP and ORDER BY\n			JOIN\n		SQL Functions\n			Data Types\n			Common Scalar Functions\n		Group By and Aggregate Function\n			Aggregate Function\n			Group By\n		SQL Basics Summary\n	Predefined Variables and Tables\n		Create Variables\n		Create Variables from Data\n		Create Table from Data (WITH)\n	Conclusion\n	Mini-Hackathon\n		Objective\n			Objective 1\n			Objective 2\n		Time Limit\nChapter 7: SharePoint Lists\n	Business Scenario\n	Create a SharePoint List\n		Create a SharePoint Site\n		Create a SharePoint List\n			Create a New List\n			Add Columns\n			Column Property Guideline\n			Add Columns for a Ticketing System\n	Edit a SharePoint List\n		Standard Edit\n		Bulk Edit\n			Edit in Grid View\n			Edit Using Microsoft Access\n	User Access and Security\n		Permission Level\n		Groups\n		List Permissions\n		Share the List with Users\n		List Views\n			Columns Selection\n			Sort Options\n			Filter Options\n	Connection with Power BI\n		Difference in Content\n		Improve Speed with Default View\n	Conclusion\nChapter 8: First Power Apps\n	Business Scenario\n	Power Apps Licensing\n		Check Access to Power Apps\n		Power Apps Connectors\n		Premium Connectors\n		Cost and Licensing Strategies\n		Power Apps with a SharePoint List\n	Build the First Power Apps\n		Create an App from a SharePoint List\n		Understanding Power Apps Studio\n		Understanding the Default App\n			Browse Screen\n			Detail Screen\n			Edit Screen\n		Share the Default App\n	Build the App from a Blank Canvas\n		Create a Blank Canvas App\n		Agile Mindset for App Development\n			Typical Approach\n			Agile Approach\n		Establish the Initial Requirements\n		Add Data\n		Main Screen\n		Gallery\n			Create a Blank Vertical Gallery\n			Gallery and Data Table Relationship\n			Organize a Gallery\n		Edit Screen\n		Edit to Display Switch\n		Add a New Record Button\n		Save to a SharePoint List\n			Use Patch to Add New Data\n			Use Patch to Modify Data\n	Conclusion\nChapter 9: Improve Power Apps\n	The Business Scenario\n	Variables and Delegation\n		Variables in Power Apps\n			Local Variable\n			Global Variable\n			Collection\n			Create Variables\n		Delegation\n			Reason for Row Limit\n			Warning and Error Messages\n			User Level Filter\n	Color Palette\n	Apply Naming Standards\n	Additional UI Features\n		Drop-down Filter\n			Single Drop-down Filter\n			Multiple Drop-down Filters\n			Create a Drop-down List from Data\n		Sorting the Gallery\n		Search Bar\n	Dynamic Calculation\n		Basic Calculations\n		Calculation in a Gallery\n		Aggregation Calculations\n		Calculation in Collection\n	User Experience\n		Have a Clear Purpose\n		Add Interaction Feedback\n			Hover Effect in Gallery\n			Pop-up Window\n		Input Validation\n	Conclusion\n	Mini-Hackathon\n		Objective\n		Time Limit\nChapter 10: Power Automate\n	Business Scenario\n	Power Automate Licensing\n	Power Automate Flows\n	Cloud Flow Overview\n	Email Notification\n	Create a Backup\n		Prepare a Backup Excel File\n		Create the Backup Process\n		Test the Backup Process\n		Fix Issues\n		OData Filter\n	Streamline Approval Processes\n		Prepare the Approver Email\n		Build the Approval Flow\n		Integrate with Power Apps\n		Approvals Customization Options\n			Custom Responses in Approval Flow\n			Add Conditional Actions After the Approval Flow\n	Conclusion\n	Mini-Hackathon\n		Objectives\n			Objective 1\n			Objective 2\n		Time Limit\nChapter 11: Integrated Solutions\n	Business Scenario\n	Power Apps Visual in Power BI\n		Limitation of Power Apps Visual\n		Integrated Architecture\n		Application Design\n	Implement the Same Page Layout\n		Underlying Data\n		Use Scatter Plot for Strategic Categorization\n		Create an Embedded App\n		Include Decisions Back into the App\n		Include Decisions Back into the Report\n	Improving the Integrated Application\n		Add Email Notification\n		Add Action Status Tracker\n	Access Management\n	Conclusion\n	Mini-Hackathon\n		Objective\n		Time Limit\n	Final Thoughts\nIndex\n0.png\n0.png