Excel data analysis assignment github. You signed in with another tab or window.
Excel data analysis assignment github. These assignments cover various topics and techniques in data analysis, machine learning, statistics, and more. The file is converted when you click 'OK' in the prompt. In this repository are various spreadsheets, where I use Microsoft Excel and many of its functions to solve fictional business problems related to data analysis and visualization. Fleet-Inventory-Data-Analysis-using-Excel This dataset contains a list of Montgomery County Fleet equipment (Department vehicle) inventory and its count. Contribute to keanamaral/KickstarterDataAnalysisExcel development by creating an account on GitHub. ONE: Perform sentimental analysis on the Elon-musk tweets (Exlon-musk. Objective of this assignment is to extract some sections (which are mentioned below) from SEC / EDGAR financial reports and perform text analysis to compute variables those are explained below. It is a key tool in data analysis and visualization. Reload to refresh your session. Power BI: Interactive dashboards and reports created using Power BI to visualize and analyze data. Each project reflects a comprehensive approach to research and execution, addressing unique challenges across various domains. ai. This is an assignment as part of a Data Analysis Bootcamp facilitated by Promise Chinonso and Victor Somadina. Power your data analyst career by learning the core principles of data analysis and gaining hands-on skills practice. - iamAdrianC/Excel_Basics_f The project involves creating an interactive Excel sales dashboard to visualize and analyze sales data. Additionally, it includes solutions for Power BI exercises. This Assignment files contains my work related to following topics : Pivot Tables, Pivot Charts, Slicers, Power Query, Measures, DAX functions, Data Importing, Creation of mash-up between data from text-files and SQL database. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as: This repository is dedicated to various assignments designed to enhance your Excel skills. mysql data-science statistics sql sql-server analytics analysis Learn Python . I downloaded the Global Superstore Orders 2016. Part 2 In this final assigment, I will be following the scenario of a recently hired Junior Data Analyst in a local government office, who has been tasked with sorting and analyzing fleet inventory data This repository contains a Power BI assignment focused on data analysis and visualization. You signed in with another tab or window. Objective The objective of this assignment is to extract textual data articles from the given URL and perform text analysis to compute variables that are explained below. . This GitHub project analyzes Airbnb data for Portland, focusing on rental patterns, income, and permit statuses. Consumer complaint analysis is critical for understanding consumers' expectations in order to give better products and services. The data is in comma-separated value (CSV) format and the data also needs cleaning up before I can start to run any kind of analysis on it. value_ifthegivencriteria_true = give the input to execute if the value is true. By using PivotTables and charts, you can dynamically filter and display key metrics such as total sales, profit, and sales by category. The dataset includes columns such as: Employee ID: A unique identifier for each employee. Association Rules; Basic stats - 1; Basic stats - 2; Basics of python; Clustering; Decision Tree; EDA1 (Exploratory Data Analysis) EDA2 The following files are work done from Excel Basics for Data Analysis by IBM courtesy of Coursera. Bureau of Labor Statistics). pdf This repository showcases my capstone projects, featuring four distinct initiatives that demonstrate my analytical and problem-solving skills. This information must be matched to the system data that has been downloaded into Excel (SYS DATA sheet) and a report produced that will be uploaded to the school system. The data worked on is an imaginary data set on Sales for an organization. Each folder focuses on a different data science or machine learning technique, providing practical implementations and analyses. main Find all EXCELR Data Science Assignment Here. The data worked on is an imaginary set of Medical Data for 200,000 people. You signed out in another tab or window. Each assignment focuses on differ II have autonomously completed data analyst assignments involving Excel, SQL, Power BI, and Tableau, honing my skills through rigorous self-practice and continual refinement. My proactive approach ensures proficiency in data analysis and visualization, fostering informed decision-making and delivering actionable insights. For each of the articles, given in the input. In this project, I cleaned and transformed Car Sales raw data, analyzed it, applied pivot tables, and created dashboard visualizations with Microsoft Power BI. In this exciting first week, we delved into the art of text manipulation using a variety of powerful Excel functions. The primary objectives of the analysis were to understand customer behavior, call center performance, call center efficiency. This repository contains assignments completed as part of the Data Analyst course at ExcelR. Data Transformation: Using Tableau You signed in with another tab or window. Here's a glimpse of what we covered: In Week 3, we unlocked the Plan and track work Code Review Gain the job-ready skills for an entry-level data analyst role through this eight-course Professional Certificate from IBM and position yourself competitively in the thriving job market for data analysts, which will see a 20% growth until 2028 (U. Column widths: Sort out the widths of all columns so that the data is clearly visible in all cells. The dataset provided is a sample, representing a comprehensive range of employee information across several key metrics. logical_test= give the criteria which you would like to act. Uncover how these factors impact user experience and the future of AI in Excel. Go to the Upload sheet (this is where all calculations are to be done). Each assignment covers different aspects of Excel, including data manipulation, formulas, functions, data analysis, visualization, and automation with VBA and macros. Feel free to explore the projects and assignments showcased here. Contribute to minmmwin/Excel-Basics-for-Data-Analysis development by creating an account on GitHub. Use formulas and functions to perform calculations on data. Create charts and tables that effectively summarize raw data. Vrinda Store Data Analysis using Excel. Contribute to MoinDalvs/Excelr_Data_Science_Assignments development by creating an account on GitHub. Analyze data and present the results in a user-friendly way. About. There are totally two parts in this project: Part-1 is cleaning the data and Part-2 Analysing the data. This repository contains a Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. Excel Sales Data Analysis. Empty rows: Use the Filter Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. com Data analysis using excel. Microsoft Excel is a spreadsheet software utilized by many across the globe. The project includes interactive dashboards and reports designed to uncover insights from complex datasets. Assignment related to Excel, Power Bi, Tableau, My SQL - Amita-Patel/Data-Analysis-Assignment Udemy Course Data Analysis Explore the world of online learning with the Udemy Course Data Analysis project. Introduction. Customer complaints, on the other hand, discuss business improvement suggestions and assist to strengthen customer relationships. The data has 51290 rows, and 24 columns. You switched accounts on another tab or window. Excelr-Data-Analytics-Excel Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. Mar 11, 2023 · More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects. The demographics of the people in the data set are males and females The following files are work done from Excel Basics for Data Analysis by IBM courtesy of Coursera. The health industry in India has rapidly become one of the most important sectors in the By analyzing this dataset, we aim to gain a deeper understanding of passenger demographics, travel patterns, and factors influencing survival outcomes. Contribute to MoinDalvs/ExcelR_Data_Analyst_Python_Assignment development by creating an account on GitHub. Tableau 5. The assignments span various key areas and tools essential for data analysis, including: Excel Assignments: Exercises and projects demonstrating data manipulation, analysis, and visualization using Microsoft Excel. Data Source Link to SEC / EDGAR financial reports are given in excel spreadsheet “cik_list. This analysis will enable us to tailor our marketing strategies, enhance customer experience - Uccodes/TITANIC-DATA-ANALYSIS-WITH-EXCEL Quizzes & Assignment Solutions for Data Visualization with Tableau Specialization on Coursera. This repository contains my assignments done for EDX course Microsoft: DAT206x Analyzing and Visualizing Data with Excel. Data Extraction Input. Whether you're a student looking for reference materials or an Excel and Power BI enthusiast seeking insights, you'll find valuable resources here. Peer-Graded Assignment Final Assignment – Part 1. Key tasks include data cleaning, pivot table analysis, and answering business questions like average stay duration and rental costs. my repository contains my own solution for the major excel assignment aims to assess proficiency in excel and covers topics such as data analysis, formula usage, and visulization. Hello! I'm NIdhi, a student of Anudip Foundation, passionate about becoming a Data Analyst. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the Go to Data Tab--> Get Data--> Launch Power Query Editor--> New Source--> File--> Excel Workbook Inner Join tables X2, and C1 on Customer Pincode Column save the merge as "Delivery Intermediate" We get a table with Zone as per X for each Customer Pincode You signed in with another tab or window. 3 billion potential beneficiaries. data-science assignments excelr excelr-assignments excelr-assignments-github This project focuses on visualizing employee records data using Microsoft Excel. I plan to expand this Explore the capabilities and challenges of ChatGPT-4 in Excel management: from executing simple tasks and data analysis to facing limitations in complex functions and direct software interaction. I have completed Data Analyst assignments in Data Analyst Course during my journey in ExcelR. commands in excel. Resources The following files are work done from Excel Basics for Data Analysis by IBM courtesy of Coursera. Jul 19, 2024 · Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. Mar 10, 2021 · The objective of the project was to create innovative and interactive Tableau dashboards that focus on potential commodities, countries, year, trade amount and quantity. xlsx onto my desktop. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as: Basic of excel; Lookup & functions; Conditional formating; Data validation; Sorting and filtering; Data analysis using toolpak Analyze Kickstarter crowd funding data in excel. For technical problems with the Coursera platform, visit the Learner Help Center. S. This is a practice project which I did to polish up my Excel skills. Assignments_data analysis using excel power query. Contribute to ABD07xx/Excel-Basics-for-Data-Analysis-by-IBM development by creating an account on GitHub. Link to SEC / EDGAR financial reports are given in excel spreadsheet “cik_list. xlsx”. xlsx For each of the articles, given in the input. Tasks For Task 1. This repository contains a comprehensive Tableau assignment that demonstrates data analysis and visualization skills. The Indian health system is one of the largest in the world, with the number of people it concerns: nearly 1. You can see all the files are Available in this Repositories. ai is a GitHub repository that contains assignments from the Full Stack Data Analytics course offered by iNeuron. - Leodelson/Car-Sales-Analysis- You signed in with another tab or window. GitHub Gist: instantly share code, notes, and snippets. Leveraging Python and data visualization techniques, this project provides a comprehensive overview of Udemy's course o About. Power BI: Interactive dashboards, data modeling, and visualizations. Data-Analysis-Cohort-3-Excel-Assignments_Week-2 Excel Medical Data Analysis. Each assignment focuses on different aspects of data analysis, including data cleaning, data visualization, and statistical analysis. xlsx file, extract the article text and save the extracted article in a text file with URL_ID Objective Objective of this assignment is to extract textual data from SEC / EDGAR financial reports and perform text analysis to compute variables those are explained below. This analysis includes sales in USD ($), sales by region, and sales by method, providing insights into financial performance and distribution strategies. Topics Covered Advanced Formulas and Functions Assignment related to Excel, Power Bi, Tableau, My SQL - Amita-Patel/Data-Analysis-Assignment Contribute to minmmwin/Excel-Basics-for-Data-Analysis development by creating an account on GitHub. In this repository, you'll find a collection of assignments completed as part of my journey in becoming a proficient data scientist. MySQL 3. Empty rows: Use the Filter Find all ExcelR Data Analyst Assignment Solution Here 1. - iamAdrianC/Excel_Basics_f Jul 19, 2024 · Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. I'm excited to showcase my learning, growth, and progress towards becoming a Data Analyst. The project showcases the use of Power BI to extract insights from datasets, create interactive dashboards, and present data-driven recommendations. The objective of this assignment is to extract textual data articles from the given URL and perform text analysis to compute variables that are explained below. Raw. - niti2212/excel_nidhi-anudip This file contains advanced excel formulas and functions like Vlookup with match function, index and match function, offset & counta, logical operators, max if function, formula formatting, text functions, Date and time functions, data cleaning, etc. Course 1: Introduction to Data Analytics Course 2: Excel for Data Analysis Exploratory Data Analysis (EDA) was conducted on the Call Centre Dataset using Microsoft Excel to uncover meaningful insights and patterns within the data. Automate choices and data lookups using functions. Resources This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. Contribute to shubhji15/data_analysis_tasks development by creating an account on GitHub. Resources In this comprehensive Excel Mastery course offered by ExcelR, I gained a deep understanding of advanced Excel functionalities and data analysis techniques. csv) TWO: Extract reviews of any product from ecommerce website like amazon Feb 8, 2022 · python data-science sql presentation spreadsheet pandas data-visualization dashboards data-analysis ibm data-manipulation jupyter-notebooks data-analyst capstone-project microsoft-excel cognos-analytics ibmcognos ibm-data-analyst-professional About. which I have worked on to take my excel skills at the high level. This is All Data Science Assignments Files. Power your data This project involves manipulating data in Microsoft Excel, focusing on data cleaning and preparation tasks for a dataset with the following columns: ID, First Name, Last Name, Job Title, Email, Date of Birth, Gender, Street, City, State or Province, Postal Code, and Country. - iamAdrianC/Excel_Basics_for_Data_Analysis This repository contains assignments completed during my Data Science course with ExcelR. The assignments cover the following tools and topics: MS Excel: Data analysis, visualization, pivot tables, and advanced functions. Topics Covered: Data Import: Connecting to various data sources and importing data into Tableau. ExcelR Data Science/Assignments/KNN_glass. For Text Mining assignment. ipynb. Full Stack Data Analytics iNeuron. Excelr-Data-Analytics-Excel 🙇This GitHub repository hosts my internship assignment projects, tasks, and reports, showcasing my skills and contributions during the internship period. Data-Analysis-using-MS-Excel This project work for in depth Data Analysis of a US Super Store Sales Data and helps for drawing meaningful insights which can help the Management Team for taking crucial decisions in order to expand there buisness and make an impactable market presence around the globe. You’ll work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Cognos Analytics, gaining practical experience with data manipulation and applying analytical techniques. List of Following Files of all Data Science Assignments Topices:- Within this project I was provided crowdfunding data and analyzed it through several metrics. Advanced Excel 2. See full list on hackernoon. Good luck as you get started, and I hope you enjoy the course! - cmaroblesg/Excel_Basics_for_Data_Analysis This repository contains assignments and projects completed as part of the Data Science course from ExcelR. This repository contains solutions to the Excel assignments offered by ExcelR Institution. Included are two final assignment files that are unedited and edited. Text Mining. This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Python 4. - ayesdeeef/Microsoft-Excel---Data-Analysis-with-Excel-Pivot-Tables Save the CSV file as an XLSX file: Click the 'Edit Workbook' button in the ToolTip to save the file as an XLSX file. xlsx file, extract the article text and save the Microsoft Excel has a long and proud history of bringing data analysis and processing to the masses with its intuitive interface and powerful functionality. excel-dashboard You signed in with another tab or window. The project uses R and Excel, with findings stored in GitHub for collaboration. Full You signed in with another tab or window. However, it has important limitations that are only becoming more apparent in our current age of Big Data and that can only be surpassed by up-skilling to a more programming oriented context. This repository contains an Excel assignment that demonstrates proficiency in using various Excel functions and formulas. - iamAdrianC/Excel_Basics_f Jun 13, 2024 · To master advanced Excel functionalities for data analysis, enabling participants to efficiently handle complex data tasks, perform in-depth analysis, and visualize data effectively. The assignments cover various data science concepts, tools, and techniques, including Python, machine learning, statistical analysis, and data visualization Save the CSV file as an XLSX file: Click the 'Edit Workbook' button in the ToolTip to save the file as an XLSX file. The repository provides a range of assignments that cover a diverse set of topics related to data analytics such as data processing, data visualization, and data analysis. Power BI - shanuhalli/Data-Analyst-Assignment Homework assignments for the Udemy course on Pivot Tables in Microsoft Excel by Chris, the Founder of Maven Analytics. Contents File: Day wise Tableau Assignments Description: This file contains a collection of Tableau projects organized by day, representing different assignments and tasks focused on learning and applying Tableau. Happy exploring! Health insurance in India is a growing segment of India's economy. Here's a glimpse of what we covered: This week, we delved into the fascinating world of numbers and dates in Excel. The primary objective of this assignment is to showcase the ability to apply advanced Excel functions . Resources Explore the 'Adidas Sales Analysis Dashboard' project, which offers an in-depth analysis of Adidas's sales performance. These metrics included: Using conditional formatting to fill each cell in the outcome column with a different color, depending on whether the associated campaign was successful, failed, canceled, or is currently live Be comfortable navigating the Excel user interface, entering, manipulating and formatting data. The following files are work done from Excel Basics for Data Analysis by IBM courtesy of Coursera. I was required to; Welcome to the Data Analyst Assignments repository! This repository contains a series of assignments designed to help data analysts practice and hone their skills. Dive into the depths of Udemy's vast collection of courses to uncover insights about course prices, popularity, and more. These assignments are completed entirely by myself without the assistance of others and without looking at any solutions available online. The assignment includes a dataset with multiple sheets that require analysis and manipulation. Each assignment focuses on different aspects of data science, ranging from basic statistics to advanced machine learning techniques. Peer_Graded_Assignment. ExcelR-Data-Science-Assignments/ ├── PCA & Clustering Analysis If you have questions about course content, please post them in the forums to get help from others in the course community. The curriculum covered a range of essential topics, including: Contribute to minmmwin/Excel-Basics-for-Data-Analysis development by creating an account on GitHub. Here, I share my Excel projects, worksheets, and data analysis assignments from my journey at Anudip. Syntax of this function- IF (logical_test, value_ifthegivencriteria_true, value_ifthegivencriteria_false) This is an excellent function in the excel. This folder contains all the assignments given during the training. This repository contains all the resources and solution to quizzes given and asked in IBM Data Analyst Professional Certification.