This repository contains a practice exercise to apply the data modeling and relationship concepts learned in the course. The goal of this exercise is to analyze the given data and answer the following questions:
- What is the total revenue in California?
- How many sales has the product "Namkeen - Rice Kodubale (Sln )"?
- What is the average price in Dallas?
The provided resources include:
- Data Files: Several data files for practicing data cleaning and relationship-building skills.
- Screenshots: Screenshots of the Power BI interface to demonstrate the process and results of the exercise.
-
Clone the Repository: Clone this repository to your local machine to work with the project files.
git clone https://github.com/Anitatorki/Data-Model-Fundamentals.git
-
Open Power BI: Open Power BI Desktop on your computer.
-
Import Data: Import the provided data files into Power BI to begin the data cleaning and relationship-building process.
-
Analyze the Data:
- Perform data cleaning as necessary.
- Create relationships between data tables as required for analysis.
-
Answer the Questions: Utilize the data model to answer the questions outlined above.
-
Generate Visualizations: Create visualizations such as charts, graphs, and tables to present your findings.
-
Add Your Photo: To include your photo in the Power BI project:
- Open the Power BI file.
- Insert an image by navigating to the Insert tab and selecting Image.
- Choose your photo and place it in the appropriate location in the Power BI report.
- Resize and adjust the photo as needed.
For detailed answers to the questions and step-by-step solutions, refer to the provided lecture materials.
This project is licensed under the MIT License. See the LICENSE file for more information.