Power BI - Online Support in Building Report - Need IMMEDIATELY
$25-50 USD / saa
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.
Kitambulisho cha Mradi: #37551704
Kuhusu mradi
Imetuzwa kwa:
10 wafanyakazi wanazabuni wastani wa $51/saa kwa kazi hii
- I am Manoj, an Azure Certified Engineer with a proven track record of providing support within 24 hours. I understand from your description that you need an expert in Power BI to provide immediate online support in Zaidi