Sreejith B. Profile

LÖYDÄ

5,0

(27 arvostelua)

Seuraat nyt käyttäjää

Virhe seurattaessa käyttäjää.

Tämä käyttäjä ei salli käyttäjien seurata häntä.

Seuraat jo tätä käyttäjää.

Jäsenyystasosi mahdollistaa vain 0 seurausta. Päivitä tästä.

Käyttäjän seuraaminen lopetettu onnistuneesti

Virhe poistettaessa käyttäjän seurantaa.

Olet onnistuneesti suositellut käyttäjää

Virhe suositeltaessa käyttäjää.

Jokin meni vikaan. Päivitä sivu ja yritä uudelleen.

Sähköposti vahvistettu onnistuneesti.

$30 USD / tunti

trivandrum,

india

$30 USD / tunti

Aika on tällä hetkellä 1:26 ap. täällä

Liittynyt syyskuuta 28, 2019

0 Suositukset

Sreejith B.

@amwazeindia

5,0

(27 arvostelua)

5,5

96%

$30 USD / tunti

trivandrum,

india

$30 USD / tunti

100 %

Suoritetut työt

100 %

Budjetin mukaisesti

99 %

Aikataulussa

14 %

Uudelleenpalkkausaste

Microsoft Certified | Power BI | Azure

I specialize in creating customized solutions for data processing, reporting and visualising using Power BI, Excel, Google Sheets and Looker Studio (Google Data Studio). Well adept in Python, DAX, M, SQL and VBA, I can also help you with process flow automation using Power Automate and Logic App. I am a Microsoft Certified Data Analyst Associate and currently preparing for the next certification on Data Engineering using Azure. Coming to my background, I have a degree in Mechanical Engineering and worked as a marine engineer for 10 years. Afterwards, I have been working as a freelance consultant for Power BI projects since 2019. Have helped organizations establish a Power BI and Azure architecture ( ADLS2, ADF , Azure SQL and Dataflows) from the scratch, train and build a team of Power BI developers and provide back end support for analytics solutions.Currently working as a Power BI consultant for a telecom infrastructure development company in EU.

Katso kaikki Excel Experts paikassa India

Ota yhteyttä käyttäjään Sreejith B. työhösi liittyen

Kirjaudu sisään keskustellaksesi yksityiskohdista chatissa.

Portfolio

Data engineering project in Azure.
Raw data is from web and a csv received in a email inbox. Objective is to have the data made available for long term historical analysis and visualize it in Power BI
Tools used :
- Google Cloud APIs
- Azure Data Lake Storage
- Azure Data Factory
- Azure SQL
- Azure Synapse Analytics
- Azure Databricks
- Lake Data House (Fabric)
- Python (pandas)
- Azure Function App
- Azure Logic App
- Power BI

Data Engineering in Azure

Issue tracker dashboard using Power BI.
Raw data is from a web api output as a json file. An Azure Logic App takes this data from the web service and saves the json in a Google Drive, which serves as a staging container. An Azure Data Factory pipeline takes this data from there. In the pipeline a Synapse notebook activity is added, which will carry out the ELT process. The cleaned data is stored in an Azure Data Lake Storage, in parquet format. Using Azure Synapse Analytics, a serverless Data Lake is created, which can be queried in the Power BI using SQL statements.
Another part of the data is a csv file that is received as an email in gmail . An appscript is created in a google sheet, stored in the previously mentioned staging Google Drive, which will copy the contents of the csv file into the google sheet. From the Google Sheet, another Data Factory pipeline will take the data and store it in the serverless data lake in csv format.

Power BI Report

Dashboard using Plotly and Dash

Dashboard designed as a part of contest. Though the contest was not won, I believe I was able to create a good looking functional dashboard.
To have a clutter free experience, dimensions that are related added as optional metrics which can be easily switched between by a flick of a button. Multiple pages in the dashboards are linked via buttons and provides a seamless navigation. Drill throughs also provided to the charts offering more analytics.
Time taken : ~3 hours

Google Data Studio Dashboard

Project : Analyze and visualize live traffic data of last 100 thousand vehicles in the roads of a city.
Dataset : Google sheet with incoming data every 15 minutes
Analysis and Visualization tool : Google Data Studio
Time taken : 8 hours

Live Traffic Dashboard

Multiple teams job tracking sheet and a central dashboard in Excel.
Data will be entered in separate sheets for each teams. All the data from multiple sheets are consolidated in a single sheet using query. Pivot tables are then created using this database and then visualized in the form of a dashboard.

Work tracker & dashboard using VBA and Excel

Data Engineering in Azure

Power BI Report

Dashboard using Plotly and Dash

Google Data Studio Dashboard

Live Traffic Dashboard

Work tracker & dashboard using VBA and Excel

Arvostelut

Muutokset tallennettu

Näytetään 1 - 5 / 26 arvostelua

Suodata arvosteluja:

5,0

Hintaa ei näytetä

Automatic data validation in excel

Excellent job

Database Administration

Satish K.

@satishkandikonda

•

3 vuotta sitten

5,0

Hintaa ei näytetä

Project for Sreejith B. -- 2

With the kind of support and intuitive involvement that Sreejith does, I will be working with him over a long time. Highly Recommended Professional. In this Project we developed a VBA tool that reduced manual efforts to minimum and improved on accuracy as well.

+1 enemmän

Abhay G.

@a020aga

•

3 vuotta sitten

5,0

Hintaa ei näytetä

Project for Sreejith B.

Excellent work! On time, on budget!

+1 enemmän

Srdjan D.

@sdrljaca

•

3 vuotta sitten

5,0

Hintaa ei näytetä

Project Report in Power BI

100% dedicated to project and delivery

Power BI

Srdjan D.

@sdrljaca

•

3 vuotta sitten

5,0

Hintaa ei näytetä

Project for Sreejith B.

Sreejith is an expert professional !! Understands the requirements and the project delivery was exactly as per expectations !! I am very satisfied and he is my go to man for any further needs. Looking ahead to many more collaborations !! Thanks Sreejith !!

+1 enemmän