Amrit Subramaniam

GUIDED BY: Revathi Santhanam PRESENTED BY: Amrit Subramaniam BaneraSoft (I) Pvt. Ltd. An analysis, on a web-sourced dataset that contains records for every tree (1995) in New York City containing the tree's location (by borough), species by Latin name and common names. Dataset - Preview CSV SQL Server Import • Queries • DML Operations • Cleaning, customizing the dataset Microsoft Power BI •Import From SQL Server •Database Object Scope of Analysis • How many species of trees have been recorded? • How many trees are unique among the species? • Which are the “greenest” areas? • Which trees are most grown in those areas, and across the rest of the city? • Which trees have been grown less, what’s their count? Dashboard - An Overview ●Trees planted the Most, ranked by common name ●Map to navigate by Borough ●Most “Green” Areas TreeMap Visualisation: By Borough TreeMap Visualisation: By Borough ●A piechart to show the top five kinds of trees. It can be observed that the selected borough’s significance in the total quantity is indicated by the colour fill. ●TreeMap visual listing out the top five “green” boroughs, that cross report on the other visuals, making them display data corresponding to the selected borough TreeMap Visualisation: Drill Down While the level of visualisation is by default Borough wise, it can be seen further down the hierarchy, viz. Tree wise, by drilling down the visualisation. This makes the next level analysis possible on the same report. With “Drill Down” facility, the level of visualisation is changed to “Tree Wise” from borough wise analysis. On this visualisation level, it can be seen that the display cards correspond to the selected tree type, showing the total number of that tree planted.