Analyzing and Visualizing Data with Microsoft Power BI

Google Data Analytics Specialization

Excel Skills for Business Specialization

SPSS Statistics Essential Training

The Complete Microsoft SQL Server Course: From A to Z

Querying Microsoft SQL Server 2022

Microsoft Office Specialist: Microsoft Excel Expert (Office 2019)

Python Essential Training

EFSET English Certificate 47\100(B1 Intermediate)

Bachelor of Applied Science - BASc

Bachelor of Business Administration - BBA

• Prepared the course syllabus, structuring lesson content, learning objectives, and assessment methods.
• Delivered hands-on training in Microsoft Excel, SQL, Python, Power BI, and Statistics to students and professionals.
• Developed engaging course materials that enhanced understanding and retention of analytical skills.
• Mentored learners in data-driven decision-making, transforming complex concepts into practical applications.

Data Analytics Instructor

dentified key customer segments through detailed Python-based customer data analysis and developed personalized sales strategies based on analytical insights to improve campaign conversion.
Created complex financial and sales reports using Excel, leveraging Power Pivot for in-memory data modeling and analysis of large datasets.
Designed and published advanced interactive dashboards in Power BI, implementing sophisticated calculations and metrics using the DAX language (Data Analysis Expressions).
Developed robust data transformation scripts and queries using the M Language (Power Query) to connect, clean, reshape, and integrate data from various disparate sources, ensuring data integrity.
Automated the ingestion of data by pulling information from various external sources (APIs or web scraping) using Python, ensuring the availability of timely and comprehensive datasets for analysis.
Utilized Power Query extensively for ETL/ELT processes, ensuring high data quality and preparing struct

Data Analyst

Developed monthly dashboards to analyze sales trends and pinpoint potential growth areas using Power BI and Excel.
Automated the report preparation process through the integration of various data sources using Power Query, thereby reducing reporting discrepancies.
Actively contributed to the automation of repetitive data handling tasks through Python scripts and Power Query transformations.
Determined root causes of variance and deviation using cleaned and grouped data processed with Pandas and NumPy
Monitored monthly sales and product performance using SQL-based queries.

Spearheaded comprehensive quantitative research efforts, including numerous survey studies and extensive data sourcing, resulting in detailed statistical analysis across key business categories
Designed and deployed Customer Satisfaction and Opinion (CSO) surveys, successfully capturing direct feedback from customers and key target audiences to gauge perception and demand.
Optimized data cleaning and validation protocols, significantly improving data reliability and reducing reporting discrepancies.
Prepared monthly market research reports by performing advanced statistical analysis, utilizing key metrics such as BDI, CDI, YOY, and MOM to derive deep market and consumer insights.
Drove substantial improvement in the effectiveness of marketing campaigns by leveraging rigorous customer data analysis and translating findings into strategic recommendations.
Mastered data visualization by combining large, disparate datasets using Power Query and developing dynamic reports in Power BI suppor

Market Research Analyst

Database management and data architectural optimization.
Power Query (M language) for automated ETL (Extract, Transform, Load) processes.
VBA for repetitive task automation.
Creating interactive, stakeholder-ready dashboards
Advanced DAX (Data Analysis Expressions) for custom measures and calculated columns
Data manipulation using Pandas and NumPy.
Statistical analysis and hypothesis testing.
Visualizations with Matplotlib, Seaborn, and Plotly

Lead Data Analyst

Data Analyst with 4+ years turning raw data into dashboards and reports that drive decisions. Now building toward Data E

github

Know about Nigar Majidzada's work experience, education, bootcamps, certifications, and much more. Nigar Majidzada