Data Storytelling: Mastering Data Visualization Techniques

Tell a story with your data using Excel PivotTable, Power BI, Alteryx, Tableau, and Qlik Sense in this 10-course bundle!

What you'll learn

How to create PivotTables

Using the fields pane and adding fields and calculated fields

Formatting numbers in PivotTable

Different ways to summarize data

Creating PivotCharts and adding sparklines and slicers

Combining data from multiple worksheets for a PivotTable

How to create stunning, interactive dashboards with Power BI

How to share your analysis and dashboards using Power BI Online

Importing Excel, Text, and CSV files into Power BI Desktop and combining files

Data Modelling, relationship types, and troubleshooting relationship issues

Creating a Shared Workspace in Power BI Service

Creating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes

How to import and transform data in Power Query

Advanced Tableau charts—circular, sunburst, bump, funnel, candlestick, and Sankey charts

Connect and manage data sources in Tableau

Create a dashboard in Tableau and animate your visualizations

Use calculated fields and spatial functions in Tableau

Level of Detail (LOD) expressions

Advanced filters and table calculations in Tableau

Using Alteryx workflows to cut out repetitive tasks

Data cleansing, manipulation, binning, and grouping in Alteryx

Take your apps and macros to the next level in Alteryx

Using multiple files and Calgary in Alteryx

All about Machine Learning and the Alteryx Intelligence Suite

How to become a Qlik Sense designer

All about the different charts and graphs available in Qlik Sense

How to use the Qlik Sense Geo Analytics tools (maps)

Requirements

Access to the relevant software/application is beneficial (Excel, Power BI, Tableau Desktop, Alteryx, and Qlik Sense)

Basic to intermediate knowledge of Microsoft Excel is needed

An understanding of data analytics is beneficial

Description

** This course bundle includes practice exercises and downloadable data files to work and follow along with, plus LIFETIME access!In this incredible-value, ten-course bundle, learn and master the essential tools to help turn your large complex data into meaningful visualizations that are easier to understand.If you want to start with data analytics and visualization, then this Data Storytelling course bundle is a good place to begin. This bundle includes ten full beginner and advanced courses in Excel PivotTable, Microsoft Power BI, Alteryx, Tableau, and Qlik Sense that will equip you with the best tools to master data visualization techniques.What's included?PivotTables for BeginnersHow to clean and prepare your dataCreating a basic PivotTableUsing the PivotTable fields paneAdding fields and pivoting the fieldsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping PivotTable dataUsing multiple fields and dimensionThe methods of aggregationHow to choose and lock the report layoutApplying PivotTable stylesSorting data and using filtersCreate pivot charts based on PivotTable dataSelecting the right chart for your dataApply conditional formattingAdd slicers and timelines to your dashboardsAdding new data to the original source datasetUpdating PivotTables and chartsAdvanced PivotTablesHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping, and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing-looking dashboardsPower BI for Beginner:What is Power BI and why you should be using it.To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.Power BI Intermediate:Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesAlteryx for Beginners:Using Alteryx workflows to cut out repetitive tasksBuilding visual workflows in AlteryxHow to make the most of 'Favorite Tools' as core Alteryx building blocksFiltering data in AlteryxUsing the basic functions in Alteryx to match dataHow to dynamically rename datasetsHow to parse data in AlteryxCreating reports in Alteryx that run on demandUsing the predictive tools in Alteryx to perform data analysisBuilding a k-centroid clustering model using AlteryxCreating a logistic regression in AlteryxMaking a decision tree-based regression in AlteryxConstructing a random forest-based modelAlteryx Advanced:Using multiple files and CalgarySampling data and using wild matchesData cleansing, manipulation, binning, and groupingUsing RegEx (regular expressions) and parsing XMLWorking with In-DatabaseBlending, selecting, and summarizing dataTake your apps and macros to the next levelUsing iterative and batch macrosUnderstanding app errors and conditionsCustomizing apps and macrosAll about Machine Learning and the Alteryx Intelligence SuiteTableau for Beginners: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 TableauTableau Advanced:Parameters and sample use casesLevel of Detail (LOD) expressionsWorking with groups and setsUse of spatial functionsAdvanced filtersTable calculationsHow to add interactivity using actionsAnimating your visualizationsAdvanced Tableau charts—circular, sunburst, bump, funnel, candlestick, and Sankey chartsBuilding geospatial dashboards and sales dashboardsCreating dashboards that utilize radial chartsQlik Sense for Beginners: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)Qlik Sense AdvancedHow to use system and user-defined variables effectivelyHow to use a variable’s input to create dynamic dimensions and measuresTo maximize the dynamic loading feature to import data from diverse sources in numerous waysTo write powerful and elegant scripts and subroutinesHow to make the most of Qlik Sense’s conditional functions, including Match and Pick and to work with the values the functions return.How to use the Alternate States feature to create and compare visualizationsTo use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboardsTo use geo-analytics and spatial functions to work with location-based dataHow to layer components with functions such as the Bubble, Line, Area, Heatmap, and Geodata Layers.To transform data with Qlik’s toolbox of analytical functions to perform geometric, aggregating, route-based, and look-up operations.This course bundle includes:50+ hours of video tutorials390+ individual video lecturesCertificate of completionCourse and exercise files to help you follow along

