Need PowerBI Expert to help me with building an extensive monitoring system (via email, chat and file transfer)

I am beginning to learn PowerBI. I am proficient in Excel, but I still have a lot to learn in PowerBI.

I would send over testfiles and taskswhat measures to create and would expect you to perform the necessarymeasures and visualizations, send the file back and write an explanation for each task so i learn how to do them myself.

the first file and tasks are in the attachement. This first tasks should be quite simplle, but get more difficult with follow up projects. This is qute time critical, so I wouold hope for reponse times of 24h for smaller things and 48h for larger tasks.

There will be a number of follow up projeccts.


the tasks are as text box in the visualization.

here is the first one as text so you get an idea:




This is monitoring for COVID tests at a lab. Samples are collected by companies at various times, are then picked up, brought to the lab and then start analysis. Results can be positive "pos" or negative "Neg". I want to monitor various aspects of this process.





TASK 1:

Calculate Calendar Week of collection date as Measure



TASK 2:

Show number of Barcodes per Calendar Week in a table



TASK 3:

Category contains Company A and A2, which are different units of the same company. Combine these into one number. Category also contains company D and D2. Combine these. Now make a table with number of barcodes for each company, with these combined into one.



TAKS 4:

Each line in data is one sample for COVID Analysis. Show for each Company in category:

The number of samples in total
The number that are Result "Pos"
The Number of samples that are result "Neg"
The Percentage, that is "Pos"


TASK 5: Calculate the time the analysis took:

You see collection date and time. You also see Analysis start Time and date. Calculate how many hours it took.

Now you see End Date and Time. Calculate how long that took. The difficulty is, some steps are after midnight on the next day.



Now show a table with minimum, average and maximum time for both steps.





TASK 6:

Make a new Measure, that shows if the analysis took more than 35h ("Yes") or less than 35h ("No").
Make a new Measure, that shows if the analysis took more than 20h ("Yes") or less than 20h ("No").


TASK 7: Determine the Pickup Time of the sample

If Collection is before 10:00, the Pickup time is at 10:00. If it is after 10 but before 18:00, the pickup is at 18:00. If it is later, the Pickup is at 23:59. Now make a measure that gives me the pickup-Time.

feel free to charge me every hour of work that has started.