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
- MS Excel
- Power BI
Modules
- Data-Driven Decision Making:
This module covers the advantages of data-driven decision making, different types of data and data analytics. - Case Studies:
This module analyzes two case studies: Amazon’s acquisition of Whole Foods and McKinsey. - Data Analyst vs. Business Analyst:
This module dives into the differences between these roles and explores the MECE framework. - 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.