Imad Ahmad

Smart Sales Corp - Consolidated Financial Metrics Power BI Desktop Date 1/1/2018   12/31/2020  172.09M 73.49M 98.61M 56.33M 57.30% 1.91K Total Sales Total Cost Total Profit YTD Sales Profit Margin Average profit per Order Total Sales by Product ProductCategory ChannelName All      Asia 57M Cameras and camco… 28M TV and Video 20M 40M Total Sales 60M  Whole Seller 0.0M 2018 Total Sales CustomerType Walk-In  Walk-In 0.2M  Whole Seller Retailer 31.75M (32.19%) 58.06M (58.88%) 2019 2020 Date Total Profit by CustomerType  North America  Retailer 0.4M 17M Cell phones 8.8M (8.92%)  Europe Customer Segment 0.6M Cell phones 64M Computers 0M Continent Name TV and Video Net Sales All Cameras and camcorders  ProductCategory RegionCountryName Computers Sales Trend over the Years 1,230,120.00 1,097,-,-,-,648.00 1,356,-,605.00 1,035,045.00 8,306,717.00  ProductName Contoso Projector 1080p X980 Black Contoso Projector 1080p X980 White Fabrikam Independent filmmaker 2/3'' 17mm X100 White Proseware Projector 1080p DLP86 Black Proseware Projector 1080p DLP86 Silver Proseware Projector 1080p DLP86 White Proseware Projector 1080p LCD86 Black Proseware Projector 1080p LCD86 White What-IF Analysis Power BI Desktop Sales Forecast Cost Forecast 0.11 -0.04 China 0.11 191.02M 91.99M 2.13K Cost Scenario Sales Scenario Profit Scenario Average Profit Scenario Germany France Sales Trend over the Years United Kingdom 0.5M 48.45M 13.12M 8.41M 5.66M 2.42M Germany France United Kingdom 0M United States 0.09 China RegionCountryName Sales Scenario Profit Scenario 50M United States Average Profit Forecast 70.55M Total Profit by Region RegionCountryName Profit Forecast 0.0M 2018 2019 Total Cost by Region 40M United States China Germany France Total Sales by Region United Kingdom 37.18M 20M 10.13M 6.40M 4.32M 0M United States China Germany RegionCountryName France 1.84M United Kingdom RegionCountryName Sales Scenario Cost Scenario RegionCountryName 2020 Date 100M United States China Germany France United Kingdom 100.64M 50M 27.33M 17.40M 11.73M 5.01M Germany France United Kingdom 0M United States China RegionCountryName Customer Segment Power BI Desktop Average Sales by CustomerType Average Profit by CustomerType CustomerType   Retailer Whole Seller 3.35K Retailer 3.32K CustomerType - Total Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller Whole Seller CustomerType Whole Seller Whole Seller Walk-In Retailer Retailer Walk-In Total Sales Total Profit 41,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,680.00 9,-,-,-,-,-,-,-,-,-,-,-,-,-,306,717.00 5,554,530.86 Average Sales Average Profit 41,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,480.73 -  Walk-In  Whole Seller ChannelName  Catalog  Reseller Total Cost by CustomerType  Store 100% BrandName  A. Datum Walk-In Whole Seller   Online Retailer 2.343 Walk-In 3.34K CustomerKey CustomerType Whole Seller 2.345 Walk-In 2.340  Adventure Works 43.34M  Contoso  Fabrikam 23.60M  Litware  Northwind Traders Retailer 6.55M  Proseware  Southridge Video 15.1%  The Phone Company  Wide World Importers 