Portfolio
<aside> 👉🏻 👩Data Analyst at Larsen & Toubro (L&T), Chennai Headquarters @https://www.lntecc.com/
</aside>
“Where there is data smoke, there is business fire.” I am currently working as a Data Analyst at Larsen & Toubro (L&T) since July 2022 after a few internships from The Sparks Foundation and Indian Overseas Bank (IOB). Also an alumna of Vellore Institute of Technology(MSc Data Science: 2020-2022) and M.O.P Vaishnav College For Women(BSc Mathematics: 2017-2020**).**
<aside> 💡 On my initial days of joining, I was given a few tasks on SQL (basic SQL questions) like creating a table, viewing, altering, updating, and deleting along with some intermediate queries which would require Counts, and joins for practicing.
</aside>
<aside> 💡 The next task was to scrap the data(Web scraping) from a commodity-based website where it was done in Python, SQL, and manually in Excel. This task was handled along with my team members.
</aside>
<aside> 💡 Then moved into the main part of learning about the Business Intelligence tool Power BI where my first task is to make a report on the “Gapminder data” ( https://data.world/missdataviz/wow2021-w11). The aim was to make a bubble chart, Correlation, and choropleth maps and to create a suitable bucket set. Further to the next task of making the report on the Top 50 highest-grossing superhero movies where I what-if parameter, a bar chart showing the Top N highest, conditional formatting, etc.
This was my journey in learning about the Power BI tool.
</aside>
<aside> 👉🏻 I was roped in for creating a report on “Cement Price Trend” which is the analysis of the rate of cement on weekly basis for two years. Process - With the data given for two years, the main work was to analyze the price trend of cement procured by the company for a particular brand of cement excluding the outliers. New findings & learnings - Removing the outliers using percentiles and creating different Dax measures according to the requirement given. Visual level filters for removing the outliers and filling in the missing values were quite challenging to bring out the correct price trend.
</aside>