Overview

Section 1: Pivot Tables for Beginners: Introduction

Lecture 1 Course Introduction

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

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Support Files

Lecture 5 What are Pivot Tables and Why are They Useful?

Section 2: Pivot Tables for Beginners: Preparing Data for Analysis

Lecture 6 The Importance of Cleaning Data

Lecture 7 Removing Blank Rows

Lecture 8 Removing Duplicate Rows

Lecture 9 Clearing Formatting

Lecture 10 Applying Number Formatting

Lecture 11 Changing the Case

Lecture 12 Removing Spaces and Non-printing Characters

Lecture 13 Merging and Splitting Columns

Lecture 14 Convert Numbers Stored as Text

Lecture 15 Finding and Replacing Text

Lecture 16 Spell Check

Lecture 17 Exercise 01

Section 3: Pivot Tables for Beginners: The Importance of Excel Tables

Lecture 18 Excel Tables vs Pivot Tables

Lecture 19 Format Data as a Table

Lecture 20 Exercise 02

Section 4: Pivot Tables for Beginners: Creating a Basic Pivot Table Report

Lecture 21 Using Recommended Pivot Tables

Lecture 22 Creating a Pivot Table from Scratch

Lecture 23 Pivot Table Ribbons and Fields

Lecture 24 Pivoting the Fields

Lecture 25 Adding Multiple Dimensions

Lecture 26 Deleting Fields and Locking the Report Layout

Lecture 27 Exercise 03

Section 5: Pivot Tables for Beginners: Aggregation and Grouping

Lecture 28 Methods of Aggregation

Lecture 29 Combining Methods of Aggregation

Lecture 30 Grouping and Ungrouping Data

Lecture 31 Exercise 04

Section 6: Pivot Tables for Beginners: Formatting Values

Lecture 32 Applying Number Formatting

Lecture 33 Handling Cells with No Data

Lecture 34 Exercise 05

Section 7: Pivot Tables for Beginners: Layout Options

Lecture 35 Subtotals and Grand Totals

Lecture 36 Choosing a Report Layout

Lecture 37 Inserting Blank Rows

Lecture 38 Exercise 06

Section 8: Pivot Tables for Beginners: Formatting Pivot Tables

Lecture 39 Applying Pivot Table Styles

Lecture 40 Modifying Pivot Table Styles

Lecture 41 Creating a Custom Pivot Table Style

Lecture 42 Exercise 07

Section 9: Pivot Tables for Beginner: Sorting and Filtering

Lecture 43 Sorting Pivot Table Data

Lecture 44 Filtering Pivot Table Data

Lecture 45 Top 10 Filter

Lecture 46 Exercise 08

Section 10: Pivot Tables for Beginners: Creating Pivot Charts

Lecture 47 Selecting the Right Chart Type

Lecture 48 Clustered Column and Bar Charts

Lecture 49 Line Charts

Lecture 50 Pie and Donut Charts

Lecture 51 Map Charts

Lecture 52 Applying Chart Layouts

Lecture 53 Exercise 09

Section 11: Pivot Tables for Beginners: Formatting Pivot Charts

Lecture 54 Adding a Slicer

Lecture 55 Formatting a Slicer

Lecture 56 Adding a Timeline

Lecture 57 Connecting Slicers and Timelines

Lecture 58 Exercise 10

