- “Today is your opportunity to build the tomorrow you want.” ―Ken Poirot
Business Intelligence Technical Women Mentorship
​
Welcome Aspiring Business Analysts to the Business Intelligence
& data analysis mentorship learning zone.
This Is a repository of references and links to support you in you in your learning and certification journey.
​
It is recommended you start getting familiar with what is Business Intelligence and read the compilation of industry articles.
​
Read the Install Power BI guide, create user and install the Power BI tool.
​
Then proceed to getting familiar with learn Microsoft learning site, resources and the syllabus recommended by Microsoft for the Business Analyst.
Study all the modules at learn Microsoft recommended in the syllabus. (about 120 hours of learning)
You can then join us for the practice with real data sets challenges and hack days organized by our Power BI user group, and publish your dashboards and reports in the Microsoft gallery.
​
start preparing for the PL-300 exam.
​
Practice for the exam using the Microsoft sandbox and other resources.
​
take the test.
​
Read articles how to apply for internships, prepare your resume and interview and where to look for jobs.
​
Join the Power BI user groups at microsoft fabic and join the free sessions at meetup.com in your area or virtual. Ours is Orlando Power BI user group.
​
Another amazing group is Power BI Women.
​
#communityrocks @PowerBIWomen
​
​
​
LEARNING MATERIAL
​
Industry Articles
​
Getting familiar with Business intelligence industry articles.
Indeed, a leading employment website published an article that explains the difference between business intelligence and analytics, is a great place to start getting familiar with what business intelligence and analytics are.
Gartner
https://powerbi.microsoft.com/en-us/blog/microsoft-named-a-leader-in-the-2022-gartner-magic-quadrant-for-analytics-and-bi-platforms/
Skills needed
https://www.datapine.com/blog/bi-skills-for-business-intelligence-career/
Forbes the future of business intelligence https://www.forbes.com/sites/bernardmarr/2022/11/02/beyond-dashboards-the-future-of-analytics-and-business-intelligence/?sh=f97c67c18040
https://www.coursera.org/articles/data-analyst-vs-data-scientist-whats-the-difference?fbclid=IwAR3iGm139qJnUJqqaw6kwOS5BSQyJnx9wr10q8IDX3OA0QHiJW2JANyYjJA_aem_AQok76CHXKViY9QUhFEhivr2Q349rfkuu8e4x76e5__wNs5LODhEN3lwxbb0R9Tv0Ps
https://www.coursera.org/articles/what-does-a-data-analyst-do-a-career-guide
https://www.simplilearn.com/tutorials/business-analysis-tutorial/how-to-become-a-business-analyst#:~:text=A%20business%20analyst%20must%20have,more%20senior%20or%20specialized%20roles.
Getting Set-up
To start using the free Microsoft resources to become a Business Intelligence you need:
1-Need to create you Microsoft learn user and password to keep track of your learning
https://learn.microsoft.com/en-us/credentials/
2-Need to create you Microsoft fabric account
https://powerbi.microsoft.com/en-us/getting-started-with-power-bi/
3-Download Free Software MS Power BI Tool overview and installations steps. https://powerbi.microsoft.com/en-us/what-is-power-bi/
Become a business analyst learning path
Customized learning Paths
Entry learning path (30 hours)
https://learn.microsoft.com/en-us/collections/nko2ipxyz3wym3
Intermediate learning path(30 hours)
https://learn.microsoft.com/en-us/collections/3o02ajegz42o1n
Advance learning path (30 hours)
https://learn.microsoft.com/en-us/collections/0ek6fj03nzr8zq
Exam preparation learning path
https://learn.microsoft.com/en-us/collections/3o02ajek0krzne
Portfolio learning path
https://careerfoundry.com/en/blog/data-analytics/data-analyst-portfolio/
Booth camps & trainings
Boothcamp -Correlation One
https://www.correlation-one.com/data-skills-for-all
https://zenatti.net/2018/01/27/free-power-bi-training-and-books/
Microsoft powerup
Power BI Data Analyst Associate
Dashboard in a Day and Webminars
Microsoft - Dashboard in a Day https://powerbi.microsoft.com/en-us/diad/
Pragmaticworks https://learning.pragmaticworkstraining.com/freeTrial?_gl=1*eo3yih*_ga*NTM0NTY1ODMwLjE2OTgzMjc5ODk.*_ga_CBKVWF9226*MTY5ODMzMzMwOS4yLjEuMTY5ODMzMzYwMy4xNS4wLjA.
Learning Power BI in 11 hours
https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Learn-Power-BI-Tutorial-for-Beginners-Full-Course/td-p/3006808
Project management to manage your BI projects
Microsoft power up
https://powerup.microsoft.com/
Tutorials to practice Power Bi
https://learn.microsoft.com/en-us/search/?terms=power%20bi%20tutorials%20
Need to complement with project management skills to manage your data project (requirements gathering is key)Project Management https://www.pmi.org/certifications
https://www.pmi.org/certifications/become-a-project-manager/certification-framework
From free entry introductory pm, exam preparation, to rigorous w/pre-requisites paid cert
Simplilearn
Datasets & practice
​
Kaggle - DataSets
Data Goblins sql dataset
SQL Data analysis Statistics R
https://www.edx.org/course/statistics-computation-and-applications?utm_source=braze&utm_medium=email&utm_campaign=Tuesday_Course_Promo_20230307&utm_content=No%20Subjects
https://www.edx.org/school/stanfordonline#programs
Intro to SQL and data https://www.khanacademy.org/computing/computer-programming/sql
YouTube
Search PowerBI learning 1,000s of how to videos
Mentorship
​
Meetup mentorship sessions
Join power bi Orlando user group for more information and dates we are meeting Also can Email to techwomenmentoring@gmail.com
Labs to practice power bi hands on
lab
https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/8-lab
Lab
https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/8-lab
Lab
https://docs.microsoft.com/en-us/learn/modules/create-measures-dax-power-bi/6-lab
Lab
https://docs.microsoft.com/en-us/learn/modules/create-measures-dax-power-bi/8-lab
Lab
https://docs.microsoft.com/en-us/learn/modules/create-paginated-reports-power-bi/6-lab
Lab
https://docs.microsoft.com/en-us/learn/modules/data-driven-story-power-bi/13-lab
Microsoft Community links
Community & user groups
Meetups & user groups In person & virtual around the world
Meetup.comhttps://community.powerbi.com/t5/custom/page/page-id/grouphubs-list-page?categoryId=pbi_usergroups
Study group
Power BI study Group- Wednesdays noon EST. Next meet up Nov 1515 Nov 2023, 12:00 PM ESTHosted by Orlando Power BI User Group
You're invited to PowerBI Orlando study group mentorship Wednesday, November 15, 2023 12:30 pm - 1:00 pm (EST) …
Speaker
Mentor - Orlando Power BI user group
PowerBiWomen https://community.powerbi.com/t5/Power-BI-Women/gh-p/pbi_PowerBIWomen_usergroup
#communityrocksTeams powerbiwomen https://aka.ms/PowerBIWomenTeams
Apex webminars and coaching https://www.apexsystems.com/event/career-readiness/so-you-wanna-be-it-insights-tips-industry-experts
Books
https://www.biblio.com/book/curso-power-bi-bisb-york-ana/d/1509095069
https://www.packtpub.com/free-ebook/learn-power-bi/9781838644482
Radacad power bi book https://radacad.com/download-free-power-bi-book-pdf-format
Download free (58 pages) splunk data ebook https://www.splunk.com/en_us/form/the-essential-guide-to-data.html
Job search roadmap From Katlyn Cook https://www.linkedin.com/posts/katlynscook_jobsearch-jobsearchstrategy-jobseekers-activity-7117906122333659137-UiD7?utm_source=share&utm_medium=member_ios
https://youtu.be/Tfk3ae0qz3A?si=TLDYs0cWKlTTPNUQ
Scholarships for highschool women in tech
Aspirations in computing ncwit
https://www.aspirations.org/
Women
Microsoft scholarships
https://www.microsoft.com/en-us/diversity/programs/women-at-microsoft-scholarshipPOC
https://www.facebook.com/fbelevate/facebook-elevate-scholarship-application?ad_id=%7B%7Bad.id%7D%7D&platform=%7B%7Bplacement%7D%7D&site_source=%7B%7Bsite_source_name%7D%7D&content_id=oM4JFTQTykCMAdc#apply
SPANISH
Spanish video tutorials - en español
https://youtu.be/hKe7bHPiSPU?si=OYzE2XlbouMxDPon
https://youtu.be/1PjBNOqQIQc?si=XPJwnFy6iF02WG_J
https://youtu.be/NI1udeBvlww?si=6_47JLlPDMrIUfE6
https://youtu.be/8Qh2oStdADE?si=Ghfe8-88h9Exz1Sm
https://youtu.be/sjrlIAQnD8M?si=RJYweelBMchtqPKL
Reference to the Microsoft learn free Material we are using for Business and Data Analysis mentorship and study groups for PL-300 exam
Article
How to Prepare to take the PL 300 Power BI Data Analyst Associate exam with Microsoft Learn FREE By Lucrecia Krause
Create your user @ Microsoft Learn https://learn.microsoft.com/en-us/
Visit the Certification path Learning path for Microsoft Certified- Power BI Data Analyst AssociateStudy Guide Study guide for Exam PL-300: Microsoft Power BI Data Analyst | Microsoft Learn
Review the Syllabus https://learn.microsoft.com/en-us/training/courses/pl-300t00?ns-enrollment-type=Collection&ns-enrollment-id=m14nt4rdwnwp04#course-syllabus
Get Familiar with “Becoming a data analyst Microsoft” https://learn.microsoft.com/en- us/training/career-paths/data-analystStart learning with Microsoft data analyst self-paced learning path https://learn.microsoft.com/en- us/collections/m14nt4rdwnwp04
Customize your own learning path, here are examples of learning paths for different skill levels.
Entry https://learn.microsoft.com/en-us/collections/nko2ipxyz3wym3
Intermediate https://learn.microsoft.com/en-us/collections/3o02ajegz42o1n
Advance https://learn.microsoft.com/en-us/collections/0ek6fj03nzr8zq
Exam preparation https://learn.microsoft.com/en-us/collections/3o02ajek0krzne
Register and attend live learning sessions.
Dashboard in a day is full day Power BI training 6-8 hours of training https://events.microsoft.com/en-us/allevents/?search=Dashboard%20in%20a%20Day&startTime=07:00&endTime=10:00&view=list&language=English&clientTimeZone=1
Virtual training days 2-6 hours of traininghttps://events.microsoft.com/en-us/mvtd-powerplatform?WT.mc_id=PP_BoM- wwl&language=EnglishExam study guide https://learn.microsoft.com/en-us/credentials/certifications/resources/study- guides/
pl-300Exam outline - skills measured https://learn.microsoft.com/en- us/credentials/certifications/resources/study-guides/pl-300#skills-measured-as-of-october-27-2023
Video Series preparation for the examPractice exam
Practice Assessment | Microsoft LearnDemo the exam experience exam sandboxRegister to take the exam @ Exam page
Exam PL-300: Microsoft Power BI Data Analyst - Certifications | Microsoft Learn Preparing for PL-300: Prepare the data (segment 1 of 4) Preparing for PL-300: Model the data (segment 2 of 4)Preparing for PL-300: Visualize and analyze the data (segment 3 of 4)
Join a study group check with your local Microsoft Communities, or join us @ Orlando Power BI user group https://community.fabric.microsoft.com/t5/Orlando-Power-BI-User-Group/gh- p/pbi_Orlando_usergroup
What’s next ??
https://learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
​
​
​
​
​
Learning Python
​
Applications for Python | Python.org
​
​