<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Damilolalawal on Medium]]></title>
        <description><![CDATA[Stories by Damilolalawal on Medium]]></description>
        <link>https://medium.com/@damilolalawal4?source=rss-986dbdffd0a8------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Stories by Damilolalawal on Medium</title>
            <link>https://medium.com/@damilolalawal4?source=rss-986dbdffd0a8------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 10:01:56 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@damilolalawal4/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[MY SALES ANALYSIS PROJECT WITH SQL (MICROSOFT SQL SERVER)]]></title>
            <link>https://medium.com/@damilolalawal4/my-sales-analysis-project-with-sql-microsoft-sql-server-d05871f6ade9?source=rss-986dbdffd0a8------2</link>
            <guid isPermaLink="false">https://medium.com/p/d05871f6ade9</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[sql-server]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Damilolalawal]]></dc:creator>
            <pubDate>Thu, 03 Aug 2023 21:30:26 GMT</pubDate>
            <atom:updated>2023-08-03T21:30:26.871Z</atom:updated>
            <content:encoded><![CDATA[<p>SQL (Structured Query Language) is a powerful and standardized programming language used to manage and interact with relational databases. As a data analyst, SQL is an essential tool that enables you to access, query, and manipulate data efficiently.</p><p>With SQL, you can retrieve specific information from databases using SELECT statements, filter data with the WHERE clause, and sort results with ORDER BY. It allows you to perform data aggregation using functions like SUM, AVG, COUNT, and more, to analyze large datasets and derive meaningful insights.</p><p>As a data analyst, having a strong grasp of SQL empowers you to explore, clean, and transform data efficiently, leading to informed decision-making and valuable insights that drive business success.</p><p>In this project I will walk you through steps I took in bring out insight from the sales data. I downloaded the dataset from Kaggle; this dataset contains information about sales transactions, including details such as the customer’s age, gender, location, the products sold, cost of the product and the revenue generated from its sale. The dataset has over 34K+ rows and 15 columns.</p><p>Before importing my dataset into SSMS (SQL SERVER MANAGEMENT STUDIO): I noticed it include a column which is not necessary for the analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/195/1*7LoIJn1mdP4gGP9D3tayiA.png" /></figure><p>So, I dropped the column named column 1 from the dataset. After dropping the column, the next task is to create a database in my SSMS which I named sales, then I import the excel file into SSMS with the import wizard.</p><p>Now Let’s get started!!!</p><p>You can look at the entire SQL code <a href="https://github.com/Lawal-faruq/Sales-Analysis/blob/main/Sales_Analysis.sql">here</a> on my GitHub profile. I used Microsoft SQL Server to develop this project.</p><p>Firstly, I look at the first ten row of the data to get a glance of the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MS1dLiF0eZ_O1rilBoKGOg.png" /></figure><p>The next thing I did was to check each columns datatype, so that I will be sure it is in the correct format for my analysis,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/638/1*NP_S4SfLveT-0tSi7f6o4w.png" /></figure><p>This shows that all the columns are in the correct datatype; These is perfect for my analysis, and it won’t throw up unnecessary errors.</p><p>Since my data is clean, I will move on to the analysis and bring out some interesting insight from the data.</p><p>DATA EXPLORATION</p><p>I would like to know the total revenue generated in our sales:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*XK8TP3O1dTKfAwGxcWgIeA.png" /></figure><p>This shows that the total revenue generated is <strong>$22344576.</strong></p><p>Now, I want to know the total profit the company make out of the total sales:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/642/1*RX10IpnG2Wnrav33lT4E8w.png" /></figure><p>Out of the <strong><em>$22,344,576</em> </strong>total sales the company made a profit of <strong><em>$2,261,602.</em></strong></p><p>The next thing I would like to know is what is the average age of our customer:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/674/1*DDZA-CwVSjixVyw3IrRAxw.png" /></figure><p>The average age of our customer is 36 years old; this shows our customers are in the young or middle age bracket.</p><p>Now, I know you are curious to know what our company’s product category is:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/776/1*isLx3E26SuCtADAcxMjpng.png" /></figure><p>We have three product categories our company deals with which are Accessories, Bikes and clothes.</p><p>Now, I would like to know which on the three categories is bring in more money to the company:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/716/1*fbvxe5mXNkYLCre14KO5dw.png" /></figure><p>Here we see that we are make more money from bike even though we sell more of accessories in term of quantity sold.</p><p>I would like to go deep to find out our top ten selling product by total revenue generated:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/722/1*ziTlzuKt9dWPQy2a2xgbEA.png" /></figure><p>We can see our top ten selling product right here.</p><p>Now, I would like to find out the top ten state where we are generating most of our revenue:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/639/1*UcyWWwgnZGAv1cLyymjygw.png" /></figure><p>The result here will assist our sales and marketing team to know where to target and where to develop marketing strategies.</p><p>I want to know how our sale is doing month to month to keep track of our progress:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1020/1*rUONQjWaJhGuZn6qoqX5Mg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/634/1*GpJLn-ht2MJU__o1qtbg_A.png" /></figure><p>CONCLUSION:</p><p>This project is just to show how SQL can be used to bring insight from data to solve business problem.</p><p>Thank you for walking through this with me.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d05871f6ade9" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>