Skip to content
View sharikansari0's full-sized avatar

Block or report sharikansari0

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.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

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

Report abuse
sharikansari0/README.md

👋 Hi, I'm Sharik Ansari

🔹 AI-Powered Data Analyst

I specialize in turning raw data into business insights using
Excel, SQL, Power BI, Python, and AI automation tools.
I love solving real-world business problems and creating dashboards that tell powerful stories.

🔧 Skills & Tools

📌 Data Analytics & Visualization

  • Excel: Advanced formulas, Pivot Tables, Data Cleaning, Dashboards
  • Power BI: Data Modeling, DAX, Time Intelligence, Interactive Dashboards

🧠 Data Engineering & Querying

  • SQL: Joins, CTEs, Subqueries, Aggregations, Window Functions

🐍 Python for Data

  • Pandas, NumPy, Exploratory Data Analysis, Cleaning Scripts

🛠 Other Tools

  • Git & GitHub
  • AI Automation (ChatGPT for analysis, text-to-SQL, ETL workflows)

📊 Featured Projects

🔹 Retail Mobile Sales Dashboard (Power BI + Excel)

A multi-page analytical dashboard covering:

  • KPIs (YoY, MoM, MTD)
  • Brand insights
  • City performance
  • Customer behavior & demand patterns
    → Excel + Power BI combined real-world project

🔹 SQL Customer Insights Analysis (Coming Soon)

A SQL project focused on:

  • Customer segmentation
  • Retention patterns
  • Purchase trend analysis
    → Full business case study

🔹 E-commerce Sales Analysis (Excel) — Coming Soon

An end-to-end Excel analytics project including:

  • KPI tracking
  • Region-wise analysis
  • Product performance
  • Dashboard visualization

📈 What I'm Currently Learning

  • Advanced DAX for business analytics
  • Python automations for data cleaning
  • Power BI end-to-end workflow (ETL → Modeling → DAX → Report)

📊 GitHub Stats (Premium Theme)

🌐 Connect With Me

🔥 Thanks for visiting my profile!
⭐ Feel free to check out my projects and connect with me.

Popular repositories Loading

  1. onlinebookstore-sql-data-analysis-postgresql onlinebookstore-sql-data-analysis-postgresql Public

  2. retail-analytics-mobile-sales-dashboard-excel-powerbI retail-analytics-mobile-sales-dashboard-excel-powerbI Public

    Power BI dashboard analyzing mobile sales data (2021–2024) with YoY, MTD, city, brand, and payment insights.

  3. sharikansari0 sharikansari0 Public

  4. sales-analysis-amazon-dashboard-powerbi-excel sales-analysis-amazon-dashboard-powerbi-excel Public

    End-to-end Amazon E-commerce Sales Analytics Dashboard built using Power BI, DAX, and Excel. Includes raw dataset, data cleaning workflow, DAX measures, interactive sales insights, courier performa…

  5. hospital-analysis-healthcare-dashboard-powerbi-excel hospital-analysis-healthcare-dashboard-powerbi-excel Public

    A Power BI healthcare analytics dashboard built using Excel, Power Query, and DAX. Analyzes 7,157 hospital records to uncover insights on patient workflow, diagnosis trends, bed occupancy, doctor f…

  6. fintech-analytics-phonepe-dashboard-powerbi-exce fintech-analytics-phonepe-dashboard-powerbi-exce Public