Ultimate Data Analytics and Visualization Bundle: 10 Courses

Ultimate Data Analytics and Visualization Bundle: 10 Courses, available at $64.99, has an average rating of 4.65, with 428 lectures, 59 quizzes, based on 18 reviews, and has 208 subscribers.

You will learn about 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) This course is ideal for individuals who are Data Analysts and Data Scientists or Anyone looking to turn raw data into meaningful business visualizations or People looking to perform Data Analysis using Excel or People who are brand-new to PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense or Users who have a foundation in PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense and are seeking to advance their skills or Business Intelligence Analysts It is particularly useful for Data Analysts and Data Scientists or Anyone looking to turn raw data into meaningful business visualizations or People looking to perform Data Analysis using Excel or People who are brand-new to PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense or Users who have a foundation in PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense and are seeking to advance their skills or Business Intelligence Analysts.

Enroll now: Ultimate Data Analytics and Visualization Bundle: 10 Courses

Summary

Title: Ultimate Data Analytics and Visualization Bundle: 10 Courses

Price: $64.99

Average Rating: 4.65

Number of Lectures: 428

Number of Quizzes: 59

Number of Published Lectures: 428

Number of Published Quizzes: 59

Number of Curriculum Items: 487

Number of Published Curriculum Objects: 487

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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)

Who Should Attend

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

Target Audiences

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

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+ hoursof video tutorials
390+ individual videolectures
Certificate of completion
Course and exercise filesto help you follow along

Course Curriculum

Chapter 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?

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

Lecture 1: The Importance of Cleaning Data

Lecture 2: Removing Blank Rows

Lecture 3: Removing Duplicate Rows

Lecture 4: Clearing Formatting

Lecture 5: Applying Number Formatting

Lecture 6: Changing the Case

Lecture 7: Removing Spaces and Non-printing Characters

Lecture 8: Merging and Splitting Columns

Lecture 9: Convert Numbers Stored as Text

Lecture 10: Finding and Replacing Text

Lecture 11: Spell Check

Lecture 12: Exercise 01

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

Lecture 1: Excel Tables vs Pivot Tables

Lecture 2: Format Data as a Table

Lecture 3: Exercise 02

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

Lecture 1: Using Recommended Pivot Tables

Lecture 2: Creating a Pivot Table from Scratch

Lecture 3: Pivot Table Ribbons and Fields

Lecture 4: Pivoting the Fields

Lecture 5: Adding Multiple Dimensions

Lecture 6: Deleting Fields and Locking the Report Layout

Lecture 7: Exercise 03

Chapter 5: Pivot Tables for Beginners: Aggregation and Grouping

Lecture 1: Methods of Aggregation

Lecture 2: Combining Methods of Aggregation

Lecture 3: Grouping and Ungrouping Data

Lecture 4: Exercise 04

Chapter 6: Pivot Tables for Beginners: Formatting Values

Lecture 1: Applying Number Formatting

Lecture 2: Handling Cells with No Data

Lecture 3: Exercise 05

Chapter 7: Pivot Tables for Beginners: Layout Options

Lecture 1: Subtotals and Grand Totals

Lecture 2: Choosing a Report Layout

Lecture 3: Inserting Blank Rows

Lecture 4: Exercise 06

Chapter 8: Pivot Tables for Beginners: Formatting Pivot Tables

Lecture 1: Applying Pivot Table Styles

Lecture 2: Modifying Pivot Table Styles

Lecture 3: Creating a Custom Pivot Table Style

Lecture 4: Exercise 07

Chapter 9: Pivot Tables for Beginner: Sorting and Filtering

Lecture 1: Sorting Pivot Table Data

Lecture 2: Filtering Pivot Table Data

Lecture 3: Top 10 Filter

Lecture 4: Exercise 08

Chapter 10: Pivot Tables for Beginners: Creating Pivot Charts

Lecture 1: Selecting the Right Chart Type

Lecture 2: Clustered Column and Bar Charts

Lecture 3: Line Charts

Lecture 4: Pie and Donut Charts

Lecture 5: Map Charts

Lecture 6: Applying Chart Layouts

Lecture 7: Exercise 09

Chapter 11: Pivot Tables for Beginners: Formatting Pivot Charts

Lecture 1: Adding a Slicer

Lecture 2: Formatting a Slicer

Lecture 3: Adding a Timeline

Lecture 4: Connecting Slicers and Timelines

Lecture 5: Exercise 10

Chapter 12: Pivot Tables for Beginners: Applying Conditional Formatting

Lecture 1: Highlight Cell Rules

Lecture 2: Data Bars

Lecture 3: Color Scales

Lecture 4: Icon Sets

Lecture 5: Exercise 11

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

Lecture 1: Adding Data to the Dataset

Lecture 2: Updating Pivot Tables and Pivot Charts

Lecture 3: Exercise 12

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

Lecture 1: Course Close and Next Steps

Chapter 15: Advanced Pivot Tables: Introduction

Lecture 1: Introduction to Advanced Pivot Tables

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

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 9 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu