Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a data given in excel. please do the task in power bi. Task 4 (1 point) Create a profit chart. Add additional clation - New
a data given in excel. please do the task in power bi.
Task 4 (1 point) Create a profit chart. Add additional clation - New Profit with the new cost. User should be able to change the costs and see how profit would change the cost wordd be different. Assume that quantity does not dange Profit and New profit by Month Number . Pront and New pro Month 11,60 Product Betadone...y South East Cast East Prod 10 Quantity Price ROP 852 S6100 10 5 LS 309 FHBO 11s EVM 204 ERAS 5 WP 7 121 ALYTNE AN W545 5 NU 2297 . CM 5 1995 WLQ-31 S 232 WTACO 1 Date Emp 10 Region North 2 2020.06.2701 North 32000.11.15 02 4 2021.05.140 2 North S 2020.10023 2021.10070 2 201022003 8 2001.05.10 D2 North 9 20200406 East 10 2000.09 XD South 11 2021.03 14D South 12 2020.09.25 DE South 11 20:30 21:00 South 19 2020 2031 01 North 15 2010 22 0 7 South 16 2021 East 17 2001.10 South 10 2030 0 D 11 South 19 20210270 South 20 20300413 02 Noth 21 2021. 10.00 Noth 22 2030.05.2012 South 20 2001.10.30S East 42030041200 North 2010.14 12 2010 27 115 14 2301003 D 15 West 23 09112016 12345 11 2005 East 10 202111150 2005120 12010010 04 16 01.05.16 12 2017 WLOU WP EVM 14 2 3 5 11 5 WON V " TER ERAS 304 4 5 6 1 304 O 30537 PM ACSI ON - 2 5 14 NON IL 2020.11.13 15 5 w 2 2011 OM ANT A1 2 SID F H 1 O 2 D_1 3 D 2 14 D_3 5 D 4 6 D 5 7 D_6 8 D7 9 08 10 D9 11 0 10 12 D 11 13 D 12 14 D 13 15 O_14 16 O_15 17 16 18 D_17 19 D 18 20 D 19 21 0 20 220_21 230_22 240_23 25 26 27 28 B D E Name Surname Hour Rate aty Koja Jurijs 0,78 Tukums Lusis Maris 0,59 Olaine Kosinskis Romans 0,76 Jurmala Borodinou Aleksejs 8,75 Olaine Lusis Ingars 0,62 Tukums Koja Maris 0,68 Riga Okulovs Dmitrijs 0,57 Jurmala Zaharovs Romans 0,55 Olaine Klescenog Aelita 0,85 Cesis Stankevic Aleksandr 0,73 Tukums Gredzens Jorens 0,66 Riga Kreslins Mareks 0,7 Cesis Muiznieks Janis 0,42 Jurmala Kalnins 2gmars 0,65 Cesis Dubika Aelita 0.89 Olaine Abolins Janis 0,4 Olaine Puhovs Igors 0,53 Riga Visaks Janis 0,54 Olaine Bertins Andris 0,4 Tukums Innuss Janis 0,78 Tukums Zalds Janis 0.87 lumala Abols Martins 0,66 Tukums Titko Valerijs 0,92 Olaine 30 31 32 33 35 ac 17 1 Name F E G H A Zool 10 Fun Trax 1 Estheco 2 Mvstop 3 Final 4 vafone 5 Fax Find Golding 7 Fresheco Spartip 9 Donlux O Mila Sano Mathilex 2 Saosonsol 23 K-rap 24 Volotstad Es Betadone 25 Warmjob 27 Fresh Lott 28 C 3.55 ERA 75461 11,86 FH-8285 13.08 IGP-33517 10,91 Q-7546 7,96 PPM-5383 10,64 CFM-6418 1,19 20-2541 10,18 JWP-4038 9,19 UBL-38541 1,67 0 3512 0,73 WTA-6427 12,98 IFM-7082: 7,43 HOT-7829 11,66 TEJ-37942 10,36 WHF-4546 2,31 ROP-8527 13,6 AZC 5310 5,01 EVM-3434 21,1 ZUZ-47368 D 30,18 29,41 29,52 25.27 27,82 24,91 25,41 28,45 29.4 27,36 28,60 27,45 32,59 30,29 35 29,36 34,45 30,29 29,64 30 31 2 23 35 17 38 39 42 4 36 0 Task 4 (1 point) Create a profit chart. Add additional clation - New Profit with the new cost. User should be able to change the costs and see how profit would change the cost wordd be different. Assume that quantity does not dange Profit and New profit by Month Number . Pront and New pro Month 11,60 Product Betadone...y South East Cast East Prod 10 Quantity Price ROP 852 S6100 10 5 LS 309 FHBO 11s EVM 204 ERAS 5 WP 7 121 ALYTNE AN W545 5 NU 2297 . CM 5 1995 WLQ-31 S 232 WTACO 1 Date Emp 10 Region North 2 2020.06.2701 North 32000.11.15 02 4 2021.05.140 2 North S 2020.10023 2021.10070 2 201022003 8 2001.05.10 D2 North 9 20200406 East 10 2000.09 XD South 11 2021.03 14D South 12 2020.09.25 DE South 11 20:30 21:00 South 19 2020 2031 01 North 15 2010 22 0 7 South 16 2021 East 17 2001.10 South 10 2030 0 D 11 South 19 20210270 South 20 20300413 02 Noth 21 2021. 10.00 Noth 22 2030.05.2012 South 20 2001.10.30S East 42030041200 North 2010.14 12 2010 27 115 14 2301003 D 15 West 23 09112016 12345 11 2005 East 10 202111150 2005120 12010010 04 16 01.05.16 12 2017 WLOU WP EVM 14 2 3 5 11 5 WON V " TER ERAS 304 4 5 6 1 304 O 30537 PM ACSI ON - 2 5 14 NON IL 2020.11.13 15 5 w 2 2011 OM ANT A1 2 SID F H 1 O 2 D_1 3 D 2 14 D_3 5 D 4 6 D 5 7 D_6 8 D7 9 08 10 D9 11 0 10 12 D 11 13 D 12 14 D 13 15 O_14 16 O_15 17 16 18 D_17 19 D 18 20 D 19 21 0 20 220_21 230_22 240_23 25 26 27 28 B D E Name Surname Hour Rate aty Koja Jurijs 0,78 Tukums Lusis Maris 0,59 Olaine Kosinskis Romans 0,76 Jurmala Borodinou Aleksejs 8,75 Olaine Lusis Ingars 0,62 Tukums Koja Maris 0,68 Riga Okulovs Dmitrijs 0,57 Jurmala Zaharovs Romans 0,55 Olaine Klescenog Aelita 0,85 Cesis Stankevic Aleksandr 0,73 Tukums Gredzens Jorens 0,66 Riga Kreslins Mareks 0,7 Cesis Muiznieks Janis 0,42 Jurmala Kalnins 2gmars 0,65 Cesis Dubika Aelita 0.89 Olaine Abolins Janis 0,4 Olaine Puhovs Igors 0,53 Riga Visaks Janis 0,54 Olaine Bertins Andris 0,4 Tukums Innuss Janis 0,78 Tukums Zalds Janis 0.87 lumala Abols Martins 0,66 Tukums Titko Valerijs 0,92 Olaine 30 31 32 33 35 ac 17 1 Name F E G H A Zool 10 Fun Trax 1 Estheco 2 Mvstop 3 Final 4 vafone 5 Fax Find Golding 7 Fresheco Spartip 9 Donlux O Mila Sano Mathilex 2 Saosonsol 23 K-rap 24 Volotstad Es Betadone 25 Warmjob 27 Fresh Lott 28 C 3.55 ERA 75461 11,86 FH-8285 13.08 IGP-33517 10,91 Q-7546 7,96 PPM-5383 10,64 CFM-6418 1,19 20-2541 10,18 JWP-4038 9,19 UBL-38541 1,67 0 3512 0,73 WTA-6427 12,98 IFM-7082: 7,43 HOT-7829 11,66 TEJ-37942 10,36 WHF-4546 2,31 ROP-8527 13,6 AZC 5310 5,01 EVM-3434 21,1 ZUZ-47368 D 30,18 29,41 29,52 25.27 27,82 24,91 25,41 28,45 29.4 27,36 28,60 27,45 32,59 30,29 35 29,36 34,45 30,29 29,64 30 31 2 23 35 17 38 39 42 4 36 0 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started