Virtual Internship in Data Analytics

Did not Received Offer Letter?

Want to Know More about The Program About?

Index...

1. Introduction

2. Instructions

3. Google Form - Sheets

4. Client Call - 1

5. Task - 1

6. Reporting Using Pivot Tables

7. Task - 2

8. Task - 3

9. Task - 4

10. Free Premium CV Templates

11. Career Boosting Products

12. Data Analytics Formula Master Program

13. Certificate Request Form

1.) Introduction

Assume there is a Data Analytics Company who provides Data Capturing & Dynamic Reporting Services to the Manufacturing Sector

They are Looking for a Data Analytics Intern who can perform Automations, Data Manipulations & Reporting inside Google Sheets!

You will be trained by your Mentor at frequent periods of this Virtual Internship & then you will be facing the Client Directly to perform the Tasks!

This Role is for Candidates who want to gain Practical Experience of Real-World Problems in Data Analytics Field Working Upon Customized Solutions

You would also be getting access to some Career Boosting Products in this Virtual Internship

2.) Instructions

Watch all Videos (720p Quality & 1 / 1.25 x Speed) in each Chapter, Read the reference Document.

• You have to perform all the Tasks inside your Personal Google Drive Account

• You have to perform all tasks as per requirement & create a Google Document by attaching screenshots & explanation of each task you are doing

• At the End of the Virtual Internship, You will fill the Certificate Request Form & attach the Google Document in PDF Format
  

3.) Google Forms - Sheets

• Context Covered
  

• Connection of Google Form with Google Sheets
• Query Function from Form Responses to Master Data
• Standard Formatting of a Google Sheet
• What is Control Master?
• Creation of a Control Master to fetch Dropdown values via Form Ranger
  

1. Training Video 1

2. Query Function Quick Tip

3. Query Manipulate Data

Basics About Data Analytics

Reference Document

Your Mentor :

I Hope you have understood on how to use a Google Form to Capture Data & Use Query Function to create a Master Database.

I am setting up a virtual Call of yours with the Client, the Client owns a Manufacturing Company and the Production Manager will co-ordinate with you to give their Requirements

I will also be there in the call and summarize the requirements of the client to you as a task which you have to perform in your own Google Drive!

Good Luck!

Client Call - 1

Client:

Hi Team, We have a Production Unit which Manufactures all types of Doors,

We have a target of reducing our Production Costs by 10% in the next 6 Months from our Management,

Currently all our Production Data is managed in manual excel sheets with negligible deep reporting being done

We need any easy medium to capture the data so our operators can enter the data easily

And we need to then Dig Down & Deeper to analyze the efficiency of each Machine and our Operators to identify where we can improve our performance & thus reduce our production cost

Also we should be able to easily filter our data in the database so we can have a look at the daily progress report!

Mentor :

Sure we have noted your points and we will get back to you with an easy medium to capture all your data from the production unit, once we start capturing Data then we will look towards reporting!

Task - 1

Mentor :

As you must have heard in the meeting, the Client needs an easy way to capture the data from the Production unit & also it should be user friendly so their operators can input the data,

So Google Forms would be a great medium to capture the data from the Production Unit

Task 1:

Create a Control Master where the Client will be adding all their Machine Names, Operator Names & Project Names

Data Set - Copy the Data Set for Control Master & Form Responses from this Sheet

Create a Google Form in your own Google Drive with the following Fields :

(D) - Dropdown fetched from Control Master

D

• Project Name (D)
  
• Machine Name (D)
• Operator Name (D)
• Duration (In Mins)
• Accepted Qty
• Rejected Qty

Connect this Form to a Google Sheet in your Own Drive

Now after you have Migrated (copy pasted) Data from the Data Set to your Form Responses Sheet,

Create a Master Data Using Query with appropriate Filters!

Mentor:

That's It for the first task, now we will show this to the Client & take the feedback and the requirements for the next task! After you have done your task 1 make sure you watch the training of reporting below

6.) Report Dashboarding Using Pivot Tables

• Context Covered
  

• How to use Pivot Tables and its formatting, pivot date group
• Use of Conditional Formatting
• Create Graphical Reports and its Standard Structure
• Numeric % Reports
• Scorecard Charts
• Using Query in Reporting
• Regression Analysis

1. Report Dashboarding

2. Scorecard Charts

3. Advance Reporting

4. Regression Analysis

Reference Dashboards

Your Mentor:

You must have understood how we can use pivot table to create any kind of Report & use any charts to create graphical representation of the Data.

