Creation of an online Power BI front end.
I need to create a PowerBI dashboard to compare and visualise some data for surveys we are undertaking for a Client. I would like the dashboard to be initially in Power BI desktop but ultimately I would like it uploaded to Power BI online so my Client can query the data himself.
The data is contained in the following four excel tables
A. Timetable data - Room ID, booking start time, booking end time, booker ID
B. Booker data – Booker ID, Faculty, school, department
C. Room Data – Room ID, Survey ID, Building, Floor, Room Type, Capacity
D. Survey Data – Survey ID, Survey Timeslot (an hour time slot), utilised, observed occupancy
The dashboard needs to be able to produce the following data views (perhaps as individual tabs):
1. Using all four tables - a comparison of booked rooms vs actually used rooms. This needs to have drop down menus / slicers to allow views of booked vs actual by faculty, by school and by department. I would be interested in your ideas on how this can best be visualised but think that an overall visualisation of % booked vs % actually used plus then a breakdown of the next level down as a bar graph showing % actual vs. booked
2. A visualisation of the observed use of each room over time in terms of % of times the room was observed in use vs overall % of observations. This would need to be able to be summarised by building and room type
3. A visualisation of the pattern of use over time – as a column with the axes observed number of occupants vs capacity of the room (% use) and time. We would need to be able to summarise and drill down by for all rooms building, floor and room by room and filter by different room types
4. A comparison (as a column or bar chart) showing peak and average utilisation by room – again with the ability to summarise by room type.
5. A graph showing the calculated overall % utilisation of the actual room, calculated as follows:
Utilisation = Frequency of observed use (as a % of overall observations made on that room) x average observed occupancy of the room
At the moment we have all data as static data tables in excel however long term we would like to be able to update the timetable and utilisation data weekly so the dashboard then reads the latest data tables so it would need to be set up with this in mind. I have some examples of the various graphs above (we do the report as a very static report in powerpoint) if these help.
It would be great if you could let me have a proposal and timescale for doing this work. If this goes well we also wish to automate our general report production via Power BI if possible for all our other Clients so that they have interactive online reports rather than our static ones using excel and powerpoint.
Bu iş için 34 freelancer ortalamada £478 teklif veriyor
Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Hi We can automate the report to be updated daily on the cloud from the excel files but we have to setup a Gateway to do so. Currently I am working at big financial organization in which I am responsible for the Daha Fazla
Hi Thanks for posting this requirement. I have a great experience working on Power BI dashboards Please have a look on my previous work: • Liquor Industry – Brand Analysis – [login to view URL] • Medical Daha Fazla
Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Daha Fazla
Hi, I'm expert in power BI and project management. You can check my profile here, on linkedin [login to view URL] where professional certifikations are published and also you can view my latest r Daha Fazla
Definitely there are ways to automate using schedule refresh , direct query. we can think of. To introduce myself , I have 12 years of experience in Microsoft technologies and leading and mentoring development and s Daha Fazla
- Based on the available four tables in Excel, can get the reports on the Utilization % , peak utlilization, comparions between rooms, on statistics on a room. - From the available structure of the field what addtiio Daha Fazla
I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.N Daha Fazla
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Daha Fazla
I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Daha Fazla
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7.4 years experience in SQL and 4.7 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky p Daha Fazla
Bid Summmary Hi Sir, I am having 10 years of experience in Microsoft Technologies including power bi report. Recently we are working on power bi report. I can show you right away
Hi, You have made a step in right direction of using Power BI for analysis and dashboarding. I am a Chartered Accountant by profession and have done projects around business planning, analysis, research, financi Daha Fazla
Hi, I am a professional Business Intelligence Consultant with over 3 years of experience. I have read your request and interested to work for you as I am expert of Data Visualization in Power BI, DAX functions etc and Daha Fazla
Hello there! First of all, congratulations for your briefing, it's really good and it has all necessary for a good work on Power BI. I have a good experience on BI tools not just on techical stuff but in interface wi Daha Fazla
Hi employer, I like your project's theme and I wish to write on it.I am a software engineer and hence I think I can do this work. I promise to provide quality work in given time and price with no grammar and spell Daha Fazla
This is something I can do for you. I'm an BI developer, working with Power BI daily. I also use R and Python for visualisations of the NHS (Cardiology research). The more information you can provide, in terms of w Daha Fazla
My Varied experience in Microsoft PowerBI puts me in a position to apply for this project. The things I have done from developing appealing reports on desktop version with attractive visuals to deploying onto cloud and Daha Fazla
Hi - Thanks for considering me for this roll. I am a Power BI expert with years of data analysis experience working until recently as a Global Data Analyst for a large multinational market leading clinical trials orga Daha Fazla