Electric Vehicle Power Bi

DEREK FILBERT M A

**************@*****.*** +91-790******* LinkedIn

CAREER OBJECTIVE

A result-oriented and self-driven analyst with practical experience through projects using SQL. Excel, Power Bl. Highly skilled in collecting, analyzing and visualizing data. Seeking an opportunity where I can utilize my skills to achieve organization goals and enhance my analytical and technical skill. TECHNICAL SKILLS

PROJECT EXPERIENCE

Analysed a pizza sales dataset to uncover trends in order frequency, revenue generation, and customer preferences using SQL. Applied Joins, Aggregations, Grouping, and Subqueries to identify top-selling pizzas, most popular sizes, and category-wise sales contributions. Optimized queries to calculate total revenue, average daily orders, and percentage contribution of each pizza category for business insights. Designed an interactive Excel dashboard for Electric Vehicle Analysis, showcasing key metrics such as vehicle distribution by model year, make, and state. Utilized Excel for data cleaning and transformation and incorporated dynamic filters to enhance user interactivity. Delivered actionable insights through advanced visualizations, enabling informed decision-making in the electric vehicle industry. Pizza Sales Data Analysis using SQL GITHUB.LINK

GITHUB.LINK

Electric Vehicle Market Analysis: Insights and Trends Using Interactive Dashboards using Excel Database Management: Oracle SQl - operators, SubQuery, JOINS, DDL, and DML. Data Analysis : Excel - (Data Cleaning and Preparation Excel Functions Pivot Tables and Pivot Charts Dashboard Design).

Data Visualization: Power BI (Dashboards Data Modeling DAX Functions Advanced Visualizations Power Query)

Programming language - Python(Numpy, Pandas)

CERTIFICATES

PwC Power Bi - Forage

Accenture North America Data Analytics and Visualization Job Simulation - Forage Tata Group Data Visualization: Empowering Business with Effective Insights - Forage EDUCATION

2024

2021

2019

Sales Analysis Dashboard in excel

The Sales Dashboard is an interactive Excel-based visualization tool designed to provide insights into key sales metrics. It consolidates data from multiple sheets (orders, products, etc.) and presents a summary of total orders, revenue, delivery times, and customer trends. GITHUB.LINK

Bachelor of Commerce (Information Technology) -70% Sri Krishna Arts And Science College Higher Secondary Education(XII) - 75% Nirmala Matha Convent Matriculation Higher Secondary School

Secondary Education(X) - 64% Nirmala Matha Convent Matriculation Higher Secondary School

Contact this candidate