En curso

Power BI - Custom Dashboard

Objective: Create a very simple dashboard to give store managers the ability to track very basic Daily Key Performance Indicators (KPIs) which helps them to understand and address behaviors on the sales floor Through Power BI Mobile and Desktop .

History: I’ve been manually gathering information from sales reports in our POS and Traffic counters, and recording it on a excel spreadsheet, then I send a picture of the spreadsheet to my managers so they know which store is ahead in sales and why, on weekends I send that picture every other hour and it takes me being stuck in front of a computer collecting reports.

Data mining:

1. Traffic counter data

a. Collect number of people that have visited each store from opening hours through the moment the report is needed

b. See [login to view URL]

2. POS data:

a. Number of transactions per store

b. Total sales per store

c. Number of items sold per store

d. Total in Returns

Store Goals:

1. Conversion of traffic: 20% (hard-set goal)

2. Average Sale: $68 (this is a variable target calculated based on combined store averages for the month)

3. Units per Transaction: 2 (hard-set goal)

Update frequency:

I’d like to be able to change that as needed, but automatically updating dashboard every 5 min is a good start.

Historical Data:

The default view should show sales of the day, but we need to be able to select ranges such as:

1. Week to date per store

2. Month to date per store

3. Year to date per store

4. User selected Date Range


Local DB servers send transaction deltas to Head Quarters DB Server through meshed VPN connection every 5 min.

Habilidades: Power BI, Servidor de Microsoft SQL , Inteligencia comercial, Análisis de negocios

Ver más: custom scripting project sale, custom flash header sale, custom shirt templates sale, custom forum software sale, power ranger custom, custom website templates sale, custom optimus prime sale, custom awbs template sale, objective sound frequency, custom csv file import field update, custom dashboard pps, custom excel macros sale, custom flash game sale, dashboard designer excel file update performance point, invision power board custom development skinning, create google analytics custom dashboard, invision power board custom theme

Información del empleador:
( 0 comentarios ) Midvale, United States

Nº del proyecto: #20800373

Adjudicado a:


Hi there, I am a Microsoft Certified Business Intelligence Developer. I have hands on experience of working with Power BI and this seems like a fairly straightforward implementation. I am just wondering if the .asmx Más

$600 USD en 7 días
(0 comentarios)

3 freelancers están ofertando el promedio de $589 para este trabajo


Hello, Power BI custom dashboard experts already worked on Power BI a lot and can share details regarding same ones we connect and can start by the time you hire. I have more than 10+ years of experience in Microso Más

$666 USD en 7 días
(1 comentario)

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Más

$500 USD en 7 días
(0 comentarios)