Analyst Builder

Building the best platform for Data Analysts with Practice Technical Questions, Full Courses, Crash Courses, and more!

Founder & CEO

Alex Analytics LLC

Consulting focused on Product Design, Marketing Strategy, and Analytics for Startups and Tech Companies.

Founder

AmerisourceBergen

Manager of Operational Analytics and Intelligence

Data Analyst II

Junior Data Analyst

KPN Advisors

Data Analyst

The Family Place

Data Collection Specialist and Analyst

Helping people around the world get jobs in Analytics and Tech!

Check out my YouTube channel Alex The Analyst for free resources and Analyst Builder for my full learning platform.

Alex Freberg

My wife and I got married over 8 years ago - since then she’s only made my life better! 

When we met I was renting a room out of a house, eating hot dogs and eggs for most meals, I was super broke, and had very little sense of style.

Unfortauntely, my style hasn’t changed much.

But she’s pushed me in so many ways over the years - ways in which I know I wouldn’t have if I was by myself. When I was by myself I was content with just surviving. 

I only had myself to take care of so I didn’t care much about my career, looks, or other things.

But she believed in me and pushed me to be more than I could have been by myself.

A good spouse will raise you up and lift you to be better. I wouldn’t be where I am today without her. Behind the scenes she’s my biggest supporter.

Founder of AnalystBuilder.com | YouTube "Alex The Analyst" | Not LinkedIn Top Voice

No alternative text description for this image

If my life has taught me anything up to this point - it’s that you need to do things you don’t feel qualified for.

I didn’t feel qualified to be a Data Analyst.

I didn’t feel qualified to be a Manager.

I wasn’t qualified to teach people on YouTube.

I wasn’t qualified or have enough experience to start consulting.

Genuinely, I wasn’t qualified for any of it - I just did it and did my best. It’s taken me places and opened doors I never even knew about.

Heading out to LinkedIn Learning to record a course!

Wish me luck - they said I had to wear makeup so hopefully I’m recognizable!

This week we wrapped up our Databricks series!

We covered:
1. Importing Data from flat files and connecting to Data Sources
2. Analyzing data using SQL Editor and Notebooks
3. Visualizing and Creating Dashboards
4. Using AI to code and talk with our Databases

You can learn all of this for Free in this series using Databricks Free Edition! 

I plan on adding to the Databricks Series in the future! Check out the playlist below!

Link: https://lnkd.in/eF3XV744

Databricks.

One of the best platforms on the planet for AI and Data - and in this video we are building a full project using it!

The best part - it's completely free to use. Practice with the SQL Editor, Notebooks, AI, and Data Visualization!

https://lnkd.in/e35AB7xs

Open video: Building an End-to-End Data Project in Databricks (Free Edition) on youtube.com

Building an End-to-End Data Project in Databricks (Free Edition)

Remote Jobs are 100x harder to land than local ones.

With all the talk about the Tough Job Market - it's great to know that there are still jobs out there!

Jobs aren't impossible to find - even ones that use Excel, SQL, and Power BI.

This is just one message, but I've gotten hundreds this year saying the same thing. Jobs are out there!

One of the biggest things I've heard from people is that the jobs aren't remote. Remote jobs are 100x harder to get than local ones since almost everyone wants to work from home. But companies want people in person!

Many people who got jobs were relocating to where their new role was. so if you're only look for remote jobs, think about looking local or see if you're willing to move for work.

Put me on LinkedIn Lunatics. Attack my character and who I am as a man and a father.

I don’t care.

I feel better when I workout and no amount of shaming me is going to stop me from going to the hotel gym and doing a workout in the morning.

Yes, I forgot workout shoes and went in my socks. 

No amount of public humiliation can stop me. 

I’ve become ungovernable. 

Why did I post this on LinkedIn when it’s completely unnecessary? Because I’m not here to make friends. 

I want enemies. It makes me want to workout even more.

I don't know when or how this started, but it's become a running theme for my kids to make me look as insane and crazy in drawings as they can.

Everyone else can look perfectly normal - or even drawn great - but not me.

I hold onto as many of these drawings as I can. They make me smile every time I see one :D

At some point I just started putting :) in my emails and I haven't quit.

Is this unprofessional?

Because I can tell you right now I've easily written 1000s of emails with smileys in them and I have no plan on stopping.

Snuck into LinkedIns employee-only party to take some pictures and eat some crepes.

Having a great time in Carpinteria!

Wrapping up recording today and heading back to the east coast tomorrow 🙌

Contec Global Limited

1. Create and configure Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
2. Manage database backup/recovery, security, integrity, storage design, and administration.
3. Assist in selecting database management systems and maintaining performance.
4. Coordinate disaster recovery planning with IT and System Engineers.
5. Develop and optimize SQL Server Agent tasks and maintenance plans.
6. Proactively monitor, troubleshoot, and resolve SQL Server issues.

Database Administrator

AAVA Brands Limited

