Business intelligence project
We modeled an efficient data warehouse, structuring the data around key tables for optimal analysis. The modeling included tables for customer information, orders, and a central fact table. For the ETL flow, we used Talend Open Studio, designed to extract and transform data from the initial sources, efficiently integrating them into our data warehouse.
Database modeling and ETL
We analyzed and presented the sales results of top-performing reps. This analysis revealed not only the key reps and their contributions to total sales, but also the specific products they sold and the regions where they were most successful, providing valuable insights for future sales strategies.
Salesperson Performance Analysis
Finally, we analyzed the product subcategories in our Power BI report and identified and presented the most popular subcategories, as well as the associated main categories. This part of the report helped to highlight consumption trends and customer preferences, providing key information for guiding inventory and marketing strategies.
