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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024