Skip to content
View RamakrishnaTanam's full-sized avatar
🎯
Focusing
🎯
Focusing
4 followers · 8 following

Achievements

Achievement: Pull SharkAchievement: YOLO

Achievements

Achievement: Pull SharkAchievement: YOLO

Block or report RamakrishnaTanam

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
RamakrishnaTanam/README.md

Profile Views

Hi 👋, I'm Rama Krishna

Data Analyst | SQL • Python • Power BI • Excel • DAX

Turning data into actionable insights and better business decisions.

👨‍💻 About Me

I'm an aspiring Data Analyst with a strong technical foundation and a focus on data analysis, business intelligence, and data-driven problem solving.

I work across the complete analytics lifecycle:

Data → SQL → Cleaning → EDA → KPI Analysis → Visualization → Insights → Recommendations

🔎 What I Do

  • 📌 Extract and analyze data using SQL / MySQL
  • 🧹 Clean and transform datasets using Python, Pandas & Power Query
  • 📊 Perform EDA and statistical analysis using Python
  • 📈 Build interactive Power BI dashboards and DAX measures
  • 📗 Analyze and report data using Excel
  • 🎯 Develop KPIs, segmentation, trend and root-cause analysis
  • 💡 Translate analytical findings into business recommendations

My software engineering background gives me a strong technical foundation for working with databases, automation, and data workflows — while my primary focus is Data Analytics and Business Intelligence.

🛠️ Tech Stack

📊 Data Analytics & BI

☁️ Database & Cloud

🔧 Tools

📂 Featured Analytics Work

🏦 Banking Analytics Dashboard

MySQL • SQL • Python/EDA • Power BI • DAX

Analyzed 2,940 banking customers, including $4.38B in loans and $3.77B in deposits, to understand customer segments, lending, deposits, account balances and engagement.

🛍️ Retail Pricing & Brand Analysis

Azure SQL • SQL • Power BI • DAX

Analyzed pricing, discounts, product variety and profitability to identify opportunities for better pricing and assortment decisions.

💳 Loan Default & Financial Risk Analysis

SQL Server • Power BI Dataflows • Power Query • DAX

Analyzed borrower segments, loan portfolios and default patterns to identify areas of financial risk.

📈 Sales Analytics Dashboard

Power BI • Data Modeling • DAX

Analyzed revenue, profitability, products, customers, promotions, time trends and geographic performance.

🧠 Analytics Capabilities

Area Skills
SQL Joins, CTEs, Window Functions, Aggregations, Subqueries
Python Pandas, NumPy, Data Cleaning, EDA
Visualization Matplotlib, Seaborn, Power BI
BI Power Query, Data Modeling, DAX, KPIs
Excel PivotTables, PivotCharts, Lookups, Dashboards
Analytics Segmentation, Trends, Root Cause, Business Insights

🎯 My Approach

Business Problem
       ↓
Data Collection
       ↓
SQL & Data Cleaning
       ↓
Exploratory Analysis
       ↓
KPI & Business Analysis
       ↓
Visualization
       ↓
Insights
       ↓
Recommendations

Pinned Loading

  1. electro-hub-sales-analytics-powerBI electro-hub-sales-analytics-powerBI Public

    An end-to-end Power BI Sales Analytics project built to help Electro Hub analyze sales, profitability, product performance, promotions, customers, time trends, and city-level performance.

    1

  2. Insurance-Claims-Policy-Analytics Insurance-Claims-Policy-Analytics Public

    An end-to-end Power BI Insurance Analytics project developed to analyze policy performance, premiums, coverage, claims, customer demographics, policy activity, and claim status.

  3. Loan-Default-Financial-Risk-Analysis Loan-Default-Financial-Risk-Analysis Public

    End-to-end Data Analytics project using SQL Server, Power BI Dataflows, Power Query, DAX and Power BI Service to analyze loan portfolio performance, borrower demographics and financial risk.

  4. Business-Optimization-Analysis-Project-Power-BI Business-Optimization-Analysis-Project-Power-BI Public

    production-style reporting solution to analyze demand, availability, supply shortages, profitability and losses, while demonstrating a practical test → production workflow and SQL Server → MySQL d…

    TSQL 1

  5. Banking-Analytics-Dashboard Banking-Analytics-Dashboard Public

    An end-to-end banking analytics project built to transform raw customer and financial data into actionable business insights using SQL, Python/EDA, Power BI, and DAX.

    Jupyter Notebook