Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate
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 Platform use case for addressing common business challenges.

While Power BI continues to be an excellent tool of choice in the BI space, Power Platform is the real game changer. Using an integrated architecture, a small team of citizen developers can build solutions for all kinds of business problems. For small businesses, Power Platform can be used to build bespoke CRM, Finance, and Warehouse management tools. For large businesses, it can be used to build an integration point for existing systems to simplify reporting, operation, and approval processes.

The author has drawn on his15 years of hands-on analytics experience to help you pivot from the traditional Excel-based reporting environment. By using different business scenarios, this book provides you with clear reasons why a skill is important before you start to dive into the scenarios. You will use a fast prototyping approach to continue to build exciting reporting, automation, and application solutions and improve them while you acquire new skill sets. The book helps you get started quickly with Power BI. It covers data visualization, collaboration, and governance practices. You will learn about the most practical SQL challenges. And you will learn how to build applications in PowerApps and Power Automate.

The book ends with an integrated solution framework that can be adapted to solve a wide range of complex business problems.


What You Will Learn



• Develop reporting solutions and business applications
• Understand the Power Platform licensing and development environment
• Apply Data ETL and modeling in Power BI

• Use Data Storytelling and dashboard design to better visualize data

• Carry out data operations with SQL and SharePoint lists
• Develop useful applications using Power Apps
• Develop automated workflows using Power Automate
• Integrate solutions with Power BI, Power Apps, and Power Automate to build enterprise solutions

Who This Book Is For

Next-generation data specialists, including Excel-based users who want to learn Power BI and build internal apps; finance specialists who want to take a different approach to traditional accounting reports; and anyone who wants to enhance their skill set for the future job market.

1142863693
Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate
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 Platform use case for addressing common business challenges.

While Power BI continues to be an excellent tool of choice in the BI space, Power Platform is the real game changer. Using an integrated architecture, a small team of citizen developers can build solutions for all kinds of business problems. For small businesses, Power Platform can be used to build bespoke CRM, Finance, and Warehouse management tools. For large businesses, it can be used to build an integration point for existing systems to simplify reporting, operation, and approval processes.

The author has drawn on his15 years of hands-on analytics experience to help you pivot from the traditional Excel-based reporting environment. By using different business scenarios, this book provides you with clear reasons why a skill is important before you start to dive into the scenarios. You will use a fast prototyping approach to continue to build exciting reporting, automation, and application solutions and improve them while you acquire new skill sets. The book helps you get started quickly with Power BI. It covers data visualization, collaboration, and governance practices. You will learn about the most practical SQL challenges. And you will learn how to build applications in PowerApps and Power Automate.

The book ends with an integrated solution framework that can be adapted to solve a wide range of complex business problems.


What You Will Learn



• Develop reporting solutions and business applications
• Understand the Power Platform licensing and development environment
• Apply Data ETL and modeling in Power BI

• Use Data Storytelling and dashboard design to better visualize data

• Carry out data operations with SQL and SharePoint lists
• Develop useful applications using Power Apps
• Develop automated workflows using Power Automate
• Integrate solutions with Power BI, Power Apps, and Power Automate to build enterprise solutions

Who This Book Is For

Next-generation data specialists, including Excel-based users who want to learn Power BI and build internal apps; finance specialists who want to take a different approach to traditional accounting reports; and anyone who wants to enhance their skill set for the future job market.

59.99 In Stock
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

by David Ding
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

by David Ding

Paperback(1st ed.)

$59.99 
  • SHIP THIS ITEM
    In stock. Ships in 1-2 days.
  • PICK UP IN STORE

    Your local store may have stock of this item.

Related collections and offers


Overview

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 Platform use case for addressing common business challenges.

While Power BI continues to be an excellent tool of choice in the BI space, Power Platform is the real game changer. Using an integrated architecture, a small team of citizen developers can build solutions for all kinds of business problems. For small businesses, Power Platform can be used to build bespoke CRM, Finance, and Warehouse management tools. For large businesses, it can be used to build an integration point for existing systems to simplify reporting, operation, and approval processes.

The author has drawn on his15 years of hands-on analytics experience to help you pivot from the traditional Excel-based reporting environment. By using different business scenarios, this book provides you with clear reasons why a skill is important before you start to dive into the scenarios. You will use a fast prototyping approach to continue to build exciting reporting, automation, and application solutions and improve them while you acquire new skill sets. The book helps you get started quickly with Power BI. It covers data visualization, collaboration, and governance practices. You will learn about the most practical SQL challenges. And you will learn how to build applications in PowerApps and Power Automate.

The book ends with an integrated solution framework that can be adapted to solve a wide range of complex business problems.


What You Will Learn



• Develop reporting solutions and business applications
• Understand the Power Platform licensing and development environment
• Apply Data ETL and modeling in Power BI

• Use Data Storytelling and dashboard design to better visualize data

• Carry out data operations with SQL and SharePoint lists
• Develop useful applications using Power Apps
• Develop automated workflows using Power Automate
• Integrate solutions with Power BI, Power Apps, and Power Automate to build enterprise solutions

Who This Book Is For

Next-generation data specialists, including Excel-based users who want to learn Power BI and build internal apps; finance specialists who want to take a different approach to traditional accounting reports; and anyone who wants to enhance their skill set for the future job market.


Product Details

ISBN-13: 9781484292389
Publisher: Apress
Publication date: 05/03/2023
Edition description: 1st ed.
Pages: 495
Product dimensions: 6.10(w) x 9.25(h) x (d)

About the Author

David Ding is the director and lead consultant of SDInnovation, a consulting company that provides customized decision support and training services to organizations across multiple industries. David is a certified Power BI developer with a master’s degree in data science. Previously, David held multiple senior business and technical positions. This book is part of his personal mission in helping everyone to get better with data.

Table of Contents

Chapter 1: Power BI First Report.- Chapter 2: Power BI Core Components.- Chapter 3: Power BI Service.- Chapter 4: Data Visualization.- Chapter 5: Power BI Governance.- Chapter 6: SQL Server.- Chapter 7: SharePoint List.- Chapter 8: Power Automate Solutions.- Chapter 9: Power Apps Solutions.- Chapter 10: Integrated Solutions.


From the B&N Reads Blog

Customer Reviews