Social Media Analytics [Personal Project]

Imani Minja LinkedIn Profile Analytics

  • In this project I did a review on how I grew my LinkedIn profile form 0 - 600 followers in a month. I downloaded LinkedIn in September 2023 with no idea how to use it, I planned a strategy, differtent ideas, learnt more about my audience and then I excuted my plan. Fast forward to November I started posting. Hope on to see how I did it and how I can help you grow your social media account!
  • I then visualized and analyzed this data for strategic decision-making.

    • Main Objective

    Building my LinkedIn social media analytics Power BI dashboard allowed me to leverage advanced data visualization. In this project I made sure that the dashboard will help me with the key areas:

  • Exploring Temporal Trends
  • Content Performance
  • Audience Analysis.
  • Data Cleaning
  • Influencer Impact

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What are the key metrics(KPI's) that are crucial for monitoring and decision-making?
  • What data source will I use?
  • What level of detail do I need?
  • Waht are my primary goals and objectives of implementing this Social Media Power Bi Dashboard?

    • Concluding with:

    By conducting a thorough exploratory analysis, I laid the foundation for a Power BI social media analytics dashboard that provided me with actionable insights.

    Customer Relationship Management Dashboard [Personal Project]

    • Owning a bussiness can be overwhelming ‼ Especially when you are doing everything alone.

    Main Objective

    This Customer Relationship management dashboard assists in monitoring, analysing and optimizing various aspects of the sales process. It provides valuable insights for effective decision maing and business structure improvement. In this project I made sure that the dashboard will help the user with the key areas:

  • Market Analysis
  • Predicitve Analysis
  • Feedback Analysis (Customer Satisfaction)
  • Personalized Marketing
  • Lifetime Value Customer Analysis

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What are the primary sales goals and objectives that the dashboard should align with?
  • Who is the intended audience?
  • Are there any specific sales territories, product lines or customer segments that should be prominently featured?
  • Are there any external factors to consider?

    • Recommendations

    ✅HAPPY CUSTOMERS, MORE SALES!!!

    Human Resource Analytics Dashboard [Personal Project]

    Main Objective

    My Human Resource (HR) Managemnet dashboard is designed to assist HR proffesionals in visualizing and analysing key workforce-related data. It provides insights into various HR metrics and helps steamline decison-making. Here are some key areas it helps with:

  • Workforce Demographics
  • Employee Count and Employee Turnover
  • Recruitment Metrics
  • Performance Management
  • Attritionn rates
  • Organisational Structure
  • Total Overtime Employees

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What specific HR metrics and key performance indicators (KPIs) are crucial for monitoring and decision making?
  • How frequent should the dashboard be updated?
  • What level of detail is required in the dashboard, and what visulaizations will best convey the information?
  • What are the primary goals and objectives of implementing the dashboard?
  • What is the plan for on going maintaince, updates and improvemnt to the HR dashboard?
  • What data sources will I use to populate the dashboard and how will data quality and accuracy be ensured?

    • Recommendations

    By consolidating and visualizing these HR metrics, this dashboard helps HR professionals to make informed decisions, enhance workforce management strategies and contribute to overall organizationl effectiveness.

    Sales Analytics Dashboard [Personal Project]

    Main Objective

    This Sales Management dashboard assists in monitoring, analysing and optimizing various aspects of the sales process. It provides valuable insights for effective decision maing and performance improvement. In this project I made sure that the dashboard will help the user with the key areas:

  • Sales performance
  • Comprehensive view of sales operation
  • Empowering sales managers to make informed decisions.
  • Identifying opportunities & Enhance overal sales performance
  • Forecasting and Profitability Analysis

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What are the primary sales goals and objectives that the dashboard should align with?
  • Who is the intended audience?
  • Are there any specific sales territories, product lines or customer segments that should be prominently featured?
  • Are there any external factors to consider?

    • Recommendations

    Generally the 2020 sales were the overall highest sales which were 57.53% higher than 2021. Even though the 2021 sales target was not reached, more efforts should be put in order to make a positive impact. With some adjustments such as increase in distribution and advertisements we can aim for better performance in 2022.

    Mike's Pizza Inventory Dashboard [Client Project]

    Main Objective

    This Sales Management dashboard assists in monitoring, analysing and optimizing various aspects of the sales process. It provides valuable insights for effective decision maing and performance improvement. In this project I made sure that the dashboard will help the user with the key areas:

  • Sales performance
  • Comprehensive view of sales operation
  • Empowering sales managers to make informed decisions.
  • Identifying opportunities & Enhance overal sales performance
  • Forecasting and Profitability Analysis

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What are the primary sales goals and objectives that the dashboard should align with?
  • Who is the intended audience?
  • Are there any specific sales territories, product lines or customer segments that should be prominently featured?
  • Are there any external factors to consider?

    • Recommendations

    Generally the 2020 sales were the overall highest sales which were 57.53% higher than 2021. Even though the 2021 sales target was not reached, more efforts should be put in order to make a positive impact. With some adjustments such as increase in distribution and advertisements we can aim for better performance in 2022.

    Personal Finance Dashboard [Client Project]

    Main Objective

    This was my first ever client Power Bi project. This Sales Management dashboard assists in monitoring, analysing and optimizing various aspects of the sales process. It provides valuable insights for effective decision maing and performance improvemnet. Here are some key areas it helps with:

  • Expense tarcking
  • Income Analysis
  • Budget management
  • Debt Management
  • Saving Goals
  • Financial Health Metrics

    • Exploratory Analysis

    The analysis was conducted based on key questions such as:

  • What are the clients specific financial gaols and objectives?
  • What type of financial data did the client want to include in the dashboard such as income, expenses or debt?
  • Are there multiple sources of financial data?
  • Did the client have short-term and long-term financial priorities and how can the dashboard help to prioritize and plan accordingly?
  • What actions or adjustments did the client expect to take based on the insights provided by the dashboard?

    • Recommendations

    January accounted for 26.07% of the Total income Income target and Total income deviated most in the month of July by 27,904 and lowest in the month of January. This is due to low expense in the month of January (21,549) with the highest income and expense deviation. Therefore more effort should be put in the months of July, October, December, September and May in order to decrease the total income and income target deviation.

    This can be done by increase in efforts on the side incomes (Google & E-commerce) either by hiring experts/assistants or by increase in personal efforts. But also it can be achieved by increase in marketing of the shop to increase sales. Which will in-turn increase the available balance which can be used for emergencies or opening a business to increase income streams.