Ditutup

Power BI Report Assistance

Job Description:

We need assistance in creating a Power BI that shows our service level performance on our jobs in a simple % we hit the target, and % we failed. We provide services to our customers that we have to "attend" site by a certain date.

We have data source from an Odata link that pulls directly from a database.

The database holds a few fields we can use:

1. Attended Score - This is automatically generated if the date we attend is before/after the target date. If we attend after the requested date, it marks is as either -1 or -100. If we attend before the date they requested it marks it as either 1 or 100. So minuses are fails and positivies are passes.

2. Sometimes the date we attend is blank in the database, because we havent actually done it yet, so if the requested date is before today's date and the attended field is blank, that also needs to be a fail.

3. If the requested attend date is blank, then just ignore that as we havent been given a target.

We simple need to add up all the fails and passes to give us a percentage.

When we have the above % we need to be able to create 3 x Pie Charts that show the different Priorities and their % we hit and failed.

We need to be able to slice is based on customer which we have a relationship to another database showing the customers.

I am struggling with the method of doing the above as I am new to Power BI.

Kemahiran: Power BI

Tentang Klien:
( 0 ulasan ) Southampton, United Kingdom

ID Projek: #35842957

51 pekerja bebas membida secara purata £450 untuk pekerjaan ini

Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I would love to work together and create the appropriate power BI based on the data you have. I'm so responsible a Lagi

£250 GBP dalam sehari
(19 Ulasan)
5.9
dataguru2110

Hi I have 13 years of experience in Data Analysis, Data warehousing ,Business Intelligence . I have worked on following technology stack. Power BI, SQL Server , SSIS , SSAS , Excel, Azure Data Factory, Azure Data la Lagi

£500 GBP dalam 7 hari
(32 Ulasan)
5.5
asin1987

Dear Employer, I am professional with an over a decade of experience and below is my proposal: - I am a Power BI professional with over a decade of experience. - Excellent experience working on DAX, Power and M quer Lagi

£500 GBP dalam 7 hari
(5 Ulasan)
5.0
AndreiBird

Hello, I'm excited to hear about your project and the opportunity to help you create a Power BI report that accurately reflects your service level performance. With my experience in Power BI, I am confident that I can Lagi

£500 GBP dalam 7 hari
(7 Ulasan)
4.2
Akmanyu

Hi There, Good morning! "First use then believe". I don't want to mention much here but I have 6+ years of extensive experience in Power BI along with Power Apps, Power Automate & Python with total 8+ years o Lagi

£250 GBP dalam sehari
(44 Ulasan)
3.8
JPAnalytics

Hi there, I have 16 years of experience in process automation, reporting and data visualisation and specialise in Power BI, Power Query, SQL and Excel,. I spent 7 years at Queensland Rail, a billion dollar organisati Lagi

£800 GBP dalam 7 hari
(2 Ulasan)
3.3
daniyal3214

Hello, Power BI Expert here. I can perfectly design that using Power BI. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs Lagi

£250 GBP dalam sehari
(7 Ulasan)
3.9
rahulg5466

Hi there. I am a full stack developer with experience in Power BI, MY SQL, C# and C++, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enth Lagi

£250 GBP dalam 7 hari
(2 Ulasan)
3.1
jayaruwanjanith

Hi There, As a Power BI developer we could help you to develop the following power bi dashboards. Cheers, Janith

£500 GBP dalam 7 hari
(6 Ulasan)
3.1
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Lagi

£500 GBP dalam 7 hari
(3 Ulasan)
3.5
chirag9700

Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 4+ years of experience i Lagi

£350 GBP dalam 4 hari
(1 Ulasan)
2.7
merinsinha

PowerBI expert. I can do it. As 5+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating f Lagi

£500 GBP dalam 7 hari
(1 Ulasan)
1.8
ennikapatinaga

Hi, I am a PowerBI / SQL developer with over 12+ years of IT experience. Having an in-depth experience into Data Warehouse / ETL / Report areas using the Microsoft stack (PowerBI, MSBI and SQL). Worked for multi Lagi

£750 GBP dalam 7 hari
(1 Ulasan)
1.3
AhDardear

Dear, I have reviewed your PowerBI requirment carfully. I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst, Tableau and PowerBI developer with 10 Lagi

£250 GBP dalam 7 hari
(2 Ulasan)
1.0
EmiliaSimon

Hello, I can help you create a report in Power BI according to your requirements. I am a Microsoft Certified Power BI Analyst with extensive experience in modeling data, creating DAX measures, creating visuals and buil Lagi

£250 GBP dalam 7 hari
(1 Ulasan)
1.0
kstathis

Hello , my name is Kostas I believe I can carry out your project. I would like to know more about it. If you don't mind check my profile. The design is important for me. Thank you very much

£300 GBP dalam 7 hari
(1 Ulasan)
0.4
timurkulinskiy

❤️❤️❤️Hi❤️❤️❤️. I am a AI engineer I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboar Lagi

£500 GBP dalam 7 hari
(0 Ulasan)
0.0
mohamedabdelall4

Hi , I am sure that I can do this job. I'm artificial intelligence engineer experienced in Data Science/Visualization/Processing & Mathematics Here you can find projects similar to yours and my client reviews (https:/ Lagi

£250 GBP dalam 4 hari
(0 Ulasan)
0.0
AwaisChaudhry

Hello Good afternoon , I just finished reading the job description and currently going through attached files . I see you are looking for someone experienced in developing products using Power BI. This is something I Lagi

£750 GBP dalam 17 hari
(0 Ulasan)
0.0
hassamuddin258

Dear client, I have understood your project requirements. I can create interactive power bi report for you . Message me so I can assist you with this. Thanks

£250 GBP dalam 7 hari
(0 Ulasan)
0.0