Power BI Report Development - Airline company

Remote, USA Full-time
Job Description We are an airline company seeking an experienced Data Analyst / Power BI Developer to build a dashboard that visualizes key operational and maintenance indicators for our fleet. I will provide the data in CSV format (with defined column names). It is important to keep these column names intact, since the final production version will connect directly to our SQL database. The dashboard should allow us to analyze and visualize the relationship between flight utilization and maintenance needs. ⸻ Objectives / Deliverables 1. Hours-to-Cycles Ratio (H:C) • Calculate and visualize the ratio of Flying Hours / Flying Cycles per aircraft. • Display trends over time (e.g., monthly/quarterly). 2. Jobs per Aircraft (Maintenance Works) • Integrate maintenance job records (TipoTrabajo, SubtipoTrabajo, Titulo, etc.) with the utilization data. • Show correlation between H:C ratio and number of jobs performed for each aircraft. 3. Maintenance Threshold Forecast (Stand-By Measure) • Implement a third measure that estimates when each aircraft will next require scheduled maintenance. • For this prototype, use example thresholds (e.g., every 500 flying hours or 300 cycles) to calculate remaining hours/cycles until the next maintenance event. • Display visually (timeline, progress bar, or chart) how close each aircraft is to the threshold. 4. User-Friendly Dashboard in Power BI • Allow filtering by aircraft, time period, job type, etc. • Clearly highlight: • Current H:C ratio • Maintenance job counts • Estimated date/remaining hours until next scheduled maintenance ⸻ Requirements • Strong experience in Power BI (DAX, Power Query, relationships). • Ability to work with CSV input first, keeping all column names identical for future SQL migration. • Experience in aviation data, fleet analytics, or maintenance tracking is a plus. • Good communication: provide documentation on calculations and assumptions. ⸻ What I Will Provide • CSV exports of: • Aircraft utilization (hours, cycles, TSN, CSN) • Maintenance jobs (with aircraft matricula and job details) • Example thresholds for maintenance (e.g., 500h / 300 cycles). ⸻ Deliverable • A Power BI file (.pbix) with the described dashboard, using the provided CSVs as the data source. • Documentation of all measures/calculations, so we can later replicate them on the SQL source. ⸻ Budget & Timeline • Fixed price project (please propose). • Expected timeline: 1–2 weeks for first version. Apply tot his job Apply To this Job

Apply Now

Similar Jobs

Remote Amazon Data Entry Jobs - No Experience - Part-Time

Remote, USA Full-time

Amazon Work-From-Home Jobs - Part-Time Positions Available

Remote, USA Full-time

Delta Remote Careers: Airlines Jobs with Work-From-Home Opportunities

Remote, USA Full-time

Remote Airlines Jobs At American Airlines - Part Time

Remote, USA Full-time

Remote Customer Support Associate - Join the Amazon Team!

Remote, USA Full-time

Remote Brand Specialist Opportunity at Amazon - $30-$35/Hour

Remote, USA Full-time

[Fully Remote] Amazon (Looking To Fill 250) - Work-From-Home Jobs

Remote, USA Full-time

Your Career Takes Flight: American Airlines Remote Customer Support Representative - Philippines

Remote, USA Full-time

Remote Data Entry Opportunity with Amazon: Launch Your Career with a Global Leader

Remote, USA Full-time

Remote Data Analyst Opportunity at Southwest Airlines - $26/Hour

Remote, USA Full-time

Sr Specialist OSP Design Engineer

Remote, USA Full-time

**Experienced Data Entry Specialist (Work From Home) – Aviation Industry Data Management**

Remote, USA Full-time

Senior Fintech Lead

Remote, USA Full-time

Remote Opportunities in Charlotte, NC

Remote, USA Full-time

Jira Developer - Beacon Systems, Inc

Remote, USA Full-time

Apple Online Customer Support Representative

Remote, USA Full-time

Creative Operations Associate

Remote, USA Full-time

Certified Pharmacy Technician – Amazon Store

Remote, USA Full-time

Remote Medical Transcription Jobs - Become a Remote Chat Support Agent in Medical Transcription, Earning $25-$35/hr

Remote, USA Full-time

Entry-Level IT Support Associate - Overnight (X)

Remote, USA Full-time
Back to Home