I will write sql queries to analyze your business data
About this Gig
Are you having trouble getting useful information out of your database? I will develop SQL queries that are clean and efficient to assist you look at your business data and answer important business issues.
What I can do for you:
- Sort and filter data based on your needs
- Use GROUP BY, SUM, COUNT, and AVG to combine data
- Combine data sources by joining several tables- Find the best customers, the most popular products, and the most money made in each region.
- Look at how things change over time (monthly, quarterly, yearly)
- Use SQL to find duplicates and tidy up data
- Use subqueries and CTEs to do more complicated analysis.
️ Tools and Tech:- SQL (MySQL, PostgreSQL, and SQLite)
- Works with database files, Excel files, and CSV files
What you'll get:
- SQL query files (.sql) that are clean and include good comments- A short explanation of what each query result means
- Results can be saved as a CSV file or a snapshot (upon request)
Good for:
Database type:
Relational database
Platform:
MS SQL
•
MySQL
•
PostgreSQL
•
SQLite
Expertise:
SQL
•
DDL
•
DQL
•
Query optimization
