
In Progress
Posted
Paid on delivery
I need a single, well-structured PowerBI report that brings together our aviation insurance statistics—Number of Aircraft, Premiums, and Claims—into a clean, reliable data model. I will supply the raw figures in several Excel workbooks; your job is to design the underlying data set, load and transform the sheets, and surface the key metrics in an intuitive, visually engaging way. The data model must support: • Bar, pie, and line visualisations for every metric • Slice-and-dice analysis by year, policy type, or any additional dimensions found in the source files • Quick comparison views so I can spot shifts in aircraft counts against premium volume and claims frequency Deliverables • A PowerBI (.pbix) file with clearly named tables, measures, and relationships • Any data-prep steps documented in Power Query so future updates are simple • A short read-me explaining how to refresh the report and where each figure originates If you already work with insurance portfolios—or, better yet, aviation risk data—you’ll recognise the quirks of premium and claims timing, which will help ensure the visuals remain accurate and decision-ready.
Project ID: 40501876
51 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
51 freelancers are bidding on average £388 GBP for this job

Hello Sir, I can build a single PowerBI report from your Excel workbooks, creating a clean data model with documented Power Query transformations, clear measures, and relationships for aircraft, premium, and claims analysis. The report will support bar, pie, and line visuals, interactive slicing by available dimensions, comparison views, and include a read-me covering refresh steps and data sources.
£250 GBP in 2 days
8.8
8.8

As a seasoned data wizard, my repertoire includes proficiency in complex data modeling, processing, and visualization using Microsoft Access, PowerBI, and Excel. I am well-versed in constructing visually appealing dashboards that provide actionable insights efficiently. My expertise will ensure not just the development of a clean and reliable data model for your aviation insurance statistics but also navigation through different dimensions and comparison views with ease, enabling you to make informed decisions at a glance. Explore my impressive profile here: https://www.freelancer.pk/u/utrathore3 . Note: "Delivering success is our commitment. To achieve this, we carefully assess your project's scope, and then provide customized costs and timelines that meet your unique needs." Thanks and Best Regards, Usman Tariq Rathore Work-Nix Solutions
£250 GBP in 1 day
8.1
8.1

Hi Sir Im excel and power bi expert I can help you to build power bi dashboard based on your excel workbook. Please share your existing excel workbook and im free now Please ping now and waiting your reply Thank you Sincerely Galih
£500 GBP in 7 days
7.9
7.9

Hi there, I understand you need a single Power BI report that consolidates aviation insurance data from multiple Excel workbooks into a clean, scalable data model with meaningful visualizations and easy-to-maintain refresh logic. I am confident I can build a professional reporting solution that transforms the raw data into actionable insights while keeping the model transparent and future-proof. My approach will be to first analyze and normalize the source workbooks, then design a structured data model with properly defined relationships, dimensions, and fact tables. Using Power Query, I will create documented transformation steps that automate data preparation and simplify future updates. I will develop DAX measures for key metrics such as aircraft counts, premium volume, claims frequency, and trend analysis, ensuring consistency across all visuals. The report will include bar, pie, and line charts, along with interactive slicers that allow analysis by year, policy type, and other relevant dimensions present in the data. I will also build comparison views to help identify relationships and shifts between aircraft numbers, premiums, and claims performance. Approximately how many Excel workbooks and years of historical data will be included in the initial dataset? I’m ready to start immediately. Warm Regards, Aneesa.
£250 GBP in 2 days
7.0
7.0

Modeling your aviation premium data... I see you need a clean, structured Power BI data model to transform your raw Excel workbooks into an interactive dashboard tracking aircraft counts, premiums, and claims timing. Here is my exact execution plan to build this for you: Power Query & Data Modeling: I will clean and merge your raw Excel sheets using Power Query (documenting every transformation step for your future use) to build a robust relational model with clearly named tables and relationships. DAX Measures & Visuals: I will write custom DAX measures to accurately handle the specific timing quirks of your premiums and claims, surfacing them in the requested bar, pie, and line comparison views so you can slice-and-dice by year or policy type. The Handoff: You will receive the fully interactive .pbix file and the concise README detailing exactly how to refresh the data when new monthly workbooks arrive. Budget & Timeline: Based on my senior rate, I will deliver this complete Power BI report and documentation for £280 GBP within 4 to 5 days. Quick question: For the premium and claims timing, are your dates recorded at the exact day level in the Excel files, or are they aggregated by month/quarter, which will dictate how I structure the central Date table in Power BI?
£280 GBP in 5 days
7.1
7.1

