Data reporting and visualisation using Power Bi
- or -
Post a project like this$$$
- Posted:
- Proposals: 22
- Remote
- #1909524
- Expired
Economist - BI/BA Consultant - Microsoft Certified Solution Associate - Tableau - Alteryx
Bogota
1343428214471321280612114665208882120758941938466187613016110561471044142698740596
Description
Experience Level: Expert
We are an e-commerce retailer, looking for a data visualisation specialist who can turn our sales data into information using power bi.
The insights we want are quite basic but its important for us to be able to systemize the process of turning the data into information so we can access and analyse our sales data anytime.
These are the basic level insights we are looking for:
*Total sales (all channels)
* Total sales per channel
* total sales per product category
* total sales per product category, per channel
* total sales per SKU within the category (all channels)
* sales per sku within the category, per channel
SKU Level:
* sales total (all channels combined)
* sales per channel
* traffic per channel
* conversion per channel
* stock level
Your experience of analysing data will be just as important as your expertise in using power bi. In addition to the above insights, we want you to advise us on any other insights we can glean from our data and what relationships we should be analysing.
The source of our sales and inventory data is an e-commerce management system called Linnworks, from which we are able to extract the data in CSV format. Linnworks has the capability of running custom SQL queries, which will be a pre-requisite of the job.
If you are an experienced retail data visualisation/analyst this job is the right fit you!
The insights we want are quite basic but its important for us to be able to systemize the process of turning the data into information so we can access and analyse our sales data anytime.
These are the basic level insights we are looking for:
*Total sales (all channels)
* Total sales per channel
* total sales per product category
* total sales per product category, per channel
* total sales per SKU within the category (all channels)
* sales per sku within the category, per channel
SKU Level:
* sales total (all channels combined)
* sales per channel
* traffic per channel
* conversion per channel
* stock level
Your experience of analysing data will be just as important as your expertise in using power bi. In addition to the above insights, we want you to advise us on any other insights we can glean from our data and what relationships we should be analysing.
The source of our sales and inventory data is an e-commerce management system called Linnworks, from which we are able to extract the data in CSV format. Linnworks has the capability of running custom SQL queries, which will be a pre-requisite of the job.
If you are an experienced retail data visualisation/analyst this job is the right fit you!
Khaled U.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
28 Aug 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Khaled, please advise if this post is still open and still looking for a pro e-commerce analyst and visualisation expert. Thanks
608505
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies