KP

Karan Patel

Data analyst with 1.5 years of data analysis experience in FMCG industry. Proven track record of analysis huge volume of data to gain business insights using Microsoft Power BI, SQL and Python.

Key Skills

Data Analytics
Data ETL
Data Visualization
Microsoft Power BI
DAX
SQL

Professional Experience

Jun 2019
Present
Data Analyst
Capgemini Technology Services Private Ltd Bangalore Urban, IN
  •  Design, develop and deploy the reports and dashboards in Power BI.
  •  Scheduled Automatic refresh and scheduling refresh in power bi service.
  •  Implemented Role Based Security as part of security in Power BI.
  •  Extensively worked with Calculated Column and Measure using DAX Expression to show good data analysis reports.
  •  Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  •  Worked on all types of transformations that are available in Power BI Query editor
  •  Prepare financial reports, charts, tables and other exhibits as requested
  •  Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management.
  •  Created various views (Pie Charts, Bar Charts, Heat maps, Tree maps, Donut, Bubble charts etc.).
  •  Expertise in creating Hierarchies for proving Drill down option & Drill through option by Region.
  •  Report requirements collection/analysis, writing SQL, extracting structured data sets, building report. 

Education

May 2015
Jul 2019
B.Tech in G.L. Bajaj Institute of Technology & Management

Hobbies & Interests

  • Cooking
  • Travelling
  • Reading Books

Languages

English
(Fluent)
Hindi
(Native)

Get in touch with Karan