Live Interactive Dashboard

Project Details

Atliq Hardware, a rapidly expanding company operating across multiple countries, confronted challenges analyzing data from various sources like Excel, SQL, and CSV files. These hurdles led to significant losses during certain periods, prompting the company to revamp its decision-making approach to ensure sustainable growth in a fiercely competitive business landscape.

In this journey, we have used multiple tools and skills for the correct development of the project such as

- Establishing a personal gateway to extract databases from MySQL
- Creating a SharePoint for extracting databases from Excel files
- Data cleaning and transformation using Power Query
- Data modeling to establish relationships between data tables
- Creating DAX formulas for various measures and KPIs to gain insights
- Visualizing these insights with data visuals and dashboards

Live Interactive Dashboard

Project Details

This project involves two critical components: sales analysis and financial evaluation. By combining these insights, we empower informed decision-making and strategic planning. Sales analytics allows us to monitor performance, identify patterns, and track key indicators. Meanwhile, financial analytics benchmarks our financial health against peers and previous periods, forming the foundation for budgeting and forecasting. Together, these reports instill confidence in our organization’s outlook. 📊💡

🔧 Technical & Soft Skills:

-Proficiency in ETL methodology (Extract, Transform, Load).
-Skills to generate a date table using Power Query.
-Ability to derive fiscal months and quarters.
-Establishing data model relationships with Power Pivot.
-Incorporating supplementary data into an existing data model using DAX to create calculated columns.