Let’s try something different. I will share a data analytics challenge here. Post your solutions in the comments.Our first challenge involves Employee Data Analysis. You can score maximum of 35 points. Imagine you have employee data in this “staff” table (in Excel / Power BI / SQL / Python or whatever tool you fancy)Download sample data file (it has all the 28 employees) or use the below CSV.Emp IDNameReports toTO-0002Jim HalpertTO-0007TO-0004Pam BeeslyTO-0015TO-0007Michael ScottTO-0067TO-0009Erin HannonTO-0004TO-0010Jan LevinsonTO-0067TO-0013Karen FilippelliTO-0076TO-0015Dwight SchruteTO-0007TO-0018Andy BernardTO-0002TO-0021Cathy SimmsTO-0002TO-0024Kevin MaloneTO-0035TO-0028Creed BrattonTO-0007TO-0030Toby FlendersonTO-0067TO-0031Kelly KapoorTO-0028TO-0033Robert CaliforniaTO-0067TO-0035Angela MartinTO-0007TO-0039Stanley HudsonTO-0007TO-0043Ryan HowardTO-0031TO-0046Oscar MartinezTO-0035TO-0050Meredith PalmerTO-0028TO-0051Gabe LewisTO-0072TO-0055Phyllis VanceTO-0030TO-0059Roy AndersonTO-0004TO-0063Nellie BertramTO-0030TO-0066Darryl PhilbinTO-0039TO-0067David WallaceTO-0072TO-0068Pete MillerTO-0015TO-0072Jo BennetTO-0076Todd ParkerTO-0002Emp IDNameReports toTO-0002Jim HalpertTO-0007TO-0004Pam BeeslyTO-0015TO-0007Michael ScottTO-0067TO-0009Erin HannonTO-0004TO-0010Jan LevinsonTO-0067TO-0013Karen FilippelliTO-0076TO-0015Dwight SchruteTO-0007TO-0018Andy BernardTO-0002TO-0021Cathy SimmsTO-0002TO-0024Kevin MaloneTO-0035TO-0028Creed BrattonTO-0007TO-0030Toby FlendersonTO-0067TO-0031Kelly KapoorTO-0028TO-0033Robert CaliforniaTO-0067TO-0035Angela MartinTO-0007TO-0039Stanley HudsonTO-0007TO-0043Ryan HowardTO-0031TO-0046Oscar MartinezTO-0035TO-0050Meredith PalmerTO-0028TO-0051Gabe LewisTO-0072TO-0055Phyllis VanceTO-0030TO-0059Roy AndersonTO-0004TO-0063Nellie BertramTO-0030TO-0066Darryl PhilbinTO-0039TO-0067David WallaceTO-0072TO-0068Pete MillerTO-0015TO-0072Jo BennetTO-0076Todd ParkerTO-00021. How many people are directly reporting to my boss? (5pts)The first question is simple. For a given employee ID (say TO-0021, Cathy Simms), how many people are directly reporting to their boss (TO-0002, Jim Halpert)? The answer should be 3.Write the necessary Excel formula / DAX / Power Query / SQL or Python code to find the answer.2. Who is my boss’s boss? (10pts)We are going to level up. For a given employee ID (say TO-0021, Cathy Simms), find out their boss’s boss. The answer should be TO-0007, Michael Scott.3. What is my reporting chain? (Score=20pts)For a given employee (say TO-0021, Cathy Simms), print their entire reporting chain, delimited by the symbol ->. Expected Answer is:Cathy->Jim->Michael->David->JoNote: You may assume a maximum depth of 7 nodes if that helps. Download Sample FileGrab the sample data file (Excel format) here. Use it to solve the problems. Alternatively, I have pasted the data above. Copy it and paste it in Python or SQL.Post your answers below.Leave a comment with your solutions / approach. All the bestWant more?Check out my Excel Homework Tag page for more challenges and problems.The post Who is my boss’s boss? [Data Analytics Challenge – 001] appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.