Section 12: Pivot Tables for Beginners: Applying Conditional Formatting

Lecture 59 Highlight Cell Rules

Lecture 60 Data Bars

Lecture 61 Color Scales

Lecture 62 Icon Sets

Lecture 63 Exercise 11

Section 13: Pivot Tables for Beginners: Updating Pivot Tables and Pivot Charts

Lecture 64 Adding Data to the Dataset

Lecture 65 Updating Pivot Tables and Pivot Charts

Lecture 66 Exercise 12

Section 14: Pivot Tables for Beginners: Course Close and Next Steps

Lecture 67 Course Close and Next Steps

Section 15: Advanced Pivot Tables: Introduction

Lecture 68 Introduction to Advanced Pivot Tables

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

Lecture 70 DOWNLOAD ME: Course Exercise Files

Lecture 71 DOWNLOAD ME: Course Support Files

Lecture 72 PivotTables Recap

Section 16: Advanced Pivot Tables: Importing Data

Lecture 73 Importing Data From a Text File

Lecture 74 Importing data from Access

Lecture 75 Exercise 01

Section 17: Advanced Pivot Tables: Preparing Data for Analysis

Lecture 76 Cleaning Data

Lecture 77 Tabular Data

Lecture 78 Exercise 02

Section 18: Advanced Pivot Tables: Creating and Manipulating PivotTables

Lecture 79 Creating and Manipulating a PivotTable

Lecture 80 Combining Data from Multiple Worksheets

Lecture 81 Grouping and Ungrouping

Lecture 82 Report Layouts

Lecture 83 Formatting Error Values and Empty Cells

Lecture 84 Exercise 03

Section 19: Advanced Pivot Tables: Formatting PivotTables

Lecture 85 PivotTable Styles

Lecture 86 Custom Number Formatting

Lecture 87 Exercise 04

Section 20: Advanced Pivot Tables: Value Field Settings

Lecture 88 Summarizing Values

Lecture 89 Show Values As

Lecture 90 Exercise 05

Section 21: Advanced Pivot Tables: Sorting and Filtering

Lecture 91 Advanced Sorting

Lecture 92 Advanced Filtering

Lecture 93 Exercise 06

Section 22: Advanced Pivot Tables: Interacting with PivotTables

Lecture 94 Inserting and Formatting Slicers

Lecture 95 Inserting and Formatting Timelines

Lecture 96 Connecting Slicers to Multiple PivotTables

Lecture 97 Using Slicers in Protected Workbooks

Lecture 98 Exercise 07

Section 23: Advanced Pivot Tables: Calculations

Lecture 99 Creating a Calculated Field

Lecture 100 Creating a Calculated Item

Lecture 101 Solve Order and List Formulas

Lecture 102 GETPIVOTDATA

Lecture 103 Exercise 08

Section 24: Advanced Pivot Tables: Pivot Charts

Lecture 104 Creating a Pivot Chart

Lecture 105 Formatting a Pivot Chart - Part 1

Lecture 106 Formatting a Pivot Chart - Part 2

Lecture 107 Creating a Map Chart using Pivot Data

Lecture 108 Dynamic Chart Titles

Lecture 109 Include a Sparkline with your PivotTable

Lecture 110 Exercise 09

Section 25: Advanced Pivot Tables: Conditional Formatting

Lecture 111 Highlighting Cell Rules

Lecture 112 Graphical Conditional Formats

Lecture 113 Conditional Formatting and Slicers

Lecture 114 Exercise 10

Section 26: Advanced Pivot Tables: Dashboards

Lecture 115 Creating an Interactive Dashboard - Part 1

Lecture 116 Creating an Interactive Dashboard - Part 2

Lecture 117 Updating Pivot Charts and PivotTables

Lecture 118 Exercise 11

Section 27: Advanced Pivot Tables: Course Close

Lecture 119 Course Close

Section 28: Power BI for Beginners: Introduction

Lecture 120 Welcome and Overview

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

Lecture 122 DOWNLOAD ME: Course Demo Files (Section 2-4)

Lecture 123 DOWNLOAD ME: Course Demo Files (Section 5-8)

Lecture 124 DOWNLOAD ME: Course Exercise File

Lecture 125 DOWNLOAD ME: Course Transcript

Lecture 126 What is Power BI?

Lecture 127 Install Power BI Desktop

