I am Mohamed Yousry, a Data Analyst with various skills in the data analysis field:
Python:
- Pandas and Numpy
- Data Visualization using Matplotlib and Seaborn
- Hypothesis testing
- Create and analyze A/B test results
- Building regression models (linear & logistic)
Excel:
- Analyze Data using Power Query, Power Pivot, Pivot Tables, creating Interactive Dashboards with Slicers
- Working with Tables, Text, and Dates
- Lookup Functions
- Calculate summary statistics using spreadsheets
- Create data visualizations using spreadsheets
- Ask questions and answer them using data
Power Bi:
- Design and develop interactive dashboards, reports, and visualizations that provide valuable insights into business performance.
- Work with a range of data sources, including SQL databases, Excel spreadsheets, and cloud-based data platforms, to transform complex data into meaningful and actionable insights.
- Create custom visuals and integrate Power BI with other Microsoft tools such as Excel, SharePoint, and Teams.
- Use data modeling, data cleansing, and data transformation techniques using Power Query to extract key insights from large datasets.
SQL:
- Write SQL to query a single table
- Write SQL to query multiple tables
- join the different tables.