Share via

Recommended technologies for creating a dashboard of ongoing jobs.

COW Farmer 0 Reputation points
2024-05-09T14:00:50.17+00:00

I'm looking for recommendations on technologies to use for the following project. I need to create a dashboard of summarized job data from a network of hundreds of users. Our current application is used in the field for inputting and tracking job costs and customer charges. I want our app to automatically upload a file of summarized job data for use by a new, yet to be created, BI application. Uploaded data will be in csv or excel format and include approximately 100 fields - mostly financial. Can you recommend which Azure technologies lend themselves to best accomplishing this so I can focus my research?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,696 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 78,986 Reputation points Microsoft Employee
    2024-05-10T03:38:06.5033333+00:00

    @COW Farmer - Thanks for the question and using MS Q&A platfrom.

    MS Fabric is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

    You can ask the experts in the dedicated MS Fabric community forum.

    Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

    User's image

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

  2. PRADEEPCHEEKATLA-MSFT 78,986 Reputation points Microsoft Employee
    2024-05-14T03:53:26.6733333+00:00

    @COW Farmer - Based on your requirements, I would recommend using Azure Logic Apps and Power BI to create a dashboard of summarized job data.

    Azure Logic Apps can be used to automate the process of uploading the summarized job data from your application to a storage account in Azure. You can use the "File System" connector in Logic Apps to read the csv or excel files from your application and then use the "Azure Blob Storage" connector to upload the files to a storage account in Azure.

    Once the data is uploaded to Azure, you can use Power BI to create a dashboard that connects to the storage account and displays the summarized job data. Power BI has a built-in connector for Azure Blob Storage, which makes it easy to connect to the data and create visualizations.

    Additionally, you can use Azure Data Factory to transform the data before it is uploaded to Azure Blob Storage. Azure Data Factory can be used to extract, transform, and load (ETL) data from various sources, including csv and excel files. You can use Data Factory to clean and transform the data before it is uploaded to Azure Blob Storage, which can improve the accuracy of your dashboard.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments