Siddhant Shah

Finlatics - Business Analyst Experience Program


Introduction to working as a Business Analyst with MS Excel & Power BI


Published on Sunday, 18 February 2024



Table of Contents


Finlatics Business Experience Program: https://www.finlatics.com.

GitHub Repo: https://github.com/SidShah2953/finlatics-baep

Tools Used

Modules

  1. Data-Driven Decision Making:
    This module covers the advantages of data-driven decision making, different types of data and data analytics.
  2. Case Studies:
    This module analyzes two case studies: Amazon’s acquisition of Whole Foods and McKinsey.
  3. Data Analyst vs. Business Analyst:
    This module dives into the differences between these roles and explores the MECE framework.
  4. Business Analyst Tools:
    This module focuses on tools used by business analysts, including Power BI, with a Zomato case study.

Overview of Projects

Project 1

Assessing Business Projects with an approach of data driven decision making
I assessed the feasibility of a proposed business and advised on ways that can lead to maximization of return. I analysed the data given in conjunction with external research.

Project 2

Solving Case Problems of Technology driven businesses
Here, I looked at a problem faced by an existing tech-driven businesses & then looked at ways in which I could solve it. This included analysing the given data in conjunction with an effective problem solving methodology; which was taught to you.

Project 3

Using Power BI to analyse consumer behaviour and product preferences
For this, I was taught Power BI and then used it on real data to analyse consumer behaviour.