Business KPI Dashboard Using Excel
Biz Model Combination - 1/ Several corrections: 1.1/ Company´s foundation name only the year 2016 (that´s the format). 1.2/ Column G (sheet 1) delete the shadow in the URL link. Example. www.google.com 1.3/ Fill the cells that contains text replicated or empty content (these are marked as yellow, 1 in sheet 1 and 5 in sheet 2. 1.4/ Check the sheet 2 column D (wich has to contain 533 companies) please check it sheet 1 and sheet 2 are not aligned according to the number of companies, besides of in sheet 2 you have to put the in column D - Comany Name X and Date of Foundation for example Facebook (2004) for all the cases. 2/ Double check and new column with industry sector reallocation. 2.1/ Check again the industry sector that belongs the company.(Add a new column with the double check). 2.2 Add a new column where you have to fit each previous sector into one of the following sector (please you don´t have to delete the column B neither the new one according to the double
Mi perfil
I am a professional Python Developer/Data Analyst/Web Mining Specialist, specialized in data extraction from excel, XML, JSON files, web scraping, data cleaning, data analysis and data visualization. I also do data entry, data manipulation in MS Excel. Developed strong engineering sense, able to identify problem quickly and provide solution to complete task. Possesses practical knowledge and skills in programming. A fast learner, collaborative, and highly motivated to meet short and long term goals of the team. During my professional career, I have performed a lot of projects of varying complexity. I specialize in the following areas: Web Scraping and Automation: - Beautifulsoup, [login to view URL],Lxml Back-end Technologies: - Python: Django, Pandas, Numpy -NodeJs -Docker Front-end Technologies: -Html, JavaScript, Angular, React,. Database: Oracle,SQL Server,SSRS,Mysql,Mongodb,Postgres,Firebase. I love to pay attention to details, which makes my projects more effective and optimized. I always provide great quality work, meeting all the deadlines and keep great long-term cooperation with my clients.