Hello, My name is Sneh, and I am an experienced Power BI developer with strong expertise in data modeling, Power Query, DAX, and dashboard design. I can consolidate your aviation insurance data from multiple Excel workbooks into a clean, scalable, and well-documented Power BI solution. The report will include a robust data model with clearly defined relationships, measures, and dimensions, enabling accurate analysis of Aircraft Counts, Premiums, and Claims. I will create intuitive bar, pie, and line visualizations, along with interactive slicers for year, policy type, and other relevant dimensions identified within the source data. Special attention will be given to comparison views that highlight trends and relationships between aircraft volumes, premium growth, and claims frequency. All data transformation logic will be documented in Power Query to ensure future refreshes remain simple and reliable. The final deliverables will include a fully organized .pbix file, documented ETL process, and a concise user guide explaining data sources and refresh procedures. I have extensive experience building business intelligence dashboards that transform complex datasets into actionable insights, and I would be happy to apply that expertise to this project. Best Regards, Sneh
£500 GBP in 2 days
6.2
6.2

Hello, I am a Power BI developer with experience in insurance and aviation risk data who will build a single .pbix report from your Excel workbooks. I will design a clean data model (Power Query transformations, named tables, measures, relationships) supporting bar/pie/line visuals for Aircraft, Premiums, and Claims, with slice‑and‑dice by year, policy type, and any other dimensions present. I will include a short read‑me for data refresh and source documentation. Deliverables: .pbix file + read‑me. Please share your Excel workbooks to begin. I can handle premium/claims timing quirks (e.g., written vs. earned premium). Regards, Zafar
£250 GBP in 7 days
6.2
6.2

Hi, I am a Power BI Developer with 8 years of rich experience with a background in data modeling and analytics dashboards. I am familiar with Power BI, Excel, Data Modeling, Power Query, and Data Visualization. For this project, the most important part is building a clean data model that keeps aircraft, premium, and claims metrics accurate across years and policy types. I can transform your Excel workbooks, create clear measures and relationships, build interactive visuals, and provide a short refresh guide so the report is easy to maintain. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
£375 GBP in 7 days
5.3
5.3

hi i have a lot of experience in power bi,vba ,SQL and python etc with advance level of data analysis.i can help you in all such projects with attractive dashboard ,kpi,creation and visualization.I will provide my previous projects as a sample.
£375 GBP in 7 days
5.2
5.2

Hi! I'd love to help bring your data to life with Power BI. I specialise in building clean, intuitive dashboards and visualisations that make complex data easy to understand at a glance. Whether it's KPI cards, trend charts, slicers, or drill-through reports — I know how to design visuals that actually tell a story. A bit about me: I have a strong background in data and analytics, and I've worked across IT and fintech domains, so I'm comfortable picking up your data quickly and turning it into something meaningful. I'll deliver: ✅ A polished, interactive Power BI report ✅ Clean layout with consistent formatting ✅ Slicers and filters for easy exploration ✅ A walkthrough of the final deliverable I take pride in communicating clearly throughout the project — no radio silence, no surprises. Happy to jump on a quick call to understand your requirements before we kick off. Looking forward to working with you!
£375 GBP in 7 days
4.7
4.7

Drawing on my extensive experience in deploying autonomous agents and implementing intricate automation systems, I will build for you a dynamic, reliable PowerBI report that accurately consolidates all the aviation insurance data you provide. My proficiency in transforming and loading complex datasets with efficient power query steps ensures seamless future updates of your data models. Slicing and dicing analysis is a snap for me whether by year, policy type, or any other relevant dimension present in your source files allowing for broader decision making. Given my past work with enterprise software like Odoo ERP and IoT hardware projects, including sensor networks, it's clear that I excel at seamlessly integrating diverse systems for an optimal solution. These unique skills make me well-suited for this project where intelligent systems are required to interact with enterprise software, as well as being capable of processing live sensor data -- not leaving any room for misunderstanding nuances of premium and claims timing. To sum it up, with me at the helm of this project, you can expect a thoroughly processed and diligently modeled aviation insurance dashboard that provides advanced visualization options such as bar, pie and line charts which are essential in any data analysis process. Don't forgo the chance to have an all-rounded specialist optimize your data flow with all these vital insights at your fingertips.
£500 GBP in 7 days
4.2
4.2

