How to fill a table I have

Attached is spreadsheet of sample data called “Ticket Data.”  I really need someone’s help to learn how to write the code to fill this table based “Opened” date and Employee.  For EVERY day I need to have a total number of tickets opened by each employee.  As you can see from the sample data, an employee may not open a ticket every day but I still need to have every employee represented for each day even if their total is ZERO.  I am thinking I need a separate table of active employees, which I have attached as well called “Employees.”  However, I have no idea where to start in order to get the data I need.  Once I have this then I will produce a bar/line chart combo where the bars represent tickets opened by each employee by date with the line above the bars representing total tickets opened by date.  Can anyone please assist me in what is needed to fill this table with the data I need?