#OpenToWork #Tableau #Dataanalytics #JobSearch #HireMe #JobHunt #JobSeeker #JobSearching #JobSeeking #LookingForWork #LookingForEmployment #OpenToOpportunities #ReadyToWork I eagerly anticipate the opportunity to apply and further develop these newfound skills in my future endeavours. The key skills I have gained through this program encompass data cleaning and preparation, data analysis to identify trends, querying relational databases using SQL, and the creation of data visualizations and interactive dashboards. These tasks were accomplished using a variety of analytical tools, including EXCEL, TABLEAU, PYTHON, and SQLite.
Throughout the bootcamp, I took charge of various projects, which included tasks such as exploring an energy usage dataset, crafting a dashboard to meet specific business requirements, evaluating the quality of a dataset for a public service agency, and extracting user activity data from an online forum. This learning experience has been truly exhilarating. We shall describe next how the Excel Solver can be used to quickly find the optimal solution.I am pleased to announce the successful completion of the Data Analyst - Digital Skills for Life Bootcamp, generously funded by the Department of Education of the UK through Openclassroom. It is not necessary to use trial and error. With this formulation, it becomes easy to analyze any trial solution.įor example, if we assign Person 1 to Task 1, Person 2 to task 2 and Person 3 to Task 3, Tasks Assigned equals Supply and Persons Assigned equals Demand. Total Cost equals the sumproduct of Cost and Assignment. Range NameĮxplanation: The SUM functions calculate the number of tasks assigned to a person and the number of persons assigned to a task. To make the model easier to understand, create the following named ranges. What is the overall measure of performance for these decisions? The overall measure of performance is the total cost of the assignment, so the objective is to minimize this quantity.Ģ. Each task only needs one person (Demand=1).Ĭ. What are the constraints on these decisions? Each person can only do one task (Supply=1). For example, if we assign Person 1 to Task 1, cell C10 equals 1. What are the decisions to be made? For this problem, we need Excel to find out which person to assign to which task (Yes=1, No=0). To formulate this assignment problem, answer the following three questions.Ī.
0 kommentar(er)
