Alana Bates
BI Solutions Consultant at Preferred Strategies- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Data Analyst in SQL
DataCampJun, 2022- Nov, 2024 -
Intermediate Python
DataCampMay, 2022- Nov, 2024 -
Python for Marketing
LinkedInMay, 2022- Nov, 2024 -
Tableau 10 for Data Scientists (2017)
LinkedInApr, 2022- Nov, 2024 -
Microsoft Certified: Power BI Data Analyst Associate
MicrosoftApr, 2023- Nov, 2024
Experience
-
Preferred Strategies
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
BI Solutions Consultant
-
Jan 2023 - Present
-
-
-
Pepperdine Graziadio Business School
-
United States
-
Higher Education
-
100 - 200 Employee
-
Graduate Research Assistant
-
Aug 2022 - Jan 2023
• Collaborated with Dr. Samuel Seaman on three research projects by conducting data wrangling, analysis, and visualization. • Developed a multivariate regression model in Python to assess the relationship between gender and veterinarian salaries in the U.S • Built nine logistic regression models in Python to analyze the relationship between personality indicators and musical preferences utilizing data collected through a survey • Created 10+ Tableau data visualizations to communicate project findings including interactive maps, line graphs, and stacked bar charts Show less
-
-
-
Inline Electrical Resources, Inc.
-
United States
-
Construction
-
1 - 100 Employee
-
Market Research Analyst
-
Jul 2021 - Dec 2021
• Executed market research and digital marketing projects for a boutique energy efficiency and lighting business • Collaborated with the CEO to identify target markets to optimize future growth • Conducted a competitor analysis to identify key players and define the competitor landscape • Spearheaded website optimization efforts by advising on website redesign to increase digital customer acquisitions • Executed market research and digital marketing projects for a boutique energy efficiency and lighting business • Collaborated with the CEO to identify target markets to optimize future growth • Conducted a competitor analysis to identify key players and define the competitor landscape • Spearheaded website optimization efforts by advising on website redesign to increase digital customer acquisitions
-
-
-
L.E.K. Consulting
-
United States
-
Business Consulting and Services
-
700 & Above Employee
-
Case Team Assistant Co-op
-
Jul 2019 - Dec 2019
• Supported consulting teams with 10+ case projects for clients in the life sciences, financial services, and technology sectors • Completed industry and market research projects for case teams by utilizing primary and secondary sources to compile research and Excel to perform quantitative analyses on datasets • Synthesized insights derived from research and analyses, such as revenue growth opportunities and market demand, into team reports • Summarized case research findings and project results into PowerPoint slide decks for client presentations Show less
-
-
Education
-
Pepperdine Graziadio Business School
Master of Science in Business Analytics, Business Analytics -
Northeastern University
Bachelor of Science - BS, Business Administration -
Neuchâtel Junior College
High School Diploma -
Collingwood School
High School