Emergency Services Analytics - Power BI Challenge 14 Submission, PART 1

[@EnterpriseDNA]

Get involved in our latest Power BI Challenge - forum.enterprisedna.co/t/challenge-14-emergency-services-analytics/17933

[@davidakanji]

This is so great Sam

[@EnterpriseDNA]

Hi david cenna, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@fadwa2413]

I have a question i am wrote this measure Intial call by date = CALCULATE( [Total calls], USERELATIONSHIP('Date'[Date],'Call Timing'[call time date]) ) and it gives me the exact same number as Total Sales ? How ?

[@EnterpriseDNA]

Hello Fox CODE, Thank you for posting your query onto our channel. Well, just based on the measure that you've provided we're not in a position to comment anything. It's always difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@JMcLeodKC711]

Great presentation. I think we are missing two valuable facts: the distance from the ambulance station to the patient and the distance from the patient house to the hospital. They should be able to pull the odometer readings. We're also missing the time stamp for when they left the patient home for the hospital. This would allow us to calculate time at the patient location.

[@musthakhahammed6535]

Exactly brother. Really missing.

[@zimprince9664]

There might be a way. I mean this data is based on real life hospitals right. You can use Google maps to get additional data, maybe distance. Use distance to get the average speed for each dispatch. Just a thought

[@JMcLeodKC711]

@@zimprince9664 I does not need to be that complicated. There were actual ambulances involved with actual odometers involved.