About
As a recent graduate , I am excited to begin my career as a data analyst. I am eager to apply my skills and knowledge to realworld situations and make meaningful contributions to a team. With a passion for using data to drive business decisions, I am confident in my ability to excel in this role and I am eager to learn and grow as a data analyst, and I am excited to take on new challenges and responsibilities in this field.
Data Analyst & Data Science.
Tableau, SQL, Python, Jupyter Notebook, and data analysis are all skills i have as a data analyst.
- DOB: 22 Feburary 2000
- Languages: English, Hindi
- Phone: 09971904537
- City: Sec-51, Noida ,India
- Age: 23
- Degree: BCA
- Mail: vrai7667@gmail.com
- Freelance: Available
I don't have any real-world experience, but I do have a solid foundation in data analytics. I've taken a variety of classes and earned certifications in database management, statistical analysis, and data analytics. I have expertise using data visualisation tools like Tableau and PowerBI and am fluent in programming languages like Python, R, and SQL. I am sure that my theoretical knowledge and technical abilities will allow me to significantly benefit your company.
Certifications
Here are some certifications.
Data Analysis with Python
As part of this certification, I built the following projects and certification.
MICROSOFT POWER BI
This free course will help me understand how to use Power BI tools to analyze data, create datasets, and more.
Skills
Resume
As a recent graduate , I am excited to begin my career as a data analyst. I am eager to apply my skills and knowledge to real world situations and make meaningful contributions to a team. With a passion for using data to drive business decisions, I am confident in my ability to excel in this role and I am eager to learn and grow as a data analyst, and I am excited to take on new challenges and responsibilities in this field.
Sumary
Vivek
Despite having no past work experience or internships, I am a proficient in data analysis, programming languages, and data visualisation tools. I am a quick learner who is passionate about problem-solving and data analysis. I am driven to achieve in any data analyst profession.
- Sec-51, Noida ,India
- +91-9971904537
- vrai7667@gmail.com
Education
Bachelor Of Computer Application
2019 - 2022
Indira gandhi National Open university, Delhi
The course curriculum covers various topics such as programming languages, computer networks, database management systems, web development, software engineering, and computer architecture.
Class 12th in (pcm)
2017 - 2018
B.s Inter Collage, Noida
A secondary education that includes Physics, Chemistry, and Mathematics as its core topics.
Certifications
Data Analysis with Python
2023
- Import necessary libraries such as pandas and numpy for data manipulation and analysis.
- Obtain certification by completing a data analysis course , such as the Certified Python for Data Analysis certification from FreeCodeCamp
Tableau
2023
- Proficient in using Tableau to connect to a variety of data sources.
- "I created a Tableau project analyzing FDI (Foreign Direct Investment) using interactive visualizations and data analysis techniques. The project highlighted trends and patterns in FDI and provided insights into factors affecting
Project
These are my projects
(TABLEAU PROJECT)
An FDI case study
About the data:
The data consists of foreign investments of the last 17 years in Cr.
| Column | Measure/Dimension | Created |
|---|---|---|
| sector | Dimension | No |
| Pivot Field of year | Dimension | Yes |
| Financial Year | Dimension | Yes |
| FDI | Measure | No |
| SUM(FDI)<1000 | Measure | Yes |
Analyizing the data for:
- Max FDI
- Min FDI
- FDI Trend
- Sector Grouping & Comparision
Max FDI
We are looking at the 5 sectors with the highest Foreign direct investment. This is the FDI for the top 5 sectors across the last 17 years. As can be seen in the image we see largeset FDI investment in:
Procedure followed:
- Dragged Sector into rows field.
- Used filter option to filter sector based on FDI using the top option within filters.
- Dragged FDI into marks and changed the measure to show maximum FDI.
- Changed the marker style to text to see the values in the table.
Min FDI
We are looking at 10 sectors that have had the lowet amount of FDI investment across 17 years. Here we are looking at the cummulative investment across 17 years. The 10 sectors with the lowest investment can be seen in the image.
Procedure Followed
- Dragged Sector into rows field.
- Used filter option to filter sector based on FDI using the bottom option within filters.
- Dragged FDI into marks and changed the measure to show sum of FDI.
- Changed the marker style to text to see the values in the table.
FDI Trend
Here we are looking at the trend of FDI across 17 years and how it has increased over time. The graph gives us a good idea about how well the country and all its major sectors are doing.
Procedure followed
- Dragged Year into column field and selected year as option since Tableau gives an option for date time fields.
- Dragged FDI into marks and chose sum. Also changed its type to text to be visible on the graph.
- Add sum FDI in Rows field.
- Chose sum number of records for color although it is not required here.
- Chose path under marks as line.
Sector Grouping and Comparison.
Here we are categorising our sectors into 2 categories. The red’s are the one’s that have not seen enough FDI over 17 years according to our set base line which is 1000. The blue values are sectors that have recieved FDI above our set baseline.
Procedure Followed
- Created a calculated field to set the baseline by passing SUM(FDI)<1000.
- Dragged FDI into marks and selected SUM.
- Dragged Sector into rows field.
Conclusions:
- There has been primarily FDI in Services, Computer, Telecom and Construction sector.
- There hasn’t been much FDI in Defense but that is primarily because of India’s rules of FDI where there was a limit of 49% for investing into the defense secotor. As of writing this post though the cap has been raised to 74% so there should be an increase in the future in this sector. Coal, coir and leather industry also don’t see much of investment from outside.
- The overall FDI trend is moving upward which is a good sign for the country.
Project Files:
Please find the project files here.