To transition from a BI developer to a data analyst, you need a strong command of SQL for data querying, statistical analysis techniques, data visualization tools, problem-solving abilities, critical thinking skills, and proficiency in data cleaning, modeling, and storytelling.
If you are interested in pursuing a career as a data analyst, then I would recommend you enroll in MSBI SQL Training from Intellipaat.
Along with that do check out this video on how Thomas switched his career with the help of Intellipaat training -