Microsoft Power BI for Beginners

Build an AI-powered Power BI dashboard with World Happiness Report data, including GDP per capita, and visualize with maps, bubble charts, and AI-driven key insights.

Explore data with your personal Power BI assistant, using GPT-4 for advanced guidance and comparing GPT-3.5, while examining World Happiness Report data.

Connect Power BI to your first data source, focusing on csv files. Use the power query editor to promote headers, set data types, and transform data for a ready-to-use dashboard.

Connect your first data source in Power BI by importing a World Happiness Report CSV. Explore applied steps like source, navigation, promote headers, and change data type.

Power BI connects to the 2015 World Happiness Report data, transforms it, and renames the table to World Happiness Data 2015 with promoted headers and proper data types.

Explore the difference between transform and add column in the Power Query Editor, and learn when to modify existing data versus creating new columns.

Learn the difference between transform and add column in Power BI, with examples of data type changes and calculated columns, plus AI prompts for formatting country or region names.

Explore a Power BI practice solution comparing transform vs add column using 2015 World Happiness data, guiding with Power Query to capitalize region words, uppercase the column, and replace values.

Master numerical value handling in the Power Query editor by calculating the average GDP per capita, counting distinct values, and rounding to two decimals, using transform rather than add column.

Round the perception of corruption to two decimal places in the Power Query Editor using add column or transform, and learn why averages use measures in Power BI.

Learn to use Power BI and the Power Query editor to compute max, min, and average of the family score, count unique regions, and round dystopia to three decimals.

Create your first Power BI dashboard by inserting an image and a text box as a title, then resize and position elements using gridlines, snap to grid, and lock objects.

Learn to insert images and text in Power BI dashboards with AI guidance: add images to reports and pin them, and use the home text box for text.

Adjust the Power BI dashboard title to Calibri, 32 point size, and uppercase, then insert a rectangle behind the report title with hex color #AB10F, adjusting transparency and layering.

Master slicers, matrices, and maps in Power BI to build an interactive dashboard, link visuals, filter by country, and display a happiness score using a 2019 World Happiness Report dataset.

Visualize country or region data on a Power BI map, then use a country or region slicer to filter visuals across the report page.

Display a matrix of country or region versus rank in Power BI, sort ascending, and add GDP per capita; switch to a filled map and discuss the insights.

Learn to create cards and filters in Power BI, including multi row cards and top N filtering, to highlight the country with the highest GDP per capita and related visuals.

Use AI as your personal instructor to create a Power BI card visual showing the country with the highest GDP per capita, using a top-one filter after data import.

Create Power BI cards and top-N filters to show Finland as the highest happiness score and Singapore as the lowest corruption, preserving formatting and updating titles accordingly.

Explore creating scatter plots and bubble charts in Power BI, plotting GDP per capita against happiness scores, sizing by overall rank, and enriching visuals with color by category and tooltips.

Create a scatterplot in power BI by importing data and plotting GDP per capita on the x-axis against happiness score. Enable interactivity and set the data color to red.

Create a scatter chart of freedom to make life choices versus score in Power BI, customize triangles in red on a light blue background with 50% transparency, and update title.

Visualize bar charts in Power BI and apply filters to display top ten countries by happiness score, then adjust the x-axis range and explore stacked, clustered, and 100% stacked options.

Learn to build a stacked bar chart in Power BI showing the top ten countries by happiness score, including data import, axis setup, filtering, and saving.

Learn to create a stacked bar chart in Power BI showing bottom ten happiness scores, filter to bottom ten, set the x-axis from 2.5 to 3.5, and color bars red.

Create and customize a tree map to display countries by GDP per capita. Filter to top 20, apply gradient colors, and configure data labels and category colors.

Create a tree map in Power BI to visualize hierarchical data with nested rectangles. Size and color reflect GDP per capita for top ten countries, with filtering and saving options.

Add a treemap to display social support by country or region, filter to the top ten, and apply a gradient color scale to visualize differences.

Discover Power BI AI visuals like key influencers and the Q&A tool to analyze happiness scores using GDP per capita, social support, and healthy life expectancy.

Learn to use the Power BI key influencers visual to identify factors affecting the happiness score, configure the visual, and analyze top and low segments, then save the report.

Practice with Power BI Q&A and smart narrative tools to analyze country scores, identify highest and lowest corruption perceptions, and generate insights from your report.

Publish your Power BI report to a workspace and explore a dashboard with maps, matrix, tree map, and key influencer insights for happiness and GDP per capita.