About me

I am Samra Amjad, a data analysis and visualization professional with strong expertise in Python, Power BI, and Excel. I specialize in analyzing large, complex datasets and turning them into clear, actionable insights through automation, visualization, and structured reporting.

My core strength lies in Python, using libraries such as Pandas for data manipulation, NumPy for numerical analysis, and Matplotlib/Seaborn for generating insightful visualizations. I efficiently clean, explore, and model data to uncover patterns and support better decision-making.

In Power BI, I build dynamic dashboards using DAX formulas, calculated columns, and Power Query transformations to provide real-time business intelligence. Iโ€™m skilled in designing visually compelling reports that highlight trends, performance metrics, and KPIs tailored to organizational needs.

Excel remains a key part of my toolkit, where I apply advanced formulas, pivot tables, and data validation techniques to structure reports and track performance. Additionally, I have experience in video editing using Adobe Premiere Pro to produce clean, polished visual content.

What can I Do

  • Power BI

    Power BI

    Creating interactive dashboards and data visualizations to transform raw data into actionable business insights.

  • Excel

    Excel

    Advanced spreadsheet solutions, data analysis, automation with VBA, and complex formula development for business efficiency.

  • Python

    Python

    Custom Python development for automation, data analysis, web scraping, and machine learning applications.

  • SQL

    SQL

    Database design, optimization, and complex query development for efficient data management and reporting.

  • Video Editing

    Video Editing

    Professional video editing, motion graphics, and post-production services for engaging multimedia content.

  • AI Tools & Automation

    AI Tools & Automation

    Custom AI solutions, chatbots, workflow automation, and intelligent systems to streamline business processes.

  • Microsoft Office

    Microsoft Office

    Complete Microsoft Office suite expertise including Word, PowerPoint, Outlook, and advanced productivity solutions.

Testimonials

  • Muhammad Abbas

    Muhammad Abbas

    Working with you on our Power BI dashboard was exceptional. Your ability to transform complex data into clear, actionable insights helped our team make better decisions. The interactive visualizations you created saved us hours of manual analysis.

    CEO GBCHEAPHOST

  • SAIF UR REHMAN

    SAIF UR REHMAN

    Your Python automation scripts revolutionized our data processing workflow. What used to take our team days now completes in hours. Your mathematical background really shows in the elegant solutions you provide.

  • NOMAN ALI

    NOMAN ALI

    Your Excel expertise is outstanding! The advanced formulas and pivot tables you created for our financial analysis were exactly what we needed. Your ability to handle complex data sets with such precision is remarkable.

  • ANAS KHAN

    ANAS KHAN

    Your SQL database optimization and query writing skills are exceptional. You helped us streamline our data retrieval processes and created efficient queries that improved our system performance by 40%. Highly recommended!

Resume

Education

  1. ๐ŸŽ“ Bachelor of Science in Mathematics

    University of Agriculture, Faisalabad โ€” Graduated June 2024

    GPA: 3.11

    During my undergraduate studies, I developed a strong foundation in statistical analysis, mathematical modeling, and logical problem-solving. As a distinguished member of the Mathematics Society, I actively participated in academic events, workshops, and peer learning groups that sharpened my analytical thinking.

    A major highlight of my academic journey was exploring advanced tools for big data analysis, which sparked my interest in data science and analytics. This coursework introduced me to techniques in data wrangling, visualization, and interpreting complex datasets skills I continue to build on in real-world projects featured in this portfolio.

  2. Punjab Group of Colleges

    2018 โ€” 2020

    Focused on foundational studies in mathematics, physics, and chemistry, which strengthened my analytical thinking and problem-solving skills. This period laid the groundwork for my interest in data, numbers, and logical reasoning.

  3. Dar-e-Arqam School

    Graduated in 2018

    Completed my secondary education with a focus on science subjects including mathematics, physics, and computer science. This phase helped me build a strong academic foundation, discipline, and a curiosity for logical problem-solving that eventually guided my path toward mathematics and data analysis.

Skills & Expertise

  1. ๐Ÿ“Š Power BI

    Skilled in using Power BI to convert complex datasets into visually rich, interactive dashboards and reports. Well-versed in data modeling, applying DAX functions for calculated measures, and using Power Query for data transformation. Able to uncover trends, patterns, and KPIs through thoughtful visualizations. Experienced in publishing reports to Power BI Service, enabling seamless collaboration, scheduled refreshes, and secure access. Confident in using Power BI as a decision-support tool in fast-paced environments.

  2. ๐Ÿ“ˆ Excel

    Proficient in advanced Excel functionalities including pivot tables, data validation, dynamic charts, and nested formulas. Experienced in cleaning and structuring raw datasets for accurate reporting and analysis. Regularly use Excel for trend identification, performance tracking, and building professional dashboards. Comfortable applying logical functions, lookup formulas, and conditional formatting to highlight insights. Adept at creating efficient, user-friendly spreadsheets for everyday business use and data-driven decision-making.

  3. ๐Ÿ Python

    Hands-on experience with Python for data analysis, automation, and visualization tasks. Proficient in using Pandas and NumPy for data manipulation, and Matplotlib/Seaborn for generating meaningful visuals. Comfortable writing clean, efficient scripts to streamline repetitive tasks, clean datasets, and conduct exploratory data analysis. Able to handle CSV/Excel files, JSON, and APIs for data integration. Use Python to support deeper insight generation and improve analytical workflows.

  4. ๐Ÿงพ SQL

    Strong command over SQL for querying and analyzing data from relational databases. Skilled in writing SELECT queries, JOINs, aggregations, and filtering data to support business reporting. Capable of working with normalized data structures and deriving meaningful insights through logical query construction. Use SQL to extract, clean, and summarize large datasets for analysis and performance monitoring. Confident in applying SQL for routine data tasks and complex problem-solving.

  5. ๐ŸŽฌ Video Editing

    Experienced in editing videos with tools like Adobe Premiere Pro and CapCut to create engaging, high-quality visual content. Skilled in trimming footage, adding smooth transitions, syncing audio, and enhancing clips with effects and text overlays. Comfortable working with different formats and resolutions to meet platform-specific requirements. Focused on maintaining pacing, clarity, and visual appeal in every edit. Use video editing to communicate messages effectively and creatively.

  6. ๐Ÿค– AI Tools & Automation

    Proficient in using AI-based tools to automate tasks, improve efficiency, and support content creation. Experienced with platforms like ChatGPT for ideation, writing, and summarization, as well as automation tools like Zapier for workflow integration. Able to streamline repetitive processes, connect applications, and reduce manual work through smart automation. Use AI tools to support decision-making, productivity, and digital innovation in daily tasks.

  7. ๐Ÿ—‚ Microsoft Office

    Well-versed in Microsoft Word, Excel, and PowerPoint for a wide range of professional tasks. Skilled in formatting documents, analyzing data, and designing presentations that are both informative and visually appealing. Able to create structured reports, automate calculations, and deliver compelling visuals. Comfortable working with templates, charts, styles, and referencing tools. Use Microsoft Office tools daily to support communication, documentation, and data presentation in an organized and professional manner.

My skills

  • Excel
    96%
  • Python
    95%
  • Microsoft Office
    94%
  • Power BI
    90%
  • SQL
    90%
  • AI Automation
    87%
  • Video Editing
    85%