Lukket

Need Power BI assessment

Job Description:

• Load all the three tables and use data modelling to relate the tables

• Calculate revenue contribution of producer (if there is a producer X with 10,000 revenue out of total 100,000; when I select producer X result should show 10%; in the same way with revenue)

• Group the accounts based on revenue as Tier1 (having revenue > 10000), Tier 2(5000 to 10000), Teir 3 (<5000)

• Compare quarterly sales for different years (Use Date field)

• Create a tab/Page to show the data or visuals for just the Construction Niche.

• Create a calculated column to dervie stage numbers from Stage Name (ex: 3-Closed Won stage number is 3)

• Create a textbox to show producer selected; if there is no producer select show as "Please select a producer"

• User should be able to drill through the report to get producer details.(A bar graph with sales by producer has to be created in one page; a table with account information in one page; user should be abe to drill through from graph to view account details page)

• Count fof Account ID's that are closed (Stage Name - 3-Closed Won)

• Use Bookmarks feature to navigate to multiple pages; add a button to clear filters;

• Create a measure to calculate cumulative sales over the quarter

Færdigheder: Excel, Databehandling, Database Administration, Microsoft PowerBI

Om klienten:
( 0 bedømmelser ) Pune, India

Projekt ID: #35366949

13 freelancere byder i gennemsnit ₹1631 timen for dette job

bdrudra

Hello, I hope you're doing really well. We are reviewing your requirements and we can do this work. We are a team of highly skilled individuals having 8+ years of experience in the IT Industry. We have worked with Mi Flere

₹1500 INR på 1 dag
(13 bedømmelser)
6.0
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping u Flere

₹1050 INR in 7 dage
(11 bedømmelser)
3.5
Hakai128

Hi, My name is Abhay Gupta. I have a typing speed of 60wpm,which makes it easier for me to complete this job. I do also happen to have a great experience at internet surfing making this project a cake walk for me. If Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
pritamsen1997

Hello, I am excel and typing exprt with more than 4 year of experience. And from Botad that is in Kolkata. So if you give me this opportunity, i will do it with 100 accuracy as given time limit.

₹1000 INR in 7 dage
(0 bedømmelser)
0.0
Dhar4433

I have a lot of experience in data entry work and also work with excel sheets so I ask you to complete this project with ease

₹1400 INR in 2 dage
(0 bedømmelser)
0.0
HarikaAvirneni

Hi, This is Harika. I have experience as business analyst and part of my job is to develop Power BI dashboards that helps executives make decisions. I have understood the assignment and confident that I can deliver the Flere

₹2000 INR på 1 dag
(0 bedømmelser)
0.0
ritikagarwal08

Hi I am interested in taking this project . I have pity good experience of working on SQL and creating Power BI reports . Feel free to chat . Thanks

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
FcmBIConsult01

I have gone through your detailed request for a Power BI developer to create a dashboard to monitor sales performance. I'd like to help complete this project for you. I have worked on a similar project like this befor Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
vanshupadhyay628

I am vansh from India . I have learnt from your job post that you are going to hire skilled workers . I am a professional multi sectoral skills. I am a creative person . I am a good study and I always look forward to Flere

₹1050 INR in 7 dage
(0 bedømmelser)
0.0
Alorher1

Hi, My name is Alvaro Ortiz. I am a data analyst and I put at your disposal my extensive experience as an analyst with Power BI. I have developed very diverse projects in large multinational companies (banking, ener Flere

₹1500 INR på 1 dag
(0 bedømmelser)
0.0