Cornerstone Homes LLC seeks to enhance its reporting efficiency by automating SQL-based company reports and integrating them into a Power BI dashboard. The current manual process is time-consuming and labor intensive, which affects decision-making efficiency. The goal of this project is to streamline the reporting process, ensuring that managers have timely access to accurate data. By automating the extraction and transformation of data from SQL databases, learners will create a seamless pipeline that feeds into a Power BI dashboard. This project will allow learners to apply their knowledge of SQL, data transformation, and Power BI to solve a real-world business problem. The tasks include understanding existing SQL reports, designing automated data pipelines, and developing an interactive Power BI dashboard that meets the needs of company managers.

The deliverables for this project include a fully automated data pipeline that extracts and transforms data from SQL databases, and a Power BI dashboard that displays key company reports highlighting KPIs. The dashboard should be user-friendly and provide managers with real-time insights. Additionally, documentation detailing the automation process and dashboard functionalities will be provided. This ensures that Cornerstone Homes LLC can maintain and update the system as needed.