Jyoti Dixit

About Jyoti Dixit

A great data story-teller who can deliver hidden and meaningful data insights and patterns to promote data-driven decision-making in the business- Prudent Senior BI Analyst specialized in providing efficient, lean and user-friendly BI dashboards and tools- 7+ years experience working with Power BI, DAX, Dataflows, Power Query/ M Language, Power Apps and Power Automate- Having 6+ years of work experience in Designing and Development of applications using R and Python- Having excellent understanding of R libraries like dplyr, officerR, flextables, ggplot2, shiny, lubridate, mschart, highcharter, reticulate, etc- Having excellent understanding of Python data structures and libraries like Numpy, Pandas, Matplotlib and Scikit-Learn- Managed large-scale databases using SQL- Working with Azure Databricks and Azure Machine Learning- Working closely with the project team in Agile Methodology- Good understanding of version-control using Git- Microsoft Certified Power BI Associate - Passed Exam 778 - Analyzing and Visualizing Data with Power BI- Microsoft Certified: Azure Data Scientist Associate - Passed DP-100 - Designing and Implementing a Data Science Solution- Blogger at https://mlforanalytics.com/ and vlogger at youtube.com/mlforanalytics.

Experience

1. Senior Bi Analyst, Project and Development Services, Apac

   JLL

   Aug 2022 — Present · Gurugram, IN

   Working with users from across APAC including Chief Operating Officer (COO), Product Owners, Project Managers and Business Analysts to understand business/functional requirements, feasibility analysis, preparing estimates and defining technical solutions/prototypes to the business and train them to use BI products. Managing internal reporting and carrying out root-cause analysis for them through Power BI to increase consistency, reliability and quality of business reporting- Building cost and time benchmarking models to estimate cost and time it would take to complete similar projects based on past data using Power BI, Python scripts and Azure Machine Learning- Building sentiment analysis and topic models based on client feedback for past projects using Python to discover hidden patterns from the textual data. Also, carried out the extraction of key-phrases using BERT- Built and maintaining reports to track data quality errors and anomalies across different applications to improve data governance, culture and accuracy to help prepare reliable and consistent dashboards- Built and maintaining interactive Power BI applications and models that involve advanced DAX and M calculations to track yearly goals, KPIs, historical logs and trends of different types of data based on historical snapshots- Improved and enabled seamless functioning of the reporting platform by building data driven alerts framework using Power BI dashboards (hosted on Power BI Service) and Power Automate which helps the team get notified in case of any inconsistency in data reports. Also, maintaining data security, data refresh schedules and gateways on Power BI service- Creating and managing backend ETL processes using Azure and Power BI services like Azure Databricks, Dataflows and SQL jobs- Creating machine learning models using Python and Azure ML Studio to identify which all opportunities can be secured in the future by looking at the past data.

Education

• IMS Proschool Pvt. Ltd.

  PG Diploma , Data Science and Business Analytics

  2019 — 2020

• Deakin University

  MDS, Artificial Intelligence

• Walsh College

  DBA, Artificial Intelligence

• Chinmaya Vidyalaya

  Senior Secondary Schooling, Mathematics and Computer Science

  2008 — 2012

• Maharaja Agrasen Institute Of Technology, Delhi

  Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications Engineering

  2013 — 2017

Skills

• Jquery
• Data Science
• Public Speaking
• English
• Python
• Bootstrap
• Css
• Regression Analysis
• Microsoft Excel
• Powerpoint
• C++
• Mathematics
• Content Development
• Tanner Tools
• Exploratory Data Analysis
• Teamwork
• Team Management
• Html5
• Html
• Pspice
• Descriptive Analysis
• Data Analysis
• Windows
• R
• Data Wrangling
• C
• Programming
• Microsoft Office
• Analytical Skills
• Data Cleaning
• Linux
• Mathematics and Statistics
• Matlab
• Embedded C
• Research
• Leadership
• Online Content Creation
• Cascading Style Sheets (Css)
• Agilent Ads
• Electronics