Power BI - Online Support in Building Report - Need IMMEDIATELY

Power BI - Online Support in Building Report - Need IMMEDIATELY

I am looking for an expert in Power BI who can provide immediate online support in building two reports. I want to learn from this engagement and am looking for an expert would can guide me in overcoming the two challenges below over a MS Teams or other screen sharing session.

I need this assist around 2pm EST.

CHALLENGE #1

I need to be able to pull data from a postgres database into my Power BI desktop, build the report and then setup a cronjob to refresh this database every day. The connection to the database is working fine. The query has been defined and is working. I am stuck in getting the data out of the editor into some construct that can be utilizes in building the report and against which I can apply visualizations.

CHALLENGE #2

I am having challenges with building metrics showing total dollars for an order that (a) links to a company table to define the company for the order and (b) links to a categorization table for the company. The issue arises from the second link. A company can have more than one categorization. So, the query that pulls the data may show n orders, when there is only 1. How do I setup these relationships correctly?

I assume that I need to define "two" tables supporting my visualizations instead of a single table to hold the data from my query (above). Then, I define the relationship between them. I am unsure how to do this correctly.

If I were using a Excel grip representation, I could use a pivot table for my representation of this data. However, I need to generate the summary metric (total dollars across all orders) to apply to the information found by the Tooltips, shown when a user hovers over the location for the company on a map.

These two challenges are associated with the same report I am trying to assemble.

Skills and experience needed:

- Expertise in Power BI

- Strong knowledge and experience in data modeling

- Ability to provide support within 24 hours

Specific requirements:

- Assistance needed in building a report using Power BI

- Focus on data modeling to ensure accurate and effective data representation

Timeline:

- As noted above... I need this assist around 2pm EST.

If you have the necessary skills and availability, please contact me immediately.

Data Visualization Power BI Azure

Nº del proyecto: #37551704

Sobre el proyecto