Designed and developed a data warehouse to answer various business queries related to smartphone market in India, USA and Ireland by performing the ETL process in SSIS, deploying the cube in SSAS, creating a database in SSMS and connecting it with tableau for the analytical purpose. Technologies used: MySQL, SSMS, Visual Studio, ETL, SSIS, SSAS, Tableau, R for extracting the unstructured data from YouTube, cleaning the data and performing the sentimental analysis.
