DAY 19/60 LEARNING DATA ANALYSIS & LANDING A JOB. Concluded Excel phase with this project, walked through the entire analytical process which included, Data cleaning, visualization using pivot tables, charts, dashboard and analyzes. #publiclearning.#60daysoflearningdataanalysis

DAY 16/60 OF LEARNING DATA ANALYSIS & LANDING A JOB. EXCEL PHASE.CHARTS IN EXCEL- helps in data visualization making it easier to analyze and understand, Charts can be tailored to suit specific needs, such as adding titles, labels etc. #Dataanalysis #60daysoflearningdataanalysis

DAY 17/60 LEARNING DATA ANALYSIS & LANDING A JOB. EXCEL PHASE.DATA CLEANING- involves identifying & correcting errors, inconsistencies, & inaccuracies in data by Removing duplicates,Text-to-Columns, Trimming whitespace, Formatting etc .#Excel .#60daysoflearningdataanalysis

DAY 18/60 LEARNING DATA ANALYSIS AND LANDING A JOB. EXCEL PHASE .DATA VISUALIZATION - It helps to communicate insights, identify patterns and trends in data. some popular visualization tools in Excel are Column charts, Line charts, Pie chart etc. #60daysoflearningdataanalysis

DAY 15/60 OF LEARNING DATA ANALYSIS AND LANDING A JOB. EXCEL PHASE.CONDITIONAL FORMATTING- allows the highlighting of cells based on specific conditions/criteria. It helps to make data more readable & understandable by applying different formats. #60daysoflearningdataanalysis

DAY 14/60 OF LEARNING DATA ANALYSIS AND LANDING A JOB. EXCEL PHASE.PIVOT TABLE- is an interactive table that allows you to rotate, summarize, analyze and visualize large datasets. #Dataanalysis #Excel #learninpublic #60daysoflearningdataanalysis

DAY 21/60 LEARNING DATA ANALYSIS AND LANDING A JOB. SQL PHASE.SELECT - this statement retrieves data from a database:. SYNTAX .SELECT column1, column2, (Specify columns to retrieve ).FROM tablename (Specify the table to retrieve from). #Dataanalysis #60daysoflearningdataanalysis

DAY 22/60 LEARNING DATA ANALYSIS AND LANDING A JOB. SQL PHASE.WHERE - this clause helps to narrow down your results to specific data that meets your conditions. SYNTAX .SELECT column1, column2, . FROM tablename.WHERE condition;. #DataAnalysis #SQL.#60daysoflearningdataanalysis

DAY 12/60 OF LEARNING DATA ANALYSIS AND LANDING A JOB. VLOOKUP - this function looks up a value in a table and returns a corresponding value from another column. VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). #Dataanalysis #Excel #60daysoflearningdataanalysis

DAY 9/60 OF LEARNING DATA ANALYSIS AND LANDING A JOB. EXCEL PHASE!!.SUMIFS function- this function is used to sum cells that meet multiple criteria. breakdown; .Syntax =SUMIFS(sum_range, range1, criteria1).#Dataanalysis #Excel #learninpublic #60daysoflearningdataanalysis

DAY 20/60 LEARNING DATA ANALYSIS & LANDING A JOB. SQL PHASE.I started with SQL basics, covering relational and non-relational databases, installed MySQL and setup MySQL Workbench, as my practice environment, and explored its interface. #Dataanalysis.#60daysoflearningdataanalysis

DAY 25/60 LEARNING DATA ANALYSIS & LANDING A JOB. SQL PHASE.ORDER BY - this clause sorts query results in ascending or descending order. SYNTAX.SELECT column1, column2, . FROM tablename.ORDER BY column_name ASC/DESC;. #DataAnalysis #SQl #60daysoflearningdataanalysis

DAY 11/60 OF LEARNING DATA ANALYSIS AND LANDING A JOB. EXCEL PHASE.OR Function- a logical function that returns TRUE if at least one condition is met, FALSE otherwise. OR Function + other functions- IF, SUMIFS, & COUNTIFS, creates powerful formulas. #60daysoflearningdataanalysis.