Data Visualization

On the part of data visualization, I use power BI to visual the data into a charts and plots, so I take the retail company products to summarize and visualize the data for there needs

VISUAL NO 1:

In the visual, I include the revenue of the year by month. The product revenue by months, so the visuals are work like this we can easily understand the profit month and loss month.

VISUAL NO 2:

In the visual, I include the Quantity and revenue bases on the country. By the help of the visual we can easily understand the quantity and revenue of the products. And also suggest improving the graphs if the revenue is high the quantity is low, we can have some idea to balance the situation at any time.

VISUAL NO 3:

In the visual, I include the revenue by customers so we can easily see the revenue of the customers.

VISUAL NO 4:

In the visual, I include the world map that our company product quantity in the world graph we can easily understand which country or which city was talk the highest quantity of the product.

So, this are the visual of the specify dataset that I learned and do in the TATA virtual Internship.

ABC Call Volume Trend Analysis

For this project I take the dataset of a call center.

In the call center we have lot of works are in now days so there is also an analysis work is present here by the help of analysis, we can correct the problem if it is occurs.

A) We can put the average call time duration and calculate each time budget (e.g., 9 to 10,10 to 11, etc...)

B) we can also suggest the man made to decrease the abandon rate increase our Service to improve our company to grow from the good position.

In this project I also enter into the call center field and analysis their work.

XYZ Ads Airing Report Analysis

For this project I will take the dataset of ADs airing company.

Advertising is a way of marketing your business in order to increase sales or make your audience aware of your products or services. Until a customer deal with you directly and actually buys your products or services, your advertising may help to form their first impressions of your business. Target audience for businesses could be local, regional, national or international or a mixture. So, they use different ways for advertisement. Some of the types of advertisement are Internet/online directories, Trade and technical press, Radio, Cinema, Outdoor advertising, National papers, magazines and TV. Advertising business is very competitive as a lot of players bid a lot of money in a single segment of business to target the same audience. Here comes the analytical skills of the company to target those audiences from those types of media platforms where they convert them to their customers at a low cost.

A) In this project we have analyze the pod position means why and what is pod position in Various brands.

B) In TV Airing and how that changed from Q1 to Q 4, that means what kind of brand ads comes in quartile 1 to quartile 4 of one year.

C) Give a man-made strategy plan Competitive analysis with other brands.

D) And if the brand was running a digital campaign ad? We will suggest the brand to target which kind of audience and giving suggestion to does and don't.

In the project we will analyze this kind of Data and Give the output to improve the company's wealth and etc..

IMDB Movie Analysis

This was the little big project because of using the big IMDb movie dataset to analysis the data the find the different set of output as per as we need.

In the dataset we have all details of the Movies, Genre, Actors, Actress, Directors, Rating, Profit, Budget of the movie and etc...

A) For the analysis we can Cleaning the data (Dropping the columns and cleaning the null values etc...)

B) we can analyze the Movies with Highest Profit based on the IMDb reports we can see the profit columns to find it highest profit movies.

C) We I find the Top 250 movies based on their Ratings.

D) We can also analysis the top Directors based on the Rating column provide by IMDb dataset and find which director is best.

E) We can also do visualization of this data specially or fully (e.g., Leonardo Dicaprio movies and the Rating, Johnny Depp movies and Rating) I use power BI for this.

This kind of work I have done in this project, for telling this was easy but practical we need lot of concentrate in our work.

Hiring Process Analytics: Statistics

For this Hiring Process Analytics, we help to the company to analysis their employees and interview application and etc...

With the help of the Statistics and Excel we can analyze the data.

A) From the analysis part of Hiring we can analysis the how many male and female are hired in the company.

B) We can also find the average salary of the employ offered by the company by different designation.

C)We can put the charts and plots to visualization the data. I use power BI to visual.

For this project I use the manual statics methods as well as excel technical methods to improve and maintain the hiring process of the comapany.

Operation Analytics and Investigating Metric Spike: Advanced SQL

Operation Analytics is the analysis done for the complete end to end operations of a company. With the help of this, the company then finds the areas on which it must improve upon.

In this dataset I use the Four time of data set like Job table, user details, event details, email events details so this are the details of the data I used

A) I can analysis the number of jobs reviewed in the particular year (e.g., November 2020)

B) If the data has duplicate rows, I can clean the data from using SQL Query and also in Excel.

C) I can also use filter tool to the data as per as I need.

D) And I can also analysis the user engagement, weekly growth, weekly retention, weekly engagement and email engagement.

So, this are the analytics work I can used in the project to improve their standards

Instagram User Analytics: SQL Fundamentals

This project is about Instagram user Analytics. In this project I use SQL Query to do analysis so this I use the SQL workbench platform to analysis the data.

Why I choose Instagram user analytics means I have to analysis the user of the Instagram does.

A) Finding the oldest users of Instagram.

B) The user how never posts in Instagram.

C) To find which user as the greatest number of like and share their details to the company.

D) Researching Hashtags and analysis most commonly used hashtags in Instagram.

E) I analysis the data and tell on which day does many registrations occur to Launch AD campaign.

F) I also use the statical Analytics to find the users average posts in one day.

So, this are the work I do in this project.

Data Analytics Process

I create a dataset in my own and I do the major 6 step of data analysis process to analysis the data. my raw data is Indian food

STEP:1 Plan

STEP:2 Prepare

STEP:3 Process

STEP:4 Analyze

STEP:5 Share

STEP:6 Act

So, this are the Data analytics process to analysis any kind of data.

MY PORTFOLIO

Hi, I am

AJMAL

ABOUT ME

Ajmal

My Professional Skills

Portfolio