Power BI Introduction

Explore text, date, and number functions in Power BI, including rounding, square root, exponent, logarithm, division by 1000, and creating new columns through transform.

Connect and import data into Power BI from Excel, shape queries in Power Query, set promoted headers, and apply data type steps for a clean dataset.

Explore how Power BI changes data types, choose between whole numbers, decimals, text, and date types, and understand why correct typing matters for calculations.

Explore data shaping in Power BI by removing, renaming, and reordering columns, duplicating columns for calculations, and managing steps in the query transformation process.

Learn how to clean and prepare imported text data in Power BI by removing top and bottom rows, blank rows, errors, and duplicates, promoting headers, and applying targeted filters.

Transform data in power bi by applying text functions, such as replace values and errors, split and merge columns, and format text, to clean and prepare data for reporting.

Import data from a csv by selecting text csv for customer data in Power BI, noting csv files contain a table and no navigation steps; adjust delimiters and data types.

Discover Power BI date and time functions, from calculating age from birth dates to extracting year or month and handling duration via date menus in the interface.

Merge queries in Power BI by linking the product and product group tables on product group number to add the group name. Explain left outer, inner, right, full outer joins.

Learn to append queries in Power BI by combining two tables into one, aligning column names, and appending at the end or after a step, with a database union analog.

Organize queries and folders in Power Query, rename steps for clarity, apply changes to all rows, refresh data, and save the final report.

Learn how to model data in Power BI using a star schema, with a fact table and dimension tables, and decide between free modeling and third normal form.

Plan and build a Power BI data model, either from a custom design or a data warehouse. Define relationships and star schemas, and fine-tune measures, formatting, and sorting for reporting.

Create a Power BI report page from a star schema data model, using table and matrix visuals, dragging revenue and year fields, and converting between list and matrix views.

Format Power BI visuals using the format pane to adjust page layout, grid lines, headers, subtotals, and display units. Add text boxes, images, and effects to design polished reports.

Apply basic and advanced filters to Power BI visuals, including not blank and greater-than filters, and use product group filtering to control report content.

Learn to define page filters and filters on all pages in Power BI, and apply a year filter to visuals so values update across the page or entire report.

Explore Power BI basic diagrams, from column and bar charts to line, area, pie, doughnut, waterfall, and small multiples, with data axes, tooltips, legends, and formatting.

Publish your Power BI reports to the Power BI service, share via workspaces, and manage access using licenses and permissions, while editing reports built on the semantic model.

Import the Excel training data into Power BI, transform it with Power Query Editor, and build an interactive report with visualizations and KPIs before publishing to the Power BI cloud.

Learn how to load an Excel file into Power BI, use Get Data, navigate sheets with the navigator, and transform data in Power Query to build a basic column chart.

Transform data with Power Query Editor by applying steps, shaping queries, and converting data types to ensure accurate calculations for revenue and visuals.

Design your first Power BI report page by creating, resizing, and configuring visuals, using data fields, date hierarchies, and basic formatting, filters, and slicers to tell a data story.

Publish and share your Power BI reports to the cloud, manage workspaces and licenses, refresh data, and collaborate with colleagues.