- “Today is your opportunity to build the tomorrow you want.” ―Ken Poirot
Business Intelligence Technical Women Mentorship
INFORMATION TECHNOLOGY
DATA & BUSINESS INTELLIGENCE
MENTORSHIP
​
​​​​​
​
​
LEARNING MATERIAL
​
Getting Familiar
Business intelligence industry articles
​
Your 1st assignment is to read this articles and ask the questions to yourself.
​
Do you feel excitement and energized about learning this skills?
Do you see yourself performing this role?
Are you willing to put time and effort into learning this new skills?
if your answer is yes, let’s start!
Jobs Outlook
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.
Power BI Tool
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
Data Analyst vs Data Scientist
https://www.coursera.org/articles/data-analyst-vs-data-scientist-whats-the-difference?fbclid=IwAR3iGm139qJnUJqqaw6kwOS5BSQyJnx9wr10q8IDX3OA0QHiJW2JANyYjJA_aem_AQok76CHXKViY9QUhFEhivr2Q349rfkuu8e4x76e5__wNs5LODhEN3lwxbb0R9Tv0Ps
Career Guide
https://www.coursera.org/articles/what-does-a-data-analyst-do-a-career-guide
How to become a Business Analyst
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.
Learn.Microsoft learning website
Power BI Software
To start using the free Microsoft resources to become a Business Analyst you need:
1-Go to Learn.Microsoft.con that is the learning website, you need to create a user and password to access the learning and to keep track of your progress
https://learn.microsoft.com/en-us/credentials/
https://powerbi.microsoft.com/en-us/getting-started-with-power-bi/
2- 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
take a look to all the learnings available at learn.microsoft.com
​
The learning we will follow to become a business analyst associate path if you already have some Power BI knowledge
​
https://learn.microsoft.com/en-us/certifications/power-bi-data-analyst-associate/
​
If you are starting with no experience is recommended to start with this other customized learning paths and then move to the analyst associate path
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/
Other study resources a 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
If you are ready to take the test go directly to the Analyst Associate, preparation, exam practice, attend review sessions like dashboard in a day.
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.
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
other great resource is Apex
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 learn.Microsoft free PL-300 exam preparation
Article
How to Prepare to take the PL 300 Power BI Data Analyst Associate exam with Microsoft Free resources
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 ?? Fabric
https://learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
​
​
​
​
​
Learning Python
​
Applications for Python | Python.org
​
​