İptal Edildi

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.

Beceriler: Excel, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Woking, United Kingdom

Proje NO: #13577760

Bu iş için 34 freelancer ortalamada £478 teklif veriyor

schoudhary1553

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

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(135 Değerlendirme)
6.4
mpalgeo

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

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
5.4
ReflexiveData

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
5.1
webbookstudio

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

in %bids___i_period_sub_35% gün içinde450%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
5.0
tomislav1975

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

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)
5.2
codedeveloperin

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

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.7
satishtl

- 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

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
4.7
AliSafder

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

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.4
prashushinde9

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

in %bids___i_period_sub_35% gün içinde773%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.3
fb57e1f6608abfb

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.4
in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.0
vw7590795vw

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.2
pratik30ei

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.9
GuruExcel

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

in %bids___i_period_sub_35% gün içinde450%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
2.8
farrukhcheema23

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
2.8
OtavioSNeto

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.6
scribblerraghav

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.4
wstockbridge

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

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
vipul22193

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

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Leecole1979

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

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0