0%
Hi I'm
Iqra Malkani
a Data Analytics Professional
SQL & Data Modeling Power BI & Reporting KPI & Performance Analysis Business Analysis Social Media Manager
About Me
I turn messy data into clear, decision-ready insights, blending SQL, Power BI, and business thinking.
- Data Modeling (Star Schema)
- SQL Analytics & Reporting
- Power BI + DAX Measures
- Marketing & Sales Dashboards
My Story
• Data → clean model → insight (SQL + Power BI)
• Executive dashboards + KPI storytelling
• Strong focus on clarity, structure, and decision support
My foundation in Computer Science trained me to think in systems, how data is structured, how logic flows, and how decisions are built on architecture. Digital Marketing added another layer- understanding behavior, performance metrics, and how strategy translates into measurable outcomes.
Working within financial operations grounded that perspective in reality, where accuracy matters, numbers carry consequences, and performance is evaluated against tangible results.
The intersection of these experiences shapes how I approach problems today: structured in thinking, analytical in execution, and commercially aware in interpretation. Whether organizing datasets, evaluating performance trends, or designing reporting frameworks, my focus is on clarity, turning complexity into insight that holds up under scrutiny.
Portfolio Projects
SQL + Power BI
Core Stack
Marketing + Sales
Dashboard Focus
Tools & Technologies:
Analytics & BI
- SQL
- Power BI
- DAX
- Data Modeling
- KPI Reporting
Tools & Workflow
- Power Query
- Excel
- SQL Server
- MYSQL
- ETL
Web Development
- HTML
- CSS
- JavaScript
- WordPress
My Projects
Data Warehouse Architecture (SQL Server)
Designed a scalable Medallion Architecture data warehouse using SQL Server to integrate ERP and CRM datasets.
Implemented ETL pipelines, data cleansing, and a star schema model to enable efficient analytical reporting.
Tech: SQL Server • ETL • Data Warehouse • Medallion Architecture • Star Schema • Data Modeling
SQL Data Analytics & Business Intelligence Queries
Built a collection of advanced SQL analytics scripts for data exploration, business metrics, and reporting.
Includes time-series analysis, segmentation, cumulative analytics, and KPI calculations.
Tech: SQL • Data Exploration • Window Functions • CTEs • Business Analytics • Reporting Queries
Sales Management Dashboard (Power BI + SQL)
Developed an executive sales dashboard analyzing internet sales, customer behavior, and product performance.
Used SQL transformations, star schema modeling, and DAX metrics to track sales vs budget and performance trends.
Tech: Power BI • SQL • DAX • Data Modeling • Star Schema • Business Intelligence
Instagram Ad Campaign Analytics Dashboard
Created a Power BI marketing analytics dashboard evaluating Instagram campaign efficiency and lead generation.
Analyzes cost per message, conversion quality, and campaign performance to support marketing optimization decisions.
Tech: Power BI • Marketing Analytics • DAX • Data Modeling • KPI Analysis • Campaign Performance