The Goal of this project is to extract data from amazon web. This information is collected and then exported into a format that is more user friendly. The data extracted is aumotized and send it by email if the price of the item change.
Dashboards, stories and viz's.
Using LOD, Forecasting & Trends.
The purpose of this analysis is to easily search for either single instances of data or for data that match a set of requirements.
KPI's used: Annual revenue, Total sales, Revenues / Profitability (monthly), Significant deals booked (monthly), Geographic split (monthly), Comissions.
The purpose is to help the marketing team to understand where is traffic coming from, and how it performs in terms of volume and conversion rates.
KPI's used: Customer acquisition and customer journey analysis, Media analytics, Bounce rate, Top clients, ROI, CAC, Conversion Rate, CPC.
The purpose of this project is to ensure that your data from online store is clean, organized, and primed for use.
Keys: Determine the critical data values needed, eliminate errors & redundancy, search for missing values and fill themincrease data reliability, ensure format consistency
The purpose of this project is to provide an environment that is both convenient and efficient for users to retrieve and store information. The design of this Database is made to divide the information into subject-based tables to reduce redundant data.