Data Science and Analytics with AWS Quicksight and Power BI

Create a simple bar chart from an Excel grocery price dataset, loading and transforming data, assigning products and prices to axes, and customizing colors, titles, and time-based views.

Explore creating and customizing line charts in AWS QuickSight and Power BI by selecting data fields, adjusting line style (solid, dashed, dotted, step), data labels, titles, colors, and tooltips.

Create a pie chart in Power BI by moving product category to the legend and order quantity to values, then adjust formatting and colors.

Learn to create a doughnut ring chart and synchronize it with a pie chart on the same dashboard, using category and subcategory data with values, labels, and formatting.

Build a treemap drill-down dashboard in Power BI with a four-rectangle dream up chart showing category weights and interlinked visuals.

Create a detailed treemap chart that drills from country to state with order quantity, links three charts for predictive insights, and refine formatting for title size, colors, and hover details.

Explore Power BI tables and matrices to organize data: columns, rows, and values. Learn formatting, drill down, and use measures and dimensions for analyzing order, quantity, profit.

Implement drill down on tables and matrices to explore deeper hierarchies and update visuals. Interact with connected charts to filter by country or category and see focused insights.

Learn to create ribbon charts that visualize rank flow over time using a dataset, with measures like order quantity and price, and apply formatting and drill-down for different timeframes.

Create a waterfall chart in Power BI to show year-over-year profit and loss with category or country breakdowns, color cues, and optional tooltips.

Learn to insert and customize a back button in Power BI, navigate between worksheets, and configure actions such as back, bookmark, and drill through.

Explore getting started with AWS QuickSight to create visualizations, prepare data, and build dashboards while configuring IAM, S3, and Redshift integrations for cloud data science.

Import or upload a dataset in QuickSight, create your first BI report and visualization, and build charts by placing fields into group and value.

Create a treemap and customize charts by mapping size to margin and color to price, then export to PDF and share insights offline.

Load datasets from connectors or upload files, then edit data and create calculated fields to prepare charts. Apply filters, clean data, and adjust data types for the data preparation dashboard.

Create a calculated field using ceil and concat to derive new columns. Learn data preparation, tax calculations on profit at 10 percent, and concatenating product id, category, and name.

Create and edit calculated fields to generate new columns such as profit per unit and price per unit, using ceiling, for data cleaning and preparation and chart creation.

Learn to refine datasets with exclude filters and standard filters in AWS QuickSight and Power BI, including country and date range filters, and create calculated fields to support visualizations.

Create and customize map charts for Italy and apply conditional formatting to a dataset by configuring filters, selecting an area map, and coloring by profit ranges.

Learn how to create and customize pivot tables in QuickSight to summarize data by country and state, using rows, columns, and values, with conditional formatting to highlight key figures.

Create Sankey charts in QuickSight to visualize data flow from source to destination, including two-layer and multilayer charts with weights like profit or order quantity.

Create a word cloud visualization by grouping by product name and sizing by order quantity or profit to reveal high-frequency items, with customizable padding, color, and layout.