Power BI Sample test with desired output, Practice test

[Shamsbutt]

Hello Everyone,

I'm new in PowerBI and have attended complete video tutorials (Analyze and Visualize Data with Power BI). Just want to do some hand practice with Power BI, Query Editor (ETL), DAX, Modeling etc. 

Anyone can please share some meterials if you have or some tutorial websites which contains numurious examples with sample inputs and desired outputs. Moreover with scenario based questions with their solutions.

Thanks & Regards,

Adeel

[amitchandak · Accepted solution]

You Tube : https://youtu.be/m1eLTtZHGs4 

https://youtu.be/W0mG3KFR3Hw 

https://youtu.be/3u7MQz1EyPY

Power BI udemy Course -https://www.udemy.com/share/1000SGBEoTdVZbTXk=/ .

Power BI Row level Security - Important for Multi Tenant Env like Trax 

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...

Aggregate table 

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...

Drill Across Page
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

https://community.powerbi.com/t5/Desktop/Divide-a-value-in-one-column-by-the-corresponding-value-in/... 

Measures vs Calculated Columns: https://www.youtube.com/watch?v=nJSXty9Y4tM

DAX Fridays! #5: CALCULATE (Part 1) : https://www.youtube.com/watch?v=-oDpOfhgmzA

DAX Fridays! #8: CALCULATE (Part 2): https://www.youtube.com/watch?v=uZ15A13AsHY

https://docs.microsoft.com/en-us/power-bi/guidance/ 

https://www.linkedin.com/pulse/did-you-know-hidden-power-bi-features-wyn-hopkins/?trackingId=mB7Dk61... 

Use following pbix for practice

[v-alq-msft · Accepted solution]

Hi, @Shamsbutt 

Here are some Power BI samples and tests.

Power BI Desktop:

Connect to data: https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-connect-to-data

Query Editor: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

Model relationships: https://docs.microsoft.com/en-us/power-bi/desktop-relationships-understand

Create measures and columns:

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

RLS:  https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

Samples: https://docs.microsoft.com/en-us/power-bi/sample-datasets

Dax: https://docs.microsoft.com/en-us/dax/

https://community.powerbi.com/t5/Desktop/DAX/m-p/821963

https://community.powerbi.com/t5/Desktop/DAX/m-p/536687

https://community.powerbi.com/t5/Desktop/DAX/m-p/831676

Best Regards,

Allan

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

[amitchandak · Accepted solution]

You Tube : https://youtu.be/m1eLTtZHGs4 

https://youtu.be/W0mG3KFR3Hw 

https://youtu.be/3u7MQz1EyPY

Power BI udemy Course -https://www.udemy.com/share/1000SGBEoTdVZbTXk=/ .

Power BI Row level Security - Important for Multi Tenant Env like Trax 

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...

Aggregate table 

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...

Drill Across Page
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

https://community.powerbi.com/t5/Desktop/Divide-a-value-in-one-column-by-the-corresponding-value-in/... 

Measures vs Calculated Columns: https://www.youtube.com/watch?v=nJSXty9Y4tM

DAX Fridays! #5: CALCULATE (Part 1) : https://www.youtube.com/watch?v=-oDpOfhgmzA

DAX Fridays! #8: CALCULATE (Part 2): https://www.youtube.com/watch?v=uZ15A13AsHY

https://docs.microsoft.com/en-us/power-bi/guidance/ 

https://www.linkedin.com/pulse/did-you-know-hidden-power-bi-features-wyn-hopkins/?trackingId=mB7Dk61... 

Use following pbix for practice