SQL scripts for data exploration, analytics, and reporting. These scripts cover various analyses such as database exploration, measures and metrics, time-based trends, cumulative analytics, segmentation.
Data starting and ending date 2010-2014 Here I am Finding EDA From the given dataset, I Analysed Five Important Exploration For Data Analysis that is: Dimension Exploration, Date Exploration, Measure Exploration, Magnitude Exploration, Rank Exploration
Identifying the unique values(or categories) in each dimension. This will help us to understand recognizing how data might be grouped or segmented. which is useful for later analysis. eg: DISTINCT[Dimension], DISTINCT[country], DISTINCT[category], DISTINCT[product]
Identify the earliest and latest dates(boundries). Understand the scope of he data and the timespan. In order to get earliest and latest date MIN / MAX functions is very useful
Calculate the key matrics of the business(Big Numbers). -Highest level of aggregation -Lowest level if details using SUM,AVG,COUNT functions
Compare the measure values by categories. It help us to understand the importance of different categories.
Order the values of dimensions by measures. The Top N Performers and Bottom N Performers
This are my exploration using SQL queries and i believe it will answer some important business questions
Thank you!.....
Hi there! I'm Gowtham Subramanian, I’m an IT professional and passionate Data Analyst on a mission to share knowledge and make working with data enjoyable and engaging!
Let's stay in touch! Feel free to connect with me on the following platforms:
