Big Data Visualization Toolkit (Tableau, Alteryx, Qliksense)

Get to grips with Tableau, Alteryx and QlikSense in this ultimate, must know, three course bundle

What you'll learn
What Tableau is and the product suite
The Tableau interface and its major functions
Which data structures are suitable for Tableau
How Tableau reads and categorizes data
How to connect and manage data sources in Tableau
How to build a view and different chart types in Tableau
How to create a dashboard in Tableau
How to publish and share a workbook
How to use numeric, string, conditional, and analytical expressions/functions in Tableau
How to use calculated fields in Tableau
How to use Alteryx workflows to cut out repetitive tasks
How to build visual workflows in Alteryx
How to make the most of 'Favorite Tools' as core Alteryx building blocks
How to filter data in Alteryx
How to use the basic functions in Alteryx to match data
How to parse data in Alteryx
How to create reports in Alteryx that run on demand
How to become a Qlik Sense designer
How to load data in Qlik Sense
How to create and upload apps in Qlik Sense
All about the different charts and graphs available in Qlik Sense
How to create your analysis in the Story Telling tab
About numeric and string functions in Qlik Sense
How to use Conditional Functions
How to use the Qlik Sense Geo Analytics tools (maps)
Requirements
Access to Tableau Desktop will be helpful but not necessary
Alteryx downloaded and installed (ideal but not essential)
A good understanding of Microsoft Excel (ideal but not essential)
An understanding of data analytics
Access to Qlik Sense (not essential, but recommended)
Description
**This course bundle includes practice exercises and downloadable data files**We live in a world where data dominates. If you want to get started with Data Analytics and Business Intelligence, then this Big Data Toolkit Bundle is a good place to begin. This HUGE Toolkit includes three full courses aimed at helping you become a big data expert inTableau Desktop, Qlik Sense, and Alteryx.Tableau is one of the best data analytics and business intelligence tools available. In this course, we introduce you to this powerful, market-leading tool and get you started building your very own visualizations. This course focuses on Tableau Desktop and is aimed at people brand new to Tableau.Qlik Sense is an impressive BI and data visualization tool. In this comprehensive course, we teach you how to become a Qlik Sense designer and make the most of this powerful software. This course is the perfect starting place if you have experience with data analytics in Excel and are looking to move to Qlik Sense.Alteryx is quickly becoming a popular tool to help people make sense of the volume of data produced by businesses each minute. In this beginner course, we show you how to get started with the Alteryx Designer and help you become an Alteryx developer. We assume you have no prior knowledge of Alteryx and start at the very beginning with this course.Tableau DesktopWhat you will learn:What Tableau is and the product suiteWhat business intelligence isThe Tableau interface and its major functionsWhich data structures are suitable for TableauHow Tableau reads and categorizes dataDifferent data concepts and theoryHow to connect and manage data sources in TableauHow to navigate the Tableau workspaceHow to build a view and different chart types in TableauHow to create a dashboard in TableauHow to publish and share a workbookHow to use calculated fields in TableauHow to use numeric, string, conditional, and analytical expressions/functions in TableauGetting Started in Qlik SenseWhat you will learn:The difference between Qlik Sense and Qlik ViewHow to load data in Qlik SenseHow to create and upload apps in Qlik SenseAll about the different charts and graphs available in Qlik SenseAll about Tables and Pivot Tables in Qlik SenseHow to create your analysis in the Story Telling tabAbout numeric and string functions in Qlik SenseHow to use the date and time formatting functionsHow to use Conditional FunctionsHow to combine tables using JOIN, KEEP and CONCATENATEHow to use different charts and tablesHow to use the Qlik Sense Geo Analytics tools (maps)Introduction to AlteryxWhat you will learn:How to use Alteryx workflows to cut out repetitive tasksHow to build visual workflows in AlteryxHow to make the most of 'Favorite Tools' as core Alteryx building blocksHow to filter data in AlteryxHow to use the basic functions in Alteryx to match dataHow to dynamically rename datasetsHow to parse data in AlteryxHow to create reports in Alteryx that run on demandHow to use the predictive tools in Alteryx to perform data analysisHow to build a k-centroid clustering model using AlteryxHow to build a logistic regression in AlteryxHow to build a decision tree-based regression in AlteryxHow to build a random forest-based modelThis course bundle includes:1. 18+ hours of video tutorials2. 100+ individual video lectures3. Exercise and Instructor files to practice and follow along4. Certificate of completion

Overview

Section 1: Tableau: Introduction

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Exercise Files

Lecture 4 Tableau Introduction

Lecture 5 Tableau Product Suite Introduction

Lecture 6 Business Intelligence introduction

Lecture 7 Exploring Tableau

Lecture 8 Tableau Data Concepts

Lecture 9 Connecting to Data Sources

Lecture 10 Data Sources in Tableau

Lecture 11 Tableau Workspace

Lecture 12 Creating a New View

Lecture 13 Exercise 1

