Effective business intelligence with QuickSight: from data to actionable business insights using Amazon QuickSight!
From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-worl...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham ; Mumbai
Packt Publishing
2017
|
| Subjects: | |
| Online Access: | FHD01 |
| Summary: | From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-world examples with Solution Architectures needed for a cloud-powered Business Intelligence service Who This Book Is For This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service. |
| Physical Description: | 1 Online-Ressource (vii, 242 Seiten) |
| ISBN: | 9781786465009 |
Staff View
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV048595908 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 221206s2017 |||| o||u| ||||||eng d | ||
| 020 | |a 9781786465009 |9 978-1-78646-500-9 | ||
| 035 | |a (OCoLC)1354309446 | ||
| 035 | |a (DE-599)BVBBV048595908 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 | ||
| 100 | 1 | |a Nadipalli, Rajesh |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Effective business intelligence with QuickSight |b from data to actionable business insights using Amazon QuickSight! |c Rajesh Nadipalli |
| 264 | 1 | |a Birmingham ; Mumbai |b Packt Publishing |c 2017 | |
| 300 | |a 1 Online-Ressource (vii, 242 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 505 | 8 | |a Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: A Quick Start to QuickSight -- Era of big data -- Current BI landscape -- Key features provided by BI tools -- Typical process to build visualizations -- Key issues with traditional BI tools -- Rise of cloud BI services -- Overview of QuickSight -- How is QuickSight different to other BI tools? -- High level BI solution architecture with QuickSight -- Getting started with QuickSight -- Registering for QuickSight -- Signing up to QuickSight with a new AWS account -- Signing up to QuickSight with an existing AWS account -- Building your first analysis under 60 seconds -- Downloading data -- Preparing data -- QuickSight navigation -- Loading data to QuickSight -- Starting your visualizations -- Building multiple visualizations -- Summary -- Chapter 2: Exploring Any Data -- AWS big data ecosystem -- Collect -- Store -- Analyze -- Orchestrate -- Supported data sources -- Supported data types -- Supported data sizes -- File limits -- Table limits -- Use case review -- Permissions on AWS resources -- Loading text files to QuickSight -- Uploading a data file to S3 -- Building the manifest file -- Creating a new QuickSight dataset from S3 -- Loading MySQL data to QuickSight using the AWS pipeline -- Pre-requisites -- Uploading data to S3 -- Creating and executing the AWS Data Pipeline -- Creating a new QuickSight dataset from MySQL -- Loading Redshift data to QuickSight -- Pre-requisites -- Uploading data to S3 -- Creating and executing an AWS Data Pipeline -- Creating a new QuickSight dataset from Redshift -- Loading data from Athena to QuickSight -- Uploading data to S3 -- Creating a table in Athena -- Creating a new QuickSight dataset from Athena -- Loading data from Salesforce to QuickSight | |
| 505 | 8 | |a Pre-requisites -- Creating a dataset from Salesforce -- Editing existing datasets -- Summary -- Chapter 3: SPICE up Your Data -- SPICE -- overview and architecture -- Importing data into SPICE -- Joining data in SPICE -- Loading data to Redshift -- Creating a new joined dataset -- Enriching your data -- Arithmetic and comparison operators -- Conditional functions -- ifelse -- coalesce -- isNotNull -- isNull -- nullIf -- Date functions -- epochDate -- formatDate -- now -- dateDiff -- extract and truncDate -- Numeric functions -- ceil -- decimalToInt -- floor -- intToDecimal -- round -- String functions -- concat -- left -- locate -- ltrim -- parseDate -- parseDecimal -- parseInt -- replace -- right -- rtrim -- strlen -- substring -- toLower -- toString -- toUpper -- trim -- Filtering data using SPICE -- Adding new filters -- Filter on medianincome -- Filter on statecode -- Editing existing filters -- Changing existing filter criteria -- Enable, disable, or delete a filter -- Summary -- Chapter 4: Intuitive Visualizations -- From data to visualization using QuickSight -- Building analyses from datasets -- Creating a new dataset -- Creating a new analysis -- Adding a visual to an analysis -- Renaming and adding descriptions to an existing analysis -- Deleting an existing analysis -- Building effective visuals -- Changing visual type -- Bar charts -- Simple bar charts -- Stacked bar charts -- Line charts -- Simple line chart -- Area line chart -- Pivot tables -- Adding statistical functions -- Scatter plot -- Tree map -- Pie chart -- Heat map -- Autograph -- General options -- Configuring the visual title -- Configuring legends -- Configuring the axis range -- Changing visual colors -- Adding drill down to charts -- Selecting the right visualizations -- Does the business want to compare values? -- Do you need to compare compositions of a measure? | |
| 505 | 8 | |a Do you need to see distributions and relationship between two measures? -- Do you want to see trends with multiple measures? -- Do you want to slice and dice multiple measures over different dimensions? -- Deleting a visual -- Telling a story -- Creating a story -- Playing a Story -- Deleting a Story -- Sharing dashboards -- Deleting a dashboard -- Summary -- Chapter 5: Secure Your Environment -- Managing users and access -- Adding new users -- Reactivate a user -- View existing User -- Deleting a user -- Enterprise account user management -- Prerequisites -- Adding AD user accounts to QuickSight -- Deactivating AD accounts with QuickSight -- Managing QuickSight permissions on AWS resources -- Authorizing connections from QuickSight to AWS data sources -- Creating a new security group for QuickSight -- Authorizing connections to RDS instances -- Authorizing connections to Redshift cluster -- Authorizing connections to EC2 instance -- Closing a QuickSight account -- Summary -- Chapter 6: QuickSight Mobile -- Installing QuickSight -- Dashboards on the go -- Dashboard detailed view -- Find your dashboard -- Favorite a dashboard -- Limitations of the mobile app -- Analyses on the go -- View details of your analysis -- Share your analysis -- Stories related to analysis -- Search for analysis -- Favorite your analysis -- Limitations of the mobile app -- Stories on the go -- Story detailed view -- Search your stories -- Favorite a story -- Advanced options for the QuickSight mobile app -- Summary -- Chapter 7: Big Data Analytics Mini Project -- Overview of AWS Data Lake solution -- Data lake core concept -- package -- AWS Data Lake architecture -- Managed data ingestion to AWS Data Lake -- Centralized data storage for AWS Data Lake -- Processing and analyzing data within the AWS Data Lake -- Governing and securing the AWS Data Lake | |
| 505 | 8 | |a A mini project on AWS Data Lake -- Mini use case business context -- Air quality index -- Census population -- Deploying AWS Data Lake using CloudFormation -- Creating a new stack -- Access your data lake stack -- Acquiring the data for the mini project -- Hydrating the data lake -- Air quality index data in S3 -- US population data in S3 -- Cataloging data assets -- Creating governance tags -- Registering data packages -- EPA AQI data package -- USA population history package -- Searching the data catalog -- Extracting packages using manifest -- Processing data in the AWS Data Lake -- Creating Athena tables -- Analyzing using QuickSight -- Population analysis -- Creating the population dataset -- Insights from population dataset -- Combining population and EPA datasets -- EPA Trend with population impact -- Additional data lake features -- User management for the AWS Data Lake -- Inviting a new user -- Updating an existing user -- General system settings for AWS Data Lake -- Summary -- Chapter 8: QuickSight Product Shortcomings -- QuickSight product features -- Easy ad hoc analysis and visualizations -- Wide range of data connectivity -- Fast and visual data preparation -- Sharing and collaboration -- Security and access -- Easy operations -- Features lacking in QuickSight -- Lack of integration with the visualization layer -- Only basic visualizations -- Limited mobile and sharing -- Lack of advanced data management -- Advanced data preparation features -- Lack of fine grain access -- General -- Accessing the user guide -- Providing feedback -- Summary -- Index | |
| 520 | |a From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-world examples with Solution Architectures needed for a cloud-powered Business Intelligence service Who This Book Is For This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service. | ||
| 650 | 4 | |a Application software / Development | |
| 650 | 4 | |a Logiciels d'application / Développement | |
| 650 | 7 | |a Application software / Development |2 fast | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-78646-636-5 |
| 912 | |a ZDB-30-PQE | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-033971532 | ||
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=4822558 |l FHD01 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
Record in the Search Index
| _version_ | 1804184637573955584 |
|---|---|
| adam_txt | |
| any_adam_object | |
| any_adam_object_boolean | |
| author | Nadipalli, Rajesh |
| author_facet | Nadipalli, Rajesh |
| author_role | aut |
| author_sort | Nadipalli, Rajesh |
| author_variant | r n rn |
| building | Verbundindex |
| bvnumber | BV048595908 |
| collection | ZDB-30-PQE |
| contents | Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: A Quick Start to QuickSight -- Era of big data -- Current BI landscape -- Key features provided by BI tools -- Typical process to build visualizations -- Key issues with traditional BI tools -- Rise of cloud BI services -- Overview of QuickSight -- How is QuickSight different to other BI tools? -- High level BI solution architecture with QuickSight -- Getting started with QuickSight -- Registering for QuickSight -- Signing up to QuickSight with a new AWS account -- Signing up to QuickSight with an existing AWS account -- Building your first analysis under 60 seconds -- Downloading data -- Preparing data -- QuickSight navigation -- Loading data to QuickSight -- Starting your visualizations -- Building multiple visualizations -- Summary -- Chapter 2: Exploring Any Data -- AWS big data ecosystem -- Collect -- Store -- Analyze -- Orchestrate -- Supported data sources -- Supported data types -- Supported data sizes -- File limits -- Table limits -- Use case review -- Permissions on AWS resources -- Loading text files to QuickSight -- Uploading a data file to S3 -- Building the manifest file -- Creating a new QuickSight dataset from S3 -- Loading MySQL data to QuickSight using the AWS pipeline -- Pre-requisites -- Uploading data to S3 -- Creating and executing the AWS Data Pipeline -- Creating a new QuickSight dataset from MySQL -- Loading Redshift data to QuickSight -- Pre-requisites -- Uploading data to S3 -- Creating and executing an AWS Data Pipeline -- Creating a new QuickSight dataset from Redshift -- Loading data from Athena to QuickSight -- Uploading data to S3 -- Creating a table in Athena -- Creating a new QuickSight dataset from Athena -- Loading data from Salesforce to QuickSight Pre-requisites -- Creating a dataset from Salesforce -- Editing existing datasets -- Summary -- Chapter 3: SPICE up Your Data -- SPICE -- overview and architecture -- Importing data into SPICE -- Joining data in SPICE -- Loading data to Redshift -- Creating a new joined dataset -- Enriching your data -- Arithmetic and comparison operators -- Conditional functions -- ifelse -- coalesce -- isNotNull -- isNull -- nullIf -- Date functions -- epochDate -- formatDate -- now -- dateDiff -- extract and truncDate -- Numeric functions -- ceil -- decimalToInt -- floor -- intToDecimal -- round -- String functions -- concat -- left -- locate -- ltrim -- parseDate -- parseDecimal -- parseInt -- replace -- right -- rtrim -- strlen -- substring -- toLower -- toString -- toUpper -- trim -- Filtering data using SPICE -- Adding new filters -- Filter on medianincome -- Filter on statecode -- Editing existing filters -- Changing existing filter criteria -- Enable, disable, or delete a filter -- Summary -- Chapter 4: Intuitive Visualizations -- From data to visualization using QuickSight -- Building analyses from datasets -- Creating a new dataset -- Creating a new analysis -- Adding a visual to an analysis -- Renaming and adding descriptions to an existing analysis -- Deleting an existing analysis -- Building effective visuals -- Changing visual type -- Bar charts -- Simple bar charts -- Stacked bar charts -- Line charts -- Simple line chart -- Area line chart -- Pivot tables -- Adding statistical functions -- Scatter plot -- Tree map -- Pie chart -- Heat map -- Autograph -- General options -- Configuring the visual title -- Configuring legends -- Configuring the axis range -- Changing visual colors -- Adding drill down to charts -- Selecting the right visualizations -- Does the business want to compare values? -- Do you need to compare compositions of a measure? Do you need to see distributions and relationship between two measures? -- Do you want to see trends with multiple measures? -- Do you want to slice and dice multiple measures over different dimensions? -- Deleting a visual -- Telling a story -- Creating a story -- Playing a Story -- Deleting a Story -- Sharing dashboards -- Deleting a dashboard -- Summary -- Chapter 5: Secure Your Environment -- Managing users and access -- Adding new users -- Reactivate a user -- View existing User -- Deleting a user -- Enterprise account user management -- Prerequisites -- Adding AD user accounts to QuickSight -- Deactivating AD accounts with QuickSight -- Managing QuickSight permissions on AWS resources -- Authorizing connections from QuickSight to AWS data sources -- Creating a new security group for QuickSight -- Authorizing connections to RDS instances -- Authorizing connections to Redshift cluster -- Authorizing connections to EC2 instance -- Closing a QuickSight account -- Summary -- Chapter 6: QuickSight Mobile -- Installing QuickSight -- Dashboards on the go -- Dashboard detailed view -- Find your dashboard -- Favorite a dashboard -- Limitations of the mobile app -- Analyses on the go -- View details of your analysis -- Share your analysis -- Stories related to analysis -- Search for analysis -- Favorite your analysis -- Limitations of the mobile app -- Stories on the go -- Story detailed view -- Search your stories -- Favorite a story -- Advanced options for the QuickSight mobile app -- Summary -- Chapter 7: Big Data Analytics Mini Project -- Overview of AWS Data Lake solution -- Data lake core concept -- package -- AWS Data Lake architecture -- Managed data ingestion to AWS Data Lake -- Centralized data storage for AWS Data Lake -- Processing and analyzing data within the AWS Data Lake -- Governing and securing the AWS Data Lake A mini project on AWS Data Lake -- Mini use case business context -- Air quality index -- Census population -- Deploying AWS Data Lake using CloudFormation -- Creating a new stack -- Access your data lake stack -- Acquiring the data for the mini project -- Hydrating the data lake -- Air quality index data in S3 -- US population data in S3 -- Cataloging data assets -- Creating governance tags -- Registering data packages -- EPA AQI data package -- USA population history package -- Searching the data catalog -- Extracting packages using manifest -- Processing data in the AWS Data Lake -- Creating Athena tables -- Analyzing using QuickSight -- Population analysis -- Creating the population dataset -- Insights from population dataset -- Combining population and EPA datasets -- EPA Trend with population impact -- Additional data lake features -- User management for the AWS Data Lake -- Inviting a new user -- Updating an existing user -- General system settings for AWS Data Lake -- Summary -- Chapter 8: QuickSight Product Shortcomings -- QuickSight product features -- Easy ad hoc analysis and visualizations -- Wide range of data connectivity -- Fast and visual data preparation -- Sharing and collaboration -- Security and access -- Easy operations -- Features lacking in QuickSight -- Lack of integration with the visualization layer -- Only basic visualizations -- Limited mobile and sharing -- Lack of advanced data management -- Advanced data preparation features -- Lack of fine grain access -- General -- Accessing the user guide -- Providing feedback -- Summary -- Index |
| ctrlnum | (OCoLC)1354309446 (DE-599)BVBBV048595908 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>09195nmm a2200385 c 4500</leader><controlfield tag="001">BV048595908</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">221206s2017 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781786465009</subfield><subfield code="9">978-1-78646-500-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1354309446</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV048595908</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Nadipalli, Rajesh</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Effective business intelligence with QuickSight</subfield><subfield code="b">from data to actionable business insights using Amazon QuickSight!</subfield><subfield code="c">Rajesh Nadipalli</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham ; Mumbai</subfield><subfield code="b">Packt Publishing</subfield><subfield code="c">2017</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (vii, 242 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: A Quick Start to QuickSight -- Era of big data -- Current BI landscape -- Key features provided by BI tools -- Typical process to build visualizations -- Key issues with traditional BI tools -- Rise of cloud BI services -- Overview of QuickSight -- How is QuickSight different to other BI tools? -- High level BI solution architecture with QuickSight -- Getting started with QuickSight -- Registering for QuickSight -- Signing up to QuickSight with a new AWS account -- Signing up to QuickSight with an existing AWS account -- Building your first analysis under 60 seconds -- Downloading data -- Preparing data -- QuickSight navigation -- Loading data to QuickSight -- Starting your visualizations -- Building multiple visualizations -- Summary -- Chapter 2: Exploring Any Data -- AWS big data ecosystem -- Collect -- Store -- Analyze -- Orchestrate -- Supported data sources -- Supported data types -- Supported data sizes -- File limits -- Table limits -- Use case review -- Permissions on AWS resources -- Loading text files to QuickSight -- Uploading a data file to S3 -- Building the manifest file -- Creating a new QuickSight dataset from S3 -- Loading MySQL data to QuickSight using the AWS pipeline -- Pre-requisites -- Uploading data to S3 -- Creating and executing the AWS Data Pipeline -- Creating a new QuickSight dataset from MySQL -- Loading Redshift data to QuickSight -- Pre-requisites -- Uploading data to S3 -- Creating and executing an AWS Data Pipeline -- Creating a new QuickSight dataset from Redshift -- Loading data from Athena to QuickSight -- Uploading data to S3 -- Creating a table in Athena -- Creating a new QuickSight dataset from Athena -- Loading data from Salesforce to QuickSight</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Pre-requisites -- Creating a dataset from Salesforce -- Editing existing datasets -- Summary -- Chapter 3: SPICE up Your Data -- SPICE -- overview and architecture -- Importing data into SPICE -- Joining data in SPICE -- Loading data to Redshift -- Creating a new joined dataset -- Enriching your data -- Arithmetic and comparison operators -- Conditional functions -- ifelse -- coalesce -- isNotNull -- isNull -- nullIf -- Date functions -- epochDate -- formatDate -- now -- dateDiff -- extract and truncDate -- Numeric functions -- ceil -- decimalToInt -- floor -- intToDecimal -- round -- String functions -- concat -- left -- locate -- ltrim -- parseDate -- parseDecimal -- parseInt -- replace -- right -- rtrim -- strlen -- substring -- toLower -- toString -- toUpper -- trim -- Filtering data using SPICE -- Adding new filters -- Filter on medianincome -- Filter on statecode -- Editing existing filters -- Changing existing filter criteria -- Enable, disable, or delete a filter -- Summary -- Chapter 4: Intuitive Visualizations -- From data to visualization using QuickSight -- Building analyses from datasets -- Creating a new dataset -- Creating a new analysis -- Adding a visual to an analysis -- Renaming and adding descriptions to an existing analysis -- Deleting an existing analysis -- Building effective visuals -- Changing visual type -- Bar charts -- Simple bar charts -- Stacked bar charts -- Line charts -- Simple line chart -- Area line chart -- Pivot tables -- Adding statistical functions -- Scatter plot -- Tree map -- Pie chart -- Heat map -- Autograph -- General options -- Configuring the visual title -- Configuring legends -- Configuring the axis range -- Changing visual colors -- Adding drill down to charts -- Selecting the right visualizations -- Does the business want to compare values? -- Do you need to compare compositions of a measure?</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Do you need to see distributions and relationship between two measures? -- Do you want to see trends with multiple measures? -- Do you want to slice and dice multiple measures over different dimensions? -- Deleting a visual -- Telling a story -- Creating a story -- Playing a Story -- Deleting a Story -- Sharing dashboards -- Deleting a dashboard -- Summary -- Chapter 5: Secure Your Environment -- Managing users and access -- Adding new users -- Reactivate a user -- View existing User -- Deleting a user -- Enterprise account user management -- Prerequisites -- Adding AD user accounts to QuickSight -- Deactivating AD accounts with QuickSight -- Managing QuickSight permissions on AWS resources -- Authorizing connections from QuickSight to AWS data sources -- Creating a new security group for QuickSight -- Authorizing connections to RDS instances -- Authorizing connections to Redshift cluster -- Authorizing connections to EC2 instance -- Closing a QuickSight account -- Summary -- Chapter 6: QuickSight Mobile -- Installing QuickSight -- Dashboards on the go -- Dashboard detailed view -- Find your dashboard -- Favorite a dashboard -- Limitations of the mobile app -- Analyses on the go -- View details of your analysis -- Share your analysis -- Stories related to analysis -- Search for analysis -- Favorite your analysis -- Limitations of the mobile app -- Stories on the go -- Story detailed view -- Search your stories -- Favorite a story -- Advanced options for the QuickSight mobile app -- Summary -- Chapter 7: Big Data Analytics Mini Project -- Overview of AWS Data Lake solution -- Data lake core concept -- package -- AWS Data Lake architecture -- Managed data ingestion to AWS Data Lake -- Centralized data storage for AWS Data Lake -- Processing and analyzing data within the AWS Data Lake -- Governing and securing the AWS Data Lake</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">A mini project on AWS Data Lake -- Mini use case business context -- Air quality index -- Census population -- Deploying AWS Data Lake using CloudFormation -- Creating a new stack -- Access your data lake stack -- Acquiring the data for the mini project -- Hydrating the data lake -- Air quality index data in S3 -- US population data in S3 -- Cataloging data assets -- Creating governance tags -- Registering data packages -- EPA AQI data package -- USA population history package -- Searching the data catalog -- Extracting packages using manifest -- Processing data in the AWS Data Lake -- Creating Athena tables -- Analyzing using QuickSight -- Population analysis -- Creating the population dataset -- Insights from population dataset -- Combining population and EPA datasets -- EPA Trend with population impact -- Additional data lake features -- User management for the AWS Data Lake -- Inviting a new user -- Updating an existing user -- General system settings for AWS Data Lake -- Summary -- Chapter 8: QuickSight Product Shortcomings -- QuickSight product features -- Easy ad hoc analysis and visualizations -- Wide range of data connectivity -- Fast and visual data preparation -- Sharing and collaboration -- Security and access -- Easy operations -- Features lacking in QuickSight -- Lack of integration with the visualization layer -- Only basic visualizations -- Limited mobile and sharing -- Lack of advanced data management -- Advanced data preparation features -- Lack of fine grain access -- General -- Accessing the user guide -- Providing feedback -- Summary -- Index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-world examples with Solution Architectures needed for a cloud-powered Business Intelligence service Who This Book Is For This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service. </subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Application software / Development</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Logiciels d'application / Développement</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Application software / Development</subfield><subfield code="2">fast</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-78646-636-5</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-033971532</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=4822558</subfield><subfield code="l">FHD01</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">FHD01_PQE_Kauf</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV048595908 |
| illustrated | Not Illustrated |
| index_date | 2024-07-03T21:08:46Z |
| indexdate | 2024-07-10T09:42:30Z |
| institution | BVB |
| isbn | 9781786465009 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-033971532 |
| oclc_num | 1354309446 |
| open_access_boolean | |
| owner | DE-1050 |
| owner_facet | DE-1050 |
| physical | 1 Online-Ressource (vii, 242 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE FHD01_PQE_Kauf |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Packt Publishing |
| record_format | marc |
| spelling | Nadipalli, Rajesh Verfasser aut Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! Rajesh Nadipalli Birmingham ; Mumbai Packt Publishing 2017 1 Online-Ressource (vii, 242 Seiten) txt rdacontent c rdamedia cr rdacarrier Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: A Quick Start to QuickSight -- Era of big data -- Current BI landscape -- Key features provided by BI tools -- Typical process to build visualizations -- Key issues with traditional BI tools -- Rise of cloud BI services -- Overview of QuickSight -- How is QuickSight different to other BI tools? -- High level BI solution architecture with QuickSight -- Getting started with QuickSight -- Registering for QuickSight -- Signing up to QuickSight with a new AWS account -- Signing up to QuickSight with an existing AWS account -- Building your first analysis under 60 seconds -- Downloading data -- Preparing data -- QuickSight navigation -- Loading data to QuickSight -- Starting your visualizations -- Building multiple visualizations -- Summary -- Chapter 2: Exploring Any Data -- AWS big data ecosystem -- Collect -- Store -- Analyze -- Orchestrate -- Supported data sources -- Supported data types -- Supported data sizes -- File limits -- Table limits -- Use case review -- Permissions on AWS resources -- Loading text files to QuickSight -- Uploading a data file to S3 -- Building the manifest file -- Creating a new QuickSight dataset from S3 -- Loading MySQL data to QuickSight using the AWS pipeline -- Pre-requisites -- Uploading data to S3 -- Creating and executing the AWS Data Pipeline -- Creating a new QuickSight dataset from MySQL -- Loading Redshift data to QuickSight -- Pre-requisites -- Uploading data to S3 -- Creating and executing an AWS Data Pipeline -- Creating a new QuickSight dataset from Redshift -- Loading data from Athena to QuickSight -- Uploading data to S3 -- Creating a table in Athena -- Creating a new QuickSight dataset from Athena -- Loading data from Salesforce to QuickSight Pre-requisites -- Creating a dataset from Salesforce -- Editing existing datasets -- Summary -- Chapter 3: SPICE up Your Data -- SPICE -- overview and architecture -- Importing data into SPICE -- Joining data in SPICE -- Loading data to Redshift -- Creating a new joined dataset -- Enriching your data -- Arithmetic and comparison operators -- Conditional functions -- ifelse -- coalesce -- isNotNull -- isNull -- nullIf -- Date functions -- epochDate -- formatDate -- now -- dateDiff -- extract and truncDate -- Numeric functions -- ceil -- decimalToInt -- floor -- intToDecimal -- round -- String functions -- concat -- left -- locate -- ltrim -- parseDate -- parseDecimal -- parseInt -- replace -- right -- rtrim -- strlen -- substring -- toLower -- toString -- toUpper -- trim -- Filtering data using SPICE -- Adding new filters -- Filter on medianincome -- Filter on statecode -- Editing existing filters -- Changing existing filter criteria -- Enable, disable, or delete a filter -- Summary -- Chapter 4: Intuitive Visualizations -- From data to visualization using QuickSight -- Building analyses from datasets -- Creating a new dataset -- Creating a new analysis -- Adding a visual to an analysis -- Renaming and adding descriptions to an existing analysis -- Deleting an existing analysis -- Building effective visuals -- Changing visual type -- Bar charts -- Simple bar charts -- Stacked bar charts -- Line charts -- Simple line chart -- Area line chart -- Pivot tables -- Adding statistical functions -- Scatter plot -- Tree map -- Pie chart -- Heat map -- Autograph -- General options -- Configuring the visual title -- Configuring legends -- Configuring the axis range -- Changing visual colors -- Adding drill down to charts -- Selecting the right visualizations -- Does the business want to compare values? -- Do you need to compare compositions of a measure? Do you need to see distributions and relationship between two measures? -- Do you want to see trends with multiple measures? -- Do you want to slice and dice multiple measures over different dimensions? -- Deleting a visual -- Telling a story -- Creating a story -- Playing a Story -- Deleting a Story -- Sharing dashboards -- Deleting a dashboard -- Summary -- Chapter 5: Secure Your Environment -- Managing users and access -- Adding new users -- Reactivate a user -- View existing User -- Deleting a user -- Enterprise account user management -- Prerequisites -- Adding AD user accounts to QuickSight -- Deactivating AD accounts with QuickSight -- Managing QuickSight permissions on AWS resources -- Authorizing connections from QuickSight to AWS data sources -- Creating a new security group for QuickSight -- Authorizing connections to RDS instances -- Authorizing connections to Redshift cluster -- Authorizing connections to EC2 instance -- Closing a QuickSight account -- Summary -- Chapter 6: QuickSight Mobile -- Installing QuickSight -- Dashboards on the go -- Dashboard detailed view -- Find your dashboard -- Favorite a dashboard -- Limitations of the mobile app -- Analyses on the go -- View details of your analysis -- Share your analysis -- Stories related to analysis -- Search for analysis -- Favorite your analysis -- Limitations of the mobile app -- Stories on the go -- Story detailed view -- Search your stories -- Favorite a story -- Advanced options for the QuickSight mobile app -- Summary -- Chapter 7: Big Data Analytics Mini Project -- Overview of AWS Data Lake solution -- Data lake core concept -- package -- AWS Data Lake architecture -- Managed data ingestion to AWS Data Lake -- Centralized data storage for AWS Data Lake -- Processing and analyzing data within the AWS Data Lake -- Governing and securing the AWS Data Lake A mini project on AWS Data Lake -- Mini use case business context -- Air quality index -- Census population -- Deploying AWS Data Lake using CloudFormation -- Creating a new stack -- Access your data lake stack -- Acquiring the data for the mini project -- Hydrating the data lake -- Air quality index data in S3 -- US population data in S3 -- Cataloging data assets -- Creating governance tags -- Registering data packages -- EPA AQI data package -- USA population history package -- Searching the data catalog -- Extracting packages using manifest -- Processing data in the AWS Data Lake -- Creating Athena tables -- Analyzing using QuickSight -- Population analysis -- Creating the population dataset -- Insights from population dataset -- Combining population and EPA datasets -- EPA Trend with population impact -- Additional data lake features -- User management for the AWS Data Lake -- Inviting a new user -- Updating an existing user -- General system settings for AWS Data Lake -- Summary -- Chapter 8: QuickSight Product Shortcomings -- QuickSight product features -- Easy ad hoc analysis and visualizations -- Wide range of data connectivity -- Fast and visual data preparation -- Sharing and collaboration -- Security and access -- Easy operations -- Features lacking in QuickSight -- Lack of integration with the visualization layer -- Only basic visualizations -- Limited mobile and sharing -- Lack of advanced data management -- Advanced data preparation features -- Lack of fine grain access -- General -- Accessing the user guide -- Providing feedback -- Summary -- Index From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-world examples with Solution Architectures needed for a cloud-powered Business Intelligence service Who This Book Is For This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service. Application software / Development Logiciels d'application / Développement Application software / Development fast Erscheint auch als Druck-Ausgabe 978-1-78646-636-5 |
| spellingShingle | Nadipalli, Rajesh Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: A Quick Start to QuickSight -- Era of big data -- Current BI landscape -- Key features provided by BI tools -- Typical process to build visualizations -- Key issues with traditional BI tools -- Rise of cloud BI services -- Overview of QuickSight -- How is QuickSight different to other BI tools? -- High level BI solution architecture with QuickSight -- Getting started with QuickSight -- Registering for QuickSight -- Signing up to QuickSight with a new AWS account -- Signing up to QuickSight with an existing AWS account -- Building your first analysis under 60 seconds -- Downloading data -- Preparing data -- QuickSight navigation -- Loading data to QuickSight -- Starting your visualizations -- Building multiple visualizations -- Summary -- Chapter 2: Exploring Any Data -- AWS big data ecosystem -- Collect -- Store -- Analyze -- Orchestrate -- Supported data sources -- Supported data types -- Supported data sizes -- File limits -- Table limits -- Use case review -- Permissions on AWS resources -- Loading text files to QuickSight -- Uploading a data file to S3 -- Building the manifest file -- Creating a new QuickSight dataset from S3 -- Loading MySQL data to QuickSight using the AWS pipeline -- Pre-requisites -- Uploading data to S3 -- Creating and executing the AWS Data Pipeline -- Creating a new QuickSight dataset from MySQL -- Loading Redshift data to QuickSight -- Pre-requisites -- Uploading data to S3 -- Creating and executing an AWS Data Pipeline -- Creating a new QuickSight dataset from Redshift -- Loading data from Athena to QuickSight -- Uploading data to S3 -- Creating a table in Athena -- Creating a new QuickSight dataset from Athena -- Loading data from Salesforce to QuickSight Pre-requisites -- Creating a dataset from Salesforce -- Editing existing datasets -- Summary -- Chapter 3: SPICE up Your Data -- SPICE -- overview and architecture -- Importing data into SPICE -- Joining data in SPICE -- Loading data to Redshift -- Creating a new joined dataset -- Enriching your data -- Arithmetic and comparison operators -- Conditional functions -- ifelse -- coalesce -- isNotNull -- isNull -- nullIf -- Date functions -- epochDate -- formatDate -- now -- dateDiff -- extract and truncDate -- Numeric functions -- ceil -- decimalToInt -- floor -- intToDecimal -- round -- String functions -- concat -- left -- locate -- ltrim -- parseDate -- parseDecimal -- parseInt -- replace -- right -- rtrim -- strlen -- substring -- toLower -- toString -- toUpper -- trim -- Filtering data using SPICE -- Adding new filters -- Filter on medianincome -- Filter on statecode -- Editing existing filters -- Changing existing filter criteria -- Enable, disable, or delete a filter -- Summary -- Chapter 4: Intuitive Visualizations -- From data to visualization using QuickSight -- Building analyses from datasets -- Creating a new dataset -- Creating a new analysis -- Adding a visual to an analysis -- Renaming and adding descriptions to an existing analysis -- Deleting an existing analysis -- Building effective visuals -- Changing visual type -- Bar charts -- Simple bar charts -- Stacked bar charts -- Line charts -- Simple line chart -- Area line chart -- Pivot tables -- Adding statistical functions -- Scatter plot -- Tree map -- Pie chart -- Heat map -- Autograph -- General options -- Configuring the visual title -- Configuring legends -- Configuring the axis range -- Changing visual colors -- Adding drill down to charts -- Selecting the right visualizations -- Does the business want to compare values? -- Do you need to compare compositions of a measure? Do you need to see distributions and relationship between two measures? -- Do you want to see trends with multiple measures? -- Do you want to slice and dice multiple measures over different dimensions? -- Deleting a visual -- Telling a story -- Creating a story -- Playing a Story -- Deleting a Story -- Sharing dashboards -- Deleting a dashboard -- Summary -- Chapter 5: Secure Your Environment -- Managing users and access -- Adding new users -- Reactivate a user -- View existing User -- Deleting a user -- Enterprise account user management -- Prerequisites -- Adding AD user accounts to QuickSight -- Deactivating AD accounts with QuickSight -- Managing QuickSight permissions on AWS resources -- Authorizing connections from QuickSight to AWS data sources -- Creating a new security group for QuickSight -- Authorizing connections to RDS instances -- Authorizing connections to Redshift cluster -- Authorizing connections to EC2 instance -- Closing a QuickSight account -- Summary -- Chapter 6: QuickSight Mobile -- Installing QuickSight -- Dashboards on the go -- Dashboard detailed view -- Find your dashboard -- Favorite a dashboard -- Limitations of the mobile app -- Analyses on the go -- View details of your analysis -- Share your analysis -- Stories related to analysis -- Search for analysis -- Favorite your analysis -- Limitations of the mobile app -- Stories on the go -- Story detailed view -- Search your stories -- Favorite a story -- Advanced options for the QuickSight mobile app -- Summary -- Chapter 7: Big Data Analytics Mini Project -- Overview of AWS Data Lake solution -- Data lake core concept -- package -- AWS Data Lake architecture -- Managed data ingestion to AWS Data Lake -- Centralized data storage for AWS Data Lake -- Processing and analyzing data within the AWS Data Lake -- Governing and securing the AWS Data Lake A mini project on AWS Data Lake -- Mini use case business context -- Air quality index -- Census population -- Deploying AWS Data Lake using CloudFormation -- Creating a new stack -- Access your data lake stack -- Acquiring the data for the mini project -- Hydrating the data lake -- Air quality index data in S3 -- US population data in S3 -- Cataloging data assets -- Creating governance tags -- Registering data packages -- EPA AQI data package -- USA population history package -- Searching the data catalog -- Extracting packages using manifest -- Processing data in the AWS Data Lake -- Creating Athena tables -- Analyzing using QuickSight -- Population analysis -- Creating the population dataset -- Insights from population dataset -- Combining population and EPA datasets -- EPA Trend with population impact -- Additional data lake features -- User management for the AWS Data Lake -- Inviting a new user -- Updating an existing user -- General system settings for AWS Data Lake -- Summary -- Chapter 8: QuickSight Product Shortcomings -- QuickSight product features -- Easy ad hoc analysis and visualizations -- Wide range of data connectivity -- Fast and visual data preparation -- Sharing and collaboration -- Security and access -- Easy operations -- Features lacking in QuickSight -- Lack of integration with the visualization layer -- Only basic visualizations -- Limited mobile and sharing -- Lack of advanced data management -- Advanced data preparation features -- Lack of fine grain access -- General -- Accessing the user guide -- Providing feedback -- Summary -- Index Application software / Development Logiciels d'application / Développement Application software / Development fast |
| title | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! |
| title_auth | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! |
| title_exact_search | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! |
| title_exact_search_txtP | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! |
| title_full | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! Rajesh Nadipalli |
| title_fullStr | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! Rajesh Nadipalli |
| title_full_unstemmed | Effective business intelligence with QuickSight from data to actionable business insights using Amazon QuickSight! Rajesh Nadipalli |
| title_short | Effective business intelligence with QuickSight |
| title_sort | effective business intelligence with quicksight from data to actionable business insights using amazon quicksight |
| title_sub | from data to actionable business insights using Amazon QuickSight! |
| topic | Application software / Development Logiciels d'application / Développement Application software / Development fast |
| topic_facet | Application software / Development Logiciels d'application / Développement |
| work_keys_str_mv | AT nadipallirajesh effectivebusinessintelligencewithquicksightfromdatatoactionablebusinessinsightsusingamazonquicksight |