Find Jobs
Hire Freelancers

Power BI Report Design

£250-750 GBP

Cancelado
Publicado hace casi 7 años

£250-750 GBP

Pagado a la entrega
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.
ID del proyecto: 13577760

Información sobre el proyecto

34 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
34 freelancers están ofertando un promedio de £478 GBP por este trabajo
Avatar del usuario
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 en 4 días
4,9 (135 comentarios)
6,4
6,4
Avatar del usuario
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 BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
£500 GBP en 20 días
5,0 (28 comentarios)
5,4
5,4
Avatar del usuario
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 our devs can work on Your project without delay. We have years of working on projects related on any available CMS, from "scratch" with core php and php-frameworks(Yii/Yii2, Laravel, CodeIgniter), JavaScript, jQuery, AJAX, HTML5, CSS3, Bootstrap, javascript-frameworks, 3d desidg, graphic design etc. However, I shall discuss about the requirements and functionalities in details to have a better understanding about time frame and price. We are glad to chat with You and discuss all in details. Contact us and we will reply immediately. Waiting for Your reply! Best regards, Webbook team
£450 GBP en 8 días
5,0 (1 comentario)
5,0
5,0
Avatar del usuario
- 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 addtiional information could be garnered can be looked into to present it in Power BI reports. - Have done extensive data analysis, graphing using Excel, Crystal Reports and exposed to Power BI reports. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
£300 GBP en 7 días
5,0 (30 comentarios)
4,7
4,7
Avatar del usuario
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 support teams. Involve in planning, estimation and allocation of work packets, Analyzing and translating business requirements to technical requirements and architecture. I have good knowledge & experience in below tools & tecnologies. Azure (Intelligence & Analytics) Power BI (Desktop & Service) MSBI (SSIS,SSAS(Tabular),SSRS) .NET Technologies(Web technologies & C#) SQL Server Please consider me.
£333 GBP en 5 días
4,9 (22 comentarios)
4,7
4,7
Avatar del usuario
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 you will get a quick response from my end.
£773 GBP en 20 días
4,4 (3 comentarios)
4,3
4,3
Avatar del usuario
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 interactive KPI dashboards using pivot tables, slicers, and graphs. Projects range from long-term support of data analysis and visualization needs to short-term specific projects. Skills: - Excel/VBA Automation - Excel Dashboards & Reporting (Data Visualization) - QlikView/QlikSense/Tableau (Data Warehousing and Business Intelligence) - Microsoft Access (SQL) - SAS / R Language - Data Analytics (Executive Decks/Analysis - Key Results and Insights) - Commercial Insights and Analytics Once I receive a project, my biggest priority/focus is to ensure that quality work is delivered always on time. Give me an opportunity, I will deliver you the quality. Warm Regards, Rohit Ahuja |
£555 GBP en 2 días
5,0 (7 comentarios)
3,4
3,4
Avatar del usuario
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 pe: jikenjd
£250 GBP en 2 días
5,0 (10 comentarios)
3,2
3,2
Avatar del usuario
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 en 2 días
4,3 (5 comentarios)
2,9
2,9
Avatar del usuario
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, financial modeling for various clients. I have designed various Dashboard in Power BI. I am also an excel expert and have done numerous projects. I have understood your requirement and can quickly deliver the task. Rest assured of a quality outcome. Message me so that we can discuss the details and take it forward. Regards, Dinesh V
£450 GBP en 7 días
4,7 (7 comentarios)
2,8
2,8
Avatar del usuario
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 spelling mistakes. I hope you will like my proposal and give me a chance to get awarded. Regards, Raghav
£250 GBP en 5 días
4,8 (1 comentario)
0,4
0,4
Avatar del usuario
Bid Summmary We, Ieota Technologies aims at providing services in the field of Development with various technologies for APP/WEB Development . Simply concentrating on bringing more innovation in this world,
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
information technology-driven business solutions that meet the strategic objectives of our clients globally. we provide solutions on sharepoint,cloud, mobile apps and microsoft technologies for a dynamic environment where business and technology strategies converge. meeting your business priorities requires a team of both astute business strategists and technical experts with broad industry experience.of-fshoresoftware application development company, experts from india having range of skills available in ourin-house staff: dedicated: android developer, ios developer ,website developer, ecommerce developer, php developers, asp.net developer, asp programmer, web designer, vb/vb.net developer, admin staff and more… thanks & regards
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Plenty of experience working in Excel and modeling databases. Could perform the application to a localhost as well to a webserver.
£250 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project description and confident to accomplish your project. I am an individual developer and you will be working directly with me if we proceed work on this project. My key skills are – 1) Ruby 2) Ruby On Rail 3) Angular JS 4) Node JS 5) PHP with Codeigniter and Laravel Framework. 6) App development Let's initiate our chat so we can proceed towards the conclusion of this project scope and give it a start as soon as possible. Thanks & Regards
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have good knowledge and hands on experience in MS-office and database like SQL PLSQL ORACLE and DBA. My plus point for this project is i have good typo-speed and i hope if i get a chance i can reach your exceptions and i can deliver in time.
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Having 16+ years of experience in Database and Business Intelligence using MSSQL including MSBI/PowerBI technologies. Handson experience in making PowerBI desktop dashboards and writing DAX code.
£611 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Bid Summmary i studied the whole bid. i will do your job in the most cheap but efficient way. I assure you that your job will be done.
£444 GBP en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i have worked on similar power BI projects. I understand the do's and don't s of power bi and with my prior experience we can walk on right track for desired destination
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir and Madam, My name is Hai. I currently work as analyst for a technical company base in Germany. Most of my job is related to PowerBi and PowerPivot. I am very confident with my skill and i am sure that i can complete your job with the best result. I hope that i have chance to work to with you. Thank for reading. Best regards, Hai Tran
£277 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Woking, United Kingdom
0,0
0
Miembro desde ene 26, 2015

Verificación del cliente

Otros trabajos de este cliente

Research Writing
£18-36 GBP / hour
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.