Skip to content
View ksashi95's full-sized avatar

Block or report ksashi95

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
ksashi95/README.md
K S Ashish analytics profile header
Open to Work

πŸ‘‹ About Me

Data Analyst with a Market Research background, focused on turning structured and survey data into clear, decision-ready insights.

I bring 1.3 years of hands-on Market Research Analytics experience in survey data processing, validation, consumer insights and analytical reporting, while building portfolio projects in SQL Server, Power BI, DAX and data modeling.

Current direction: Data Analytics β†’ Business Intelligence β†’ Consumer & Market Insights

Area Focus
πŸ”Ž Data Analysis SQL, Excel, data validation, analytical problem solving
πŸ“Š Business Intelligence Power BI, DAX, Power Query, data modeling
🧱 Data Engineering Foundations SQL Server, ETL concepts, Medallion Architecture
🧠 Consumer Insights Survey analytics, brand health, consumer preferences

πŸ”„ My Analytics Workflow

RAW DATA β†’ CLEAN β†’ TRANSFORM β†’ MODEL β†’ ANALYZE β†’ VISUALIZE β†’ INSIGHT


πŸš€ Featured Projects

01 Β· SQL Data Warehouse & Analytics

SQL Server Β· Medallion Architecture Β· Advanced SQL Β· Analytics

A portfolio data warehouse built around a Bronze β†’ Silver β†’ Gold architecture, followed by analytical SQL for business questions.

Pipeline: CSV / Source Data β†’ Bronze β†’ Silver β†’ Gold β†’ Analytics

  • Data loading and validation
  • Cleaning and standardization across Silver tables
  • CTEs, joins, aggregations and window functions
  • Customer, product, trend, ranking and segmentation analysis
  • KPI-oriented analytical views
View SQL project

02 Β· Consumer Insights & Market Research Analytics

Power BI Β· Power Query Β· Star Schema Β· DAX Β· Survey Analytics

An interactive consumer insights report built from survey-style data, combining data preparation, dimensional modeling and business-focused analysis.

Pipeline: Survey Data β†’ Power Query β†’ Star Schema β†’ DAX β†’ Power BI β†’ Insights

  • Survey data preparation and transformation
  • Fact and dimension modeling
  • DAX measures and Field Parameters
  • Consumer preferences and product attributes
  • Purchase intent and Price Sensitivity Meter analysis
View Power BI project

🧰 Technology Stack

Core Analytics

Data & BI Practices

Market Research & Statistics


πŸ“š Currently Learning

  • Python for Data Analysis β€” Python, NumPy, Pandas, cleaning, transformation, visualization and EDA
  • Advanced SQL & Data Analysis β€” analytical SQL and SQL Server workflows
  • Power BI & DAX β€” modeling, measures, context and interactive reporting
  • Statistics for Data Analysis β€” practical statistical thinking for business and research data

🎯 What I'm Looking For

Data Analyst Β· BI Analyst Β· Reporting Analyst Β· Consumer Insights Analyst Β· Market Research Analyst

Interested in roles where data preparation + analysis + visualization + business context come together.


🀝 Let's Connect

LinkedInΒ Β  GmailΒ Β  MediumΒ Β  GitHub

Profile Views

Animated analytics pipeline

Pinned Loading

  1. sql-data-warehouse-project sql-data-warehouse-project Public

    TSQL

  2. consumer_insights_market_research_powerbi consumer_insights_market_research_powerbi Public

  3. Data_Analytics_Practice_Dataset Data_Analytics_Practice_Dataset Public

    Realistic Power BI & DAX practice dataset with a star schema, 20K sales transactions, dimension tables, relationships, and 40+ DAX practice questions.

  4. Sample-Superstore-PowerBi-Project Sample-Superstore-PowerBi-Project Public

    Power BI exploration of the Sample Superstore dataset.

    1

  5. Power_Bi_Project_Visual-Analysis-of-Hospital-Emergency-Room-Data Power_Bi_Project_Visual-Analysis-of-Hospital-Emergency-Room-Data Public