Atliq Hardweres Sales reports

Project Details

I'd like to share my initial Excel project. 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 : "Sales and Finance Report"

In this challenging project, I dived deep into the world of data analytics, transforming a massive dataset of about 1 million records of raw sales data into actionable insights. Here's a glimpse of what I accomplished:

𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗱:
• Utilized ETL (Extract, Transform, Load) techniques using Power Query to efficiently clean and prepare data.
• Mastered advanced Excel functions, including VLOOKUP and XLOOKUP, to seamlessly integrate and analyze data from multiple sources.
• Leveraged Power Pivot and Data Analysis Expressions (DAX) for multidimensional analysis, crafting dynamic data models.
• Applied sophisticated conditional formatting techniques to enhance data visualization, making insights easier to interpret.
• Created slicers, measures, and filters, empowering users to dynamically tailor their analysis for a user-friendly experience.