Banner Image

All Services

Programming & Development Math / Algorithms / Analytics

Data Analyst | Mis Analyst

$15/hr Starting at $40

Design a database that holds all the information for each and every module in the hotel from the Goibibo Website. * With the help of, mysql workbench, I created a schema which represents all the attributes, constraints and relationships between the tables using normalization organizing the columns and tables of a database to ensure that database integrity constraints properly execute their dependencies. And create triggers , views, index ,and Stored procedure . * Scraped all the hotel details using python libraries, extracts the data and transformed it into a single file using a query editor. * Then perform EDA with visualization. * Did Sentiment Analysis on the basis of customer's Feedbacks using TextBlob Library. * At the end, I created an interactive Dashboard using POWER BI .

About

$15/hr Ongoing

Download Resume

Design a database that holds all the information for each and every module in the hotel from the Goibibo Website. * With the help of, mysql workbench, I created a schema which represents all the attributes, constraints and relationships between the tables using normalization organizing the columns and tables of a database to ensure that database integrity constraints properly execute their dependencies. And create triggers , views, index ,and Stored procedure . * Scraped all the hotel details using python libraries, extracts the data and transformed it into a single file using a query editor. * Then perform EDA with visualization. * Did Sentiment Analysis on the basis of customer's Feedbacks using TextBlob Library. * At the end, I created an interactive Dashboard using POWER BI .

Skills & Expertise

AnalyticsData AnalysisData ManagementData ModelingData VisualizationDatabase DesignDatabase DevelopmentGoogle AnalyticsMATLABMicrosoft ExcelMySQLPower BIPython

0 Reviews

This Freelancer has not received any feedback.