Shashi Kant Singh Email & Phone Number

• Skilled in Advance Excel, Power BI and SQL with expertise in crafting dynamic dashboards optimizing SQL queries for performance and leveraging DAX and Power Query for efficient data transformation, resulting in actionable insights and improved decision-making, showcasing strong analytical and problem-solving abilities, with 2 years of experience.• A strategic thinker with a proven ability to communicate technical findings effectively to diverse audiences, driving organizational success through data-driven innovation.POWER BI • Connecting & Shaping Data - Power Query Editor, Table Transformations, Index & Conditional Columns, Calculated Column, Grouping & Aggregating, Appending Files from a Folder, Data Source Settings, Importing Excel Models.• Creating a Data Model - Database Normalization, Primary & Foreign Keys, Creating Table Relationships, Star & Snowflake Schemas, Creating Hierarchies.• Calculating Measures with DAX - DAX Measures, Dedicated Measure Tables, Conditional & Logical Functions, SWITCH Function, COALESCE Functions, Joining Data with RELATED, Iterator (X) Functions.• Visualizing Data with Dashboards - Building & Formatting Charts, Trend Lines & Forecasts, KPI Cards, Table & Matrix Visuals, Top N Filtering, Report Slicers, Custom Tool Tips, Drill Up & Drill Down.MS EXCEL• Conditional statements - IF, AND, OR, NOT, IFERROR, SUMIFS/COUNTIFS, SUMPRODUCT, COUNTIF.• State function- COUNT, AVERAGE, MEDIAN, MODE, MAX, MIN, STDEV, RANK, RAND• Lookup & Reference Function – Named Arrays, VLOOKUP, HLOOKUP, INDEX, MATCH• Text Function – TRIM, UPPER, LOWER, PROPER, CONCATENATE, LEFT, RIGHT, MID, LEN, SEARCH• Design an Interactive Dashboard using Pivot Table SlicerSQL • DDL (Data Definition Language)- Create, Alter, Drop, Truncate, Rename• DML (Data Manipulation Language)- Select, Insert, Update, Delete• Aggregate functions in SQL –Min, Max, Count, Avg, Sum• JOIN – Inner Join, Left Join, Right Join, Full Join• Union and UNION ALL, Common Table Expression (CTE)• Subquery, CASE Statement, Window Function#PowerBI #SQL #Excel

• 

  Dit University

  7.58