Skip to content

Latest commit

 

History

History
15 lines (14 loc) · 1.25 KB

README.md

File metadata and controls

15 lines (14 loc) · 1.25 KB
Raw

fake-DHW-Food

fake-DHW-Food Food Data Warehouse and Data Analysis Technologies: faker, python, sql server , sql server analysis services , excel,Reporting Description A project focused on creating a data warehouse for Tunisian food data using Faker to generate sample data. The data is centralized into a database and organized into an OLAP cube for efficient analysis. The final step involves visualizing the data for insightful analysis and reporting

Key Features

  1. Generate Data Warehouse with Faker: Use Python and Faker library to generate sample data for the food data warehouse.
  2. Import Data to SQL Server Database: Import the generated data into an SQL Server database for storage and management.
  3. Connect to SSAS and Create OLAP Cube: Connect to SQL Server Analysis Services (SSAS) and create an OLAP cube for data analysis.
  4. Create Customized Date Dimension: Design and implement a customized date dimension and relate it to the fact table.
  5. Process Cube: Process the OLAP cube to ensure data is up-to-date and ready for analysis.
  6. Test with Excel: Test the OLAP cube and data integration using Excel for initial validation.
  7. Visualize with Customized Tool: Use my customized development tool to create smooth and insightful reports for data visualization.