Data Analysis
“Analytical applications designer for consumer problems”
Data Analysis
Project 1
Volume of Quarter 2 Analysis
Business Problem:
- Client wants to see the volume by region of quarter 2 of the year analysis and give them meaningful information to show the report to their CEO and CFO.
Analysis
- Report contains volume of customers and their quarterly business with client
- Summary report contains comparative values from previous quarters business
- It contains visual charts to make the clear understanding of the data
- It contains customer growth percentages of different clients by region comparison
-Microsoft Excel :
Xlookup , vlookup, SUMIFS, COUNTIFS,Pivot tables, custom charts, contidional formatting
Project 2
SQL Data Exploration
Business Problem:
- Explore covid data file to calculate death percentage rate and number of vaccinated population
Analysis
- Rearrange the data
- querying the covid deaths per population
- Calculate death percentage
- Calculate vaccinated population
-Microsoft SQL Server :
Ordering , Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types