Lecture 128 A Tour of BI Desktop

Lecture 129 Explore Commonly Used Power BI Options

Section 29: Power BI for Beginners: Getting and Transforming Data

Lecture 130 Import Files from a Folder into Power BI Desktop

Lecture 131 Get Data from Excel and Text Files

Lecture 132 Changing Query Source

Lecture 133 Reference Queries to Create Additional Lookup Tables

Lecture 134 Merge Queries in Power Query

Lecture 135 Prevent Queries from Loading into Power BI Desktop

Lecture 136 Practise Exercise

Section 30: Power BI for Beginners: Data Modelling

Lecture 137 Create Relationships Between Tables

Lecture 138 Create a Dynamic List of Dates

Lecture 139 Create Additional Date Columns for Analysis

Lecture 140 Sort the Month and Weekday Names Correctly

Lecture 141 Mark the Table as a Date Table

Lecture 142 Hide Unnecessary Fields from Report View

Lecture 143 Practise Exercise

Section 31: Power BI for Beginners: Introduction to DAX Measures

Lecture 144 Calculate the Total Revenue

Lecture 145 Count the Total Rows of a Table

Lecture 146 Use the CALCULATE Function

Lecture 147 Calculate the Total Revenue Last Year

Lecture 148 Difference Compared to Last Year

Lecture 149 Practise Exercise

Section 32: Power BI for Beginners: Adding Visualizations to your Report

Lecture 150 Show Summary Information with Cards

Lecture 151 Columns Charts to Compare Values

Lecture 152 Map Visual to Plot Geographic Data

Lecture 153 Slicers to Filter your Reports

Lecture 154 KPI Card to Measure Performance Against a Goal

Lecture 155 Line Graphs to Visualise Trend

Lecture 156 Show Detail with the Matrix

Lecture 157 Top N Lists with the Table Visualisation

Lecture 158 Practise Exercise

Section 33: Power BI for Beginners: Report Design

Lecture 159 Adding Text Boxes and Shapes

Lecture 160 Use Themes

Lecture 161 Conditional Formatting

Lecture 162 Practise Exercise

Section 34: Power BI for Beginners: Editing Interactions and Filters

Lecture 163 Edit the Interactions Between your Visualisations

Lecture 164 The Filter Pane to Filter at Any Level

Lecture 165 Drill Through to More Detail

Lecture 166 Practise Exercise

Section 35: Power BI for Beginners: Power BI Service

Lecture 167 Publish Your Report to the Power BI Service

Lecture 168 Different Ways to Share your Power BI Report

Lecture 169 Practise Exercise

Section 36: Power BI for Beginners: Closing

Lecture 170 Wrap Up

Section 37: Power BI Intermediate: Introduction

Lecture 171 Course Introduction

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

Lecture 173 DOWNLOAD ME: Course Instructor File

Lecture 174 DOWNLOAD ME: Course Transcript

Lecture 175 Setting Up for Success

Section 38: Power BI Intermediate: Importing and Transforming Data in Power Query

Lecture 176 Importing Excel Data Files from a Folder

Lecture 177 Combining Files and Removing Columns

Lecture 178 Splitting and Merging Columns

Lecture 179 Applying Data Types

Lecture 180 Importing Text and CSV Files

Lecture 181 Relationships and Lookup Tables

Lecture 182 Duplicate vs Reference

Lecture 183 Creating a Lookup Table

Lecture 184 Creating Index Columns

Lecture 185 Merging Queries

Lecture 186 Enable/Disable Load and Report Refresh

Lecture 187 Advanced Editor

Lecture 188 Resolving Data Import Errors

Lecture 189 Organizing Queries into Groups

Section 39: Power BI Intermediate: Data Modeling

Lecture 190 Troubleshooting Relationship Issues

Lecture 191 Relationship Types

Lecture 192 Cross Filter Direction

Section 40: Power BI Intermediate: DAX - Essential Skills

Lecture 193 Measures vs Calculated Columns

Lecture 194 Creating a Date Table with DAX

Lecture 195 Creating Additional Columns

Lecture 196 Creating Conditional Columns

Lecture 197 Marking Table as a Date Table

Lecture 198 Using ROUNDUP to Extract Quarters

Lecture 199 Creating Quick Measures

Lecture 200 Creating a Key Measures Table

Lecture 201 Aggregation Methods

