Project Details

1. Connect & Import Data:
Ingested over 1.8 million records from diverse sources like Excel, CSV, and MySQL into Power BI, ensuring a unified data platform for in-depth analysis.

2. Extract, Transform & Load Data (ETL):
Applied Power Query for seamless extraction, transformation, and loading, optimizing data flow. Leveraged DAX Studio to reduce load time and storage by 25%.

3. Data Model and DAX:
Engineered a robust data model with 15+ tables using a Snowflake Schema, fostering efficient relationships. Utilized DAX for insightful calculated columns and measures.

4. Create Reports:
Crafted tailored reports, including P&L for Finance, Sales Performance Matrix, NP% and GM% for Marketing, Forecast Accuracy for Supply Chain, and Market Share Trend for Executives.

5. Dashboard Creation:
Engineered a versatile Power BI dashboard, catering to AtliQ Hardware's departmental needs, facilitating a holistic view of critical insights.

Project video

Project Details

The goal was to analyze this data and provide key insights to guide Mitron Bank in tailoring credit cards to customer needs and market trends.

Key metric Used:
𝐈𝐧𝐜𝐨𝐦𝐞 𝐔𝐭𝐢𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 % - It is calculated as Average Spends / Average Income.
𝐂𝐫𝐞𝐝𝐢𝐭 𝐂𝐚𝐫𝐝 𝐔𝐬𝐚𝐠𝐞 % - It is calculated as Total Credit card spent / Total Spent.

Key findings:
--> Income Impact: Top spenders include Salaried IT, Business Owners, and Other Salaried.
--> Age Preferences: 25-34 and 21-24 age groups prioritize Entertainment, Apparel, and Travel.
--> Spending Trends: Dominance in Bills, Groceries, Electronics, led by Mumbai.
--> City Dynamics: Mumbai leads, diverse patterns in Delhi NCR, Bengaluru, and Chennai.
--> Gender & Marital Impact: Males and married individuals emerge as prominent card users.

𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻:
Targeted Marketing Campaigns
Strategic Partnerships
Competitive Interest Rates and Fees
Flexible Credit Limits
Personalization in Rewards

Project video

Project Details

1. Ad-hoc Query Resolution:
Analyzed and resolved 10 ad-hoc requests using fundamental SQL concepts. Applied WHERE clause, GROUP BY, ORDER BY, JOINS, CTE, WINDOW FUNCTION, etc. Ensured accuracy and efficiency in data retrieval for each query.

2. Power BI Data Visualization:
Exported query results to Power BI for robust data visualization. Employed effective visualizations such as bar charts, pie charts, maps, donuts, and line charts. Utilized conditional formatting to enhance clarity and highlight key insights.

3. Insights Presentation:
Delivered a comprehensive video presentation explaining insights derived from visualizations. Shared meaningful observations and actionable recommendations. Ensured a clear and engaging narrative to facilitate understanding.

This integrated approach, from ad-hoc query resolution to impactful data visualization and insightful presentation, demonstrates a holistic strategy in transforming raw data into actionable informed decision-making.

Project video

Project Details

Steps in Making this Report-

1. ETL (Extract Transform Load) Process
Loaded and processed CSV files in Power Query, ensuring data integrity, uniqueness, and correcting errors before integrating into Power Pivot.

2. Data Modeling
Implemented a star schema, created dim_date table with a fiscal year perspective, ensuring seamless integration with other tables.

3. Pivot Table and Power Pivot Integration
Integrated the data model with a Pivot Table for quick analysis, utilizing Power Pivot for efficient data transformation and connectivity.

4. DAX (Data Analysis Expressions) Formulas
Developed 10+ new measures and columns using DAX, including Net Sales, Gross Margin, GM%, COGS, and applied a fiscal year perspective for deeper insights.

5. Conditional Formatting
Applied Conditional Formatting to enhance data presentation, highlighting key information, identifying trends, and improving overall data readability for effective analysis.

Project video

Project Details

1. Connecting and shaping data :- Connected the data, shape and transform tables using profiling tools, edit, merge and append queries.

2. Created a data model :- Build relational models, creating table relationships, understand cardinality and filter flow.

3. Calculated Measure with DAX :- Understand DAX syntax, added calculated columns and measures, write common formulas and functions.

4. Visualize Data and Dashboards :- Insert charts and visuals, customize formats, edit interactions, apply filters and bookmarks.

Project video