Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Ultimate Data Analytics and Visualization Bundle: 10 Courses

Name: Ultimate Data Analytics and Visualization Bundle: 10 Courses
Rating: 4.7 (87 reviews)

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

Created bySimon Sez IT

Last updated 3/2026

English

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)

Course content

76 sections • 428 lectures • 53h 52m total length

Course Introduction5:10
Learn pivot tables for data analysis in Excel, from cleaning data to building pivot charts and dashboards with slicers and timelines.
WATCH ME: Essential Information for a Successful Training Experience2:11
DOWNLOAD ME: Course Exercise Files0:23
DOWNLOAD ME: Course Support Files0:23
What are Pivot Tables and Why are They Useful?6:12
Explore how pivot tables dynamically summarize large data sets in Excel, turning data into actionable insights. See pivot charts and dashboards visualize profit and units sold across regions and countries.
Section Quiz

The Importance of Cleaning Data3:05
Clean data in Excel before analyzing with a pivot table, tidy up data sets to ensure consistent formatting, and remove blanks and duplicates for accurate results.
Removing Blank Rows5:30
Learn to clean data by removing blank rows before pivot table analysis, using go to special to select blanks and delete sheet rows quickly, and auto-fit columns for readability.
Removing Duplicate Rows2:37
Identify and remove exact duplicate rows in a data set using Excel's remove duplicates tool, selecting all columns and confirming header options to prevent data issues.
Clearing Formatting4:26
Learn how to tidy Excel worksheets by clearing formatting to remove shading, bold, italics, and other styles, returning data to plain text and values, then reapply formatting as needed.
Applying Number Formatting8:38
Learn how to apply text, date, number, currency, and accounting formatting in Excel to improve readability, using format cells, keyboard shortcuts, and currency alignment.
Changing the Case9:16
Learn to tidy text in Excel by converting case with upper, lower, and proper functions, using a helper column, and pasting values to replace formulas.
Removing Spaces and Non-printing Characters10:06
Clean messy Excel data by removing spaces and non-printing characters with trim and clean. Learn to combine formulas, convert case, and paste values to produce clean, pivot-ready columns.
Merging and Splitting Columns13:00
Convert Numbers Stored as Text2:28
Learn to fix numbers stored as text after importing data by recognizing left-aligned values with a green triangle, then convert to number or use the value function.
Finding and Replacing Text6:07
Spell Check3:57
Run a spell check on worksheets to prevent pivot tables from misclassifying misspellings. Open spell checker with F7, adjust language, and change or add words to the dictionary.
Exercise 014:01
Section Quiz

Using Recommended Pivot Tables5:29
Learn to use Excel's recommended pivot tables to summarize data by region or item type, with sums of unit price, unit cost, revenue, and profit.
Creating a Pivot Table from Scratch5:45
Create a pivot table from scratch using a sales data table, choose a data source, and place it on a new worksheet; rename sheets and use the table design ribbon.
Pivot Table Ribbons and Fields6:39
Learn to use the pivot table ribbons—design and analyze—to customize styles and layout, manage the field list, and drag fields into filters, columns, rows, or values for analysis.
Pivoting the Fields5:32
Adding Multiple Dimensions2:48
Discover how to create multi dimensional pivot tables by adding and removing fields, analyzing regions, sales channels, item types, and order priorities with filters.
Deleting Fields and Locking the Report Layout3:41
Exercise 031:37
Section Quiz

Methods of Aggregation4:09
Combining Methods of Aggregation5:37
Combine methods of aggregation in a pivot table to extend analysis beyond source data, showing sum, average, max, and min of profit and unit price by region and item type.
Grouping and Ungrouping Data9:45
Learn to group and ungroup pivot table data in Excel, including automatic date grouping into years and quarters, and create custom groups like food and drink using group selection.
Exercise 043:23
Learn to aggregate data in a pivot table by adding average, min, and max gross sales, renaming them to average, min, and max sales, and creating Luxe and Premium groups.
Section Quiz

