#60daysoflearningdataanalysis search results

DAY 60/60 LEARNING DATA ANALYSIS & LANDING A JOB. I committed myself to a 60 days data analysis learning challenge, and today I’m proud to say I made it to the finish line 🎉 I appreciate everyone who went on this journey with me, thank you 🎉❤️ #60daysoflearningdataanalysis

DAY 57/60 LEARNING DATA ANALYSIS & LANDING A JOB. POWER BI PHASE POWER QUERY EDITOR- this tool is used to import, clean, and transform your dataset before it is loaded into the report view. #powerbi #60daysoflearningdataanalysis

DAY 55/60 LEARNING DATA ANALYSIS & LANDING A JOB. POWER BI PHASE Started out this phase by Exploring the Power BI interface and learnt how to import Excel data for Creating and managing relationships. #powerbi #60daysoflearningdataanalysis

DAY 54/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA VISUALIZATION IN PYTHON- is the using of Python libraries like Matplotlib, seaborn, plotly etc,to create charts, plots or graphs for better understanding of the Dataset. #python #60daysoflearningdataanalysis

DAY 53/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE AGGREGATION WITH PANDAS- generally refers to combining or summarizing data to get useful insights often by grouping values and applying functions like sum(), mean() etc. #python #60daysoflearningdataanalysis

DAY 52/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA CLEANING IN PANDAS- is the process of preparing raw data for analysis by detecting and correcting (or removing) errors, inconsistencies, and missing values. #python #60daysoflearningdataanalysis

DAY 49/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE MODULES- are files that contain Python code (functions, variables, classes, etc) reusable in other programs. They help organize code into smaller, manageable pieces #python #60daysoflearningdataanalysis

DAY 47/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE LOOPS- are used to execute a block of code repeatedly until a condition is met or a sequence is fully iterated. Eg FOR and WHILE Loops. #python #60daysoflearningdataanalysis

DAY 45/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE LIST- is an ordered, mutable (changeable) collection of items. Lists can contain elements of any data type, including numbers, strings, and even other lists. #python #60daysoflearningdataanalysis

DAY 44/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE CONDITIONAL STATEMENT- allow you to control the flow of Python program by executing code only when certain conditions are met, eg IF STATEMENT, ELIF STATEMENT, ELSE STATEMENT. #python #60daysoflearningdataanalysis

DAY 43/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA TYPE- are classifications that tell the interpreter what kind of value a variable holds, Data types can be checked using; SYNTAX Type() #python #60daysoflearningdataanalysis

DAY 42/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE VARIABLES- is a defined name that reference an object, variables are used to store data to be used or manipulated. variables are created by assigning it a value using the = sign. #60daysoflearningdataanalysis

DAY 41/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE Kicked off my Python journey by setting up Jupyter Notebook, explored the interface, basic navigations, and wrote my first line of code. Ready to dive deeper!! #60daysoflearningdataanalysis

DAY 40/60 LEARNING DATA ANALYSIS & LANDING A JOB Concluded my SQL phase with an Exploratory Data Analysis Project which involved using SQL queries to investigate, summarize, and understand the structure, quality, and patterns within a dataset. #SQL #60daysoflearningdataanalysis

DAY 35/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE STRING FUNCTION- this functions are used to manipulate, process, or extract information from string/text data in a database. Examples are LENGTH, CONCAT, SUBSTRING, TRIM, LOWER, UPPER etc. #SQL #60daysoflearningdataanalysis

DAY 31/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE MULTIPLE JOIN- this is using two or more JOINs in a single SQL query To combine data from three or more tables based on related columns. #Dataanalysis #SQl #60daysoflearningdataanalysis

DAY 29/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE OUTER JOIN LEFT OUTER JOIN- returns all rows from the left table, & the matching rows from the RIGHT table, If there’s no match, NULLs are returned, and vice versa for the RIGHT OUTER JOIN #SQl #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 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 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 54/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA VISUALIZATION IN PYTHON- is the using of Python libraries like Matplotlib, seaborn, plotly etc,to create charts, plots or graphs for better understanding of the Dataset. #python #60daysoflearningdataanalysis

DAY 49/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE MODULES- are files that contain Python code (functions, variables, classes, etc) reusable in other programs. They help organize code into smaller, manageable pieces #python #60daysoflearningdataanalysis

DAY 45/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE LIST- is an ordered, mutable (changeable) collection of items. Lists can contain elements of any data type, including numbers, strings, and even other lists. #python #60daysoflearningdataanalysis

DAY 53/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE AGGREGATION WITH PANDAS- generally refers to combining or summarizing data to get useful insights often by grouping values and applying functions like sum(), mean() etc. #python #60daysoflearningdataanalysis

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 47/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE LOOPS- are used to execute a block of code repeatedly until a condition is met or a sequence is fully iterated. Eg FOR and WHILE Loops. #python #60daysoflearningdataanalysis

DAY 57/60 LEARNING DATA ANALYSIS & LANDING A JOB. POWER BI PHASE POWER QUERY EDITOR- this tool is used to import, clean, and transform your dataset before it is loaded into the report view. #powerbi #60daysoflearningdataanalysis

DAY 43/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA TYPE- are classifications that tell the interpreter what kind of value a variable holds, Data types can be checked using; SYNTAX Type() #python #60daysoflearningdataanalysis

DAY 40/60 LEARNING DATA ANALYSIS & LANDING A JOB Concluded my SQL phase with an Exploratory Data Analysis Project which involved using SQL queries to investigate, summarize, and understand the structure, quality, and patterns within a dataset. #SQL #60daysoflearningdataanalysis

DAY 35/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE STRING FUNCTION- this functions are used to manipulate, process, or extract information from string/text data in a database. Examples are LENGTH, CONCAT, SUBSTRING, TRIM, LOWER, UPPER etc. #SQL #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 29/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE OUTER JOIN LEFT OUTER JOIN- returns all rows from the left table, & the matching rows from the RIGHT table, If there’s no match, NULLs are returned, and vice versa for the RIGHT OUTER JOIN #SQl #60daysoflearningdataanalysis

DAY 41/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE Kicked off my Python journey by setting up Jupyter Notebook, explored the interface, basic navigations, and wrote my first line of code. Ready to dive deeper!! #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 52/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE DATA CLEANING IN PANDAS- is the process of preparing raw data for analysis by detecting and correcting (or removing) errors, inconsistencies, and missing values. #python #60daysoflearningdataanalysis

DAY 44/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE CONDITIONAL STATEMENT- allow you to control the flow of Python program by executing code only when certain conditions are met, eg IF STATEMENT, ELIF STATEMENT, ELSE STATEMENT. #python #60daysoflearningdataanalysis

DAY 31/60 LEARNING DATA ANALYSIS & A JOB. SQL PHASE MULTIPLE JOIN- this is using two or more JOINs in a single SQL query To combine data from three or more tables based on related columns. #Dataanalysis #SQl #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 42/60 LEARNING DATA ANALYSIS & LANDING A JOB. PYTHON PHASE VARIABLES- is a defined name that reference an object, variables are used to store data to be used or manipulated. variables are created by assigning it a value using the = sign. #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