Power BI specialist here--------------I will surely transform your aviation insurance Excel data into a clean, scalable data model with interactive dashboards that make aircraft, premium, and claims trends easy to analyze and compare. Please ping me to get started and provide you great results. Thanks
£344 GBP in 7 days
3.6
3.6

Hi there, I have read your project requirement. You need a professional Power BI report that consolidates aviation insurance data from multiple Excel workbooks into a clean, scalable data model with interactive dashboards, trend analysis, and comparison views for Aircraft Count, Premiums, and Claims. We have experience with Power BI, data modeling, Power Query, DAX measures, insurance reporting, dashboard design, and Excel-based data transformation. We can build a well-structured .pbix solution with documented data preparation steps, optimized relationships, interactive filtering, and easy refresh processes for future updates. A few questions: ============= Approximately how many Excel workbooks and worksheets will be included in the data source? Are premiums and claims recorded by policy year, underwriting year, accident year, or multiple reporting bases? Do you already have preferred KPI calculations and business definitions, or should we help define them? Will the report be used in Power BI Desktop only, or published to Power BI Service for sharing across teams? Best Regards, Srashtasoft Team
£395 GBP in 7 days
3.5
3.5

Hi You need a single, well-structured Power BI report built from several Excel workbooks — covering aircraft counts, premiums, and claims — with a clean data model, intuitive visuals, and a setup that makes future updates straightforward. I've noted the full scope including the slice-and-dice and comparison requirements. What you'll get: A fully built .pbix file with clearly named tables, measures, and relationships supporting bar, pie, and line visuals across every metric Slice-and-dice capability by year, policy type, and any additional dimensions found in your source files Quick comparison views highlighting shifts between aircraft counts, premium volume, and claims frequency All data prep steps documented in Power Query so refreshing or updating the report is simple and self-serve A short read-me explaining how to refresh the report and where each figure originates I'm a verified freelancer and I've completed similar projects with 5⭐ feedback for accuracy and delivery. Timeline: 2 to 3 days after you share the Excel workbooks. Budget: £250 GBP Please send me a message so we can get started immediately.
£250 GBP in 2 days
2.5
2.5

BEFORE YOU HIRE ANYONE, GIVE ME 30 SECONDS TO SHOW YOU WHY I'M DIFFERENT. I recently completed a project for an aviation client, creating a PowerBI report that streamlined their insurance statistics. This resulted in a 20% increase in data accuracy and a 15% reduction in report generation time. I have over five years of experience in data analytics, specializing in insurance portfolios. My expertise ensures that I understand the nuances of premium and claims timing, crucial for accurate visual representation. Understanding your need for a well-structured PowerBI report, I will design a reliable data model with intuitive visualizations. My focus on execution, clear communication, and long-term success guarantees exceptional results. The difference between an average result and an exceptional one is usually decided before the work even begins. Regards, Patrick
£250 GBP in 7 days
1.1
1.1

Hi, there. I’m Susie Kalson, a data analyst with over 7 years of experience specializing in data visualization and modeling. I understand that managing aviation insurance data can be complex, especially when it comes to accurately reflecting changing metrics like aircraft counts, premiums, and claims. My expertise in Power BI and data processing will address the inconsistencies and challenges you face. ✅ Develop a robust data model that integrates and transforms raw data from multiple Excel workbooks. ✅ Create bar, pie, and line visualizations tailored to your key metrics for clear insights. ✅ Implement slice-and-dice functionality for year and policy type comparisons to enhance analysis. ✅ Document data-prep steps in Power Query for easy future updates to the report. ✅ Provide a user-friendly read-me for refreshing the report and tracing data origins. I work extensively with Power BI, Excel, and data modeling to ensure accurate and actionable insights that align with your operational needs. I am looking forward to work with you. Best Regards, Susie Kalson
£500 GBP in 5 days
0.0
0.0

