Power BI Report Design

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.

Skills: Excel, SQL

See more: report aided power system design analysis, power active filter design, graphic design report cover page indesign template, excel, sharepoint, user design report runtime vbnet, design report hotel, domain crawler project design report, design linear phase fir lowpass filter, ssrs design report blackberry, microsoft access inventory form shareware edu design report, poster design report, write lighting design report, design web invision power board, design appropriate fir low pass filter matlab, design report aspnet, graphic design report layout styles, design report excel 10g, messenger project design report, design report openbravo erp

About the Employer:
( 0 reviews ) Woking, United Kingdom

Project ID: #13577760

34 freelancers are bidding on average £478 for this job


Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

£500 GBP in 4 days
(135 Reviews)

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 More

£500 GBP in 20 days
(28 Reviews)

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 More

£250 GBP in 3 days
(11 Reviews)

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 More

£450 GBP in 8 days
(1 Review)

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 More

£600 GBP in 10 days
(33 Reviews)

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 More

£333 GBP in 5 days
(22 Reviews)

- 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 More

£300 GBP in 7 days
(30 Reviews)

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 More

£500 GBP in 15 days
(22 Reviews)

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 More

£773 GBP in 20 days
(3 Reviews)

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 More

£555 GBP in 2 days
(7 Reviews)
£750 GBP in 20 days
(2 Reviews)

Please review my profile. 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 More

£250 GBP in 2 days
(10 Reviews)

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

£555 GBP in 2 days
(5 Reviews)

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 More

£450 GBP in 7 days
(7 Reviews)

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 More

£250 GBP in 7 days
(2 Reviews)

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 More

£555 GBP in 3 days
(1 Review)

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 More

£250 GBP in 5 days
(1 Review)

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 More

£500 GBP in 7 days
(0 Reviews)

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 More

£388 GBP in 20 days
(0 Reviews)

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 More

£277 GBP in 10 days
(0 Reviews)