Lecture 202 Using SUMX

Section 41: Power BI Intermediate: DAX - CALCULATE Function

Lecture 203 The CALCULATE Function

Lecture 204 Changing Context with FILTER

Lecture 205 Using ALL with CALCULATE

Section 42: Power BI Intermediate: Visualizations

Lecture 206 Visualizations

Lecture 207 Tables vs Matrix Tables

Lecture 208 Formatting Visualizations - Part 1

Lecture 209 Formatting Visualizations - Part 2

Lecture 210 Conditional Formatting

Lecture 211 Column and Line Charts

Lecture 212 Card Visualizations

Lecture 213 Map Charts

Lecture 214 The Gauge Visualization

Lecture 215 Slicers and Filter

Lecture 216 Applying Design Elements

Section 43: Power BI Intermediate: The Power BI Service

Lecture 217 Creating a Shared Workspace in Power BI Service

Lecture 218 Inviting Others to a Shared Workspace

Lecture 219 Reports vs Dashboards

Lecture 220 Pinning Visualizations to the Dashboard

Lecture 221 Setting up Scheduled Refreshes

Section 44: Power BI Intermediate: Orders Dashboard Example - Preparation

Lecture 222 Orders Dashboard Example

Lecture 223 Report Requirements

Lecture 224 Importing Order Data

Section 45: Power BI Intermediate: Orders Dashboard Example - Transformation

Lecture 225 Transforming Order Data in Power Query

Lecture 226 Creating Lookup Tables

Lecture 227 Merging Queries

Lecture 228 Creating a Dates Table

Lecture 229 Creating DAX Measures

Section 46: Power BI Intermediate: Orders Dashboard Example - Report

Lecture 230 Adding a Report Title

Lecture 231 Report Navigation with Buttons and Bookmarks

Lecture 232 Card Visualizations and Filtering

Lecture 233 Line Chart: Count of Male vs Female Customers

Lecture 234 Stacked Column Chart: Total Revenue by Region

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

Lecture 236 Funnel Chart: Age Distribution

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

Lecture 238 Adding Conditional Formatting

Section 47: Power BI Intermediate: Orders Dashboard Example: Dashboard

Lecture 239 Publishing the Report to the Power BI Service

Lecture 240 Pinning Media Tiles to Dashboard

Section 48: Power BI Intermediate: Course Close

Lecture 241 Course Close

Section 49: Alteryx for Beginners: Introduction

Lecture 242 Introduction Video

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

Lecture 244 DOWNLOAD ME: Course Instructor Files

Lecture 245 Alteryx Essentials

Lecture 246 Data Types 101

Lecture 247 Components of Alteryx Workflow

Lecture 248 Formatting Your Data

Lecture 249 Basic Workflow Examples

Section 50: Alteryx for Beginners: Data Blend & Prep

Lecture 250 Data Filtering for Beginners

Lecture 251 Intro to Blending Data

Lecture 252 Grouping Data with Alteryx

Lecture 253 Introduction to Basic Functions - Part 1

Lecture 254 Introduction to Basic Functions - Part 2

Lecture 255 Introduction to Basic Functions - Part 3

Section 51: Alteryx for Beginners: Data Parsing

Lecture 256 Basic Parsing Methods

Lecture 257 Basic Parsing Methods w/ Dynamic Renaming

Lecture 258 Basic Vlookup and Append

Lecture 259 Working on Multiple Fields in Alteryx

Lecture 260 Build an Alteryx Workflow

Lecture 261 Basic Tips and Tricks

Section 52: Alteryx for Beginners: Reporting

Lecture 262 Alteryx Best Practices - Visualizing Data

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

Lecture 264 Alteryx Best Practices - Layouts and Rendering

Section 53: Alteryx for Beginners: Analytic Apps

Lecture 265 Introduction to Analytic Apps

Lecture 266 Introduction to Macros

Section 54: Alteryx for Beginners: Spatial Data Analysis

Lecture 267 Intro to Data Analysis - Working Spatial Data

Lecture 268 Intro to Data Analysis - Measuring Areas and Distance

Lecture 269 Intro to Data Analysis - Working Spatial Objects

Section 55: Alteryx for Beginners: Analytics

Lecture 270 Introduction to Analytics

Lecture 271 Introduction tok-centroid clustering

