Aatiqa noohani's Work | ContraWork by Aatiqa noohaniAatiqa noohani
AI & Data Analyst | Python | SQL | Power BI
Built a SQL Data Analytics Portfolio focused on cleaning messy data, exploring business trends, and generating actionable insights using MySQL. Worked with real-world company layoffs data using CTEs, window functions, data cleaning, ranking, aggregation, and exploratory analysis.
Tools: MySQL, SQL
Skills: Data Cleaning, Data Analysis, Business Insights Built an interactive Power BI dashboard to analyze e-commerce sales performance, revenue trends, product performance, and key business KPIs, helping turn raw sales data into clear and actionable business insights. Analyzed 1,500 retail transactions using Excel, MySQL, and Power BI to identify sales, profit, discount, product, regional, and customer trends. Built an interactive dashboard and identified the 5% discount as the highest-profit level, with actionable insights for pricing and promotional strategy. AI-Powered OTT Customer Churn & Revenue Intelligence Platform
Built an end-to-end data analytics and machine learning solution to identify customer churn patterns, predict high-risk customers, and analyze potential revenue loss.
I cleaned and analyzed customer data using Python and SQL, created an interactive Power BI dashboard, developed machine learning models for churn prediction, and used SHAP explainability to understand the key factors driving customer churn.
Tools: Python, Pandas, SQL, MySQL, Power BI, Scikit-learn, XGBoost, SHAP, K-Means.