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.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
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
0
Votes
1
Answer

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

Hello,
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,
Ned

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.

2 weeks

Please feel free to explain better. Thanks!

1 week
×
EXTENDED SALE
Learn Data Science this Summer!
Get 50% OFF