Section 2: Tableau: Bringing Data to Life

Lecture 14 Selecting a Chart Type Part 1

Lecture 15 Selecting a Chart Type Part 2

Lecture 16 Building a View Part 1

Lecture 17 Building a View Part 2

Lecture 18 Designing Callout Numbers and Tables

Lecture 19 Histograms and Whisker Plots

Lecture 20 Scatter Plot and Correlation Matrix

Lecture 21 Spatial Charts

Lecture 22 Creating a Dashboard

Lecture 23 Presenting a Story

Lecture 24 Publishing & Sharing a Workbook

Lecture 25 Exercise 2

Lecture 26 Exercise 3

Section 3: Tableau: Calculations and Expressions in Tableau

Lecture 27 Using Expressions in Tableau

Lecture 28 Numeric Expressions & Automatic Calculations

Lecture 29 String Expressions

Lecture 30 Conditional Expressions

Lecture 31 Analytical Functions

Lecture 32 Exercise 4

Lecture 33 Exercise 5

Section 4: Tableau: Conclusion

Lecture 34 Course Conclusion

Section 5: Alteryx: Introduction

Lecture 35 Introduction

Lecture 36 WATCH ME: Essential Information for a Successful Training Experience

Lecture 37 DOWNLOAD ME: Course Instructor Files

Lecture 38 Alteryx Essentials

Lecture 39 Data Types 101

Lecture 40 Components of the Alteryx Workflow

Lecture 41 Formatting data to create a more efficient workflow

Lecture 42 Basic Workflow Examples: Getting started with the tool palette

Section 6: Alteryx: Data Blend & Prep

Lecture 43 Data filtering for Beginners

Lecture 44 Intro to blending data

Lecture 45 Grouping Data with Alteryx

Lecture 46 Introduction to Basic Functions - Part 1

Lecture 47 Introduction to Basic Functions - Part 2

Lecture 48 Introduction to Basic Functions - Part 3

Section 7: Alteryx: Data Parsing

Lecture 49 Basic Parsing Methods

Lecture 50 Basic Parsing Methods with Dynamic Renaming

Lecture 51 Basic Vlookup and Append

Lecture 52 Working on Multiple Fields in Alteryx

Lecture 53 Build an Alteryx Workflow

Lecture 54 Basic Tips and Tricks

Section 8: Alteryx: Reporting

Lecture 55 Alteryx Best Practices - Visualizing Data

Lecture 56 Alteryx Best Practices - Visualizing Data with Texts and Charts

Lecture 57 Alteryx Best Practices - Layouts and Rendering

Section 9: Alteryx: Analytic Apps

Lecture 58 Introduction to Analytic Apps

Lecture 59 Introduction to Macros

Section 10: Alteryx: Spatial Data Analysis

Lecture 60 Intro to Data Analysis - Working Spatial Data

Lecture 61 Intro to Data Analysis - Measuring Areas and Distance

Lecture 62 Intro to Data Analysis - Working Spatial Objects

Section 11: Alteryx: Analytics

Lecture 63 Introduction to Analytics

Lecture 64 Introduction to K-Centroid Clustering

Lecture 65 Introduction to K-Nearest Neighbor

Lecture 66 Introduction to Market Basket Analysis

Lecture 67 Introduction to Logistic Regression Analysis

Lecture 68 Introduction to Linear Regression Analysis

Lecture 69 Introduction to Tree-based Models Part 1

Lecture 70 Introduction to Tree-based Models Part 2

Section 12: Alteryx: Course Close

Lecture 71 Course Close

Section 13: Qlik Sense: Introduction

Lecture 72 Introduction to the course

Lecture 73 WATCH ME: Essential Information for a Successful Training Experience

Lecture 74 DOWNLOAD ME: Course Exercise and Instructor Files

Lecture 75 What is Qlik Sense?

Lecture 76 Qlik Sense vs. QlikView

Lecture 77 Different Versions of Qlik Sense

Lecture 78 Exploring the Qlik Sense Interface

Lecture 79 Loading Data Part 1

Lecture 80 Loading Data Part 2

Lecture 81 Creating & Loading Apps

Lecture 82 Adding Your First Chart

Lecture 83 Editing Your Visualization Part 1

Lecture 84 Editing Your Visualization Part 2

Lecture 85 Publishing and Sharing Apps

Lecture 86 Exercise 01: Loading Data

Section 14: Qlik Sense: Beginners Guide to Visualization

Lecture 87 Data Assets in Visualization Part 1

Lecture 88 Data Assets in Visualization Part 2

Lecture 89 Types of Charts & Graphs Part 1

Lecture 90 Types of Charts & Graphs Part 2

Lecture 91 Types of Charts & Graphs Part 3

Lecture 92 Types of Charts & Graphs Part 4

Lecture 93 Types of Charts & Graphs Part 5

Lecture 94 Generating Insights and Analysis

Lecture 95 Exercise 02: Build a chart

