Hi👋
Ayush Raj
I am a versatile web developer and data analyst, delivering intuitive user experiences and valuable data insights. With expertise in HTML, CSS, JavaScript, SQL, Python, and data visualization. Let's collaborate and bring your vision to life through the synergy of web development and data analysis
About Me
Who Am I ?
As a 7th-semester BTech student specializing in Data Science, I am passionate about data analytics and continuously expanding my skills in web development. Proficient in Excel, Tableau, Power BI, Python, SQL, and R, I leverage these tools to derive valuable insights from data. Additionally, I have a solid foundation in HTML, CSS, and JavaScript for web development. With a drive for learning and a focus on delivering impactful solutions, I am eager to contribute to data-driven projects and explore the intersection of data science and web development.
With a drive for learning I have gained valuable internship experience in Yoshop, where I learned Power BI for data visualization. Currently interning at Celebal, I am sharpening my SQL skills for data manipulation and extraction. I am eager to contribute to data-Analyst projects and explore the intersection of data Analyst and web development.
My Education
B.Tech
Lovely Professional University
6.72 CGPA |2020-2024
My Certificates
Visualization with PowerBI
Issued by Coursera
Experience
Partime Tutor
Partime Tutor at Filo
As a tutor at Filo for 1.5 years, I gained extensive experience in providing educational support to students. Throughout my tenure, I successfully conducted over 500 start sessions, demonstrating my proficiency in helping students begin their learning journeys. Additionally, I earned three certifications, showcasing my expertise and dedication in delivering high-quality tutoring services. I take pride in my role as a tutor and strive to create a positive and impactful learning environment for my students.
Analysis with PowerBI
Get pratical Experience working with Powerbi
During my two-month internship at Yoshop, I had the opportunity to gain practical experience working with Power BI. Power BI is a powerful business intelligence tool that enables data visualization and analysis. Throughout my internship, I immersed myself in various projects where I utilized Power BI to extract insights from data, create interactive reports and dashboards, and present information in a visually appealing manner. This experience allowed me to develop a strong understanding of Power BI's capabilities and enhanced my skills in data analysis and visualization. The internship at Yoshop provided me with valuable hands-on experience and deepened my knowledge in working with Power BI.
Summer Internship in Sql
Getting Practical experience in Sql
During my summer internship at Celebal, which commenced on June 20th 2023, I am focusing on gaining valuable experience in SQL. SQL, or Structured Query Language, is a fundamental language used for managing and manipulating relational databases. Throughout this two-month internship, I will have the opportunity to work hands-on with SQL, honing my skills in querying databases, retrieving data, and performing various data operations. This internship provides a valuable opportunity to gain practical knowledge and enhance my technical abilities in the field of data management and analysis.
My Skills
My Projects
Road Accident Analaysis
Road Accident Analaysis Dashboard
I conducted a road accident analysis using data from Kaggle and developed a Tableau dashboard with key performance indicators (KPIs). The KPIs include the total number of accidents, fatal cases, and serious casualties. These metrics provide a concise overview of the road accident landscape. The total accident count gives an understanding of the overall occurrence, while the number of fatal cases highlights the gravity of accidents resulting in loss of life. The count of serious casualties sheds light on accidents causing severe injuries. This dashboard enables stakeholders to gain insights into the prevalence, severity, and urgency of road safety measures
Customer Analysis PowerBI
Codebasic Challeange PowerBi Dashboard
For the codebasic resume challenge, I created a comprehensive Power BI dashboard focused on customer analysis and product analysis. The dashboard provides insights into customer behavior, preferences, and purchasing patterns. By analyzing customer data, such as demographics, purchasing history, and engagement metrics, it helps identify key customer segments and their specific needs. The product analysis component enables a deep dive into product performance, sales trends, and profitability. The interactive reports offer valuable insights for strategic decision-making, marketing campaigns, and optimizing product offerings. This Power BI dashboard combines customer and product analysis to provide actionable insights
Answering Question Using Sql Queries
Answering Question Using Sql Queries for Codebasic Challeange
In the codebasic challenge, I successfully answered the questions using SQL queries, employing various advanced techniques such as window functions. These powerful functions allowed me to perform calculations and analysis across rows and groups of data. By utilizing window functions, I was able to efficiently handle tasks such as ranking, aggregations, and data partitioning. These advanced SQL techniques helped me extract meaningful insights from the dataset, providing valuable information and facilitating informed decision-making. Through my utilization of window functions and other SQL features, I effectively tackled the challenge, showcasing my proficiency in SQL and analytical capabilities
Web Scraping Project
web_scrapping
In this project, the aim was to extract links related to YouTube from the Openin app website. The project involved a number of steps, including sending HTTP requests to the website, parsing the HTML content, and filtering the relevant links. To start, the requests library was used to send HTTP requests to the Openin app website. The HTTP response was then retrieved and the HTML content was extracted. Once the HTML content was obtained, it was parsed using the beautifulsoup4 library. This involved identifying the relevant HTML tags and attributes to extract the desired data. Once the relevant Tag objects were identified, the next step was to filter out the links that were not related to YouTube. This involved using the re library to search for links that contained the YouTube domain name. The re library provides a number of powerful tools for working with regular expressions. Regular expressions are a way of specifying patterns that can be used to match strings of text.
Code Basic Challenge
Codebasic Challenge 5
Telangana is one of India’s leading states and has published its tourism data under its open data policy.As a data analyst my task is to analyze the given visitor data for 2016-2019 and answering the research question provided and provide data imformtion recommendations to the telangana government which can be used to increase their revenue by improving administrative operation
Responsive Website Built with Bootstrap
Responsive Website Built with Bootstrap
I have created a responsive website using Bootstrap, incorporating various essential components. The navigation bar ensures easy browsing and seamless navigation throughout the site. Buttons are strategically placed to encourage user interaction and enable intuitive actions. Images are utilized to enhance visual appeal and effectively communicate information. Forms facilitate data collection and user input. The range component enables users to select values within a specific range, enhancing interactivity. The accordion component organizes content in collapsible sections, providing a neat and user-friendly layout. This Bootstrap-based website offers a visually appealing and mobile-friendly experience, catering to a wide range of devices and delivering an intuitive and engaging user interface.
My portfolio
Responsive Website Built with Bootstrap
I have developed my portfolio website using HTML, CSS, and JavaScript, showcasing my skills, projects, and achievements. The website features a visually appealing and user-friendly design, allowing visitors to easily navigate through different sections. It highlights my expertise in web development and design, while providing a comprehensive overview of my professional background and accomplishments. Through interactive elements and engaging content, the website effectively presents my portfolio, demonstrating my capabilities and creating a positive impression on potential clients or employers. With a focus on responsiveness and aesthetics, my portfolio website serves as a digital representation of my skills and serves as a valuable tool for showcasing my work.
,Contact me
Get in Touch
If you want, you can contact me, and I will get back to you as soon as I can. Please fill out the form to send me a message. Also, you can connect with me on LinkedIn, WhatsApp, and email, as mentioned below.
Message me
