LOW LEVEL DESIGN
DOCUMENT
LOW LEVEL BY
Dhrumil Sanghavi
Revision Number and Date :- 0.0
01/02/2024
DESIGN
DOCUMENT
Amazon Sales Data
Analysis
LOW LEVEL DESIGN
DOCUMENT
Document Version Control
Date Issued Version Description Author
Created Document and
01st Feb 2024 0.0 Add Document Version Dhrumil
Control, Content Page,
Introduction Page
Created Architecture Dhrumil
01st Feb 2024 0.0 Page
,Architecture
Description Page & Add
page number to contents
section
1
LOW LEVEL DESIGN
DOCUMENT
CONTENTS
INTRODUCTION 3-4
Need of LOW LEVEL DOCUMENT
DESIGN
SCOPE
PROJECT INTRODUCTION
PROBLEM STATEMENT
ARCHITECTURE 5-6
ARCHITECTURE 7-10
DESCRIPTION
2
LOW LEVEL DESIGN
DOCUMENT
INTRODUCTION
Need of Low Level Design Document
The purpose of this Low-Level Design (LLD) document is
to give the internal logic design of the actual program
code for Foreign Direct Investment Analysis .LLD
document describes the class diagrams with the methods
and relations between classes and program specs. It
describes the modules so that the programmer can
directly code the program from the document.
SCOPE
The LLD document is a component-level design process
that follows a step-by-step refinement process. The
process can be used for designing data structures,
required software architecture, source code and
performance algorithms. Overall, the data organization
may be defined during requirement analysis and then
refined during data design work.
PROJECT INTRODUCTION
As different Organizations under the e-commerce
industry seek to increase market footprint by creating
and sustaining a unique process to collect personal
information about customers and their purchasing
trends. The report critically evaluates how a service-
based organization Amazon uses management information
systems as a vibrant tool in attaining competitive
advantage through efficient management and acquisition
of information. As in today’s market without proper
sales management, it’s very hard to predict how the
business is running and how it will be in future. Many
companies with proper sales management have shown
better growth as they already know which item they have
to focus on, which product needs some improvement etc.
Sales management helps in maintaining its customer base
for a longer time by providing them attractive offers,
as they already have the information’s like who are
their top customers, whom they have to focus on etc.
3
LOW LEVEL DESIGN
DOCUMENT
Sales management so helps in minimizing the losses.
Also, the competition is increasing day by day as many
new companies are coming with better management
systems and giving tough
4
LOW LEVEL DESIGN
DOCUMENT
competition due to that it is now very important to
have a proper sales management to run any business and
to compete with these companies.
PROBLEM STATEMENT
The problem statement aims to analyze amazon sales of
2023 to know more in depth information about the items
that are in high demand, high profit so that ways are
find out to improve methods of distribution to reduce
cost ,stay ahead in the competition, have progressive
growth as well as further increase in the sales. As
sale management today is the most important function in
a commercial and business enterprise. To achieve the
goal, we used a data set that is given and analyze most
important parameter that are responsible for it. Also
get some meaningful insights from the given information
regarding Sales Data.
Do ETL (Extract-Transform-Load) the dataset and find
for me some information from this large data. This is
form of data mining. What all information can be
achieved by mining this data, would be brainstormed by
interns. Find key metrics and factors and show the
meaningful relationship between attributes. Do your own
research and come up with findings.
5
LOW LEVEL DESIGN
DOCUMENT
ARCHITECTURE
Microsoft Power BI architecture consists of four major
steps that explain the whole process from data sourcing
to creation of reports and dashboard. Various
technologies and process work together to get required
results with extreme precision. Let us see those steps
in pictorial format.
6
LOW LEVEL DESIGN
DOCUMENT
Sourcing data:
The sourcing of data coming from Amazon Central
typically refers to the process of extracting,
retrieving, or accessing data related to sales, orders,
inventory, and other relevant metrics from Amazon's
central platform or seller central dashboard. Once the
data is sourced from Amazon Central, sellers and
businesses typically perform data analysis and
reporting to gain insights into sales trends, customer
behavior, inventory management, advertising
performance, and overall business health.
Transforming the data: Before visualizing the data,
cleaning and preprocessing it should be done. This
means useless or missing values from rows or columns.
Following that certain rules will be applied to
transform and load datasets into the warehouse.
Report and publish: After cleaning and transforming the
data, reports will be created based on requirements. A
report is a visualization of the data with different
filters and constraints presented in the form of
graphs, pie-chart, and other figures.
Creating dashboards: Power BI Dashboards are created by
pinning individual elements or pages of live reports.
Dashboard should be created after you have published
your reports to the BI service. When the reports get
saved, the visual maintains the filter setting chosen
so that the user can apply filters and slicers.
7
LOW LEVEL DESIGN
DOCUMENT
ARCHITECTURE DESCRIPTION
Data Sourcing:
The dataset is in excel format and Microsoft excel is
used to load the data. The
Data Description: Here is the Data Dictionary
Transaction Details Table:
Transaction Type: Type of transaction (e.g., Order,
Refund).
Order ID's: Unique identifier for each order.
SKU: Stock Keeping Unit, a unique identifier for each
product.
UNIT QTY: Quantity of units purchased or refunded.
FULFILLMENT TYPE: Type of fulfilment (e.g., FBA - Fulfilled
by Amazon, FBM - Fulfilled by Merchant).
STATE: State where the transaction occurred.
Product Gross Sales: Gross sales amount for the product.
product sales tax: Sales tax applied to the product.
shipping credits: Credits applied to shipping.
shipping credits tax: Tax applied to shipping credits.
8
LOW LEVEL DESIGN
DOCUMENT
gift wrap credits: Credits applied to gift wrapping.
giftwrap credits tax: Tax applied to gift wrap credits.
promotional rebates: Promotional rebates applied.
promotional rebates tax: Tax applied to promotional
rebates.
marketplace withheld tax: Tax withheld by the marketplace.
selling fees: Fees charged for selling the product.
fba fees: Fees charged for FBA fulfilment.
other transaction fees: Other transaction fees.
other: Other miscellaneous fees.
Product Net Sales: Net sales amount for the product.
Ship Year: Year of the transaction.
Month: Month of the transaction.
Ship Date: Date of the transaction.
Ship Week: Week number of the transaction.
Parent Style: Parent style of the product.
Brand: Brand of the product.
Style: Style of the product.
Garment: Type of garment.
Color: Color of the product.
SKU: Stock Keeping Unit, a unique identifier for each
product.
Parent Style: Parent style of the product.
Brand: Brand of the product.
Style: Style of the product.
Garment: Type of garment.
9
LOW LEVEL DESIGN
DOCUMENT
Data Pre-Processing: Before building any model, it is
crucial to perform data pre-processing to
feed the correct data to the model to learn and
predict. This process includes following steps:-
Handing Missing/Null values , Handling Skewed Data and
Outliers Detection and removal.
Data Cleaning: Data cleaning is the process of fixing
or removing incorrect, corrupted, incorrectly
formatted, duplicate, or incomplete data
within a dataset.
a)Remove duplicate or irrelevant observations. b)
Filter unwanted outliers. c) Renaming required
attributes.
Exploratory Data Analysis(EDA):Exploratory Data
Analysis refers to the critical process of performing
initial investigations on data to discover patterns,
spot anomalies,
10
LOW LEVEL DESIGN
DOCUMENT
test hypothesis and check assumptions with the help of
summary statistics and graphical representations.
Reporting: Reporting is a most important and underrated
skill of a data analytics field. Because being a Data
Analyst you should be good in the easy and self-
explanatory report because your model will be used
by many stakeholders who are not from a technical
background. a) HLD(High Level Document)b)LLD(Low Level
Document)c)Architecture Report. d) Wireframe report. e)
Detailed Project Report.
Modelling: Data Modelling is the process of analyzing
the data objects and their relationship to the other
objects. It is used to analyze the data requirements
that are required for the business processes. The data
models are created for the data to be stored in a
database. The Data Model's main focus is on what data
is needed and how we have to organize data rather
performing the operations that are need.
11
LOW LEVEL DESIGN
DOCUMENT
Deployment: Power BI Dashboard
12
