rakeshpunna
New Member
I have data in excel as below for Annual Turnover column and want to create Power Bi dashboard. Can you suggest the best way to cleanse data, below is the screen shot. Need your recommendations
Best way to cleanse data to create Power BI dashboard for Revenue Column
- Thread starter rakeshpunna
- Start date
AlanSidman
Well-Known Member
1. Cannot manipulate data in a picture. Suggest you upload a sample file
2. Suggest you also upload a manually mock up of what you want your dashboard to look like.
3. Lastly, what version of Excel are you using?
2. Suggest you also upload a manually mock up of what you want your dashboard to look like.
3. Lastly, what version of Excel are you using?
rakeshpunna
New Member
Thanks for your inputs. Below are the details and attached the file. Your recommendations are highly valued.
Scenario:
You will be provided unidentifiable data, it will include demographic data such as business type and postcode.
Task:
Using PowerBI develop a dashboard and provide analysis. Present the data using visuals such a graphs and maps and consider grouping them by Local government area, metro/regional etc. If you are unable to present the information, explain the steps on missing information etc.
I'm
Scenario:
You will be provided unidentifiable data, it will include demographic data such as business type and postcode.
Task:
Using PowerBI develop a dashboard and provide analysis. Present the data using visuals such a graphs and maps and consider grouping them by Local government area, metro/regional etc. If you are unable to present the information, explain the steps on missing information etc.
I'm
AlanSidman
Well-Known Member
This appears to be a Homework or School Assignment.
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.