Completed

Flexible Azure PowerBI Graphing of IoT Sensor Variables over time, UI design, report generation

I have 6 sensors in a construction site. Each of sensors report 1. A raw sensor output, 2. a PSI output, 3. a height (mm) output, 4. a temperature output, 5. a barometric output, 6. a humidity output. The sensors report their variables every 5minutes.

I need a UI through powerBI (or another portal) where I can view the history of each sensor variable over time as a graph. The length of time should be settable with a date select input. It would be good to have tick boxes to turn on/off each sensor in the graph.

It would be good to be able to overlay a 2nd variable on a secondary axis (as you can do in excel). For example I might graph all 6 sensors for mm height reading, then overlay temperature from one or more of them. The temp is going to be in 1/1000 of degrees celcius ( i.e. 24'C is 24000 ) and the height is mm, between 0..30000.

I would also like to be able to download a csv or xls sheet of all variables for each sensor, arranged in columns next to their timestamps. ie. <timestamp_var1>,<value_var1>,<timestamp_var2>,<value_var2>, etc with Var1 always same column over time.

I need someone to setup the backend in Azure, to make it all work. I can share screen shots of what we have today which is harvesting and storing the sensor data effectively, it's just not meeitng the UI needs.

Thanks for your time!

Skills: Power BI, Internet of Things (IoT), User Interface Design, Excel, Microsoft Azure

See more: motion sensor time project design, iot sensor web app, azure powerbi, iot sensor simulator, iot sensor data storage, iot sensor development kit, da14583 iot sensor development kit, da14585 iot sensor, azure web app iot hub, iot sensor data, iot sensor data analytics, which can be a sensory input to an iot sensor for decision making?, iot sensor manufacturers in india, iot sensor installation, azure function to iot hub, iot based real time ecg monitoring system using cypress wiced, azure app service docker environment variables, ble iot sensor, predict equipment failure using iot sensor data, aws iot just-in-time provisioning example

About the Employer:
( 4 reviews ) Elanora, Australia

Project ID: #28218064

Awarded to:

(12 Reviews)
4.8

15 freelancers are bidding on average $37/hour for this job

(60 Reviews)
6.6
(96 Reviews)
6.4
(4 Reviews)
5.4
Kartheekreddyn

Hi I can help you with building and maintaining Power BI dashboards and the underlying database . I have experience in writing complex SQL queries, DAX measures, and building Excel models & Power BI dashboards from s More

$30 AUD / hour
(7 Reviews)
3.7
macroenergy

Thanks for Freelancer which gives chance to meet you. I hope you are good. I’m Electronics engineer who have 25 year experience on analog design, hardware design, power electronics, motor control, microcontroller cod More

$25 AUD / hour
(2 Reviews)
3.5
ImtiyazAliJafri1

Hello, Hope this proposal finds you well. Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stag More

$38 AUD / hour
(1 Review)
2.0
alekwasser86

Hi, I am a full-stack developer with 10 years of experience. I have working experience with UI/UX designing. Here are some examples of my past projects: - A German Tinder-like dating app - [login to view URL] - Tour, h More

$50 AUD / hour
(0 Reviews)
0.0
ayushjain951

i can design this kind of website or ui as per your requirement it will take a week of time i have experience in cloud aws and azure also i have been working with iot devices from more than a year here is my linkedin More

$50 AUD / hour
(0 Reviews)
0.0
tangramua

Hello Brent S.,   We have 20 years of strong experience in Excel, User Interface Design, Internet of Things (IoT), Power BI, Microsoft Azure, as a result, we can successfully complete this project.   Please, review our More

$25 AUD / hour
(2 Reviews)
0.2
jinc772

Hi there. I have many experiences for Iot projects. I got really excited with your project and I can say that really matches to my skills. Good luck with your work and really look forward to meet you soon. Regards.

$38 AUD / hour
(0 Reviews)
0.0
naveedchulari

i am sure i can easily complete this project within the given time as i have over 10 years of experience in data entry. i will start right now. thanks.

$25 AUD / hour
(0 Reviews)
0.0
girishshetty126

Hello Greetings, Im a certified PowerBI and Azure Professional with 10+ years of Technical and Functional experience as Business Intelligence Developer, Data Analysis & Visualization, Advanced Analytics, Data Warehous More

$39 AUD / hour
(0 Reviews)
0.0
Ushyaku

Hi there, You’re looking for a mobile app developer and this is exactly what we specialise in. Talk about a perfect match! I’ll keep this short and we can go into more details when we chat. Before anything else, I More

$38 AUD / hour
(0 Reviews)
0.0
jain206542

Gone thru your requirements. I am a Master's in Engineering possess 18 years experience of which International experience of 10 years in the gulf. We have our own freelancing firm where you will find expert for all sor More

$25 AUD / hour
(0 Reviews)
0.0