Embedded Files
Tags: Financial Analysis, Dashboards, Data Visualization
Tableau
PostgreSQL
Python
Jupyter Notebook
● GOAL
● GOAL
Provide AtliQ Hardware with insights into their financial performance based on revenue, costs, profit and margin analyses, enabling them to make data-driven decisions that enhance their profitability and operational efficiency.
● CONTEXT
● CONTEXT
We're part of the Analytics team for TTWC Consulting Agency (TripleTen World Consultancy). This year, we're working with a particular special client: AtliQ Hardware.
AtliQ Hardware is one of the leading computer hardware producers in India, with presence in different countries across Europe, Latin America and Asia. Operating as a multinational entity, AtliQ sells various types of hardware to major players, including Amazon, Best Buy and Walmart.
● OVERVIEW
● OVERVIEW
This year, we have been asked to conduct a comprehensive audit for AtliQ's sales and help them automate their existing data processes. For this part of the project, our Data Analytics Department, in conjunction with AtliQ's Financial Department, is conducting a financial Analysis for the period 2018 - 2022.
AtliQ Hardware has provided us with a backup of their database in the SQLite format. The project includes the exploration of the data, calculation of relevant metrics, and test of relevant hypotheses. We have drawn conclusions and provided recommendations based on the insights gained during the analysis. Finally, we created an interactive dashboard with relevant metrics and insights, providing AtliQ with a tool for future use.
● DATA USED
● DATA USED
.
dim_customers: contains customer-related data.
dim_product: contains product-related data.
fact_pre_discount: contains pre-invoice deductions information for each customer.
fact_manufacturing_cost: contains the cost incurred in the production of each product.
fact_gross_price: contains gross price information for each product.
fact_sales_monthly: contains monthly sales data for each product.
● DASHBOARD
● DASHBOARD
This project includes the creation of a dashboard in Tableau, showing different metrics for each year.
The dashboard is accessible at the following URL:
To see the code, please visit my GitHub.
Page updated
Google Sites
Report abuse