Deepthi V P

Experience

• 

  Wipro

  Nov 2008 - Dec 2015

  Information Specialist
• 

  Predis.ai

  Aug 2023 - Oct 2023

  WordPress Content Consultant

  • Collaborating with content writers to maintain content quality and ensure timely submission of blogs for review.• Reviewing and providing constructive feedback on blog posts and articles published on WordPress websites.• Conducting thorough proofreading and fact-checking to ensure content accuracy and quality.• Evaluating grammar, style, and content coherence, making recommendations for improvement.• Ensuring that blog posts meet high editorial standards and effectively target the intended audience.• Implementing SEO best practices, including keyword research and on-page SEO, to optimize content for search engines.• Creating comprehensive outlines for blog posts to guide content development and structure. Show less

• 

  Power-BI_Dashboard_ExpenseReport

  Dec 2023 - Jan 2024

  Power-BI_Dashboard_ExpenseReport

  The core component of the Project involved the creation of a dynamic dashboard, achieved by extracting data from a Sharepoint Folder. Key features of this Project include:Data Loading from Sharepoint FolderSuccessfully extracted and loaded data from the specified Sharepoint Folder.Dropdown Selections:Implemented two dropdown menus for enhanced user interaction.Dropdown 1: Allows selection of the desired file name. [Monthly Expense Data]Dropdown 2: Enables the selection of the cost type. [USD / INR]Dynamic File Updates:Ensured that the dropdown menus are dynamically updated.Whenever a new file is added to the Sharepoint Folder, it is automatically included in the dropdown list after refreshing the data. Show less

• 

  Sales Order Dashboard

  Dec 2023 - Jan 2024

  PowerBi_Sales_Order_Dashboard

  This dashboard is designed to provide insightful analytics on sales orders. Here's a structured overview of its key features:Key Features:Dynamic Filtering:**Utilized slicers to facilitate easy filtering of data based on years, quarters, and months.Quick Insights:Utilized card visuals to offer immediate insights into the total number of orders and customers.Visual Trends:Implemented charts to analyze order trends over time, understand shipping distribution, and identify top customers.Geographical Analysis:Incorporated a map visual for a comprehensive analysis of the geographical spread of orders. Show less

• 

  Vrinda Store

  Jan 2024 - Jan 2024

  Excel Dashboard Project - Vrinda Store Annual Report.

  Overview:Vrinda Store's Annual Sales Report Dashboard is designed to provide insights into the sales performance in 2022. This interactive Excel dashboard allows users to analyze and understand customer behavior, identify top-performing states, and gain valuable insights to strategize for increased sales in 2023.Features:Sales and Orders Comparison Chart- Visual representation of the comparison between sales and orders in a single chart for quick analysis.Highest Sales and Orders by Month- Identify the month with the highest sales and orders to understand peak performance.Gender-based Purchases- Determine whether more men or women made purchases in 2022.Order Status Overview- Explore different order statuses in 2022 to understand the flow of transactions.Top 5 Contributing States- List of the top 10 states contributing the most to sales.Age and Gender Analysis- Relationship between age and gender based on the number of orders placed.Sales Channel Insights- Identify the channel contributing to the maximum sales.Discovered the category that generated the highest sales. Show less

• 

  Foresight BI & Analytics

  Feb 2024 - Mar 2024

  Power BI Developer

  Responsibilities handled included: Data Dictionary Creation, Data Preparation with Power Query, Data Modeling and KPI Computations with DAX, Report Mockup Design Creation, Data Visualization & Report Creation

• 

  SQL Demographic Analysis

  Apr 2024 - May 2024

  SQL Demographic Analysis

  Project OverviewThis SQL project is focused on analyzing demographic data to uncover trends and insights. Key tasks include:Extracting data from two main datasets.Analyzing population distribution, growth rates, literacy rates, and sex ratios.Performing advanced SQL operations to calculate demographic metrics and trends.Key SQL Techniques Used: Joins: Combining data from multiple tables to generate comprehensive datasets. Unions: Merging results from different queries to create unified outputs.Subqueries: Nesting queries to perform complex data retrieval operations.Aggregate Functions: Calculating sums, averages, counts, and other aggregate metrics.Window Functions: Ranking and partitioning data to provide detailed analysis.Findings:Population Analysis: Detailed breakdown of the population across states.Growth Trends: Insights into the average growth rates at national and state levels.Literacy Rates: Identification of states with the highest and lowest literacy rates.Sex Ratio Disparities: Examination of the average sex ratio across states.ConclusionThis project showcases the power of SQL in analyzing and deriving meaningful insights from large demographic datasets. The findings can assist in policy formulation, resource allocation, and understanding regional development dynamics. Show less