OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

Complete Introduction to Amazon QuickSight

Ian Littlejohn

Amazon QuickSight is a cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights to the people who you work with, wherever they are. Amazon QuickSight connects to your data in the cloud and combines data from many different sources so that you can build visualizations, perform ad hoc analysis, and get business insights from your data. It can scale to hundreds of thousands of users and delivers responsive performance by using a robust in-memory engine (SPICE).

Read more

Amazon QuickSight is a cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights to the people who you work with, wherever they are. Amazon QuickSight connects to your data in the cloud and combines data from many different sources so that you can build visualizations, perform ad hoc analysis, and get business insights from your data. It can scale to hundreds of thousands of users and delivers responsive performance by using a robust in-memory engine (SPICE).

I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.

WHAT STUDENTS ARE SAYING

  • Excellent course - I started out knowing nothing and now feel confident that I can go into QuickSight and use it quite competently.

  • Ian is really clear and has an easy-going way of teaching. His course is really complete and practical on how to use this service and I'd totally recommend that.

  • Great course. Instructor took the topics and was able to translate them to be very easily understood. Would highly recommend.

With the right skills and a proactive approach, a data analyst can reach unprecedented heights. I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.

Microsoft Excel

  • Introduction to Analyzing Data with Excel Pivot Tables

  • Complete Introduction to Excel Power Pivot

  • Complete Introduction to Excel Power Query

  • Excel Interactive Dashboards and Data Analysis

  • Complete Introduction to Business Data Analysis

  • Tables and Formulas with Excel

Microsoft Power BI

  • Complete Introduction to Microsoft Power BI

  • Complete Introduction to Power BI Query Editor

  • Power BI Master Class-Data Models and DAX Formulas

  • Power BI Master Class - Dashboards and Power BI Service

Google

  • Complete Introduction to Google Sheets Pivot Tables

  • Complete Introduction to Looker Studio (formerly Google Data Studio)

Amazon QuickSight

  • Complete Introduction to Amazon QuickSight

ChatGPT

  • Introduction to Analyzing Data with ChatGPT

Enroll now

What's inside

Learning objectives

  • Enjoy clear and concise step by step lessons from a best selling udemy instructor in full hd 1080 p video
  • Quickest and easiest method to learn aws quicksight with a best selling udemy instructor
  • Create powerful analysis, reports and insight from data in minutes
  • Create table calculations for percentages, running totals, ranking and difference from
  • Learn different types of visualizations to understand your data
  • Load and prepare your data for analysis using aws quicksight tools
  • Create relationships between data for enhanced analysis

Syllabus

Introduction

Introduction to the course - Complete Introduction to AWS QuickSight

Information about the course and how the course runs

Read more

Learn how to login and start with AWS QuickSight

Download the files that we use in the lessons for the course

Learn to load data into AWS QuickSight.  QuickSight uses an online database called SPICE

An overview of the QuickSight interface and different sections of the software

Learn to create tables using QuickSight

Introduction to Tables section

Learn how to create tables in QuickSight

Learn how to sort and format tables

Practical activity on creating tables

The answers to the practical activity for tables

Learn how to easily calculate different methods of aggregation - average, highest value, lowest value and counts

Practical activity for methods of aggregation including, averages, highest value, lowest value and count

The answers to the practical activity for methods of aggregation exercise

Learn how to use cross filtering.  Cross filtering allows you to filter one table from another

Learn how to group and summarize your dates automatically in your tables.  Easily create tables with summaries of year and month

Learn how to apply conditional formatting to tables

Learn how to create and use the Pivot Table and KPI visualizations

Introduction to the Pivot Tables and KPIs section

Learn how to create pivot tables in AWS QuickSight

Learn how to use different methods of aggregation with the Pivot Table.  Use averages, highest value, lowest value and counts

Learn how to create percentages in the Pivot Tables.

Learn how to use the KPI visualization to create dominant card visualisations

Practical activity including KPI and Pivot Tables

Answer to the KPI and Pivot Tables practical activity

Learn to create table calculations such as running totals, ranking and difference from

Introduction to the Table calculation section

Learn how to use running total and rankings calculations in visualizations

Learn how to use the Difference from calculations

Learn to filter data on a sheet or a visualization

Introduction to the filters section

Learn how to use the text filters in the visualization

Learn how to use numeric filters in the visualizations

Learn how to use the date filters in the visualizations

Practical activity using filters in visualizations

Answers to the practical activity on how to use filters

