Technical Skills involved : 𝗣𝘆𝘁𝗵𝗼𝗻, 𝗦𝗤𝗟, 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲, 𝗗𝗮𝘁𝗮 𝗺𝗼𝗱𝗲𝗹𝗹𝗶𝗻𝗴, 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜, 𝗗𝗔𝗫, 𝗗𝗮𝘁𝗮 𝗪𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗶𝗻𝗴, 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻 , 𝗘𝗧𝗟
The project 𝗲͟𝘅͟𝘁͟𝗿͟𝗮͟𝗰͟𝘁͟𝘀͟, India Statewise yearly (2008-16) accident due to high speed, , data as 𝗝𝗦𝗢𝗡 from API provided by Government Open Data Portal. After 𝘁͟𝗿͟𝗮͟𝗻͟𝘀͟𝗳͟𝗼͟𝗿͟𝗺͟𝗮͟𝘁͟𝗶͟𝗼͟𝗻͟ (Python, SQL) in accordance with Target Schema (reporting use case) it is then ingested/𝗹͟𝗼͟𝗮͟𝗱͟𝗲͟𝗱͟ to 𝗣͟𝗼͟𝘀͟𝘁͟𝗴͟𝗿͟𝗲͟𝗦͟𝗤͟𝗟͟ ͟𝗖͟𝗹͟𝗼͟𝘂͟𝗱͟ db, which is then fetched by 𝗣͟𝗼͟𝘄͟𝗲͟𝗿͟ ͟𝗕͟𝗜͟ for analytics.
𝗙𝗹𝗼𝘄 𝗗𝗶𝗮𝗴𝗿𝗮𝗺:
𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀:
𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗮𝗰𝘁𝗶𝘃𝗶𝘁𝘆 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
𝗣𝗮𝘁𝗶𝗲𝗻𝘁𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 Dynamic Interactive dashboard