Advanced Excel Skills | Pivot Tables | Advanced Formulas and Functions | Macro | Data Visualization | Data cleaning and preprocessing techniques
SQL skills | ETL | Database querying | Data cleaning
ETL| Data Visualization | Dashboard | Power Query | DAX | Data Cleaning| Data Modeling
Python Libraries: Pandas|SciPy|Seaborn|Matplotlib|NumPy| Data Analysis with Python libraries using Google Colaboratory/Jupyter Notebook for data acquisition, cleaning, exploration, transformation, and visualization
Data Visualization | Dashboard Creation
This Data Analytics job simulation at Forage provides an opportunity to apply my skills in data quality assessment, customer segmentation, data insights and presentations, and analytical dashboard creation.
Read MoreThis Power BI job simulation at Forage provides an opportunity to apply my skills and gain confidence in using Power BI to work on real-world data scenarios and problem-solving tasks.
Read MoreThe objective of this project is to apply the skills learned in Data analytics such as SQL, Excel, Power BI, Python, and Business Metrics for business expansion.
Read MoreThe goal of this project is to strengthen the skills and have more practice in Excel, SQL, and Power BI.
Read MoreThe primary objective of this project is to craft a professional report in Excel and conduct data analysis in SQL, a task that data analysts handle on a daily basis.
Read MoreThe objective of this task is to test the skills and understanding in Microsoft Power BI which covers Data visualization, DAX formulas, and Power Query.
Read MoreThe objective of this task is to further test the skills in Microsoft Power BI which covers Data cleaning and manipulation, Data modeling, Data Visualization, and DAX formulas.
Read MoreThe goal of this project is to apply the valuable techniques and best practices in data preparation with Power Query, data modeling, DAX calculation, and Power BI dashboard creation.
Read MoreThe task is to create a data visualization in Microsoft Power BI for the dataset of Google Play.
Read MoreFor this task, we applied necessary python codes in order to solve a business-related problem.
Read MoreThis task involves calculation of Business Metrics such as Financial Viability, Website Performance, and Customer Satisfaction and dashboard creation using Excel.
Read MoreIt includes series of projects from Alex the Analyst Youtube Channel: SQL, Microsoft Power BI, Tableau, Python, and Microsoft Excel
Read More