Data Analytics Bootcamp : Excel, Google Sheets And Tableau

Data Analytics masterclass, Start with using Excel and Google Sheets then create awesome dashboards in Tableau.

4.62 (29 reviews)
Udemy
platform
English
language
Other
category
instructor
59
students
6 hours
content
Apr 2022
last update
$39.99
regular price

What you will learn

Confidently Showcase your Data Analytics skills to the world and Add it in your Resume.

Create Interactive Dashboards in Tableau and Excel.

Create Drop down list, Check boxes, Freeze Row and Column, Concatenate strings and Extract data from strings

Create Amazing graphs and Map visualization alongside some great advanced Excel and Tableau features

Get Experienced in Data Analysis and Analytical thinking.

Learn from basics to Advance MS Excel and Spreadsheet

Learn to clean, prepare and Visualize data.

Finding Out insights from Data and Turning them into assets for the organization

Description

**Amazing updates and class projects coming soon**

This is a Condensed course that will teach you all you need to know about how to get started and get going with data analysis we will start with learning how to use Excel and spreadsheet then use Tableau for Data analysis. This course is made for anyone who wants to learn the art of Data analysis and data visualization. We will begin by learning how to use Excel and Spreadsheet then we will learn the various steps for doing data analysis which are data cleaning, preparation and finally data visualization after which we will use all of these learned skills to create a real interaction dashboard for our projects in Tableau. This course should prepare you to utilize Excel, Spreadsheet and Tableau to do your next analysis with confidence. You will be able to proudly showcase your skills to the world and add it to your resume.

==================================================

You will receive the following benefits as a result of taking this course:

  • Full free lifetime access to all the lecture videos

  • More than 6 hours of content.

  • This course is made using the latest versions of Excel, Spreadsheet and Tableau so it will be great for any future version.

  • Confidently add your skills to your Resume

  • Udemy offers an unconditional 30-day money-back guarantee. - However, I am confident that you would enjoy the course:)

Why this Course:

  • I have tried to create the video and explain it in view short and crisp manner.

  • The course structure is such a way that you go through Tableau and understand all concepts in the most structured way.

  • The course is segmented into various sections to help the student’s individual section in-depth and in a step-by-step manner.

  • The course has used learn by doing method which is best for software like Spreadsheet, Excel and Tableau.

With ZERO prior experience, you may begin your journey to become experienced at Excel, Google Sheets and Tableau!

Looking forward to seeing you on the other side with me in your Data Analysis journey.

Screenshots

Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_01Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_02Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_03Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_04

Content

Introduction

Introduction

SpreadSheet and Excel Part -1

Basic and Spreadsheet and Its Interface
Basics, Referencing and Autocompleting your Data
Formatting Your Data
Formatting our Tables to make them More appealing
Using Conditional Formatting
Excel

Spreadsheet and Excel Part- 2

What's In this Section
Filter/Sorting Our Data
Data Validation(Creating Drop down List), Formulas and Functions
Combining Data And Extracting Data from cells
Using IF Function
Vlookup Function and Data Cleaning
Excel : Using Checkbox, Slicer and All other features

Visualizing Our Data And Additional features

Quick Recap
Pivot Tables
Creating Different Chart and Map Visualizations
Creating Pivot table and Charts in Excel
Creating Dashboard In Excel
Using Macros
Congratulations for Completing Part 1

Tableau Part 1: Data Analysis and Data cleaning and Preparation Steps

What is data Analysis and how to gather information?
Dashboards and Its Types
Blueprinting your Dashboards
Let's Download Tableau
Let's load our data in Tableau
Combining Data in Tableau
Let's Clean our Data
Preparation of our data

Data Visualisation

Let's Create our First Visualisation
Let's Create our first map visual
Advanced Tableau features For creating Territories in Tableau
Using The Marks Card
Let's Create Some filters

Final Project

Let's Complete First few Tasks( Data cleaning, Preparation and some charts)
Let's Create our Hollow pie Chart
Let's Create the Highlight Table
Let's Create Map with Drilldowns

Dashboard

Dashboard Interface
Let's start Creating dashboard
Using various Filters to make our dashboards more Interactive and Dynamic
Additional Content and How to download and Share your Dashboards
Congratulations

Reviews

Steven
July 3, 2022
An amazing class! The teacher explained everything about data analytics in great details with lots of examples. It is very easy to follow and I learnt a lot from this class.
Ana
June 6, 2022
Awesome class with a lot of practical examples. Recommended to anyone who wants to gain understanding on Excel, Google Sheets and Tableau!
Roman
June 5, 2022
As promised, this course has a lot of information on Excel, Google Sheets and Tableau. Learning a lot with each lecture.
Christie
June 5, 2022
This is a great course to learn and develop your Excel skills and then take it one step further with Google Sheets and Tableau
Darakhsha
April 23, 2022
The course was the thing I needed to learn the skills I wanted in my data Analytics journey. Looking forward to the future courses
Jake
April 23, 2022
I have very less idea about data Analytics , this course helped me get experienced in it also learned several software in detailed manner In a very concise way
Samar
April 20, 2022
The course is for anyone who want to get experienced in the domain of data visualisation. Really enjoyed the course and would recommend anyone who want to learn these softwares
Raito
April 19, 2022
The course is perfect for anyone who want to get experienced in these software. really loved the course
Jake
April 19, 2022
Started from someone who has no idea about these software to now I am really confident in my skills and can create good dashboard and projects. Thank you :)
Talha
April 19, 2022
Course structure was really good being a beginner it helped a lot in understanding everything in a very simplified manner
Badar
April 19, 2022
The course was very nice for someone who wants to learn data visualization. I loved each and every lecture and found them really informative

Charts

Price

Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Price chart

Rating

Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Ratings chart

Enrollment distribution

Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Distribution chart
4631290
udemy ID
4/7/2022
course created date
4/20/2022
course indexed date
Bot
course submited by