Jayachandra Kumar P Email & Phone Number

Chennai, Tn, In

Chennai, Tamil Nadu, India

Expertise in importing data from multiple data sources into Power BI, created relationships between various Tables in Power Pivot.Experience in Data preparation such as shaping data in Edit Query like add columns, split column, pivot column, unpivot column, changing data type and managing columns in Power Query Editor.Combined the tables and columns by append queries and merge queries in Power BI. Experience on understanding DAX Functions in Power BI and created calculated columns, measures and New Tables using DAX. Expertise in Creating Data Visualizations like Matrix table, Area Charts, tree map, Line, stacked bar chart, stacked column chart, Donut chart, Waterfall chart, Gauge chart and Funnel chart in Power View. Hands on Experience in creating different filters like Visual level, page level, report level and drill through filters. Expertise in Dashboard Designing, Created Customized and interactive Power BI Reports and dashboards using multiple data sources. Experience on sharing the reports created app workspace and Worked on On-Premises Gateway to refresh the data sources/creating a live connection. Implemented Role level security as part of security in Power BI and as well as Worked on Microsoft SQL Server databases and have a Knowledge in SQL for data retrieval and manipulation. Knowledge in working with complex SQL queries like Joins, Analytical Function, Aggregate Function, Set Operator, sub queries Expertise in SQL objects like Tables, Standard views, Materialized views

Chennai, Tamil Nadu, India

Creating reports and dashboards that present data and insights in a clear and comprehensible manner.Using tools like Tableau and Power BI to create charts, graphs and visual representations of data to make it moreaccessible and understandable.Extracting the raw data from the customer database and analyzing the missing values, or inconsistencies.Analyze data to identify trends and patterns to conduct statistical analysis to draw meaningful conclusions from the data.Providing the findings and insights to decision-makers within the organization, often through reports and dashboards.