Become A Data Analyst Excel, Sql & Tableau - 3-In-1 Bundle

Free Download What you'll learn
Discover the power of Excel and use it to manipulate and analyze data like a pro.
Master SQL queries to extract, filter, and aggregate data from relational databases.
Explore Tableau's interface and create stunning visualizations that communicate insights.
Develop the skills to integrate data from multiple sources and create interactive dashboards in Tableau.
Apply best practices for data cleaning, wrangling, and transformation in Excel and SQL
Create dynamic and automated reports in Tableau that update with new data.
Use Excel and Tableau to identify trends, patterns, and outliers in data.
Develop a data-driven mindset and use data to make informed business decisions.
Apply critical thinking and problem-solving skills to data analysis challenges.
Requirements
Only a PC with any version of Excel installed is needed for this course
Description
If you are interested in becoming a data analyst, but feel overwhelmed by the technical skills required, this "Become a Data Analyst: Excel, SQL & Tableau - 3-in-1 Bundle" course is designed for you. You'll learn Excel, SQL, and Tableau - the essential tools for data analysis - and develop the skills to turn raw data into insights that drive better business decisions.In this course, you willevelop advanced Excel skills to manipulate and analyze dataMaster SQL queries to extract data from databasesCreate stunning data visualizations in Tableau to communicate insightsLearning these skills will allow you to excel as a data analyst, and open up new career opportunities. You'll practice real-world examples and complete hands-on exercises, so you can apply your new skills to real-world situations.This course is different because it offers a comprehensive, 3-in-1 bundle approach that covers all of the key skills required to become a successful data analyst. The course is also taught in an engaging and easy-to-understand format, so you can learn at your own pace and confidently apply your skills in the workplace.What makes us qualified to teach you?The course is taught by Abhishek (MBA - FMS Delhi, B. Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B. Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problems using Analytics and we have used our experience to include the practical aspects of business analytics in this course. We have in-hand experience in Business Analysis.We are also the creators of some of the most popular online courses - with over 1,200,000 enrollments and thousands of 5-star reviews like these ones:This is very good, i love the fact the all explanation given can be understood by a layman - JoshuaThank you Author for this wonderful course. You are the best and this course is worth any price. - DaisyWhat is covered in this course?The analysis of data is not the main crux of analytics. It is the interpretation that helps provide insights after the application of analytical techniques that makes analytics such an important discipline. We have used the most popular analytics software tools which are MS Excel, SQL, and Tableau. This will aid the students who have no prior coding background to learn and implement Analytics and Machine Learning concepts to actually solve real-world problems of Data Analysis.Let me give you a brief overview of the coursePart 1 - Excel for data analyticsIn the first section, i.e. Excel for data analytics, we will learn how to use excel for data-related operations such as calculating, transforming, matching, filtering, sorting, and aggregating data.We will also cover how to use different types of charts to visualize the data and discover hidden data patterns.Part 2 - SQL for data analyticsIN the second section, i.e. SQL for data analytics, we will be teaching you everything in SQL that you will need for Data analysis in businesses. We will start with basic data operations like creating a table, retrieving data from a table etc. Later on, we will learn advanced topics like subqueries, Joins, data aggregation, and pattern matching.Part 3 - Data visualization using TableauIn this section, you will learn how to develop stunning dashboards, visualizations and insights that will allow you to explore, analyze and communicate your data effectively. You will master key Tableau concepts such as data blending, calculations, and mapping. By the end of the course, you will be able to create engaging visualizations that will enable you to make data-driven decisions confidently.Our PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.Don't let technical skills hold you back from pursuing a career in data analysis. Enroll now and start your journey towards becoming a data analyst.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Excel Basics
Lecture 2 Getting started with Excel
Lecture 3 Course Resources
Lecture 4 This is a milestone!
Lecture 5 Worksheet basics
Lecture 6 Entering values and Formulas
Lecture 7 Data Formats
Lecture 8 Data Handling Basics - Cut, Copy, Paste
Lecture 9 Saving and Printing in Excel
Section 3: Essential Excel functions
Lecture 10 Basic Formula Operations
Lecture 11 Mathematical Functions - Part 1
Lecture 12 Mathematical Functions - Part 2
Lecture 13 Difference between RANK, RANK.AVG and RANK.EQ
Lecture 14 Textual Functions - Part 1
Lecture 15 Textual Functions - Part 2
Lecture 16 Logical Functions
Lecture 17 Date-Time Functions
Lecture 18 Lookup Functions ( V Lookup, Hlookup, Index-Match )
Section 4: Data Tools
Lecture 19 Data Tools Part 1
Lecture 20 Data Tools Part 2
Section 5: Formatting data and tables
Lecture 21 Formatting data and tables
Section 6: Pivot Tables
Lecture 22 Pivot Tables
Section 7: Excel Charts
Lecture 23 Excel Charts - Categories of messages that can be conveyed
Lecture 24 Elements of charts
Lecture 25 The Easy way of creating charts
Lecture 26 Bar and column charts
Lecture 27 Formatting charts Part -1
Lecture 28 Formatting charts Part -2
Lecture 29 Line Charts
Lecture 30 Area Charts
Lecture 31 Pie and Doughnut Charts
Lecture 32 Why we should avoid Pie charts
Lecture 33 Scatter plot or XY chart
Lecture 34 Frequency Distribution and Histograms
Lecture 35 Waterfall Charts
Lecture 36 Hierarchy Charts: Sunburst and Treemap
Lecture 37 Combination charts
Lecture 38 Sparklines
Section 8: Pivot Charts
Lecture 39 Pivot Charts
Section 9: Special purpose charts
Lecture 40 Stock charts
Lecture 41 Radar charts
Lecture 42 Surface charts
Lecture 43 Heatmaps
Section 10: Named Ranges
Lecture 44 Named Ranges
Lecture 45 Indirect Functions
Section 11: Excel Shortcuts
Lecture 46 Shortcuts
Section 12: Macros
Lecture 47 Macros
Section 13: Advanced Excel
Lecture 48 Advanced Excel: Analytics in Excel
Section 14: Creative Infographics
Lecture 49 Infographic Example 1
Lecture 50 Infographic Example 2
Section 15: SQL
Lecture 51 Introduction
Section 16: Installation and getting started
Lecture 52 Installing PostgreSQL and pgAdmin in your PC
Lecture 53 If pgAdmin is not opening...
Section 17: Case Study : Demo
Lecture 54 Case Study Part 1 - Business problems
Lecture 55 Case Study Part 2 - How SQL is Used
Section 18: Fundamental SQL statements
Lecture 56 CREATE
Lecture 57 INSERT
Lecture 58 Import data from File
Lecture 59 SELECT statement
Lecture 60 SELECT DISTINCT
Lecture 61 WHERE
Lecture 62 Logical Operators
Lecture 63 UPDATE
Lecture 64 DELETE
Lecture 65 ALTER part -1
Lecture 66 ALTER part - 2
Section 19: Restore and Back-up
Lecture 67 Restore and Back-up
Lecture 68 Debugging restoration issues
Lecture 69 Creating DB using CSV files
Lecture 70 Debugging summary and Code for CSV files
Section 20: Selection commands: Filtering
Lecture 71 IN
Lecture 72 BETWEEN
Lecture 73 LIKE
Section 21: Selection commands: Ordering
Lecture 74 Side Lecture: Commenting in SQL
Lecture 75 ORDER BY
Lecture 76 LIMIT
Section 22: Alias
Lecture 77 AS
Section 23: Aggregate Commands
Lecture 78 COUNT
Lecture 79 SUM
Lecture 80 AVERAGE
Lecture 81 MIN & MAX
Section 24: Group By Commands
Lecture 82 GROUP BY
Lecture 83 HAVING
Section 25: Conditional Statement
Lecture 84 CASE WHEN
Section 26: JOINS
Lecture 85 Introductions to Joins
Lecture 86 Concepts of Joining and Combining Data
Lecture 87 Preparing the data
Lecture 88 Inner Join
Lecture 89 Left Join
Lecture 90 Right Join
Lecture 91 Full Outer Join
Lecture 92 Cross Join
Lecture 93 Intersect and Intersect ALL
Lecture 94 Except
Lecture 95 Union
Section 27: Subqueries
Lecture 96 Part-1 Subquery in WHERE clause
Lecture 97 Part-2 Subquery in FROM clause
Lecture 98 Part-3 Subquery in SELECT clause
Section 28: Views and Indexes
Lecture 99 VIEWS
Lecture 100 INDEX
Section 29: String Functions
Lecture 101 LENGTH
Lecture 102 UPPER LOWER
Lecture 103 REPLACE
Lecture 104 TRIM, LTRIM, RTRIM
Lecture 105 CONCATENATION
Lecture 106 SUBSTRING
Lecture 107 LIST AGGREGATION
Section 30: Mathematical Functions
Lecture 108 CEIL & FLOOR
Lecture 109 RANDOM
Lecture 110 SETSEED
Lecture 111 ROUND
Lecture 112 POWER
Section 31: Date-Time Functions
Lecture 113 CURRENT DATE & TIME
Lecture 114 AGE
Lecture 115 EXTRACT
Section 32: PATTERN (STRING) MATCHING
Lecture 116 PATTERN MATCHING BASICS
Lecture 117 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part -1
Lecture 118 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part 2
Section 33: Windows Functions
Lecture 119 Introduction to Window functions
Lecture 120 Introduction to Row number
Lecture 121 Implementing Row number in SQL
Lecture 122 RANK and DENSERANK
Lecture 123 NTILE function
Lecture 124 AVERAGE function
Lecture 125 COUNT
Lecture 126 SUM TOTAL
Lecture 127 RUNNING TOTAL
Lecture 128 LAG and LEAD
Section 34: COALESCE function
Lecture 129 COALESCE function
Section 35: Data Type conversion functions
Lecture 130 Converting Numbers/ Date to String
Lecture 131 Converting String to Numbers/ Date
Section 36: User Access Control functions
Lecture 132 User Access Control -1 Grant and Revoke
Lecture 133 User Access Control -2 Drop, Alter users
Section 37: Nail that Interview!
Lecture 134 Tablespace
Lecture 135 PRIMARY KEY & FOREIGN KEY
Lecture 136 ACID compliance
Lecture 137 Truncate
Section 38: Performance tuning tips
Lecture 138 TIP 1 (EXPLAIN)
Lecture 139 TIP 2
Lecture 140 TIP 3
Lecture 141 TIP 4 (VACCUM)
Lecture 142 TIP 5
Lecture 143 TIP 6 ( STRING FUNCTIONS)
Lecture 144 TIP 7 (JOINS)
Lecture 145 TIP 8 (SCHEMAS)
Section 39: Database Basics
Lecture 146 What is SQL?
Lecture 147 Tables and DBMS
Lecture 148 Types of SQL commands
Lecture 149 PostgreSQL
Section 40: TABLEAU
Lecture 150 Introduction
Lecture 151 Why Tableau
Lecture 152 Tableau Products
Section 41: Installation and getting started
Lecture 153 Installing Tableau desktop and Public
Lecture 154 About the data
Lecture 155 Connecting to data
Lecture 156 Live vs Extract
Section 42: Combining data to create Data model
Lecture 157 Combining data from multiple tables
Lecture 158 Relationships in Tableau
Lecture 159 Joins in Tableau
Lecture 160 Types of Joins in Tableau
Lecture 161 Union in Tableau
Lecture 162 Physical Logical layer and Data models
Lecture 163 The visualization screen - Sheet
Section 43: Data categorization in Tableau
Lecture 164 Types of Data - Dimensions and Measures
Lecture 165 Types of Data - Discreet and Continuous
Lecture 166 Changing Data type in Tableau
Section 44: Most used charts
Lecture 167 Bar charts
Lecture 168 Line charts
Lecture 169 Scatterplots
Section 45: Customizing charts using Marks shelf
Lecture 170 Marks cards
Lecture 171 Dropping Dimensions and Measures on marks card
Lecture 172 Dropping Dimensions on Line chart
Lecture 173 Adding marks in scatterplot
Section 46: Other important charts
Lecture 174 Text tables, heat map and highlight tables
Lecture 175 Pie charts
Lecture 176 Area charts
Lecture 177 Creating custom hierarchy
Lecture 178 Tree map
Lecture 179 Dual combination charts
Lecture 180 Creating Bins
Lecture 181 Histogram
Section 47: Grouping and Filtering data
Lecture 182 Grouping Data
Lecture 183 Filtering data
Lecture 184 Dimension filters
Lecture 185 Measure filters
Lecture 186 Date-Time filters
Lecture 187 Filter options
Lecture 188 Types of filters and order of operation
Lecture 189 Customizing visual filters
Lecture 190 Sorting options
Section 48: Map chart in Tableau
Lecture 191 How to make a map chart
Lecture 192 Considerations before making a Map chart
Lecture 193 Marks card for customizing maps
Lecture 194 Customizing maps using map menu
Lecture 195 Layers in a Map
Lecture 196 Visual toolbar on a map
Lecture 197 Custom background images
Lecture 198 Territories in maps
Lecture 199 Data blending for missing geocoding
Section 49: Calculations and Analytics
Lecture 200 Calculated fields in Tableau
Lecture 201 Functions in Tableau
Lecture 202 Table calculations theory
Lecture 203 Table calculations in Tableau
Lecture 204 Understanding LOD expressions
Lecture 205 LOD expressions examples
Lecture 206 Analytics pane
Section 50: Sets and Parameters
Lecture 207 Understanding sets in Tableau
Lecture 208 Creating Sets in Tableau
Lecture 209 Parameters
Section 51: Dashboard and Story
Lecture 210 Dashboard part -1
Lecture 211 Dashboard part - 2
Lecture 212 Story
Section 52: Appendix
Lecture 213 Connecting to SQL data source
Lecture 214 Connecting to cloud storage services
Section 53: Congratulations and about your certificate
Lecture 215 The final milestone!
Lecture 216 Bonus lecture
Anyone curious to master Data Analysis in a short span of time,Individuals who want to pursue a career in data analysis, business intelligence, or data visualization,Professionals who want to upskill and add value to their existing roles by learning data analysis,Aspiring data analysts who want to develop the skills to turn raw data into actionable insights,Small business owners who want to use data to drive better decision-making in their companies

Homepage