Muhammad Talha

DATA ANALYST ( BUSINESS INTELLIGENCE DEVELOPER )
POWER BI | SQL | PYTHON | GOOGLE LOOKER STUDIO | EXCEL

I'm a Computer Science graduate and Microsoft Certified Data Analyst with expertise in transforming complex datasets into actionable business intelligence. Currently working as a Power BI Developer at Ikonami Technologies, I bring strong proficiency in SQL, Python, Power BI, Google Looker Studio, and Azure Data Factory to build end-to-end data solutions. I specialize in developing data pipelines and ETL workflows, designing interactive dashboards, implementing predictive analytics (linear regression, decision trees), and creating data warehouse architectures using star schema and dimensional modeling.My work centers on empowering organizations to make data-driven decisions through statistical analysis, hypothesis testing, and performance optimization. I excel at translating technical insights into strategic recommendations for stakeholders, automating reporting processes, and identifying operational inefficiencies. With hands-on experience in OLAP systems, DAX, and advanced Excel, I'm passionate about leveraging analytics to solve complex business challenges and deliver measurable impact in fast-paced environments.

PROJECTS ⬇️

AZURE , SQL and POWER BI

House and Units Approvals Analytics Reporting

📊 Interactive Dashboards: Visualize house and unit approval trends with dynamic charts and filters powered by Azure SQL Server.🧠 Automated Insights: Get real-time, data-driven insights to support planners, analysts, and decision-makers.🏢 Performance Monitoring: Track authority performance and explore property-specific stats for smarter urban planning.

Details

POWER BI , Azure Data Factory and SQL Server

Real time Inventory and Stock Analysis with Automated Reporting

🔄 Realtime ETL Workflow: Leveraged Azure Data Factory to automate data ingestion and transformation across multiple sources and branches.
🗃️ SQL Integration: Backend SQL queries power performance-optimized views and supply chain insights.📈 Automated Dashboards: Refresh-enabled reports with filters for branches, states, and SKUs.

Details

Python, PostgreSQL and Power Bi

United States Fires Trends and Analysis

🐍 Python for EDA & Cleaning: Used Python to explore and clean fire incident data for accurate analysis.🗃️ PostgreSQL Extraction: Extracted key insights and structured data using SQL queries from a PostgreSQL database.📈 Power BI Visualization: Built an interactive dashboard to showcase trends and patterns of fire incidents across the US using official government data.

Details

POWER BI and SQL

Restaurants Bankruptcy Analysis

🧹Performed data cleaning, preprocessing, and transformation to ensure quality insights.🗄️ Utilized SQL to extract and analyze key patterns related to restaurant bankruptcies.📊 Created a dashboard to visualize the main causes of bankruptcy in the restaurant industry.

Details

AWS and SQL

SUPERSTORE SALES ANALYSIS

☁️ Utilized AWS S3 for data storage, AWS Glue for data cataloging and ETL, AWS Athena for SQL-based querying, and AWS QuickSight for creating interactive dashboards.
📊 Delivered insights into sales trends, customer behavior, and product performance using scalable and cost-efficient AWS services.
⚙️ Implemented a streamlined process from raw data ingestion to insightful visualizations, enabling data-driven decision-making.

Python

MENTAL HEALTH ANALYSIS

🧠 Utilized healthcare data to explore and identify key insights related to mental health issues in society.
🔍 Analyzed responses to a set of targeted questions to uncover patterns and trends.
🐍 Employed Python for data cleaning, analysis, and deriving meaningful conclusions.

Details

PYTHON(pandas, matplotlib, seaborn)

CUSTOMER CHURN ANALYSIS

📉 Conducted in-depth analysis of Telco customer churn data to uncover reasons behind customer attrition.
🔄 Cleaned and transformed the dataset using Pandas for effective analysis.
📊 Created insightful visualizations with Matplotlib and Seaborn in Jupyter Notebook to highlight key trends.

Details

CERTIFICATIONS

Details

Made with Carrd