Ultimate Data Analytics and Visualization Bundle: 10 Courses

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 Beginners

• How to clean and prepare your data

• Creating a basic PivotTable

• Using the PivotTable fields pane

• Adding fields and pivoting the fields

• Formatting numbers in PivotTable

• Different ways to summarize data

• Grouping PivotTable data

• Using multiple fields and dimension

• The methods of aggregation

• How to choose and lock the report layout

• Applying PivotTable styles

• Sorting data and using filters

• Create pivot charts based on PivotTable data

• Selecting the right chart for your data

• Apply conditional formatting

• Add slicers and timelines to your dashboards

• Adding new data to the original source dataset

• Updating PivotTables and charts

Advanced PivotTables

• How to do a PivotTable (a quick refresher)

• How to combine data from multiple worksheets for a PivotTable

• Grouping, ungrouping, and dealing with errors

• How to format a PivotTable, including adjusting styles

• How to use the Value Field Settings

• Advanced Sorting and Filtering in PivotTables

• How to use Slicers, Timelines on multiple tables

• How to create a Calculated Field

• All about GETPIVOTDATA

• How to create a Pivot Chart and add sparklines and slicers

• How to use 3D Maps from a PivotTable

• How to update your data in a PivotTable and Pivot Chart

• All about Conditional Formatting in a PivotTable

• How to create amazing-looking dashboards

Power 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 Query

• Importing Excel, text, and CSV files and combining files

• Enabling/disabling load and report refresh

• Resolving data import errors

• Data modeling, relationship types, and troubleshooting relationship issues

• Measures vs. calculated columns

• Creating a date table with DAX

• Creating additional and conditional columns

• Using the ROUNDUP and SUMX functions

• Creating quick measures and key measures tables

• The DAX - CALCULATE function

• Tables vs. matrix tables

• Formatting visualizations and applying conditional formatting

• Using column, line, and map charts

• Gauge and card visualizations

• Using slicers and filters and applying design elements

• Creating a shared workspace in Power BI service

• Building reports and dashboards

• Pinning visualizations to the dashboard

• Setting up scheduled refreshes

Alteryx for Beginners:

• Using Alteryx workflows to cut out repetitive tasks

• Building visual workflows in Alteryx

• How to make the most of 'Favorite Tools' as core Alteryx building blocks

• Filtering data in Alteryx

• Using the basic functions in Alteryx to match data

• How to dynamically rename datasets

• How to parse data in Alteryx

• Creating reports in Alteryx that run on demand

• Using the predictive tools in Alteryx to perform data analysis

• Building a k-centroid clustering model using Alteryx

• Creating a logistic regression in Alteryx

• Making a decision tree-based regression in Alteryx

• Constructing a random forest-based model

Alteryx Advanced:

• Using multiple files and Calgary

• Sampling data and using wild matches

• Data cleansing, manipulation, binning, and grouping

• Using RegEx (regular expressions) and parsing XML

• Working with In-Database

• Blending, selecting, and summarizing data

• Take your apps and macros to the next level

• Using iterative and batch macros

• Understanding app errors and conditions

• Customizing apps and macros

• All about Machine Learning and the Alteryx Intelligence Suite

Tableau for Beginners:

• What Tableau is and the product suite

• What business intelligence is

• The Tableau interface and its major functions

• Which data structures are suitable for Tableau

• How Tableau reads and categorizes data

• Different data concepts and theory

• How to connect and manage data sources in Tableau

• How to navigate the Tableau workspace

• 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 calculated fields in Tableau

• How to use numeric, string, conditional, and analytical expressions/functions in Tableau

Tableau Advanced:

• Parameters and sample use cases

• Level of Detail (LOD) expressions

• Working with groups and sets

• Use of spatial functions

• Advanced filters

• Table calculations

• How to add interactivity using actions

• Animating your visualizations

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

• Building geospatial dashboards and sales dashboards

• Creating dashboards that utilize radial charts

Qlik Sense for Beginners:

• The difference between Qlik Sense and Qlik View

• 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

• All about Tables and Pivot Tables in Qlik Sense

• How to create your analysis in the Story Telling tab

• About numeric and string functions in Qlik Sense

• How to use the date and time formatting functions

• How to use Conditional Functions

• How to combine tables using JOIN, KEEP and CONCATENATE

• How to use different charts and tables

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

Qlik Sense Advanced

• How to use system and user-defined variables effectively

• How to use a variable’s input to create dynamic dimensions and measures

• To maximize the dynamic loading feature to import data from diverse sources in numerous ways

• To write powerful and elegant scripts and subroutines

• How 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 visualizations

• To use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboards

• To use geo-analytics and spatial functions to work with location-based data

• How 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:

1. 50+ hours of video tutorials

2. 390+ individual video lectures

3. Certificate of completion

4. Course and exercise files to help you follow along