Lern to create controls to filter the sheet of data
Introduction to Controls
Text Controls
Numeric Controls
Date Controls
Parameters and Actions
Learn to use the different types of graphical visualizations
Introduction to Graphs Visualizations
Line graphs
Area Graphs
Column and Bar graphs
Practical Activity - Visualizations
Completed Practical Activity - Visualizations
Pie graph
Other Graphs
Learn to create and share dashboards in QuickSight
Introduction to Dashboards
Practical Activity - Create Dashboard
Create dashboards
Publish and Share dashboards
Work with Themes
Lean to add new columns of data using calculations and formulas
Introduction to Calculations
Download Training Data File
Creating a Calculated Column
Date Calculated Fields
IFELSE Function
Practical Activity - Calculated Columns
Practical Activity Calculated Column
Learn to use calculated fields using measures
Introduction to Measures
Creating Measures
Practical Activity - Measures
SUMIF Function
Learn to create relationships between tables of data
Introduction to Relationships
Download Training Data Files
Create relationships
Practical Activity - Human Resource Data
Completed Practical Activity - HR Data
Learn to prepare your data for analysis with QuickSight
Introduction to Data Preparation
Data Preparation
Learn to use ML insights in your analysis
Introduction to ML Insights
Create ML Insights
Top N Insights
Customize Insights
Learn about the QuickSight Community and other resources that keep you up to date with the latest features and developments
AWS Community and useful resources
Conclusion to the course
Conclusion

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Teaches how to create relationships between data, which enhances analysis and provides a more comprehensive understanding of complex datasets
Focuses on transforming data into useful information and intelligence, which is essential for data-driven decision-making in business contexts
Covers creating table calculations for percentages, running totals, ranking, and difference from, which are essential for in-depth data analysis and reporting
Requires learners to download files to use in the lessons, which may require additional storage space and software to open and view the files
Explores ML Insights, which allows learners to create and customize insights, potentially giving them an edge in understanding innovation and groundbreaking topics
Includes creating and sharing dashboards, which is a core skill for presenting data insights to stakeholders and making data accessible to a wider audience

Save this course

Save Complete Introduction to Amazon QuickSight to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Complete Introduction to Amazon QuickSight with these activities:
Review Basic Data Visualization Principles
Reinforce fundamental data visualization concepts to better understand how QuickSight transforms data into meaningful visuals.
Browse courses on Data Visualization
Show steps
  • Read articles or watch videos on effective chart types and design principles.
  • Identify examples of good and bad data visualizations.
  • Summarize key takeaways in a short document.
Review 'Storytelling with Data'
Learn how to craft compelling narratives from data, enhancing the impact of QuickSight dashboards and reports.
View Storytelling with You: Plan, Create, and... on Amazon
Show steps
  • Read the book 'Storytelling with Data'.
  • Identify key principles for effective data storytelling.
  • Apply these principles to improve existing QuickSight visualizations.
Practice Creating Calculated Fields
Master the creation of calculated fields in QuickSight to derive new insights from existing data.
Browse courses on Calculated Fields
Show steps
  • Create calculated fields for common business metrics (e.g., profit margin, sales growth).
  • Experiment with different functions and operators in calculated fields.
  • Test calculated fields with various data scenarios.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Write a Blog Post on a QuickSight Feature
Deepen understanding of a specific QuickSight feature by researching, experimenting, and writing a blog post explaining its functionality and benefits.
Browse courses on AWS QuickSight
Show steps
  • Choose a QuickSight feature to focus on.
  • Research the feature and its use cases.
  • Experiment with the feature in QuickSight.
  • Write a blog post explaining the feature and its benefits.
Build a Dashboard for a Specific Business Problem
Apply QuickSight skills to solve a real-world business problem by designing and building an interactive dashboard.
Show steps
  • Identify a business problem that can be addressed with data visualization.
  • Gather and prepare relevant data for the dashboard.
  • Design and build the dashboard in QuickSight, incorporating key metrics and visualizations.
  • Present the dashboard to stakeholders and gather feedback.
Review 'The Visual Display of Quantitative Information'
Gain a deeper understanding of data visualization principles to create more effective and impactful QuickSight dashboards.
View Beautiful Evidence on Amazon
Show steps
  • Read 'The Visual Display of Quantitative Information'.
  • Identify key principles for effective data visualization.
  • Apply these principles to improve existing QuickSight visualizations.