1. Develops and implements a predictive demand forecasting model using Excel's statistical functions and Oracle's data mining tools, resulting in a 15% reduction in forecast error.
2. Designed dashboards to monitor sales trends, demand patterns, and campaign performance, while implementing predictive models for demand forecasting and churn analysis, reducing forecast errors by 15%.
3. Leads a team to develop an automated demand planning process using Excel's Power Pivot measures increasing efficiency by 60% and reducing manual errors.
4. Collaborates with cross-functional teams to optimize inventory stock levels and minimize stockouts utilizing Excel's data analysis features.
5. Analyses sales data using Excel data visualization capabilities, identifying opportunities to optimize pricing and inventory strategies.
6. Optimized inventory planning and established a robust Sales and Operations Planning (S&OP) process, improving collaboration and resource utilization.

Demand Planner

Hayat

Sales Admin Manager

1. Provides data analyses and reports that enhances an increase in sales volume by an average of 1.5% month-on-month.
2. Effectively guides the sales team in setting and tracking accurate forecasts which helps in achieving an average of 2.5% increase in sales value in Q1, Q2, and Q3 2023.
3. Compiling in-depth analysis, and reporting of sales data of all our brand categories and over 100 SKUs by identifying trends and opportunities for optimal sales performance
4. Helps in achieving Sales volume budget on MOLFIX, BEBEM, and MOLPED brands in quarter 1 and quarter 2, 2023 by providing trend insights and measuring the impact of promotions in trade.
5. Develops models and reporting structure for the sales team to monitor sales-in and sales-out of all brand categories at the National and Divisional levels.
6. Effectively guides the sales team in the setting of accurate forecasts which helped in achieving a 2.5% increase in value sales against the previous quarter (Q1 2023).
7. Monitoring and analyzing competition activity with in-depth price intelligence reports and actionable insights which helped increase market share in the hygiene category.
8. Data extraction, transformation, and loading using Power Query.
9. Provides data and sales analyses to channel VPs, Sales Direct, and sales Managers to improve decision making.

Skills: Data Analysis. SAP ERP. SQL. Advanced Microsoft Excel · Forecasting. ETL.

Data Analyst - Sales

Wild Fusion Limited

- Led data-driven strategies for customer acquisition, retention, and churn prevention, achieving a 48.9% increase in retention rates across multiple startups.
- Conducted transaction tracking and revenue optimization analysis, leveraging MongoDB, Power BI, Google Analytics, and Google Sheets to provide actionable insights for business growth.
- Collaborated with stakeholders to gather business requirements and developed technical specifications to align data strategies with business need.
- Conducted in-depth research on revenue management and pricing analytics using Cloud platforms (AWS, Google BigQuery, Microsoft Azure), optimizing pricing strategies.

Data Stack: Python, MongoDB, SQL, Cloud Platforms, Power BI, Microsoft Excel, Google Analytics, Trello.

Data Analyst Manager

Startupbootcamp

- Increase customer retention by 48.9% for 10 startups through churn analysis and targeted improvement initiatives.
- Optimized financial performance with forecasting, reporting, market research, and competitive analysis, supporting strategic decision-making.
- Developed impactful financial models for valuation and planning, leveraging Google Sheets, Excel, and Google Data Studio for efficient collaboration across multiple startups.

Data Stack: Google Sheet, Microsoft Excel, Google Data Studio, Trello.

Financial Data Analyst

Dangote Industries Limited

- Collected, cleaned, visualized, and analyzed data to support the implementation and maintenance of an enterprise-wide identity and access control system (UNIS|VIRDI) for 48,000+ staff.
- Provided data management support and collaborated with a team of 20 analysts to automate employee smart access cards using Google Sheets, Excel, and UNIS.

Data Stack: Google Sheet, Microsoft Excel, UNIS.

National Youth Service Corps

1. Designed and implemented learning objectives and graded and evaluated students' performance.
2. Trained and Prepared students for the terminal West African Examination with a record 87% success rate.

Mathematics Tutor

Trijech Academy

1. Designed and implemented learning objectives and graded and evaluated students' performance.
2. Trained and Prepared students for the terminal West African Examination with a record 80% success rate.

As a seasoned data professional with expertise in database administration, I leverage my analytical mindset and technical skills to drive business growth and efficiency. In my previous roles at AAVA Brands Limited and Hayat Kimya Limited, I successfully implemented data-driven solutions, resulting in significant improvements in forecast accuracy, operational efficiency, and sales volume. Now, as a Database Administrator at Contec Global, I'm excited to apply my expertise in database design, development, and administration to support the company's data management needs and drive strategic decision-making.

taplio

The Battle

Alex Freberg

Ayomide Fadeyi

Followers

Posts

Engagements

Likes

Performance ScoreAlex Freberg's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

Alex Freberg

Ayomide Fadeyi

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Alex Freberg's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreAlex Freberg's LinkedIn Performance