Data Visualization in Tableau & Power BI (2 Courses in 1)

Create your first diagram in Tableau by dragging location, creating a horizontal bar chart, sorting states by sales volume descending, and exploring heat maps and table views for intuitive formatting.

Apply formatting to diagrams in Tableau by coloring bars by sales volume, adding labels, and customizing currency and thousands display, then craft titles and choose diagram types.

Learn to choose diagram types with Tableau's Show Me, add sheets, and apply size, color, and text to create treemaps and packed bubbles, while noting removal collapses visuals.

Create a horizontal bar chart of profits by state, highlight lowest profits and color highest blue. Format profits in thousands with a dollar sign and add a chart title.

Create a horizontal bar chart of profit by state, sorted descending with currency formatting and title profits per state, using blue for the highest profits and red for the lowest.

create calculated fields to compute cost and profit in Tableau and Power BI, using formulas that subtract profit from sales and apply a 10 percent discount.

Apply filters in Tableau to focus your diagram on specific locations or profit ranges by dragging location into filters, showing the filter, and adjusting min and max profit values.

Connect to a flat-file data source in Tableau and select city and profit to explore aggregation measures. Use average, sum, min, max, and other aggregations to compare city profits.

Create a vertical bar chart showing the maximum IT expenses for a company in London, using Tableau and Power BI.

Explore building a vertical bar chart to display the maximum IT expenses for company A in London, using filters to compare cities and show the value of 165,349.

Create a vertical bar chart to show company A's IT expenses in London, using filters to compare cities and display maximum values in Tableau and Power BI.

Learn to clean messy Excel data with Tableau's data interpreter, removing nulls and misaligned headers to prepare employee flight data for visualization.

Prepare Excel and flat-file data for Tableau by pivoting date fields, renaming columns, splitting section and employee IDs with a dash, and converting fields to date for analysis.

Explore data preparation and analysis in Excel and flat files, then visualize how to compare employees by flights using filters, sorting, color, and date trends in Tableau and Power BI.

Learn to manage metadata in Tableau by renaming and hiding data fields, selecting relevant sheets from an Excel data source, and toggling fields between dimensions and measures for cleaner visualizations.

Organize data fields by creating folders and grouping related fields into hierarchies, using drag-and-drop, rename, and collapse to reveal categories, subcategories, and products.

Master data granularity from continent to city, and explore how dimensions and measures shape visuals in Tableau and Power BI for deeper sales insights.

Explore time series analysis to visualize sales trends and seasonality over years, months, and days using continuous date dimensions, line and area charts, and trend line analytics.

Learn how data bins and class intervals organize data into ranges for histogram-based analysis, with a practical age example using seven five-unit bins from 10 to 70.

Learn to create bins in Tableau to group age and income, convert age to a dimension, and analyze customer segments with bar charts by age and income bands.

Tackle homework in data visualization with Tableau and Power BI: compute total orders, daily sales over 30000 (2012–2015), max sales, and average monthly profit by technology category across four years.

Organize data fields into folders and hierarchies for customers, locations, orders, and projects, then analyze daily sales, maximum sales, and monthly profit by technology category in Tableau and Power BI.

Explore how a dashboard functions as a graphical user interface showing key performance indicators for a business process, with sheets added to display sales indicators or quantity sold.

Create a Tableau dashboard displaying sales and KPI time series with monthly trends, category and product breakdowns, and threshold-based filters to highlight top-performing items.

Create dashboard diagrams by building sales by country maps, applying filters across worksheets, and analyzing time series and sales by category for Australia.

Create and customize a dashboard by arranging sheets, removing legends, and using a country filter, then adjust sizing to automatic, preview on devices, and set a dashboard title.

Interpret KPIs by analyzing the trend line, category sales, and country performance to drive data-driven decisions.

Tell a data story in Tableau or Power BI by sequencing visualizations to show facts and outcomes, with story points and diagrams as pages that lead to conclusions.

Create a data story in Tableau and Power BI highlighting U.S. sales by country, time (2012–2016), category, and product, including peak sales 2.3 million with technology as the highest category.

Connect to an Excel dataset of American universities, clean and convert fields to measures, fix data types, and prepare data for map visualizations in Tableau and Power BI.

Create a United States map in Tableau to visualize the number of universities per state, fix misspelled locations, apply filters, add labels, and compare public versus private universities.

Learn to create a state map of total student enrollment and label it. Then compute the average percentage of graduates out of enrollers and adjust color to reflect the averages.

Connect to an Excel dataset, clean and map location fields in Tableau, convert them to spatial data, and resolve unknown cities by building a country, state, city hierarchy.

Explore how to join tables for data visualization by linking customers and orders on common fields such as customer id and order id, comparing inner, left, and full outer joins.

Join the customers, orders, and order details tables in Tableau to analyze orders and sales by company, using inner, left, right, and full outer joins and calculated fields.

Learn how to blend data in Tableau by combining primary and secondary sources to compare sales and profit across locations and periods.

Learn to blend data from two sources in Tableau by connecting two Excel files, setting primary and secondary sources, and configuring relationships based on shared fields and correct time granularity.

Blend data in Tableau part 2 to compare Company A and Company B across states, using dual-axis, color-coded sales, and time-series charts while filtering missing data.

Group multiple dimension members into a single category in tableau and explore constant and dynamic sets, including three top salt products, to enable region-wide analysis like African region groups.

Create a group in Tableau by turning location into geographic, then form western, middle, and eastern region groups from states to analyze regional sales and profit.

Create a constant set in Tableau to highlight the top three states by sales and profit, color in/out members, and enable a dynamic set.

Learn to create dynamic sets in Tableau using top and condition to identify the top five customers by sales and the top profitable customers, with filters for profit analysis.

Combine two Tableau sets to identify the top five customers by sales who also generate profit above 8000, using an inner join style combined set.

Use Tableau's quick table calculation to compute the percentage of orders that generated profit or loss. Build a pie chart, label counts, and format as percent of total.

Add a table calculation to analyze the number of orders per category and per customer segment (consumer, corporate, home office) across furniture, office supplies, and technology.

Create a tax percentage parameter in Tableau, define 1%, 2%, and 3% values, and use a calculated field to compute sales plus tax, reflecting changes in the diagram.

Learn how to add a reference line in Tableau to benchmark average sales by category, compare technology, furniture, and office supplies, and use a parameter to set target values.

Explore scatter plot analysis in Tableau by visualizing sales and profit across countries, products, and customers, using color, size, and opacity to reveal profit vs. loss and top categories.

Learn to use Tableau's forecast feature to predict future sales from time-series data, configure forecast periods, view confidence intervals, and interpret the regression model.

Apply Tableau's unsupervised cluster tool to group data by investment and revenue, interpret clusters, and identify high-revenue, low-investment opportunities in technology products.

Explore the American Airlines flight data, including year, month, arrivals, delays by reason, and cancellations, with up to July 2019 in a Tableau and Power BI context.

Visualize arrival flights per airline in Tableau and Power BI using a date-based line chart, a calculated date field, and filters to compare airlines.

Create a bar chart to compare airline arrival flights and delays by percent of total for 2018, revealing Southwest's top arrivals and Delta's lower delays.

Visualize the percentage of delayed flights per airline over time in Tableau using a calculated field, highlighting summer peaks and a February 2019 spike.

Map the percentage of delayed flights per state in Tableau by extracting city and state from airport names and building a location hierarchy, then format percentages and compare states.

Create a data visualization story by calculating the percentage of delayed flights by reason, build bar charts, then assemble a dashboard and story to identify the leading delay cause.