Lecture 272 Introduction to k-nearest neighbor

Lecture 273 Introduction to market basket analysis

Lecture 274 Introduction to logistic regression analysis

Lecture 275 Introduction to linear regression analysis

Lecture 276 Introduction to tree-based models part 1

Lecture 277 Introduction to tree-based models part 2

Section 56: Alteryx for Beginners: Course Close

Lecture 278 Course Close Video

Section 57: Alteryx Advanced: Data Cleansing & Manipulation

Lecture 279 Introduction to the Course

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

Lecture 281 DOWNLOAD ME: Course Exercise Files

Lecture 282 DOWNLOAD ME: Course Instructor Files

Lecture 283 Using Multiple Files & Calgary

Lecture 284 Sampling

Lecture 285 Tiles & Binning

Lecture 286 Cleaning

Lecture 287 Wild Matches & Grouping

Lecture 288 RegEx & Parsing XML

Lecture 289 Gathering Numbers

Section 58: Alteryx Advanced: Working in Database

Lecture 290 In-Database

Lecture 291 Blending

Lecture 292 Select & Summarize

Section 59: Alteryx Advanced: Apps & Macros

Lecture 293 Level-up Your Apps & Macros Part 1

Lecture 294 Level-up Your Apps & Macros Part 2

Lecture 295 Batch Macros

Lecture 296 App Errors & Conditions

Lecture 297 App & Macro Customization

Section 60: Alteryx Advanced: Intelligence Suite

Lecture 298 Machine Learning Part 1

Lecture 299 Machine Learning Part 2

Lecture 300 Machine Learning Part 3

Lecture 301 Machine Learning Part 4

Lecture 302 Machine Learning Part 5

Section 61: Alteryx Advanced: Exercises and Course Close

Lecture 303 Exercise 1

Lecture 304 Exercise 2

Lecture 305 Exercise 3

Lecture 306 Exercise 4

Lecture 307 Exercise 5

Lecture 308 Ending Video

Section 62: Tableau for Beginners: Introduction to Tableau

Lecture 309 Course Introduction

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

Lecture 311 DOWNLOAD ME: Course Exercise Files

Lecture 312 Tableau Introduction

Lecture 313 Tableau Product Suite Introduction

Lecture 314 Business Intelligence Introduction

Lecture 315 Exploring Tableau

Lecture 316 Tableau Data Concepts

Lecture 317 Connecting to Data Sources

Lecture 318 Data Sources in Tableau

Lecture 319 Tableau Workspace

Lecture 320 Creating a New View

Lecture 321 Using Multiple Data Sources

Lecture 322 Exercise 1

Section 63: Tableau for Beginners: Bringing Data to Life

Lecture 323 Selecting a Chart Type Part1

Lecture 324 Selecting a Chart Type Part2

Lecture 325 Building a View Part1

Lecture 326 Building a View Part2

Lecture 327 Designing Callout Numbers and Tables

Lecture 328 Histograms and Whisker Plots

Lecture 329 Scatter Plot and Correlation Matrix

Lecture 330 Spatial Charts

Lecture 331 Creating a Dashboard

Lecture 332 Presenting a Story

Lecture 333 Publishing and Sharing a Workbook

Lecture 334 Exercise 2

Lecture 335 Exercise 3

Section 64: Tableau for Beginners: Calculations and Expressions in Tableau

Lecture 336 Using Expressions in Tableau

Lecture 337 Numeric Expressions and Automatic Calculations

Lecture 338 String Expressions

Lecture 339 Conditional Expressions

Lecture 340 Analytical Functions

Lecture 341 Exercise 4

Lecture 342 Exercise 5

Section 65: Tableau for Beginners: Conclusion

Lecture 343 Course Conclusion

Section 66: Tableau Advanced: Intro and Advanced Calculations & Functions

Lecture 344 Welcome to the Course

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

Lecture 346 DOWNLOAD ME: Course Exercise Files

Lecture 347 DOWNLOAD ME: Course Instructor Files

Lecture 348 Advancing in Tableau

Lecture 349 Parameters Part 1

Lecture 350 Parameters Part 2

Lecture 351 Level of Detail Expressions

Lecture 352 Groups & Sets

Lecture 353 Spatial Functions

Lecture 354 Geospatial Charts Part 1

Lecture 355 Geospatial Charts Part 2

