The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Can we create a dashboard for an SAP data set in Excel? 

Can we create a dashboard for an SAP data set in Excel? 

Super Learner

Can we create a dashboard for an SAP data set in Excel? 
I have been given a problem where I need to create a dashboard from an SAP data set
There are various common problems in the SAP data set like the data is missing or incorrect reference used or the date is incorrect. The goal is to identify the problems and report them in the form of a dashboard. Now, I have identified the problems by using a Filter but I am unable to picture them in a dashboard.
Also, the problem that I have is of Excel but not anything from the course that I went over in Basic Excel. So can I share the problem and have a solution to it?

1 Answer

365 Team

That’s a difficult task to help with remotely.
You’ll need to use formulas or pivot tables automating the calculation of Errors in the SAP data.
To be honest, that’s quite complicated to do as far as I understand the issue at hand.
A few weeks from now, we will add new lessons on ‘how to create a dashboard’ in the Data visualization course, but that’s with different data than the one described by you.
All the best,

Okay! I might not be clear with the problem. Can I get support with the given problem? I think I might not have been able to explain it clearly.

7 months

Please feel free to explain better. Thanks!

6 months
Complete Data Science Education
Get 50% OFF