Quick Tip: You can use the Filter function of pivot table to filter data based upon any type of Custom Condition.

Task - 2

Client :

I checked out the Google Form & also I did check that 4 Months of my Data has been Migrated into the Master Data, That's Great!

-Now I want some Analysis from this Data.

Report 1: Give me a Tabular Report of Month Wise - Machine Wise - Sum of Accepted Qty - Rejected Qty & Calculate the % of Rejected Qty against Accepted Qty.

- Now Give me a Graph of Month wise % of Rejected Qty Against Accepted Qty.

- Also Give me a Bar Graph of Machine vs Sum of Accepted Qty & Sum of Rejected Qty.

Report 2: Month Wise - Machine Wise - Average Duration

Mentor :

Hi I think you are going good and can handle the Client Directly, just make sure whatever report you provide to the Client are Formatted Properly and are Understandable!

Task - 3

Mentor :

Hi, We can also predict the next 3 Months Data and provide it to the Client, It can help him to set certain targets where based upon previous pattern the data has been predicted.

I Hope you were attentive during the Regression Analysis training I gave you before,

So provide the Client next 3 Months Prediction on the Report of : Month Wise - Machine Wise - Rejection Percentage Against Accepted Qty.

9.) Code Authentication

1. Code Authentication

Your Mentor :

We know that you have created the Reports, but now the Client needs this Code Authentication Feature added in the Form & Sheet,

Task 4 : Implement the Code authentication feature & add Sample Codes in Control Master and fetch the Data, Now as you add a form field, All columns will change in Report, Google Form Ranger & Master Data

But this is how Real-World problems are, According to Business need we need to rework whatever is needed.

Get the Code Authentication Feature Done ASAP!

Good Job, If you have finished all the tasks till Now !

This is just the beginning of a Real-World experience & if you keep learning like this working on Live Projects, your profile will be very Strong and you would be unstoppable!

10.) Bonus Report Dashboarding Task

Google Data Studio Tutorial

Here is the background information on your task

An online retail store has hired you as a consultant to review their data and provide insights that would be valuable to the CEO and CMO of the business. The business has been performing well and the management wants to analyse what the major contributing factors are to the revenue so they can strategically plan for next year.

The leadership is interested in viewing the metrics from both an operations and marketing perspective. Management also intends to expand the business and is interested in seeking guidance into areas that are performing well so they can keep a clear focus on what’s working. They would also like to view different metrics based on the demographic information that is available in the data.

A meeting with the CEO and CMO has been scheduled for next month and you need to draft the relevant analytics and insights that would help evaluate the current business performance and suggest metrics that would enable them to make the decision on expansion.

Remember, thinking from the perspective of business leaders allows you to analyse the data more effectively and present better insights.

You’ve been provided a dataset in the resources below to use as the basis for your exploration. Review this data, taking note of what information has been provided, what insights you can garner, and what is relevant to both the CEO and CMO respectively.

Google Data Studio Tutorial

Use this Data Set & Create a Report Dashboard in Power BI / Tableau or Google Data Studio by seeing the Report Requirements!

11. Premium CV Templates

CV Template - 1

CV Template - 2

CV Template - 3

• Open the Link & Sign Up on Canva Account,
• Edit the CV Template & Download it as PDF,
• You have a Lifetime Free Access to these CVs.
  

12. Career Boosting Products

You have got Access to the Following Products :

1 . Career Explorer Test - This Test will provide you a Detailed PDF Report on which Sector & Career are suitable for you based upon your Knowledge, Personality & Interests.

2 . Career Hub- Explore all Career Options according to the Sector with their Career Path, Scope of Career & Skills required.

3 . Industry Wise CV Library - With the Premium CV Templates you have earned, you also get an Ideal CV of real Candidates in various Domains which you can refer while creating your own CV.

How to Access Career Products?

ID : careermentor@gmail.com

Pass : pass5678

Press the Orange Login Button & Login with the Credentials Given above

Internship Certificate

To Earn a Certificate for this Internship and Use this Experience on your CV & Linkedin for Job or College Purpose & also to Get your Work Evaluated, You need to pay a Nominal Fee on the Button Below as we have already provided you access to a lot of Valuable things for your Career :

1.) Offer Letter from Mentored Minds Pvt Ltd

2.) Training on Google Sheets Advanced Formulas

3.) Practical Business Scenario with Hands-on tasks

4.) 3 Paid Premium ATS Friendly CV Templates

5.) Access to 3 Career Boosting Products

© Mentored Minds Pvt Ltd 2019 All Rights Reserved.

Powered by Mentored Minds