Lecture 356 Advanced Filters

Lecture 357 Table Calculations

Lecture 358 Table Calculations Examples

Section 67: Tableau Advanced: Improving Dashboards

Lecture 359 Actions

Lecture 360 Animating your Visualization

Lecture 361 Advanced Tableau Charts Part 1

Lecture 362 Advanced Tableau Charts Part 2

Lecture 363 Advanced Tableau Charts Part 3

Lecture 364 Visual Analytics Best Practices

Lecture 365 Geospatial Dashboard

Lecture 366 Marketing Dashboard Part 1

Lecture 367 Marketing Dashboard Part 2

Lecture 368 Sales Dashboard

Section 68: Tableau Advanced: Exercise & Conclusion

Lecture 369 Exercise 1

Lecture 370 Exercise 2

Lecture 371 Exercise 3

Lecture 372 Exercise 4

Lecture 373 Exercise 5

Lecture 374 Ending Video

Section 69: Qlik Sense Beginners: Introduction to Qlik Sense

Lecture 375 Introcuction to the Course

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

Lecture 377 DOWNLOAD ME: Course Exercise and Instructor Files

Lecture 378 What is Qlik Sense?

Lecture 379 Qlik Sense vs. QlikView

Lecture 380 Different versions of Qlik Sense

Lecture 381 Exploring the Qlik Sense Interface

Lecture 382 Loading Data P1

Lecture 383 Loading Data P2

Lecture 384 Creating & Loading Apps

Lecture 385 Adding your First Chart

Lecture 386 Editing your Visualization P1

Lecture 387 Editing your Visualization P2

Lecture 388 Publishing and Sharing Apps

Lecture 389 Exercise 1 - Loading Data

Section 70: Qlik Sense Beginners: Beginners Guide to Visualization

Lecture 390 Data Assets in Visualization P1

Lecture 391 Data Assets in Visualization P2

Lecture 392 Types of Charts & Graphs P1

Lecture 393 Types of Charts & Graphs P2

Lecture 394 Types of Charts & Graphs P3

Lecture 395 Types of Charts & Graphs P4

Lecture 396 Types of Charts & Graphs P5

Lecture 397 Generating Insights and Analysis

Lecture 398 Exercise 2 - Build a Chart

Lecture 399 Exercise 3 - Types of Charts and Graphs

Section 71: Qlik Sense Beginners: Scripting Basics

Lecture 400 Aggregations

Lecture 401 Functions & Expressions P1

Lecture 402 Functions & Expressions P2

Lecture 403 Date and Time Formatting

Lecture 404 Conditional Functions

Lecture 405 Data Load Script

Lecture 406 Join, Keep, and Concatenate Prefixes

Lecture 407 Set Analysis

Lecture 408 Exercise 4 - Numeric and String Functions

Lecture 409 Exercise 5 - Inner Join

Section 72: Qlik Sense Beginners: GeoAnalytics

Lecture 410 Geo Analytics in Qlik Sense

Section 73: Qlik Sense Beginners: Course Conclusion

Lecture 411 Qlik Sense Course Conclusion

Section 74: Qlik Sense Advanced: Advanced Scripting & Functions

Lecture 412 Course Introduction

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

Lecture 414 DOWNLOAD ME: Course Exercise Files

Lecture 415 DOWNLOAD ME: Course Instructor Files

Lecture 416 Introduction to Variables

Lecture 417 Uses of Variables

Lecture 418 Dynamic Loading Part 1

Lecture 419 Dynamic Loading Part 2

Lecture 420 Script Files & Sub-routines

Lecture 421 Advanced Script Functions

Section 75: Qlik Sense Advanced: Step Up Your Visualization

Lecture 422 Alternate States

Lecture 423 Customizing Dashboards with CSS

Lecture 424 Using Geoanalytics for Spatial Data Part 1

Lecture 425 Using Geoanalytics for Spatial Data Part 2

Section 76: Qlik Sense Advanced: Exercises & Course Close

Lecture 426 Exercise 1

Lecture 427 Exercise 2

Lecture 428 Course Close

Data Analysts and Data Scientists,Anyone looking to turn raw data into meaningful business visualizations,People looking to perform Data Analysis using Excel,People who are brand-new to PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense,Users who have a foundation in PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense and are seeking to advance their skills,Business Intelligence Analysts