Lecture 96 Exercise 03: Types of Charts and Graphs

Section 15: Qlik Sense: Scripting Basics

Lecture 97 Aggregations

Lecture 98 Functions & Expressions Part 1

Lecture 99 Functions & Expressions Part 2

Lecture 100 Date and Time Formatting

Lecture 101 Conditional Functions

Lecture 102 Data Load Script

Lecture 103 Join, Keep, and Concatenate Prefixes

Lecture 104 Set Analysis

Lecture 105 Exercise 04: Numeric and String Functions

Lecture 106 Exercise 05: Inner Join

Section 16: Qlik Sense: GeoAnalytics

Lecture 107 Geo Analytics in Qlik Sense

Section 17: Course Conclusion

Lecture 108 Qlik Sense Course Conclusion

Section 18: Introduction to Power BI Intermediate Course

Lecture 109 Course Introduction

Lecture 110 WATCH ME: Essential Information for a Successful Training Experience

Lecture 111 DOWNLOAD ME: Course Instructor File

Lecture 112 Setting Up for Success

Section 19: Importing and Transforming Data in Power Query

Lecture 113 Importing Excel Data Files from a Folder

Lecture 114 Combining Files and Removing Columns

Lecture 115 Splitting and Merging Columns

Lecture 116 Applying Data Types

Lecture 117 Importing Text and CSV Files

Lecture 118 Relationships and Lookup Tables

Lecture 119 Duplicate vs Reference

Lecture 120 Creating a Lookup Table

Lecture 121 Creating Index Columns

Lecture 122 Merging Queries

Lecture 123 Enable/Disable Load and Report Refresh

Lecture 124 Advanced Editor

Lecture 125 Resolving Data Import Errors

Lecture 126 Organizing Queries into Groups

Section 20: Data Modelling

Lecture 127 Troubleshooting Relationship Issues

Lecture 128 Relationship Types

Lecture 129 Cross Filter Direction

Section 21: DAX - Essential Skills

Lecture 130 Measures vs Calculated Columns

Lecture 131 Creating a Date Table with DAX

Lecture 132 Creating Additional Columns

Lecture 133 Creating Conditional Columns

Lecture 134 Marking Table as a Date Table

Lecture 135 Using ROUNDUP to Extract Quarters

Lecture 136 Creating Quick Measures

Lecture 137 Creating a Key Measures Table

Lecture 138 Aggregation Methods

Lecture 139 Using SUMX

Section 22: DAX - CALCULATE Function

Lecture 140 The CALCULATE Function

Lecture 141 Changing Context with FILTER

Lecture 142 Using ALL with CALCULATE

Section 23: Visualizations

Lecture 143 Visualizations

Lecture 144 Tables vs Matrix Tables

Lecture 145 Formatting Visualizations - Part 1

Lecture 146 Formatting Visualizations - Part 2

Lecture 147 Conditional Formatting

Lecture 148 Column and Line Charts

Lecture 149 Card Visualizations

Lecture 150 Map Charts

Lecture 151 The Gauge Visualization

Lecture 152 Slicers and Filter

Lecture 153 Applying Design Elements

Section 24: The Power BI Service

Lecture 154 Creating a Shared Workspace in Power BI Service

Lecture 155 Inviting Others to a Shared Workspace

Lecture 156 Reports vs Dashboards

Lecture 157 Pinning Visualizations to the Dashboard

Lecture 158 Setting up Scheduled Refreshes

Section 25: Orders Dashboard Example - Preparation

Lecture 159 Orders Dashboard Example

Lecture 160 Report Requirements

Lecture 161 Importing Order Data

Section 26: Orders Dashboard Example - Transformation

Lecture 162 Transforming Order Data in Power Query

Lecture 163 Creating Lookup Tables

Lecture 164 Merging Queries

Lecture 165 Creating a Dates Table

Lecture 166 Creating DAX Measures

Section 27: Orders Dashboard Example: Report

Lecture 167 Adding a Report Title

Lecture 168 Report Navigation with Buttons and Bookmarks

Lecture 169 Card Visualizations and Filtering

Lecture 170 Line Chart: Count of Male vs Female Customers

Lecture 171 Stacked Column Chart: Total Revenue by Region

Lecture 172 Treemap Chart: Count of Orders by Year/Month

Lecture 173 Funnel Chart: Age Distribution

Lecture 174 Matrix Table: Count of Customers by Type and Status

Lecture 175 Adding Conditional Formatting

Section 28: Orders Dashboard Example: Dashboard

Lecture 176 Publishing the Report to the Power BI Service

Lecture 177 Pinning Media Tiles to Dashboard

Section 29: Course Close

Lecture 178 Course Close

Data Analysts,Data Scientists,Anyone looking to turn raw data into meaningful business outcomes using Tableau,Beginner Alteryx users who are looking to get started in the Alteryx Designer,Anyone wanting to learn to master Qlik Sense,Anyone interested in data visualization