Ajaykumar Kv

Background

About Ajaykumar Kv

Around 5+ years of Professional Experience in IT industry in Data Warehousing related Projects using Power BI Desktop & Power Bl Service Software's. Experience in connecting with multiple data sources like SQL Server, Redshift and Excel from Power Bl to build complex Datasets. Extensively worked on performing the ETL Activities in Power Query. Good Experience in filtering the Unwanted Data in Power Query. Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc. Extensive Experience in doing Data Modeling in Power Pivot Model. Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions. Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information. Having good knowledge on SQL query in AWS Redshift. Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report. Good Experience in Creating Hierarchies and Drilldown Reports. Extensive Experience in Creating APP Workspaces and adding the Members to APP Workspace to Manage the Content in Power BI Service. Experience in publishing the Reports to Power Bl Service and setting up the necessary connections. Extensive Experience in Creating the Dashboards using Multiple Reports. Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset. Implemented ROW LEVEL SECURITY (RLS) as part of security in Power BI. Experience in sharing the Reports and Dashboards with End Users. Hands on Experience on writing SQL Queries and creating materialized views. Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.