cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tal_87
New Member

Standardize the data- Is it possible to create a common data model in powerApp- st

Hi

I have an idea for business application which can help me a lot. I'm asking your help so to see if it's possible.

The story goes like this:

I have a small business which provides financial services (audit, bookkeeping etc.) to small and medium businesses. My client mostly uses small bookkeeping system (obviously not SAP or Oracle).  In addition, the verity of the system is pretty big.

 

I want to help my client to get a better understanding about their financial data and provide them insights. I am doing this by Power BI. I created a power BI dashboard which I import a spreadsheet of all the revenue data (Let's call it "revenue spreadsheet"). The revenue spreadsheet mainly contains the following fields: client ID, client name, invoice id, invoice amount, when the invoice was submitted to the client, when the client should pay the invoice, was the invoice was paid. etc. Since each client uses a different bookkeeping system (the verity is pretty big) each client provides me a different "revenue spreadsheet". The data is the same, but the fields names are different.

 

In this situation each time I import the "revenue spreadsheet" to my Power BI dashboard I need to modify the fields names (which obviously takes me a lot of time) I need to find a way to standardize the data, in other words I need to create a common data model. I can create a "smart spreadsheet" which modify the fields names to my common data model, but I am thinking about a smarter solution.

 

My best solution is to create an app which do the following:

  • I upload the " revenue spreadsheet" to the app.
  • I map the fields names on the spreadsheet which my client sent me to the fields name on my Power BI dashboard (my common data model).
  • I generate the Power BI app.

 

I know that I can solve my problem using a python app, but I can’t code but  my tech skills are super strong.

Do you think it's possible using PowerApp or any other low-code solution?

Thank you, Tal

1 REPLY 1

Common Data Service is great for this kind of thing. It has standard fields for common account and contact fields (it's based on the Microsoft Common Data Model). Then when you get your client spreadsheet, you can import your data and map the fields. You can also save data maps so if customers send you the same format every month, you don't have to re-map the data.

https://www.inogic.com/blog/2019/02/import-data-in-cds-common-data-service/

 

Then you can reference it in power bi or power apps.

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,368)