Data Analysis

I can do Data Analysis in Power BI and Excel

-Expertise in Excel

• Data cleaning, merging or Data validation using power query
• Creating charts, dashboards using pivot table or without pivot table 
• command on useful excel formulas like Vlookup, Indexmatch, and IF(s) etc

-Expertise in Power BI 

• Using Power Query to transform clean or validate data 
• connect data to SQL server 
• Creating live dashboards
• Creating key metrics for the data, like revenue , sales, profit

-Expertise in SQL and R Programming 

• Apart from excel and power bi I have a beginner level experiences in Sql and R programming.
• I can retrieve data  using basic SQL queries like SELECT, FROM and WHERE 
• Also I can use JOINS, GROUP BY and ORDER BY commands
• For R programming I can manipulate and create data visuals using tidyverse and ggplot packages