DATA ANALYST

ABOUT ME

Experienced leader with 10+ years, boosting revenue by 20% and improving operational efficiency by 15%. Transitioning to data analysis, driven by passion, leverage data for informed decisions and contributing quantifiable value.

Projects

IBM Capstone Project

1. Collecting Data Using APIs and Collecting Data Using Web Scraping
2. Data Wrangling
3. Exploratory Data Analysis
4. Data Visualization
5. Dashboards
6. Findings Presentation

Key Terms: Exploring Data, Duplicates, Missing Values, Normalizing data, distribution, outliers, Correlation, Python Libraries

Analyzing Wildfire Activities in Australia (Data Visualization with Python)

• Part 1 Analyzing Wildfire Activities in Australia
• Part 2 Creating Dashboards

Key Terms: Matplotlib, Seaborn, Folium, Plotly, Dash

House Sales in King County, USA (Data Analysis with Python)

Data Analytics for House Pricing Data Set

Key Terms: Understanding the data, Python Packages for Data Science, Pandas, NumPy, SciPy, Matplotlib, Seaborn, Scikit-learn, Statsmodels, Binning, Exploratory Data Analysis, Descriptive Statistics, Chi-Square, Model Development, Pipelines

Analysis of Real World datasets for the city of Chicago (Databases and SQL For Data Science with Python)

Practice Querying Real World Datasets

Key Terms: SQL, DDL, DML, TRUNCATE, SQL Scripts, String, BD-API, SQL Magic, Tables, Columns, Stored Procedure, ACID Transactions, Rolling Back, Join operations

Analyzing Stock Performance and Building Dashboards (Python Project for Data Science)

1. Web Scraping
2. Project Overview
3. Extracting Stock Data Using Python
4. Reading: yfinance Library

Key Terms: Python, Web Scraping, HTML scrapping, BeautifulSoup, IBM Cognos, IBM Waston, Jupyter Notebook, Pandas

Financial Analyst (New York Jobs CEO COUNCIL, JOB sim on theforage.com)

1. Extract information from BigTechCompany's Financial reports using MS Excel
2. Developed a MS PowerPoint presentation of the analysis.
3. Developed a presentation outline that concisely expresses my opinions and analysis.
4. Recorded a video of the presentation

Key Terms: Financial statements, Revenue, Operating income (EBITDA), Net income, Free cash flow, EBITDA margin, Leverage ratios

Corporate Analyst Development Program (JP MORGAN CHASE & CO, JOB sim on theforage.com)

1. Data Analysis and Visualization in Excel: Sorted Data, Filtered Data, Vlookup Function, Created Charts
2. Data Visualization Dashboard (Tableau)
3. Process Mapping and Improvement
4. Storytelling with MS PowerPoint
5. Video Presentation

Key terms: Borrowers, loan-to-value ratios, minority homeowners, annual income, appraised home value

Data Analytics and Visualization (Accenture JOB sim on theforage.com)

1. Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture.
2. Cleaned, modeled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions.
3. Prepared a PowerPoint deck and video presentation script to communicate key insights for the client and internal stakeholders.

Key Terms: SQL, CSV, MS Excel, PowerQuery, Communication, Data Analysis, Data Modeling, Data understanding, Data Visualization, Presentations, Project Planning, Public Speaking, Storytelling, Strategy, Teamwork

Contact:

Email: mazouali2016@gmail.com
Telegram: @kmazou