Description
Book SynopsisWelcome 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 r
Table of Contents
1. Power BI Solutions
Goal: as the introduction chapter, this chapter starts with the most popular tool in Power Platform. It covers the important components relating to the integrated architecture. The same components are also powerful in their own rights in building powerful reports.
2. Data Visualisation
Goal: After covering the key components of Power BI, this chapter focus on the design and user experience, which is also a key component in a great report.
3. Power BI Governance
Goal: The readers will understand that report governance is an enabler not a restrictor. This chapter break governance into 4 key components and discusses the needs in each area.
4. SQL ServerGoal: Most business data stores in SQL Server. SQL is by far the most common data language. The readers will understand the basics of SQL and able to write the most common queries.
5. SharePoint List
Goal: The readers will understand how to setup and utilize SharePoint list as a security measure.
6. Power Automate Solutions
Goal: The readers will understand the basic concept of Power Automate as well as some practical applications.
7. Power Apps Solutions
Goal: PowerApps is another critical component in the book. This chapter will spend considerably more time in explaining the concept and construct. The readers will understand how to build PowerApps and how to integrate it with Power BI and Power Automate.
8. Integrated Solutions
Goal: In the final chapter of the book, readers will start to explore the full architecture. How different parts add value to the business application. The readers will understand the full potential of Power Platform. By this stage, the users also have the skillset required to implement such solutions at work.
