In this 2-hour long project-based course, you will learn how to transform date, time, and duration data for analysis in Power BI, merge and clean datasets by handling inconsistencies and outliers, and apply mean imputation and other cleaning techniques to prepare data for predictive modeling.

To achieve this, you will create a fully transformed and cleaned dataset by working through a real-world scenario, where you will assist TY77, a travel agency, in preparing their flight data for a pricing model using Excel sheets containing flight information and routes. This Guided Project was created to help mid-level data analysts develop essential skills in data transformation and cleaning using Power BI to prepare datasets for advanced analysis. This project is unique because it offers hands-on experience in tackling real-world data challenges, such as merging multiple datasets and dealing with inconsistencies. In order to be successful in this project, you will need basic familiarity with Power BI and a foundational understanding of data tables, though no prior experience in data transformation is required.