Portfolio - Deepa Iyer | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Deepa Iyer

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

I hold a Gold Medal in BA (Economics) with a strong foundation in Applied Statistics, complemented by two Master's in Economics. My academic journey involved empirical research on national and international developmental issues such as Indian microfinance and disparities in health insurance coverage across rural-urban areas in California.

I've served as a development consultant specializing in impact assessment and livelihood studies for esteemed international organizations such as Traidcraft, UK, and state-level agencies like Kudumbashree, Kerala.

Furthermore, I've gained valuable experience in agile technology as a QA Engineer for SmartOrg, a leading US-based Portfolio Management company. This role broadened my perspective on data analytics, prompting me to explore tools like Power BI and delve into contemporary advancements in the field. I'm enthusiastic about integrating cutting-edge AI tools into my work to generate high-quality insights for organizations of all kinds.

Key

Skills

MySQL

DAX

Power Query

Power Pivot

Pivot Tables

Data Visualization

My

Projects

AtliQ Hardware Excel Reports

AtliQ Hardware Excel Reports

Created Sales (Customer and Market Performance) and Finance Reports by Fiscal Year and Quarters for AtliQ Hardware, a Growth Company, using Advanced Excel.

AtliQ Business Insights 360

AtliQ Business Insights 360

Developed a detailed Power BI dashboard for AtliQ Hardware, showcasing Finance, Sales, Marketing, Supply Chain sectors, and an Executive Summary tailored for top-level management.

AtliQ Hardware MySQL Report

AtliQ Hardware MySQL Report

Created an analytics report with complex SQL queries to get key financial metrics, top customers, products, and markets from a database of 1.43 million records.

Contact Me

Email

[email protected]

Github

https://github.com/dkiyer

Linkedin

https://www.linkedin.com/in/dkiyer/

Call

+91 9727922065

Deepa Iyer

Data Aspirant

Download Resume

Resume

Excel Project

AtliQ Hardware Excel Reports

Created Sales (Customer and Market Performance) and Finance Reports by Fiscal Year and Quarters for AtliQ Hardware, a Growth Company, using Advanced Excel.

View Project
on GitHUB

AtliQ Hardware Excel Reports

Customer-wise Net Sales comparison across different Fiscal Years

AtliQ Hardware Excel Reports

Profit and Loss (P&L) by Fiscal Months and Quarters (Fiscal Year begins in September)

Project Details

TOOLS & METHODOLOGY

- Project completed with Microsoft Excel, Power Query, PowerPivot and DAX.
- Power Query was employed for data cleaning.
- Data modeling was used to link multiple tables.
- Power Pivot was employed for slicing and dicing data.
- Pivot Tables were used to visualize and create aesthetic reports.

PowerBI Project

AtliQ Business Insights 360

Developed a detailed Power BI dashboard for AtliQ Hardware, showcasing Finance, Sales, Marketing, Supply Chain sectors, and an Executive Summary tailored for top-level management.

View Project
on GitHUB

AtliQ Business Insights 360

AtliQ Hardware Data Model of dimension and fact tables

AtliQ Business Insights 360

Executive View for top-level management

Project Details

AltiQ is an electronics hardware company which has grown vastly in the recent years, and opened business all over the globe. It sells computer hardware and accessories through three main mediums/channel: Retailers, Direct, and Distributors.
Recently, AltiQ faced an unexpected setback following the launch of a store in America, assessed through surveys, intuition, and rudimentary Excel analysis. In contrast, competitors leverage dedicated analytics teams for informed decision-making. Recognizing the necessity of adapting to industry demands, AltiQ Hardware must prioritize the establishment of its own analytics team. This strategic initiative will enable the company to gather comprehensive data-driven insights, make informed decisions, and enhance its competitive position in the market.

Live Interactive Dashboard

SQL Project

AtliQ Hardware MySQL Report

Created an analytics report with complex SQL queries to get key financial metrics, top customers, products, and markets from a database of 1.43 million records.

View Project
on GitHUB

AtliQ Hardware MySQL Report

Total Yearly Sales Report for customer Croma using its customer code and user-defined function for getting Fiscal Year

AtliQ Hardware MySQL Report

Created a reusable stored procedure to get Top N Customers by Net Sales for a chosen year and market

Project Details

Technical Skills Gained:

- Proficiency in crafting complex SQL queries with various joins, functions, and procedures for data extraction and analysis.
- Efficient data extraction from multiple tables, enhancing handling of large datasets.
- Creation and utilization of user-defined functions for custom data processing tasks.
- Expertise in creating stored procedures to automate repetitive tasks.
- Utilization of database views for storing and accessing complex query results.
- Knowledge of Common Table Expressions (CTEs) and Window Functions for advanced data manipulation tasks.