There's what this Gig offers
FOR EXCEL:
Data Cleaning:
- Remove duplicates
- Fix missing or incorrect values
- Format dates, numbers, and text
- Use Find & Replace, Text to Columns
Data visualization:
- Charts: bar, line, pie, histogram
- Conditional formatting (colors, icons)
- Dashboards using slicers & filters
Calculations & Analysis:
- Use formulas: SUM, AVERAGE, IF, VLOOKUP/XLOOKUP
- Conditional analysis with COUNTIF / SUMIF
- Create KPIs and metrics
Reporting:
- Pivot Tables to summarize data
- Monthly / weekly performance reports
FOR SQL:
Data cleaning:
- Remove duplicates
- Handle NULL values
- Standardize data formats
Data analysis:
- Group data
- Calculate averages, totals, percentages
- Find trends over time
Data extraction:
- Get specific data
- Filter, sort, and limit data
Data combination:
- Join tables
- Analyze relationships between data (customers, orders, products)
FOR TABLEAU:
Create Interactive Dashboards:
- Build dynamic dashboards with filters, slicers, and actions
- Combine multiple charts in one view
Visualize Data Clearly:
- Create charts: bar, line, area, maps, scatter plots, heatmaps
If you need any service from these services or any informations, feel free to contact me