Plan Szkolenia

Introduction

  • Overview of AWS QuickSight
  • What is AWS and QuickSight

Getting Started with AWS QuickSight

  • Creating an AWS and QuickSight account
  • Understanding the QuickSight workflow
  • Navigating the QuickSight UI

Preparing Data in QuickSight

  • Understanding data preparation in QuickSight
  • SPICE vs. direct query
  • Uploading and importing data to QuickSight
  • Working with columns and fields
  • Understanding calculated fields, functions, and operators
  • Adding calculated fields using strings to our project
  • Extracting information out of strings
  • Using conditional functions
  • Creating calculated fields with numeric values
  • Adding different filters to a project

Analyzing and Visualizing Data

  • Understanding the difference between preparing and analyzing data
  • Creating the data analysis
  • Creating visuals
  • Understanding dimensions and measures
  • Adding additional data sets
  • Field formatting, aggregation, and granularity
  • Formatting visuals
  • Creating a story and treemap
  • Using filters and tables
  • Adding a KPI visual

Exporting and Sharing Project Data

  • Understanding refresh and schedule refresh
  • Exporting project data as .csv files
  • Adding users to an account
  • Sharing data set and analysis
  • Creating and sharing dashboards

Using Databases as Data Sources

  • Setting up a database
  • Preparing dummy data
  • Connecting QuickSight to a database
  • Importing data into SPICE
  • Importing data as a Query
  • Importing calculated fields and query
  • Using NoSQL databases

Summary and Next Steps

Wymagania

  • Basic knowledge and understanding of data analysis

Audience

  • Data analysts
  • Anyone who is interested in data analysis and visualization
 14 godzin

Liczba uczestników



Cena za uczestnika

Opinie uczestników (5)

Szkolenia Powiązane

Data Analysis with Redash

14 godzin

Business Intelligence and Data Analysis with Metabase

14 godzin

QlikView for Business Users

7 godzin

QlikView dla developerów

14 godzin

Google Sheets for Excel Users

14 godzin

Cognos 11

14 godzin

IBM Cognos Analytics

14 godzin

Alteryx Advanced

14 godzin

Alteryx for Data Analysis

7 godzin

Alteryx for Developers

14 godzin

Data Preparation with Alteryx

7 godzin

Algorithmic Trading with Python and R

14 godzin

Stata: Beginner to Advanced

14 godzin

Statistical Analysis with Stata and R

35 godzin

Cluster Analysis with R and SAS

14 godzin

Powiązane Kategorie