Power BI for Data Visualization and Analysis

Explore data transformation techniques in Power BI, including splitting a combined column into country, year, and order number, creating a duplicate column, and applying delimiter-based splits to build meaningful charts.

Learn to transform data in Power BI by merging columns to create combined fields (full name or category and subcategory) and applying numeric and text transformations (rounding, absolute value, uppercase).

Learn how to use group by in Power BI to summarize sales by shipping model, create grouped aggregates (sum, average), and rename results for clear analysis.

Power BI for data visualization and analysis shows how to join two tables using a common key, select inner, left, or right joins, and create a merged table for charts.

Create calculated columns in Power BI using simple formulas, then use custom and conditional columns to classify sales as high, medium, or low and create visuals.

Explore the difference between measures and calculated columns, learn when to create new measures, and understand performance and storage considerations for Power BI reports.

Learn how to group small subcategories into an 'others' category in Power BI by creating a new group, naming it, and applying it to charts for clearer data visualization.

Explore creating a category-subcategory data hierarchy in Power BI by dragging subcategories under categories, forming a hierarchy column, and enabling drill down with expand and collapse in reports.

Create a stacked column chart in Power BI using subcategories and add data labels for clearer breakdowns. Customize title, colors, and legend position, and compare with horizontal stacked bar chart.

Learn to create clustered column and bar charts to compare subcategory sales and profit, using clustering to reveal trends, legends, and year-by-year quarterly insights.

Explore Power BI line charts to analyze sales across a date hierarchy with drill up and down, comparing continuous trends and seasonal patterns to identify peak months like November.

Learn how area charts in Power BI visualize data with filled regions and how stacked area charts reveal category contributions over time.

Create and customize pie and donut charts in power bi, configuring labels and percentages (absolute values or percent of total) for categories and subcategories, with legend control.

Explore line and stack column charts to visualize profit trends and total sales by market, with segment comparisons (consumer, corporate, home office) and cluster column charts.

Explore creating and customizing funnel charts in Power BI to visualize subcategory sales, compare highest and lowest items, and apply colors, gradients, and conditional formatting for clear data storytelling.

Power BI waterfall chart visualizes cumulative data, ranking subcategories from highest to lowest to reveal total sales and each category's impact for data visualization and analysis.

Explore Power BI tree map charts to visualize subcategory performance, compare sales by rectangle area, and customize labels and units to reveal segment-level insights.

Explore correlations with scatter plot charts in Power BI, linking independent and dependent variables like family income and insurance coverage; visualize how total income relates to loan amount.

Visualize data on Power BI maps by selecting countries, using bubble size and color to compare sales across furniture, technology, and office supplies, with map controls and styles.

Explore how to create a data table in Power BI, configure category and subcategory fields, apply calculations such as sum, average, count, and percentage of grand total to analyze transactions.

Create a matrix crosstab in Power BI to present sales by region and segment, switching between absolute values and percentage of grand total for insights.

Create and customize cards and multirow cards in Power BI to visualize total sales, profit, quantity, and country reach on a single page, with tailored titles and colors.

Learn to use slicers to filter multiple data visuals by region in Power BI, creating charts and tables and controlling which visuals they affect.

Explore how to apply filters across charts, pages, and reports in Power BI, using category, subcategory, and region to shape data slices.

Explore how to visualize and analyze the relationship between family income and insurance coverage in Power BI using scatterplots, trend lines, benchmark lines, and minimum, maximum, average, and median lines.

Learn to forecast sales in Power BI using the analytics forecast on a line chart, displaying upper and lower bounds for a 10-month horizon with auto seasonality.

Explore data clustering in Barbiere by building a scatterplot of annual income and spending score, then automatically identify and interpret customer clusters.

Publish a two-page Power BI report to your workspace using a Power BI account, then share or delete the published report and its dataset.