practice data modeling

[powerbiexpert22]

i want to pracice and implement all difficult scenarios in power bi data model ..where can i find those scenarios..is there any online study course which covers those scenrios..i have approximately 2 weeks of time 

[foodd]

Hello @powerbiexpert22 , please provide more details about your questions. Let me know what you have tried and where you are encountering difficulties. Since there are numerous resources available, it would be helpful if you could specify your request. Keep in mind that not every problem can be solved with the same approach.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

[powerbiexpert22]

Hi @foodd ,

I want to practice and implement tough challenges which people face while designing data model in power bi example many to many relationships, role playing dimensions, circular references etc

[foodd]

So, based on your description, you want to enhance your skills in applying the fundamental principles of data warehousing and dimensional modeling.

As a mentor, I would seek the following information to better understand the learner and provide assistance for success. Please consider the following preparation-related questions. Some may require a financial investment, while others may not. Do you have access to the following:

• Subscription to Power BI Professional, Microsoft 365, and related services?   You can always set up trials with each service if this is a short-term need.
• Do you have a test bed and or a home test lab setup?  You can use Hyper-V if you are running Windows Professional or above, VMWare Workstation Professional now that it is free for non-commercial users, or other similar virtualization tools.
• Have you considered subscribing to services like EnterpriseDNA and other learning platforms?   Each platform offers personalized learning plans and a wealth of resources, providing significant value to the learner. Not to slight Training | Microsoft Learn, but if you have not already created a profile, I strongly recommend doin...
• What books and other online references do you have, and have you read? 
• Which of the Microsoft Certification Exams have you prepared for or completed?
• Are you part of a Power Platform / BI User Group? If not, I encourage you to join one. Having access to a study partner can be beneficial in your learning journey.

[bhanu_gautam]

@powerbiexpert22 , You can pick different datasets from open websites like kaggle and other and you can also participate in open data challenges as they are available on Linkedin , Like from Maven Analytics and Onyx Data.

Or you can look for any course related to data modelling on Udemy

[powerbiexpert22]

Hi @bhanu_gautam ,

if you can share some links of online courses that would be helpful

[bhanu_gautam]

@powerbiexpert22 , @foodd has already shared a lot and all of them are helpful let me know if you need anything else 

[foodd · Accepted solution]

A short list skimmed from top training resources in no specific order.
Each of these supports the greater Microsoft Data and Analytics Community.

https://mavenanalytics.io/online-data-analysis-courses

https://enterprisedna.co/courses

https://onyxdata.co.uk/training/

https://pragmaticworks.com/Training

https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst

https://www.microsoft.com/en-us/power-platform/products/power-bi/learning

https://www.udemy.com/topic/microsoft-power-bi/

https://www.datacamp.com/category/power-bi

https://chandoo.org/wp/training-programs/

https://www.sqlbi.com/training/

Anything by Professor Mike Galvin https://www.youtube.com/@excelisfun

https://www.linkedin.com/learning/

https://www.oreilly.com/online-learning/courses.html

https://www.pluralsight.com/