Yogesh Kumar K S Email and Phone Number

• Understand the Business requirements and analyze the Customer & Transactions behavior that impacts Business strategies.• Created Azure Notebooks to fetch the Fuel & NFR customer and transaction tables for Analysis.• Provided meaningful insights and recommendations for the data, observed previous years of transaction behavior, in each market based on Customer type (Loyalty & Non-Loyalty and B2B & B2C split), Transactions, Category and Sub-Category.• Prepared the reports to analyze high-level trends or patterns for Targeted customers’ visit frequency, Average Spend ($), Loyalty and Non-Loyalty Comparison study and Category and Sub-Category level distribution result.

Requirement analysis, Customer interaction for requirement clarifications and data collection.- Utilized power queries to pivot & un-pivot the data model for data cleansing and data masking.-Utilized Append queries to showcase multiple input table in the single view to meet the required output.- Understand data architecture for implementation of visualization, based on data relationship and table join constraints.- Implement data visualization including various charts, calculated columns using Dax functions with selections and filters applied across visualization on multiple pages.- Explore data in a Variety of ways and across multiple visualizations using Power BI. - Involved in creating new stored procedures and optimizing existing queries and stored procedures. - Perform Predictive maintenance activities like casual analysis, data problems resolution and performance tuning.- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.