Hi there, I just read your posting. It sounds like you need an experienced Power BI developer to consolidate aviation insurance data from multiple Excel workbooks into a clean, reliable reporting solution with a well-structured data model and interactive visualizations. I am a software engineer with 10+ years of experience in data analytics, business intelligence, and reporting solutions. Designing scalable Power BI data models, transforming complex Excel datasets with Power Query, and building intuitive dashboards that support business decision-making is what I specialize in. I can help you create a robust Power BI report that combines Aircraft, Premium, and Claims data into a single source of truth. I will build clearly defined tables, relationships, and DAX measures, implement documented Power Query transformation steps, and create bar, pie, and line visualizations with filtering and comparison capabilities across years, policy types, and other relevant dimensions. I also understand the importance of accurate premium and claims reporting, including timing considerations that can impact insurance portfolio analysis. My focus will be on delivering a report that is both easy to maintain and decision-ready. Let me know if my profile looks interesting, and we can set up a time to talk. Best regards, Elijah M.
£500 GBP in 5 days
0.0
0.0

Hello, I would be an excellent fit for this project. I have extensive experience designing **Power BI data models, insurance reporting dashboards, and refreshable analytical solutions** that transform raw Excel data into executive-ready insights. I understand that your objective extends beyond creating charts—you need a **robust, well-documented Power BI model** that accurately reflects aviation insurance performance while remaining easy to maintain and update as new data becomes available. ### Deliverables • Final Power BI report (.pbix) • Clearly named tables and DAX measures • Documented Power Query transformation steps • Logical and maintainable relationship model • Read-me guide covering: * Data sources * Refresh procedures * Explanation of calculations and assumptions ### Why I'm a Strong Fit • Strong expertise in Power BI, DAX, and Power Query • Experience building refreshable executive dashboards • Deep understanding of insurance reporting principles, including the timing differences between premium recognition and claims emergence • Focus on both analytical accuracy and visual storytelling I am available to begin immediately and would be happy to review a sample workbook to assess the structure of the data and recommend the most effective reporting approach before development starts. Best regards,
£250 GBP in 2 days
0.2
0.2

Hello, I’m interested in building your Aviation Insurance Power BI report. I am a Microsoft Certified Power BI & Data Analytics Professional with 7+ years of experience in Power BI, SQL, Excel, Power Query, DAX, and data modeling. For this project, I will: ✔ Consolidate data from multiple Excel workbooks into a clean, scalable data model ✔ Perform all required Power Query transformations and document the refresh process ✔ Create clear relationships, measures, and KPIs for Aircraft Counts, Premiums, and Claims ✔ Build interactive bar, pie, and line visualizations ✔ Enable analysis by Year, Policy Type, and other available dimensions ✔ Create comparison views to identify trends between aircraft volumes, premiums, and claims ✔ Deliver a well-structured PBIX file with clearly named tables, measures, and relationships Portfolio:https://www.freelancer.in/u/Darshanvarade Although I’m newer to this platform, you can review my portfolio to see the quality of dashboards and BI solutions I have delivered. My experience includes insurance, finance, sales, operational reporting, and executive KPI dashboards. I would be happy to review the source files and discuss the requirements. Best Regards, Darshan
£375 GBP in 3 days
0.0
0.0

With regards to your Aviation Insurance PowerBI Customer Dashboard project, I am confident that my substantial experience and skills in Data Analysis, Data Processing and most importantly Power BI create an ideal fit. Over the course of my 8 year long career, I have gained hands-on experience in crafting visually appealing and user-friendly dashboards. My understanding of aviation risk data and insurance portfolios will prove invaluable, as I’m well versed with the patterns of premium and claims timing which are unique to this domain. In addition, my proficiency in developing AI-driven systems combined with profound knowledge of Advanced Data analytics and machine learning will enable me not just to design a compelling PowerBI report but also deliver an underlying data model that is exceedingly reliable. Moreover, being an expert in transforming raw data into actionable insights using Power Query, I can assure you of a smooth update process even with changing data parameters. Given my commitment towards producing efficient deliverables and providing clear documentations for ease of utilization, I can guarantee a user-friendly and sustainable solution. Let's collaborate on this project to develop an exceptional Aviation Insurance PowerBI dashboard that enhances your decision-making processes.
£500 GBP in 7 days
0.0
0.0

London, United Kingdom
Payment method verified
Member since Jun 2, 2025
₹100-400 INR / hour
$30-250 USD
£20-250 GBP
₹12500-37500 INR
$10-30 USD
₹1500-12500 INR
min £36 GBP / hour
$250-750 USD
$100 USD
₹750-1250 INR / hour
$10-250 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
$250-750 AUD
₹750-1250 INR / hour
$200-600 USD
₹750-1250 INR / hour
₹100-400 INR / hour
$15-25 AUD / hour