Using power BI in school - support

[Anonymous]

I`m starting to use Power BI in my school with the idea to merge all school related data and be able to analyse it more efficiently, with live info reports and interactive dashboards.

I`ve created a basic report but still questions of how to set up so everything shows what I want and why some graphics are not as expected. 

We are about to get a connector from a different plaform which will feed us the data required.

Anyone using Power BI to analyse school data or anyone that can help?

I`m interested to do training on power BI so any suggestions?

Thanks everyone

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created the data:

Here are the steps you can follow：

Show students' learning progress throughout the year：

1. Create measure.

Grade =
SUMX(FILTER('Table',[comment]<>"Eoy target"&&[comment]<>"Baseline"),[garde])

target =
IF(MAX('Table'[comment])="Eoy Target"||MAX('Table'[comment])="Baseline",BLANK(),
SUMX(FILTER(ALL('Table'),[comment]="Eoy target"&&[Subject]=SELECTEDVALUE('Table'[Subject])&&[Student]=SELECTEDVALUE('Table'[Student])),[garde]))

Baseline =
IF(MAX('Table'[comment])="Eoy Target"||MAX('Table'[comment])="Baseline",BLANK(),
SUMX(FILTER(ALL('Table'),[comment]="Baseline"&&[Subject]=SELECTEDVALUE('Table'[Subject])&&[Student]=SELECTEDVALUE('Table'[Student])),[garde]))

2. Using [Student] and [Subject] as slicers, open the Line and clustered column chart, place [comment] in the Shared axis, [Grade] in the Column values, and [target] and [Baseline] in the Line values.

3. Result:

Through the slicer, only those subjects that meet and exceed the target or subjects that do not meet the target are displayed:

1. Use Enter data to enter a table as a slicer.

2. Create measure.

Flag =
SWITCH(
    SELECTEDVALUE('Table (2)'[Value]),
    "Over target",
    IF([Grade]>=[target],1,0),
    "Not over target",
    IF([Grade]<[target],1,0),
    1)

3. Use [Value] in Table(2) as a slicer, and put [Flag] in Filter, set is = 1, apply filter.

4. Result:

Choose "Not over target" to display data that does not meet the target:

Choose "Over target" to display the data that meets the target:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

How can I cerate a visual to demonstrate student progress throughout the year? 

Students are expected to make 0.1 progress every half term.

I want to be able to see if they aer below, meeting or exceeding expected progress considering the baseline and target. 

Also want to be able to have an overview with average of all subjects and then be able to select a specific subject and also be able to select only those meeting and exceeding target and have a full picture of school or a specific subject.

Any sugestion?

Thanks

[Anonymous]

Hi  @Anonymous  ,

Power BI is a collection of software services, apps, which can transform irrelevant data sources into coherent, and there is a process for analyzing data:

1. You can connect multiple different data sources through Get data of Power BI Desktop to transform, clean, and optimize the data model.

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-what-is-desktop

2. Use the built-in visualization type or custom visualization type of Power BI to turn the data source into the visual object you need.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

3. Publish it to Power BI Services. You can share your report to other users for viewing through various sharing methods. You can also click Refresh now to get your data.You can also configure scheduled refresh to refresh the data at the time you configure.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

This is the detailed workflow of Power BI, I hope it will help you:

https://curbal.com/blog/lesson/power-bi-workflow

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.