An attempt....  Looking forward to learning new tricks.

An attempt....  Looking forward to learning new tricks.

 

Hi Shelton!

Great attempt here! I have already posted the answers to this in the Monarch Success Plan, but a few quick comments;

1. Yes! This is correct.

2. Yes! This is correct.

3. Almost, there. Adding a Sort by Salary (Descending Order) would help you with this. I did notice that one of the salary values for one employee was different though.

Question for you; Do you think a webinar to review these would be helpful?

Hi Shelton,

By the way, the Sort option mentioned by Baba is in the Table window.  I think you have used the Sort option on a key field in a summary on your example.  Note how this sorts by the total value of all records that have same summary key value.  Therefore, Banning is at the top of the list with their individual 87,570.  Then it is the combined value of (37,500 + 44,800) = 82,300 for the two employees called Marshall.  Then Hampsted, with a combined total of 80,100, then Smith on their own with 75,000 . . and so on.

Thanks.  I should have realized that multiple employees had the same name. 

Hi,

I solved few.

• How many employees were hired between 1990 & 1995? -- Attached: Between1990-95.xls
• Who are the Top 5 Employees with the highest Salaries? -- Attached: Top-5-Salaries.xls
  
• Create a calculated field called "Bonus" that is 3% of Salary for employees in the 'Marketing' Department, and 2% for all other Departments -- working on it.

@Baba Majekodunmi 

Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.

@Baba Majekodunmi 

Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.

@Baba Majekodunmi 

Question 1:

As per your answers you got 29 as per Monarch Classic, but we used Monarch Data Prep we got 32, how ?

Your answers link:

https://community.altair.com/community?sys_id=6828c1301b8be510507ca6442a4bcbe4&view=sp&id=community_blog&table=sn_communities_blog

Here are my table and summaries for the top 5 and hires 90-95

Here are my table and summaries for the top 5 and hires 90-95

Hi Susan! You got #1 and #2 correct.

Can you share the formula you used for #3 - the bonus calculation?

@Baba Majekodunmi 

Can you share vidoe links in 'Monarch Data Preparation part', so that we have more techniques to decode the problem.

@Baba Majekodunmi 

Question 1:

As per your answers you got 29 as per Monarch Classic, but we used Monarch Data Prep we got 32, how ?

Your answers link:

https://community.altair.com/community?sys_id=6828c1301b8be510507ca6442a4bcbe4&view=sp&id=community_blog&table=sn_communities_blog

 

Yes that is correct. I made a mistake during the recording. The correct answer is 32.

@Baba Majekodunmi , thank you for confirming, really i am enjoying learning.

Thank you for the vidoes and exercies.

@Baba Majekodunmi 

Fun exercise - I've attached shots of generated tables.  I watched the answers video as well.  Nicely presented and very informational.

Thank you,

Submissions attached.

3 attachments