1.

How many years has each person worked in a specific

position? Result should include name of employee,
Position and number of years, rounded to the first decimal
place (take presentation date as end date)

2. How many years has each person been in the

company? Result should include the name of person and
the number of years since start date (there should be one
row per person & use presentation date as end date).
Round the values to the first decimal place.

3. Get a unique list of names split to 3 Columns: First

Name, Middle Name (if any, otherwise empty) & Last
Name.
Project: Data Analysis with Power Query

Name Start Date End Date Department Position Salary

Walter J Miller 1/15/2020 Sales Sales Assistant 25,709
Alissa Mitchell 6/11/2019 Marketing Marketing Assistant 25,600
Andre C Cooper 10/2/2018 Procurement Procurement Assistant 23,500
Ann Withers 9/2/2019 2/3/2020 Procurement Procurement Assistant 23,500
Ann Withers 2/3/2020 Procurement Buyer 25,000
Kim West 2/1/2018 Sales Sales Assistant 26,500
Daniel A Garrett 8/1/2017 Finance Accountant 24,700
Lyric Nate Wise 4/24/2018 Sales Sales Assistant 24,200
Robert Marquez 3/1/2017 Procurement Buyer 26,500
Vanessa Chavez 11/29/2017 Sales Sales Representative 30,600
Brylee Hunter 5/31/2017 Procurement Buyer 30,200
Robert Musser 10/1/2018 Procurement Buyer 28,400
Reid Good 3/14/2017 Sales Sales Representative 31,900
Christopher P Sharp 8/22/2016 Sales Sales Representative 32,500
Jessica Lowe 1/11/2017 Sales Sales Representative 32,800
Evie Williamson 12/20/2016 Sales Sales Assistant 25,900
Skye Bennett 10/31/2016 Finance Accountant 26,900
Braeden Wilkins 3/23/2016 Finance Accountant 47,200
Donald Caldwell 3/1/2017 6/3/2019 Finance Financial Analyst 29,800
Donald Caldwell 6/3/2019 Finance Controller 40,000
Amber Stevens 7/23/2018 Procurement Buyer 31,200
Matilda Parry 7/4/2016 Sales Regional Sales Manager 49,500
Makai Bond 11/4/2015 Sales Sales Representative 32,500
Paul Garza 2/1/2016 Sales Sales Representative 34,808
Nico Gaines 3/14/2017 Procurement Buyer 34,700
Jordan Parry 8/21/2017 Marketing Digital Marketing 58,300
Lamar Fry 8/31/2015 Sales Sales Representative 36,800
Charlie Chambers 8/6/2015 Marketing Digital Marketing 36,400
Natalie Porter 2/4/2019 1/2/2020 Sales Sales Representative 32,100
Natalie Porter 1/2/2020 3/2/2020 Sales Sales Analyst 35,000
Natalie Porter 3/2/2020 Finance Financial Analyst 35,000
Jim Mcguire 6/20/2016 Sales Sales Representative 39,600
Roger Mun 9/2/2013 Legal Attorney 89,700
James Rogers 2/19/2015 Procurement Buyer 38,900
Tommy K Dixon 10/6/2016 Sales Sales Analyst 38,500
Robert Hurley 5/22/2017 Sales Sales Analyst 39,400
Harry Burke 7/21/2014 Sales Sales Analyst 42,500
Robert N Spear 1/5/2015 Sales Sales Representative 43,668
Richard Elliot 11/5/2014 Finance Financial Analyst 49,727
Aydin Merritt 11/4/2013 Sales Sales Representative 48,500
James Willard 12/2/2013 Sales Sales Representative 49,627
Lukas Hofer 9/24/2018 Finance Tax Analyst 49,000
Jude Bell 10/11/2013 Procurement Lead Buyer 56,500
Heidi Medina 6/27/2014 Marketing Marketing Manager 79,600
Ashton Kelly 8/13/2013 Procurement Lead Buyer 57,800
Matthew Ross 7/24/2015 Procurement Lead Buyer 59,900
Esme Carney 6/20/2016 Procurement Buyer 48,500
Zac Fletcher 7/15/2013 Sales Sales Assistant 41,200
Kristina Mclean 12/27/2013 Sales Sales Analyst 52,100
Maria Tot 1/5/2015 Sales Sales Representative 88,000
Wolfgang Ramjac 7/1/2002 Sales Sales Representative 116,000
Tom Wood 5/8/2013 Procurement Lead Buyer 65,200
Peter Ramsy 5/3/2010 Sales Sales Representative 65,432
Betina Bauer 1/3/2019 Procurement Buyer 54,600
Cora Briggs 9/16/2013 Procurement Buyer 51,300
Matilda Collier 5/28/2013 Sales Sales Representative 65,200
Mike Saban 8/10/2015 Procurement Category Manager 102,500
Paul Wells 9/1/2016 Sales Sales Representative 63,500
Ewan Long Thompson 9/3/2008 Sales Regional Sales Manager 70,270
Gary Miller 9/4/2006 Finance Controller 65,270
Holly Macdonald 11/4/2019 Finance Insurance Advisor 78,600
Crystal Doyle 12/3/2012 Finance Finance Director 145,000
Corinna Schmidt 7/15/2010 Procurement Category Manager 86,055
Robert Blume 7/4/2016 Sales Sales Representative 59,600
Brigitte Bond 3/2/2015 Sales Regional Sales Manager 115,000
Cerys Holmes 8/7/2017 Finance Tax Professional 88,300
Imogen Clarke 5/15/2019 Finance Tax Professional 86,500
Paul Hill 4/5/2006 9/3/2018 Finance Controller 60,000
Paul Hill 9/3/2018 Finance Finance Manager 108,357
Stevie Bridge 10/3/2011 Sales Sales Manager 125,600
Alex Collins 1/10/2020 Procurement Procurement Manager 142,000
Robert Richardson 11/1/2016 Sales Head of Sales 141,200
Maisie Burton 11/12/2012 Management Managing Director 185,000
Brittany Lee Long 10/22/2018 Management Assistant to MD 55,800
Dan Ziegler 2/3/2020 Legal Head of Legal 125,000
Daniela Schreiber 3/2/2015 Legal Attorney 91,000
Overall End Date -> Presentation Date
6/30/2020
Name Position Total Years
Walter J Miller Sales Assistant 0.5
Alissa Mitchell Marketing Assistant 1.1
Andre C Cooper Procurement Assistant 1.7
Ann Withers Procurement Assistant 0.4
Ann Withers Buyer 0.4
Kim West Sales Assistant 2.4
Daniel A Garrett Accountant 2.9
Lyric Nate Wise Sales Assistant 2.2
Robert Marquez Buyer 3.3
Vanessa Chavez Sales Representative 2.6
Brylee Hunter Buyer 3.1
Robert Musser Buyer 1.7
Reid Good Sales Representative 3.3
Christopher P Sharp Sales Representative 3.9
Jessica Lowe Sales Representative 3.5
Evie Williamson Sales Assistant 3.5
Skye Bennett Accountant 3.7
Braeden Wilkins Accountant 4.3
Donald Caldwell Financial Analyst 2.3
Donald Caldwell Controller 1.1
Amber Stevens Buyer 1.9
Matilda Parry Regional Sales Manager 4
Makai Bond Sales Representative 4.7
Paul Garza Sales Representative 4.4
Nico Gaines Buyer 3.3
Jordan Parry Digital Marketing 2.9
Lamar Fry Sales Representative 4.8
Charlie Chambers Digital Marketing 4.9
Natalie Porter Sales Representative 0.9
Natalie Porter Sales Analyst 0.2
Natalie Porter Financial Analyst 0.3
Jim Mcguire Sales Representative 4
Roger Mun Attorney 6.8
James Rogers Buyer 5.4
Tommy K Dixon Sales Analyst 3.7
Robert Hurley Sales Analyst 3.1
Harry Burke Sales Analyst 5.9
Robert N Spear Sales Representative 5.5
Richard Elliot Financial Analyst 5.7
Aydin Merritt Sales Representative 6.7
James Willard Sales Representative 6.6
Lukas Hofer Tax Analyst 1.8
Jude Bell Lead Buyer 6.7
Heidi Medina Marketing Manager 6
Ashton Kelly Lead Buyer 6.9
Matthew Ross Lead Buyer 4.9
Esme Carney Buyer 4
Zac Fletcher Sales Assistant 7
Kristina Mclean Sales Analyst 6.5
Maria Tot Sales Representative 5.5
Wolfgang Ramjac Sales Representative 18
Tom Wood Lead Buyer 7.2
Peter Ramsy Sales Representative 10.2
Betina Bauer Buyer 1.5
Cora Briggs Buyer 6.8
Matilda Collier Sales Representative 7.1
Mike Saban Category Manager 4.9
Paul Wells Sales Representative 3.8
Ewan Long Thompson Regional Sales Manager 11.8
Gary Miller Controller 13.8
Holly Macdonald Insurance Advisor 0.7
Crystal Doyle Finance Director 7.6
Corinna Schmidt Category Manager 10
Robert Blume Sales Representative 4
Brigitte Bond Regional Sales Manager 5.3
Cerys Holmes Tax Professional 2.9
Imogen Clarke Tax Professional 1.1
Paul Hill Controller 12.4
Paul Hill Finance Manager 1.8
Stevie Bridge Sales Manager 8.7
Alex Collins Procurement Manager 0.5
Robert Richardson Head of Sales 3.7
Maisie Burton Managing Director 7.6
Brittany Lee Long Assistant to MD 1.7
Dan Ziegler Head of Legal 0.4
Daniela Schreiber Attorney 5.3
Name Total Years
Wolfgang Ramjac 18
Paul Hill 14.2
Gary Miller 13.8
Ewan Long Thompson 11.8
Peter Ramsy 10.2
Corinna Schmidt 10
Stevie Bridge 8.7
Maisie Burton 7.6
Crystal Doyle 7.6
Tom Wood 7.2
Matilda Collier 7.1
Zac Fletcher 7
Ashton Kelly 6.9
Roger Mun 6.8
Cora Briggs 6.8
Jude Bell 6.7
Aydin Merritt 6.7
James Willard 6.6
Kristina Mclean 6.5
Heidi Medina 6
Harry Burke 5.9
Richard Elliot 5.7
Robert N Spear 5.5
Maria Tot 5.5
James Rogers 5.4
Daniela Schreiber 5.3
Brigitte Bond 5.3
Charlie Chambers 4.9
Matthew Ross 4.9
Mike Saban 4.9
Lamar Fry 4.8
Makai Bond 4.7
Paul Garza 4.4
Braeden Wilkins 4.3
Esme Carney 4
Matilda Parry 4
Jim Mcguire 4
Robert Blume 4
Christopher P Sharp 3.9
Paul Wells 3.8
Tommy K Dixon 3.7
Skye Bennett 3.7
Robert Richardson 3.7
Evie Williamson 3.5
Jessica Lowe 3.5
Donald Caldwell 3.4
Robert Marquez 3.3
Reid Good 3.3
Nico Gaines 3.3
Brylee Hunter 3.1
Robert Hurley 3.1
Jordan Parry 2.9
Daniel A Garrett 2.9
Cerys Holmes 2.9
Vanessa Chavez 2.6
Kim West 2.4
Lyric Nate Wise 2.2
Amber Stevens 1.9
Lukas Hofer 1.8
Brittany Lee Long 1.7
Robert Musser 1.7
Andre C Cooper 1.7
Betina Bauer 1.5
Natalie Porter 1.4
Alissa Mitchell 1.1
Imogen Clarke 1.1
Ann Withers 0.8
Holly Macdonald 0.7
Walter J Miller 0.5
Alex Collins 0.5
Dan Ziegler 0.4
First Name Middle Name Last Name
Walter J Miller
Alissa Mitchell
Andre C Cooper
Ann Withers
Kim West
Daniel A Garrett
Lyric Nate Wise
Robert Marquez
Vanessa Chavez
Brylee Hunter
Robert Musser
Reid Good
Christopher P Sharp
Jessica Lowe
Evie Williamson
Skye Bennett
Braeden Wilkins
Donald Caldwell
Amber Stevens
Matilda Parry
Makai Bond
Paul Garza
Nico Gaines
Jordan Parry
Lamar Fry
Charlie Chambers
Natalie Porter
Jim Mcguire
Roger Mun
James Rogers
Tommy K Dixon
Robert Hurley
Harry Burke
Robert N Spear
Richard Elliot
Aydin Merritt
James Willard
Lukas Hofer
Jude Bell
Heidi Medina
Ashton Kelly
Matthew Ross
Esme Carney
Zac Fletcher
Kristina Mclean
Maria Tot
Wolfgang Ramjac
Tom Wood
Peter Ramsy
Betina Bauer
Cora Briggs
Matilda Collier
Mike Saban
Paul Wells
Ewan Long Thompson
Gary Miller
Holly Macdonald
Crystal Doyle
Corinna Schmidt
Robert Blume
Brigitte Bond
Cerys Holmes
Imogen Clarke
Paul Hill
Stevie Bridge
Alex Collins
Robert Richardson
Maisie Burton
Brittany Lee Long
Dan Ziegler
Daniela Schreiber