Mark Shrigley's Portfolio of SQL and Excel

Thank you for taking the time to explore my work with data. Below, you'll find examples of SQL queries I've created along with their results. Additionally, I've included examples of my work in Excel (below SQL Segment), utilizing Pivot Tables and various functions, along with the corresponding outcomes.


SQL Segment

Aggregate Function of Count

Table Inner Join


EXCEL Segment

Duplicate Data

Pivot Table

Data Wrangling in Excel 



Note:  In process of adding more content.

Popular posts from this blog

Pivot Table

Image
  Below is a regular table then a pivot table.  The pivot table has the retailer column that has the sum of Price per Unit column as well as the Sum of Units Sold.   Retail Partners Table Pivot Table
Read more