Follow Advanced QuickSight Tutorials
Expand QuickSight skills by following advanced tutorials on topics such as custom visuals, advanced calculations, and embedding dashboards.
Browse courses on AWS QuickSight
Show steps
  • Search for advanced QuickSight tutorials online.
  • Choose a tutorial that covers a topic of interest.
  • Follow the tutorial step-by-step, experimenting with the techniques.
  • Apply the learned techniques to a personal QuickSight project.

Career center

Learners who complete Complete Introduction to Amazon QuickSight will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data analysts examine data to identify trends and insights. This role uses tools like Amazon QuickSight, which is the focus of this course. The course helps individuals learn how to load and prepare data, create visualizations, and use table calculations. A Data Analyst uses these skills to analyze their datasets. The course also covers the creation of calculated fields and measures. This provides a foundation for a data analyst as they perform their work. This course teaches those who wish to become a data analyst to use these tools to their fullest.
See salaries and explore the career path for Data Analyst
Business Intelligence Analyst
A Business Intelligence Analyst uses data to derive insights. This role requires the ability to visualize data using tools like Amazon QuickSight. This course helps build a foundation in this exact area. Specifically, the course trains individuals to load and prepare data, create visualizations, and use table calculations, all of which are necessary to be successful as a Business Intelligence Analyst. The course also covers techniques to share dashboards, which is crucial for communicating data insights across an organization. Learning data analysis methodology, as taught in this course, is invaluable for a business intelligence analyst.
See salaries and explore the career path for Business Intelligence Analyst
Data Visualization Specialist
A Data Visualization Specialist focuses on creating compelling visual representations of data. This course on Amazon QuickSight will be extremely beneficial for someone in this role, as it covers a wide range of visualization techniques, like line graphs, pie graphs, and dashboard creation. A data visualization specialist translates data into easily understandable formats. This course gives instruction on how to create effective visualizations using QuickSight. This course provides a direct path to improving data visualization skills.
See salaries and explore the career path for Data Visualization Specialist
Reporting Analyst
Reporting Analysts are responsible for producing reports based on their analysis of data. This course, centered on Amazon QuickSight, helps build skills in data preparation, analysis, and visualization, all vital for this role. The course teaches learners to create reports and share dashboards. A Reporting Analyst relies on these abilities. Also, a reporting analyst needs a strong understanding of data analysis methodology, which is also covered in the course. Therefore a reporting analyst will find this a valuable course. The course provides a solid understanding of how to work with data and tools.
See salaries and explore the career path for Reporting Analyst
Business Analyst
A Business Analyst is responsible for improving business processes using data analysis and reporting. This course in Amazon QuickSight will provide the core skills necessary for a business analyst to succeed. A business analyst must be capable of analyzing data and generating reports. This course teaches how to use QuickSight to perform this very task. The course also includes techniques for creating calculated fields and using parameters for more insightful analysis. These areas of the course are critical to a business analyst.
See salaries and explore the career path for Business Analyst
Analytics Consultant
An Analytics Consultant helps organizations make data-driven decisions using analysis techniques. The course on Amazon QuickSight is a great place to start for an aspiring consultant because it helps to build a foundation in data visualization and analysis, which are core to the role. This course will help a consultant become comfortable using BI tools to derive insights from data. As an Analytics Consultant, you need to be able to understand data and communicate it effectively. This course teaches these skills, making it valuable for someone in this role. The course provides a good introduction to data analysis.
See salaries and explore the career path for Analytics Consultant
Data Analytics Consultant
A Data Analytics Consultant works with clients to improve their understanding of data through analysis and reporting. This course on Amazon QuickSight will help provide a foundation for a data analytics consultant. This role requires expertise in data visualization and report generation, which is exactly what this course provides. Specifically, the course covers data preparation, visualization, and dashboard creation using QuickSight. A data analytics consultant will find this information useful. This course helps build practical experience with these tools and methodologies.
See salaries and explore the career path for Data Analytics Consultant
Operations Analyst
An Operations Analyst works to improve business operations by using data analysis to identify areas for improvement. This Amazon QuickSight course may be useful for this goal. An Operations Analyst uses data visualization to measure performance and efficiency. The course helps to build a foundation in data analysis. This includes training in data preparation and dashboard creation. A focus on practical application, as provided by the course, can assist them in their role. The course may be useful, as it provides concrete data analysis skills.
See salaries and explore the career path for Operations Analyst
Market Research Analyst
A Market Research Analyst interprets market data to provide insights for product development and marketing. This role can use the skills learned in this Amazon QuickSight course to visualize market trends and conduct analysis. This course covers data preparation, visualization, and dashboard creation, all of which are useful for market research. A market research analyst needs methods to derive insight from data, and this course can help with that mission. This course may be useful to build analysis skills.
See salaries and explore the career path for Market Research Analyst
Financial Analyst
Financial Analysts use data to make financial forecasts and strategic recommendations. This course, which concentrates on Amazon QuickSight, may be useful as it covers data visualization which is a necessary skill for a financial analyst. While they use specialized tools, the ability to derive insight from data through visualization is a crucial component of this role. The training in this course around data preparation and table calculations may help a Financial Analyst. This course may be useful for a financial analyst looking to expand their toolkit.
See salaries and explore the career path for Financial Analyst
Management Consultant
Management Consultants advise businesses on strategic decisions and process improvements. Although they use many tools, this course focusing on Amazon QuickSight may be useful for building data visualization skills. As a Management Consultant, it is important to be able to make data driven presentations and reports. The course will help you to learn how to create data visuals. Thus, the data analysis methodology taught in this course may be helpful. This course may be useful as an introduction to this type of analysis.
See salaries and explore the career path for Management Consultant
Project Manager
Project Managers oversee projects and need to track progress and performance metrics. This course on Amazon QuickSight may be useful to build practical skills in data visualization. The ability to create clear and insightful data visualizations using QuickSight, as taught in the course, will help communicate status effectively. A project manager may wish to learn how to use dashboards for performance tracking. This course may be useful for those that wish to improve their data analysis skills on the job.
See salaries and explore the career path for Project Manager
Sales Operations Analyst
A Sales Operations Analyst uses data to optimize sales processes and improve sales performance. This Amazon QuickSight course may be useful to build a foundation in data visualization and analysis for sales operations. A sales operations analyst will need to create reports and dashboards. This course has a focus on this. The course includes training in data preparation, dashboard creation, and using different visualization types . This course may be helpful for those who wish to learn how to use data to improve sales.
See salaries and explore the career path for Sales Operations Analyst
Marketing Analyst
A Marketing Analyst uses data to measure the effectiveness of marketing campaigns. This course on Amazon QuickSight may be helpful for a marketing analyst. A marketing analyst must analyze key performance indicators, and this course provides instruction on data visualization techniques. The course covers data preparation and analysis, which a marketing analyst will need. The data analysis methodology taught in this course may be helpful to someone in this role. This course may be helpful to improve marketing analysis methods.
See salaries and explore the career path for Marketing Analyst
Research Associate
A Research Associate assists in research projects, often involving the collection and analysis of data. The skills gained in this course focusing on Amazon QuickSight may be useful for some research associates. In particular, research associates need to create data visualizations and reports. This course provides instruction in these areas. This course may be helpful to build data analysis skills.
See salaries and explore the career path for Research Associate

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Complete Introduction to Amazon QuickSight.
Cover image
Storytelling with You
Save
Teaches how to go beyond conventional tools to reach the root of your data and how to use your data to create an engaging, informative, and compelling story. It focuses on the communication aspects of data visualization. It valuable resource for understanding how to present data effectively in dashboards and reports created with QuickSight. This book is commonly used by business professionals.
Storytelling with You: Plan, Create, and Deliver a...
Paperback
$$
Storytelling with You: Plan, Create, and Deliver a...
Kindle Edition
$$
Cover image
Beautiful Evidence
Save
Explores the theory and design of data graphics, charts, tables, and maps. It provides a framework for understanding how to present quantitative information effectively. While not specific to QuickSight, the principles outlined in this book are essential for creating clear and insightful visualizations. This book is considered a classic in the field of data visualization.
Beautiful Evidence
Hardcover
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
5.5 total hours
Via
Udemy
Instructor
Ian Littlejohn
Language
English
Good to know
Teaches how to create relationships between data, which enhances analysis and provides a more comprehensive understanding of complex datasets
Focuses on transforming data into useful information and intelligence, which is essential for data-driven decision-making in business contexts
Covers creating table calculations for percentages, running totals, ranking, and difference from, which are essential for in-depth data analysis and reporting
Requires learners to download files to use in the lessons, which may require additional storage space and software to open and view the files
Explores ML Insights, which allows learners to create and customize insights, potentially giving them an edge in understanding innovation and groundbreaking topics
Includes creating and sharing dashboards, which is a core skill for presenting data insights to stakeholders and making data accessible to a wider audience
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser