avatar
Arsalan Anwari
Consultant Data, IT and Cloud Computing
  • Residence:
    Netherlands
  • City:
    Utrecht
  • Age:
    23
Dutch
English
German
Consulting
Data Analysis
Data Engineering
Networking & Security
Parallel Computing
Automation
  • Analytical mindset
  • Mathematical & technical
  • Not afraid to be direct
  • Studious and entrepreneurial
  • Agile in new environments
  • Has diverse set of skills
  • Can simplify complex concepts

Designing sales dashboard

Description

Votexa (formerly known as Club Logistics Services) wanted a better overview about their financial/company situation and their sales using a couple of live dashboards in PowerBL. These being:

  • Live sales dashboard of E-bike battery’s.
  • Live sales dashboard of car battery’s.
  • Operational dashboard with daily, weekly, monthly and yearly summary of all sales and revenue.
  • Forecast dashboard of E-bike battery’s.
  • Forecast dashboard of car battery’s

I first had to advise them what insights might be interesting for them to monitor before consulting them how they would be able to stream data to PowerBI. Their data was initially scattered through different sources which made it impossible for them to use PowerBI as you can only use one streaming dataset per dashboard.

  • At first I advised to them to create some middleware in Python which periodically retrieves data from different sources and combines them into a single REST call send to PowerBI. This was because a multitude of different legacy SFTP and webservers where used by each of their B2C and B2B web shops.
  • Eventually this python application was not necessary anymore as they hired me to streamline all of their data locally in another project (see Designing Hybrid cloud solution) to an on-premise NAS. This ment you could run SQL server locally that can connect to PowerBI to using PowerBI Enterprise Gateway and a Cisco ASA5506 VPN router.
  • Order Date:
    15-03-2021
  • Final Date:
    15-11-2021
  • Status:
    Active
  • Client:
    Votexa
  • Location:
    Veendendaal

Sources:

  • One of the dashboards made
  • Client reviews



    © 2021 Arsalan Anwari
    Template author:  Lucidy

    Loading Resume...