Certifications in Data Analysis, Advanced SQL, Intro to Dashboards

Data Analysis & Hypothesis Testing

• Mastered fundamental statistics and data analytics concepts

• Applied measures of central tendency and variability to summarize datasets

• Understood and utilized discrete and continuous probability

• Interpreted and analyzed probability and frequency distributions

• Conducted simple and multiple linear regression for predictive modeling

• Performed logistic regression for binary outcome analysis

• Practiced hypothesis testing to make data-driven decisions

• Gained experience with related statistical concepts for real-world data scenarios

Advanced SQL

• Completed 160 mini-projects covering a wide range of advanced SQL topics

• Proficient in writing and applying conditional expressions for data filtering and logic control

• Skilled in performing text and string operations for manipulating and analyzing textual data

• Experienced in working with sets, relations, and bags to manage complex data structures

• Capable of writing subqueries for layered data retrieval and nested logic

• Advanced knowledge of SQL joins, including inner, outer, and complex multi-table joins

• Able to define and use custom SQL functions to streamline queries and reuse logic efficiently

Introduction To Dashboards

• Proficient in designing and constructing both static and dynamic dashboards using spreadsheets

• Skilled in profiling and preparing data for dashboard presentation

• Experienced in selecting and creating clear charts and tables to communicate data insights effectively

• Able to implement advanced spreadsheet functions to support dashboard interactivity and automation

• Knowledgeable in applying data validation techniques to ensure data integrity

• Proficient in using conditional formatting to highlight key metrics and trends in dashboard views

• Capable of building dashboards tailored for multiple business or analysis purposes