Applying Number Formatting4:45
Apply consistent number formatting in pivot tables by using value field settings to apply accounting formatting with two decimal places and a currency symbol, ensuring formatting moves with numbers.
Handling Cells with No Data4:00
Master handling empty cells in pivot tables by replacing blanks with zeros. Learn to adjust pivot table options and layout to show zeros and stabilize pivot charts.
Exercise 052:18
Apply accounting number formatting with zero decimal places and a US dollar symbol to all pivot table value columns, and configure pivot table options to display zero for empty cells.
Section Quiz

Subtotals and Grand Totals4:27
Master pivot table layout by configuring subtotals and grand totals in the design tab, choosing bottom versus top subtotals and rows or columns grand totals, or turning them off.
Choosing a Report Layout4:44
Adjust pivot table report layout with compact, outline, and tabular forms to optimize readability and subtotals placement. Learn how repeat item labels and grid lines affect readability and chart creation.
Inserting Blank Rows2:14
Exercise 061:58
Section Quiz

Applying Pivot Table Styles4:15
Explore pivot table styles to quickly format data visuals. Apply built-in light, medium, and dark styles, preview changes live, and adjust options like row headers, column headers, and banded rows.
Modifying Pivot Table Styles4:19
Modify a pivot table style by duplicating it to create a custom design. Adjust borders, header and row colors, and italicize fonts, then apply the new style.
Creating a Custom Pivot Table Style5:37
Create a custom pivot table style from scratch with the new pivot table style option, then copy it between workbooks using a simple workaround.
Exercise 073:30
Apply the light blue pivot style and enable banded rows; duplicate and modify to add dark blue borders and a first row fill, then apply to the pivot table.
Section Quiz

Sorting Pivot Table Data8:31
Sort pivot table data to organize by region, item type, and profit, using ascending, descending, manual orders, or custom lists, with sorting options and refresh.
Filtering Pivot Table Data7:20
Filter pivot table data by region and item type using label and value filters, with wildcards and contains, then clear filters or enable multiple filters per field.
Top 10 Filter3:31
Exercise 081:57
Practice sorting and filtering a pivot table by removing the product field, sorting country descending, and filtering to the top three countries by gross sales and Lux range.
Section Quiz

Selecting the Right Chart Type8:40
Choose the right chart type to visualize pivot table data, compare profits with column or bar charts, and use line, donut, and map charts to reveal trends and geography.
Clustered Column and Bar Charts13:40
Create clustered column and bar charts from pivot tables in Excel, using top ten and top five filters, sorting, removing grand totals, and applying basic formatting for clarity.
Line Charts9:55
Create a line chart from existing pivot table data for time series, rearranging fields, then format with a chart title, currency axis, a 1.5 million minimum, and markers.
Pie and Donut Charts11:31
Learn to insert and format donut and pie charts from pivot table data, grouping by cancelled and active orders and adding data labels for clear visual analysis.
Map Charts8:47
Applying Chart Layouts3:06
Use Excel's quick chart layouts to apply multiple chart elements at once, such as axes, titles, legends, data labels, and gridlines, across column, line, and donut charts.
Exercise 094:07
Section Quiz

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

50+ hours of video tutorials
390+ individual video lectures
Certificate of completion
Course and exercise files to help you follow along

Who this course is for:

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

Ultimate Data Analytics and Visualization Bundle: 10 Courses

What you'll learn

Explore related topics

Course content

Pivot Tables for Beginners: Introduction5 lectures • 14min

Pivot Tables for Beginners: Preparing Data for Analysis12 lectures • 1hr 13min

Pivot Tables for Beginners: The Importance of Excel Tables3 lectures • 16min

Pivot Tables for Beginners: Creating a Basic Pivot Table Report7 lectures • 32min

Pivot Tables for Beginners: Aggregation and Grouping4 lectures • 23min

Pivot Tables for Beginners: Formatting Values3 lectures • 11min

Pivot Tables for Beginners: Layout Options4 lectures • 13min

Pivot Tables for Beginners: Formatting Pivot Tables4 lectures • 18min

Pivot Tables for Beginner: Sorting and Filtering4 lectures • 21min

Pivot Tables for Beginners: Creating Pivot Charts7 lectures • 1hr

Requirements

Description

Who this course is for: