Sales Insights An Exercise by CodeBasics

First off, this data analysis project has been taken by "Code Basics" which is a youtube channel. You can access it using below link

1. Sales Insights Tutorial

We are going to cleanse and visualize our data by using Microsoft Power BI as an exercise. In addition to that, as a database, we will be using MySQL to analyze our data.

As a feedback for the youtube channel (codebasics), I have really enjoyed with the whole series which gave me a good insight to comprehend how data analysis works by using data science tools. So, this has been a good starting point to dive into data science.

1. To find out the total transaction of a company

   Use this code : Total Transaction = COUNTROWS('sales transactions')

2. To find out the revenue of a company

   Use this code : Revenue = SUM('sales transactions'[sales_amount])

3. To see the revenue of a company in SQL by looking at the year 2020

   Use this code : SELECT SUM(sales_amount) FROM transactions as trns INNER JOIN date as dt ON trns.order_date = dt.date WHERE dt.year = 2020)

4. To see the revenue of a company in SQL by looking at distinctive years

   Use this code : SELECT DISTINCT(year) FROM date

5. To see the profit margin in terms of percentage

   Use this code in Microsoft Power BI : Profit Margins % = DIVIDE([Total Profit Margin], [Revenue], 0)

6. To see the profit margin in terms of contribution

   Use this code in Microsoft Power BI : Profit Margin Contribution % = DIVIDE([Revenue], CALCULATE([Total Profit Margin], ALL('sales products'), ALL('sales customers'), ALL('sales markets')))

To see design and short demo, click the link below:

1. First Glance

2. List top 5s

3. Revenue Trend

4. Comparison betweeen customer type and markets

5. A short insight about data with a video