Emily is working on employee statistics for her company, looking at distributions in employee age, gender, ethnicity, and education level. How can she prepare the information to present it to HR?1 pointCreate the appropriate charts for each of the factors assessed and present each individual worksheet with the chart and the corresponding table to HR.Create the appropriate PivotTables for each of the factors assessed and compose a dashboard with the tables to present it to HR.Create the appropriate charts for each of the factors assessed and compose a dashboard with the charts to present it to HR.Create the appropriate PivotTables for each of the factors assessed and create a word document with the tables to present it to HR.

Calculations on pivot table in HR analytics dataset - Data Analysis in Excel, Aggregating and Summarizing Data in Pivot tables - Post ClassGiven an Employees dataset, there are different categories for people who are required to travel as part of their job, your task is to find the following insights for each category in order to reconsider budget allocation.Tasks1.Find the percentage of employees from each department using pivot table in the cells B2:B5 in sheet named Pivot

According to the ‘Creating a Simple Dashboard using Excel’ video, which of the following should you have already done prior to creating a dashboard? (Select all that apply) 1 pointFormatted the data as a table.Created pivot tables to help analyze data.Created a data analysis findings report.Verified data is clean and error free.

Create Table Employee with attributes firstName,LastName,SSN,Address,Salary,Birthday,Sex,SupervisorSSN,DepartmentNo

What are some of the goals of developing an organization chart?Multiple select question.To communicate the contact information for all employeesTo show relationships among peopleTo show who reports to whomTo show quarterly and annual production numbers

In this task, you will be required to read the questions carefully and understand that business requirement. Once you have an idea of what is required from the perspective of the CEO and CMO, you will need to come up with the perfect visual which will illustrate what the senior managers are looking for in each scenario. Remember, data can be presented in multiple types of charts, but you are required to select the visual that would best display the information which is being presented.You will be provided resources on how to select visuals based on the different scenarios, these are available in the resources section. These resources will help you get an idea on which visual to select for the given business scenario and will also guide you on how to choose the right chart or graph for your data. Each question will contain a unique scenario and you will be expected to answer the questions based on that scenario.To complete this task, answer the multiple-choice quiz. Start the quiz by clicking 'Click here to start the task' in section 5 below. Please note there are 5 multiple choice questions to complete in this task. Please be patient as each question loads.