Completed

2 Power BI dashboards / pbi reports

The goal is to create 2 Power BI reports showing if facilities/departments/units at various facilities are over or under capacity. This is a start of many reports and right now I am looking for someone who knows PBI inside out, who can explain to me how he did this project, and how cleanly he writes the code.

I have 3 facilities that have various departments, and each department can have multiple units and they can be physically located in that facility or be virtual (but still allocated to that facility).

I also have a maximum # of people that can be in these units, and people are constantly moving. The report will show me a breakdown for each facility/department/unit and at what capacity we are currently at. It will also show me a 7-day trendline.

I will provide an excel with 2 tables (this will eventually be in MS SQL). See attached PDF for more info.

Table1: UnitInfo. It lists all units for facilities, the max occupancy for that unit, what department the unit belongs to, and the type (virtual vs physical unit)

I can have a Support unit that is part of IT department. This Support unit can have up to 10 people. It’s of type physical since it’s physically located in facility #1.

Table2: UserLocation. It contains info on which unit the users are currently in or where they were. People can move from unit to unit in a matter of minutes and we have a timestamp of when they do so. People can also completely leave the facility and therefore shouldn’t be counted toward current occupancy (datetime should be used for trendlines).

Power BI report 1 could show me totals, capacity % for facilities,, and virtual vs physical. When we are nearing capacity at let’s say 50%, colors should be orange. When at 75% or more, color should be red

Report 2 could show the breakdown for all units and departments (separating physical vs virtual) together with a 7 day trendline.

If this project is done well, future projects, we will report on users (different tables that I am not providing here), how long a person has been in the facility/unit, where they went, reasons for, more trendlines, etc. Future reports will get more complicated.

To bid, please mention the word "trendline" so that I can see you read the job description. I don't like getting generic answers that talk about how you create wordpress websites.

More information is in the PDF.

Skills: Power BI, Tableau, Business Analytics

See more: power bi reports vs dashboards, power bi reports examples, power bi reports tutorial, best power bi dashboards, power bi api get reports, principles for designing power bi reports, power bi best dashboards, power bi angular 2 example, power bi embedded angular 2, power bi sample dashboards download, power bi reports, sharing power bi reports with external users, what are two reasons for uploading excel reports to power bi?, power bi insurance dashboards, best power bi dashboards examples, power bi copy visual between reports, power bi partner dashboards, power bi dashboards, microsoft power bi dashboards step by step, best power bi reports

About the Employer:
( 18 reviews ) Kelowna, Canada

Project ID: #28009549

Awarded to:

ksanalytics

Hi, I am Sangamesh K S with 5 years of experience in Market Research and Product launch. I am well versed with powerbi and Tableau. I have a dedicated team of 5 Data visualization experts and have succefully complete More

$120 CAD in 5 days
(3 Reviews)
3.2

32 freelancers are bidding on average $221 for this job

(43 Reviews)
6.1
schoudhary1553

Hi, Greetings! ✅checked your project details: 2 Power BI dashboards / pbi reports ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projec More

$340 CAD in 4 days
(6 Reviews)
5.4
(15 Reviews)
5.4
(11 Reviews)
5.3
dataguru2110

Hi I have 10 years of experience in Data Analysis, Data warehousing ,Business Intelligence and certified Power BI Expert. I have built so many Power BI reports and have experience in building report using different da More

$300 CAD in 15 days
(20 Reviews)
4.8
aimefx

Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact More

$200 CAD in 7 days
(17 Reviews)
4.8
Udeep

Trendline - I'm a Senior BI Consultant with 7 years of experience working closely with the business and translating the requirements to BI solutions. I would like to discuss the project further, please feel free to c More

$250 CAD in 4 days
(14 Reviews)
4.3
abhilesh99

Hello Sir/madam, Trending I have gone through the project requirements. I have more than 3yrs of experience in Microsoft BI technologies including SQL and Power BI. I have completed Microsoft certifications for SQL, P More

$150 CAD in 7 days
(7 Reviews)
4.1
Kartheekreddyn

Trendline Hi I can help you in building the 2 Power BI dashboards which can provide you the required insights. I have experience in building SQL, Excel models & Power BI dashboards from scratch and also making chang More

$250 CAD in 7 days
(7 Reviews)
3.7
jbaserga

Hello. I am a Senior BI Consultant with more than 8 years in the field. I have vast experience in data modelling and visualization, so I think I can be of help in your project, as I will try to create a model that refl More

$250 CAD in 10 days
(5 Reviews)
3.7
dsamwork20

Trendline Power BI | DAX | SQL | Excel | Power Query | FREE Consultation Please read through and respond with a message. If there is anything you would want me to improve in my proposal writing, please suggest. Hi, More

$300 CAD in 15 days
(4 Reviews)
3.4
chirag9700

Hi, I hope you are well. I have gone through the requirement and it does meet with my experience so I want to discuss it in more detail. I have 6+ years of experience in SharePoint (Well versed with all the versions More

$250 CAD in 5 days
(1 Review)
2.8
Gameel92

#trendline Hi, I am a professional data analyst since 2016. I created many reports using power [login to view URL] your project. I am thinking of arranging facilities departments and units first in a hierarchy and then crea More

$100 CAD in 1 day
(5 Reviews)
2.5
hillaryjustin73

Hello, I am a Business Intelligence Analyst with 2 years of experience in reporting, dimensional modelling, data extraction, enrichment, transformation (ETL). Technology Stack: Power BI , R, and Tableau. Accomplishm More

$200 CAD in 4 days
(2 Reviews)
2.5
girishshetty126

Hello Greetings, trendline I have went through the requirements and the charts shown in the pdf and I have recently worked on a similar engagement using powerBI and MySQL. And I’m available to take the task ASAP. Ab More

$278 CAD in 2 days
(4 Reviews)
2.4
marasinghe82

Dear Sir, trendline Many Thanks for the clear requirement document. I can start today if you are ok to proceed with me please reply me for details. I am a Tech-lead on Business Intelligence with more than 14 years of More

$200 CAD in 2 days
(1 Review)
2.0
freelancer96500

Hi, I check your requirement. this is awsome work for me. i have 9 years+ experience in Advance Excel, VBA Macros, Power Bi Visualization using DAX and Data Entry/Processing. My Intention is only provide accurate and More

$221 CAD in 4 days
(1 Review)
1.1
DIGITALJOY

Already I have worked with many simple to complex level Power BI projects; Here are the details: I have developed BI applications utilizing BI stack, Power BI, Tableau etc. Have expertise with reporting services, Powe More

$250 CAD in 7 days
(0 Reviews)
0.0
minaximarvaniya

Hello there!! I hope you are doing great. I just read your job posting and I can certainly assist you for the same. ------------------ ABOUT ME:- ------------------ -I have over 5 years of experience in the More

$200 CAD in 5 days
(0 Reviews)
1.4
infosciencelabs

Hello I found your job posting read the description and believe I could be the right fit for this job. I'm a seasoned BI developer and have worked on several Power BI projects, I offer 10+ years of experience and can More

$300 CAD in 3 days
(0 Reviews)
0.0