Hello!

I'm Janak Ram



Know Me My works

Name: Janak Ram

Job Role: Data Analyst intern

Experience: 2 Month

Address: Remote

Skills

SQL
PYTHON
POWER BI
ADVANCED EXCEL
Communication Skill

About

About Me

BCA graduate skilled in utilizing tools such as SQL, Python, Advanced Excel, and Power BI. Proficient in data collection, data cleaning, insightful data analysis, and data visualization.

  • Profile: Data Analyst
  • Education: Bachelor of Computer Application
  • Language: English , Hindi
  • BI Tools: Microsoft Power BI, & Tableau
  • Other Skills: JIRA , Google Analytics
  • Interest: Traveling , Travel Photography, learning

0 +   Projects completed

Resume

Resume

As a Data Analysis, I'm ready to leverage my skills in SQL, Python, and Power BI to drive success in a dynamic environment. With a strong foundation in data visualization and database management, I aim to contribute immediately in a data analyst role, enhancing business insights and decision-making processes..

Experience


10/2024-11/2024

Data Analyst

KultureHire

  • Extracted and analyzed key insights from the GenZ dataset, providing valuable information for decision-making.
  • Implemented data aggregation and transformation processes to enhance data visualization.
  • Executed complex MySQL queries to address critical business questions and extract actionable insights.
  • Created dynamic dashboards in Excel and Power BI, integrating Pivot Charts and Slicers for enhanced data visualization and filtering across sales and customer relations.



Education


2017-2019

Bachelor of Computer Application

Mats University, Raipur

Resume

Projects

Projects

Below are the sample Data Analytics projects on SQL, Power BI, Python

Consumer-Goods-Ad-hoc requests Data Analysis SQL project

AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Hence, company decided to conduct a SQL challenge.

Data Analysis Python Project

"AtliQ Grands faced intense competition, resulting in a decline in revenue. Recognizing the need for data-driven strategic insights, they lacked internal expertise. My goal is to perform an in-depth analysis using Python, equipping AtliQ Grands with valuable insights for enhancing customer retention

CodeX Energy Drink Customer Analysis

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. I , a marketing data analyst is tasked to convert these survey results to meaningful insights which the team can use to drive actions.


Mitron Bank Credit Card Analysis Power Bi Project

The purpose of this dashboard is to aid the strategy team of Mitron Bank in making data-driven decisions to launch a new line of credit cards. We will segment the top three categories of customers most likely to need credit cards and analyze their spending patterns

Atliq Hardware Sales Report Excel Project

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Pune, India

Contact Number

9131562586

Email Address

janakram.official55@gmail.com

Download Resume

resumelink