Project Abstract
Covid-19 vaccination report and cost analysis
vaccination report and cost analysis
LIVE PROJECT WHICH ANALYSE DATA OF ASSOCIATE WHO VACCINATED COST REIMBURSMENT ENTIRE WORK FUNCTION IMPLEMENTED BY AZURE MODERN TECHNOLOGY SERVICES A CODELESS ARCHITECTURE DATA(ETL) AUTOMATION END TO END PROCESS.
- ChatBot
- WebApp Deployment
- Data Transform
- Automate Flow
- Report Analysis
Implementation Flow
Patet project was developed by a young energetic team and successful outcome was submitted on CALIBER HACKATHON-2021. Thanks to Microsoft and Cognizant for providing oppurtunity to learn, explore new technology.
Project Demonstration Download
Project Architecture Download
AI-1 ChatBot
Create and manage powerful AI chatbots using Power Virtual Agents
AI-1
Patet AI-1 chatbot is a no code bot which takes decision and action based on specific condition usng power flow and connectors a best enterprise AI chatbot - enhance customer experience.
TECHNOLOGY
AI-1 bot will answer customer queries and create servicenow ticket for solution,also transfer call to agent for complex issues.
USE CASES
customer service-Internal Helpdesk Support, Sales-Appointment Booking, Social Media-Messenger Platform, Personal Services-Reminder Bot, Marketing-Product Recommendation
IMPLEMETATION
POWERVIRTUAL AGENT: https://patet.azurewebsites.net/WEB APP DEPLOYMENT
Deploying a website using azure web app services and data stored in azure sql db and datalake storage
Feature
website was built with asp .net app in which data stored in sql and blob containers, for image to text convertor using ocr Computer Vision services.
TECHNOLOGY
Azure SQL Database, ASP.NET, Azure Datalake storage are maintained by Microsoft so integration and deployment is seamless.
USE CASES
Data storage
IMPLEMETATION
HOST: https://teampatet.azurewebsites.net/DATA TRANSFORM
Azure PaaS solution for data transformation and load
Project information
- Category-Azure Data flow
- Support Resources: link
Azure Data flow
Associate who vaccinated and not seggerated by the dataflow using mapdrift,pivot,datatransformation and data stored in destination - Datalakestoragegen2
Extract: Data is extracted from a source location
Transform: Data is transformed from its source format in order to fit the target location schema
Load: Transformed data is loaded into a target location,where it can be used for analytics and reporting
Automate Flow
Automate complex regular tasks
Power Flow
Codeless Architecture which makes complex regular activity easier consists of connectors to link database and other monitoring tools.
TECHNOLOGY
SAAS which used for automating workflows by various connectors to integrate apps, data, systems, services across enterprise or organizations a codeless architecture makes task ease with 100% outcome.
USE CASES
All sectors - Automate email reminder,data tracking and documentation
IMPLEMETATION
SUPPORT DATA: LINKReport Analysis
Powerful visualize data dashboard
Project information
- Category:PowerBi report
- Project URL: LINK
PowerBi
Report shows Associate who vaccinated and not with country and project wise comparsion, cost analysis also captured
Transform data, edit, remove unwanted column, add filters, add new query for column (power query editor) to add a custom column. power Query M function is used in mapping more input values to a single output
Team
DEEPANRAJ
TECHNICAL LEADCLOUD ENTHUSIAST
KAVYAMANDLEM
Programmer AnalystCLOUD ENTHUSIAST
