Browsing by Author "SATISH SINGH 1NH21MC083"

Now showing 1 - 1 of 1
  • Thumbnail Image
    Item
    Data Modeling in Power BI with Azure SQL
    (NHCE, 2023) SATISH SINGH 1NH21MC083
    The aim of this internship project is to demonstrate the process of creating a data model using Power BI and SQL. Data modeling plays a vital role in business intelligence and analytics projects by facilitating the organization and integration of data from diverse sources. It serves as a crucial step in ensuring data is structured and prepared for effective analysis and reporting. By creating a well-designed data model, businesses can unlock valuable insights and derive meaningful conclusions from their data, enabling informed decision-making and driving strategic actions. This project will utilize Power BI, a powerful data visualization and reporting tool, along with SQL,I it is a popular relational database management system , to design and implement comprehensive data model. The data model will provide a structured framework for organizing and storing data, facilitating efficient data retrieval and analysis. The project will follow a systematic approach, starting with data source identification and understanding the data requirements. SQL will be used to extract and transform the required data from various platform , ensuring data quality and consistency. The transformed data will be loaded into a target database or data warehouse. Power BI will be employed to connect to the SQL database and create a data model. Power Query, a data transformation and cleansing tool within Power BI, will be utilized to perform any further necessary data transformations or manipulations. Power BI's modeling capabilities will be employed to define relationships between tables, create calculated columns and measures, and optimize the data model for efficient analysis.