Hi, This in Nobuko_ao. very new user of Power BI.
I need your help to creating some chart with Power BI.
We would like to analyze our client’s “aptitude test” results (Over 3,000 lines), and create a summary with Power BI.
The data format of aptitude test are as follows;
Basically we have no idea to doing preliminary preparation with excel file, like as copy & past with switching cell(column) and row.
1) How do we make a chart A), with most simple and efficient way with Power BI?
2) How do we make a chart B), with most simple and efficient way with Power BI?.
3) How do we calculate “descriptive statistics value”, and make a chart C) with Power BI?
4) If using Power BI is not the efficient/productive way, please advise the best tools to make these chart,
e.g. using R, or anything else.
Many thanks in advance.
Solved! Go to Solution.
I did it with your advise. Thanks !!
Chart A) and Chart B) are solved.
Do you have any idea regarding calcurate “descriptive statistics value”, and make a chart C) ?
My boss mentioned that it would be better to using "R" for Chart C), do you agree?
Many thanks in advance,