Charan Teja — Data Analyst

Data Analyst | Business Analyst

Hi, I'm Charan Teja

>

Data Analyst

I am a Data Analyst who believes raw columns are noise until decoded with the right questions. I design custom analytical pipelines, build interactive dashboards, and extract meaningful patterns to support data-driven decision-making.

Connect with Me Explore Projects CV
Charan Teja Profile Photo
NumPy / Pandas
SQL Query Ops
Power BI DAX

About Me

Get to know me better — personal telemetry and system specs.

charanteja@identity:~

Hello! I'm Charan Teja

I'm a recent Computer Science postgraduate with a strong foundation in data analysis, statistical interpretation, and visualization. I'm currently enhancing my skillset through a Data Analyst with AI Tools program.

Proficient in SQL, Excel, Python (Pandas, NumPy, Matplotlib), Power BI, Tableau, and MySQL. I thrive on solving real-world problems by turning data into actionable insights.

Active Packages:
SQL Excel Python (Pandas/NumPy) Power BI Tableau MySQL

Fresh Post Graduate

Computer Applications

Master of Computer Applications (MCA)

Data Analysing

Love building Dashboards

ETL pipelines & Interactive Visualizations

Quick Learner

Always eager to learn

AI-assisted analysis & emerging methodologies

Analytics Workflow

How I process unstructured chaos into structured decisions.

01

Sifting the Noise

Data Ingestion & SQL ETL

Data is collected in chaotic, messy streams. My first step is isolation: writing optimized SQL subqueries, handling null records, and executing Python scripts to extract high-fidelity columns.

MySQL Pandas Clean JSON Parsing
02

Isolating the Patterns

Statistical EDA & Modeling

Once structured, I check the statistical integrity. I examine parameter correlations, calculate rolling indices, and build clean Star Schemas to link variables logically.

Star Schema EDA DAX Modeling
03

Illuminating the Signal

Visual Storytelling & Dashboards

A report is only useful if it drives action. I build UX-optimized dashboards featuring interactive slicers and parameters that answer specific executive decision queries instantly.

Power BI Interactive UX Actionable KPIs
0+

Dashboards Deployed

0k+

Records Analyzed

0%

Hypothesis Tested

Analytical Toolkit

Technologies and tools I leverage to decode data frameworks.

Data Visualization

  • Power BI & DAX85%
  • Advanced Excel90%
  • Tableau Reports75%

Code & Database Layer

  • SQL (MySQL Query Ops)85%
  • Python (Pandas, NumPy)80%
  • HTML / CSS / JS80%

Core Methodologies

  • Data Cleaning & ETL90%
  • Data Modeling (Star Schema)85%
  • Statistical Hypothesis80%

Projects

Explore my project portfolios structured as interactive lab experiments.

Power BI

Enterprise Retail Dashboard

The Clutter (Problem): Retail sales rows were fragmented across CSV sheets, featuring mismatched date indexes, return discrepancies, and missing geographic coordinates. Forecasting regional quarterly margins was impossible due to data noise.

Chaos Identified

Star Schema & DAX ETL

The Extraction (Process): Built a Star Schema relationships layout in Power BI. Utilized Power Query M code to standardize calendar keys, filtered out duplicate transaction records, and wrote dynamic DAX measures for rolling time-intelligence metrics.

Data Restructured
Enterprise Retail Dashboard Screenshot
Repository

The Signal (Insight): Isolated a 14% drop in product category margins due to return anomalies, steering the inventory restocking plan for Q3.

Power BI

Beijing Air Quality Visualizations

The Clutter (Problem): Environmental sensor records displayed massive pollutant spikes but lacked context. Unorganized pollutant dimensions (PM2.5, PM10, SO2) made it impossible to isolate correlation dynamics with humidity and wind indexes.

Chaos Identified

Multidimensional Air Correlation

The Extraction (Process): Built customized parameter slicers and calculated environmental indexes. Integrated multi-pollutant metrics over temporal calendar scales, mapping air health indices dynamically against humidity benchmarks.

Data Restructured
Beijing Air Quality Screenshot
Repository

The Signal (Insight): Proved that PM2.5 concentrations spikes 22% during low-wind, high-humidity weather patterns, enabling local health safety alerts.

Python Analysis

911 Emergency Calls EDA

The Clutter (Problem): 100k+ messy transaction rows of emergency logs containing unparsed string timestamps, miscellaneous emergency descriptions, and random geographical coordinates without frequency categorization.

Chaos Identified

Pandas Wrangling & Heatmapping

The Extraction (Process): Coded a Python cleaning pipeline using Pandas and NumPy. Extracted day-of-week, hour-of-day, and month columns. Grouped entries by emergency reasons and built matrix shapes for coordinate plots.

Data Restructured
911 Emergency Calls Screenshot
Repository

The Signal (Insight): Isolated traffic emergencies peaking precisely at 8:00 AM and 5:00 PM on weekdays, guiding local traffic patrol dispatch plans.

Web Application

Online Crime Reporting Portal

The Clutter (Problem): Citizens faced slow, manual emergency logging loops. Lack of centralized digital registration created huge processing backlogs, preventing law enforcement from categorizing incident status in real-time.

Chaos Identified

PHP MySQL Dashboard Layer

The Extraction (Process): Developed a relational MySQL model with user, police, and administrator clearance ranks. Coded PHP session authentication and direct database insert scripts to log incidents securely.

Data Restructured
Online Crime Reporting Screenshot
Repository

The Signal (Insight): Standardized complaints reporting through role-based access portals, reducing administrative processing delays.

Credentials & Timeline

Academic foundations and specialized analytic training.

2023 - 2025

Master of Computer Applications (MCA)

Jawaharlal Nehru Technological University (JNTU)

Focus on software architectures, database optimization techniques, and structured mathematics. Honored as **Best Outgoing Student of the Year 2023-2025** and led corporate communications as Student Placement In-charge.

GPA: 8.68 Best Outgoing Student

Analytics Specializations

Data Analyst with AI Tools

Specialized training in SQL optimizations, Python structures (Pandas/NumPy), Power BI reporting modeling, and utilizing LLM prompts for analytical automation.

NPTEL Certification: Cloud Computing

Studied scalable architectures, virtualization, cloud database structures, and warehouse scale computing models.

Query Intake

Ready to decode complex questions. Get in touch to start analyzing.

Initiate Collaboration

Have a complex spreadsheet, a messy database, or want to discuss analytics methodologies? Get in touch and let's turn that clutter into clear visual signals.

teja0942@gmail.com +91-9182856702
Hyderabad, Telangana, India