Pinned Repositories
Capstone-Final-Presentation
Final Presentation for the Capstone Project where I demonstrate all my key findings and what approaches I took to analyze all 3 datasets for Python, Sql and Tableau
Ski-Snow-Resort
A dataset of ~500 ski resorts all around the world, including details on their location, prices, slopes, lifts, and seasons.
Capstone-Python
TMDB Movies
Capstone-SQL
Sakila Movie Rental Database
Capstone-Tableau
Churn Bank Data
Python-ManipulatingDataFrames
Analysis of real-world data involves a huge collection of raw data. Learned the process of reading files to create DataFrames, index DataFrames, and append rows and columns. Also learned to search and replace elements and perform update and delete operations.
Python-Basic-Conditional-Statements
Using conditional statements to implement decision making through programming and automate repetitive tasks using loops in Python.
Descriptive-Analysis-Using-Python
Descriptive analysis is a common form of analysis that companies use to highlight patterns in data. This type of analysis also produces reports and KPIs that enable companies to track performance and monitor trends. Will perform descriptive analysis using measures of central tendency, dispersion, and correlation using the Python coding.
Excel-Correlation-of-Data
analyze data using measures of dispersion and correlation.
Excel-Statistical-Techniques
Techniques to find information from the given data using the measures of central tendency.
marcosx1099's Repositories
marcosx1099/World-Cup
Historical data leading up to the 2022 FIFA World Cup, including all the matches from the previous world cups, all international matches for the qualified countries, and the groups, squads, and matches for the upcoming tournament.
marcosx1099/Ski-Snow-Resort
A dataset of ~500 ski resorts all around the world, including details on their location, prices, slopes, lifts, and seasons.
marcosx1099/marcosx1099
marcosx1099/Capstone-Final-Presentation
Final Presentation for the Capstone Project where I demonstrate all my key findings and what approaches I took to analyze all 3 datasets for Python, Sql and Tableau
marcosx1099/Capstone-SQL
Sakila Movie Rental Database
marcosx1099/Capstone-Tableau
Churn Bank Data
marcosx1099/Capstone-Python
TMDB Movies
marcosx1099/Descriptive-Analysis-Using-Python
Descriptive analysis is a common form of analysis that companies use to highlight patterns in data. This type of analysis also produces reports and KPIs that enable companies to track performance and monitor trends. Will perform descriptive analysis using measures of central tendency, dispersion, and correlation using the Python coding.
marcosx1099/Python-Data-Analysis
Related data exists in multiple source files. Joining/merging data is required after extracting data into DataFrames. It’s important to summarize data to provide better insights about data to stakeholders.I explored the process of illustrating the concept of joining DataFrames, merging and grouping DataFrames,finding and droping duplicate rows.
marcosx1099/Python-ManipulatingDataFrames
Analysis of real-world data involves a huge collection of raw data. Learned the process of reading files to create DataFrames, index DataFrames, and append rows and columns. Also learned to search and replace elements and perform update and delete operations.
marcosx1099/Python-Data-Science-DataFramesUsingSeries
DataFrames help to keep all related variables together. The collection of related data in a DataFrame exists in a row and column format. Each column represents a series object. Learned how to create, index, and manipulate a series of data structures. Learned to create DataFrames using series.
marcosx1099/Python-Data-Science--Numpy-Arrays
Learning the functionality of NumPy Python package. How to create 1D and 2D arrays and perform array indexing. Manipulating data, apply arithmetic operations on arrays, execute matrix operations, and convert CSV file to an array.
marcosx1099/Python-Functions
Develop reusable modules using user-defined functions
marcosx1099/Python-Loops-DataStructures
Using "while" loops in Python to perform operations on data structures such as tuples, sets, and dictionaries.
marcosx1099/Python-Loops
Tasks using for-loops and while-loops in Python. Also used loops to perform operations on list data structures.
marcosx1099/Python-Basic-Conditional-Statements
Using conditional statements to implement decision making through programming and automate repetitive tasks using loops in Python.
marcosx1099/Python-Basics
Explore the Programming constructs like arithmetic, syntax and semantics
marcosx1099/Excel-Correlation-of-Data
analyze data using measures of dispersion and correlation.
marcosx1099/Excel-VisualizationTools
Basic visualization tools to create graphs and charts to visualize the data and generate useful insights.
marcosx1099/Excel-Statistical-Techniques
Techniques to find information from the given data using the measures of central tendency.
marcosx1099/ExcelBasics
Use the basic features of Excel to analyze discrete or structured data and derive useful insights.
marcosx1099/SQL-Joins2
The HR team of New Tech Inc., an IT firm, wants to update its employee database for implementing a hybrid work model (on-site and work from home). help fetch the data to facilitate work from home from time to time.
marcosx1099/SQL-Joins
Sarah, a data analyst with New Tech Inc., has been asked to help the HR department with certain business queries by fetching the required records from the database.
marcosx1099/SQL-QueryData2
IGH Corporation has decided to give a one-time bonus to its employees as per the following details. the HR department wants to analyze their employee data through the upcoming tasks.
marcosx1099/SQL-QueryData
The Sakila database is a sample database provided by MySQL. Help Eric fetch these details by answering the following queries.
marcosx1099/SQL-DataManipulation2
StylexCarz, a car manufacturing company, has decided to manage sales data through the MySQL database. Adriana, a data analyst with the company, has been asked to create a database to capture and manage the sales data of the company. Help Adriana do this by performing the following tasks.
marcosx1099/SQL-DataManipulation
You need to construct a database for TechMac Inc. to store and manage the records of the employees of the three start-ups.
marcosx1099/homework3
Wordle game
marcosx1099/homework1
Homework1