{"product_id":"power-bi-hands-on-reports-and-dashboards-training","title":"Power BI: Hands-On Reports and Dashboards Training","description":"\u003cdiv\u003e\u003cp\u003eExperience Power BI Desktop and Power BI Service in action. Watch and perform exercises to connect to 7 million records from various sources, refine the data in Power Query and import the tables into Power BI. Organize and model your data to “slice and dice” summary information. Implement insightful, dynamic data visualizations. Publish your report to Power BI Service. Add a workspace and an app to distribute your report and share it with others.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePower BI: Hands-On Reports and Dashboards Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eConnect to various data sources in Power BI Desktop and Power Query; refine and clean up data; restructure tables; and import data to the Power BI document.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eImplement a tabular data model for reporting, examining, and relating tables with a calculated column to handle a many-to-many relationship.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eTake a tour of visuals: move and resize the visual container; populate the visual with the design well; format the visual with the formatting pane and analytic panes. Finally, examine the Ellipse for additional features: show as a table and sorting.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eFilter the visual with the top 5 items. Investigate custom grouping to add a column to a table. Use the new field in a visual. Filter the page using the custom group as a criterion. Add a slicer to add additional filters to the page.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003ePlace several visuals on the page and examine cross-filtering — control cross-filtering by editing interactions.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage automatic date and custom hierarchies to drill down from summary to detail information. Explore cross-filtering and interactions to gain insights into granular information.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eEnhance the data model with DAX formulas to add a date table and measure summing sales for this year. Explore implicit measures vs. explicit measures.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eProgram a formula with CALCULATE and SAMEPERIODLASTYEAR functions to produce the previous year’s total. Find the % Growth reusing custom measures and the DIVIDE Function.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eTell the data story - format visuals, add finishing touches - investigate themes, backgrounds, and conditional formatting; refresh data and publish your results to the Power BI Service.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eExplore the Power Bi Service, activate a unique workspace to collaborate with others online – publish and add reports to the new workspace.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eConsider various dashboard designs to launch multiple reports with tiles that preview the report. Pin several tiles to a custom dashboard. Add a visual with the Q\u0026amp;A feature.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eExamine the files used in the workspace. Then, transform the unique workspace into an app to distribute your reports and share them with others.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eBonus: Share your app with others in the class with an app on the phone.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eReports and Dashboards Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eLearning Tree Course 1360, Introduction to Power BI Training, offers a great base before taking this course.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWho should attend?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis course's audience is data and business professionals who need to learn how to build Power BI reports to present data using a tabular model and insightful visualizations telling a dynamic data story to share with others in your organization and online.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExam information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree end-of-course exam included\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLab 1 - Accessing \u0026amp; Preparing the Data\u003c\/h4\u003e\n\u003cp\u003eConnect to multiple data sources and prepare the data for reporting\u003c\/p\u003e\n\u003cp\u003eConnect to multiple data sources\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eView original data in Excel\u003c\/li\u003e\n\u003cli\u003eConnect to a CSV file in Power BI\u003c\/li\u003e\n\u003cli\u003eConnect to an Excel file from Power Query\u003c\/li\u003e\n\u003cli\u003eConnect to a file folder and combine CSV files from Power Query\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eHands-on Exercise – Connect to multiple data sources\u003c\/b\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAdjust and Prepare Data in Power Query\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview Power Query Interface\u003c\/li\u003e\n\u003cli\u003eRename Tables\u003c\/li\u003e\n\u003cli\u003eFill in missing data\u003c\/li\u003e\n\u003cli\u003eSplit Columns by Delimiter\u003c\/li\u003e\n\u003cli\u003eAdd a column with Columns by Examples\u003c\/li\u003e\n\u003cli\u003eChange Data Types\u003c\/li\u003e\n\u003cli\u003eRemove top or bottom rows\u003c\/li\u003e\n\u003cli\u003eTranspose a table\u003c\/li\u003e\n\u003cli\u003eAppend Data to bring two tables together\u003c\/li\u003e\n\u003cli\u003eFilter rows\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eHands-on Exercise – Connect to multiple data sources\u003c\/b\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLab 2 – Data Modelling and Exploration\u003c\/h4\u003e\n\u003cp\u003eExplore the data with visuals and build a data model enhanced by calculations.\u003c\/p\u003e\n\u003cp\u003eOverview of Power BI Views\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplement Visuals\u003c\/li\u003e\n\u003cli\u003eInsert and configure visuals\u003c\/li\u003e\n\u003cli\u003eShow data as tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eModel Data\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview of relationship types\u003c\/li\u003e\n\u003cli\u003eRelate tables in the Model View\u003c\/li\u003e\n\u003cli\u003eAdd a calculated column to handle many to many relationships.\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eHands-on Exercise – Data Modeling and Exploration\u003c\/b\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExplore the data with Filters\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExamine Top N Filter with visuals\u003c\/li\u003e\n\u003cli\u003eLeverage custom groups in visuals\u003c\/li\u003e\n\u003cli\u003eFilter the page with values from a custom group\u003c\/li\u003e\n\u003cli\u003eImplement a slicer to filter the page\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExamining data with Hierarchies and Cross Filtering\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDiscover insights with automatic Date Hierarchies\u003c\/li\u003e\n\u003cli\u003eAdd custom Hierarchy groups\u003c\/li\u003e\n\u003cli\u003eExplore Cross Filtering Visuals\u003c\/li\u003e\n\u003cli\u003eEdit interactions between Visuals\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eHands-on Exercise – Edit Interactions, Slicers, and Hierarchies\u003c\/b\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eEnhance the Data Model with a Date Table\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplement a date table for time intelligence formulas\u003c\/li\u003e\n\u003cli\u003eRelate the Date table to the sales table\u003c\/li\u003e\n\u003cli\u003eAdjust Hierarchies to use the date table\u003c\/li\u003e\n\u003cli\u003eHide key fields not used in reporting\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eRefine the data model with Measures\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChange the formula used in an implicit measure – Show Values as\u003c\/li\u003e\n\u003cli\u003eDesign an explicit measure\u003c\/li\u003e\n\u003cli\u003eFind out the total from last year with CALCULATE and SAMEPERIODLASTYEAR Functions\u003c\/li\u003e\n\u003cli\u003eAdd a percent change measure using the DIVIDE Function\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eHands-on Exercise – Date Calendars and DAX formulas\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLab 3 – Visualizations\u003c\/h4\u003e\n\u003cp\u003eTell the data story, format visuals to gain insights into the data, and publish the report to Power BI Service.\u003c\/p\u003e\n\u003cp\u003eVisualize and format visuals to present insights\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConditional Formatting\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eReturn to Power Query to make changes and refresh data\u003c\/p\u003e\n\u003cp\u003eArrange visuals to tell the Data story\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFormat slicers with URL images\u003c\/li\u003e\n\u003cli\u003eApply a combo clustered column chart to show the variation of time and comparison between dates\u003c\/li\u003e\n\u003cli\u003eAdd a Gauge visual to show Total Revenue vs. Last Year’s sales\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eHands-on Exercise – Format Visuals and Update Data\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eFinishing Touches\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDiscover themes to change the look of a report\u003c\/li\u003e\n\u003cli\u003eImport a custom corporate theme\u003c\/li\u003e\n\u003cli\u003eRefine the page background with a jpg graphic\u003c\/li\u003e\n\u003cli\u003eAdd a Title and Logo\u003c\/li\u003e\n\u003cli\u003eFind an automated slicer from AppSource\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eHands-on Exercise – Finishing Touches\u003c\/strong\u003e\u003c\/li\u003e\n\u003cli\u003eBonus: Try out a bookmark to store filters on the page and create a slide show\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cdiv\u003e\n\u003cp\u003ePublish Online\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLab 4-5 – Visualizations\u003c\/h4\u003e\n\u003cp\u003eImplement a dashboard online. Define a custom workspace to store, share and collaborate on reports.\u003c\/p\u003e\n\u003cp\u003eDefine terminology and explore Dashboard designs to handle multiple reports\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTour of Online Menus and Workspaces\u003c\/li\u003e\n\u003cli\u003eAdd a custom Workspace\u003c\/li\u003e\n\u003cli\u003ePublish reports to the Workspace\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eImplement a Dashboard to access more than one report\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePin report items to a Dashboard\u003c\/li\u003e\n\u003cli\u003eConfigure the Dashboard for a Web page\u003c\/li\u003e\n\u003cli\u003eConfigure the Dashboard for the Phone\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eHands-on Exercise: Dashboards\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePublish Workspace to an App\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cstrong\u003eHands-on Exercise – Create an App\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBonus: Access the new app on Power BI Mobile with your phone\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267A38US \/ 2026-07-27T09:00:00 \/ New York","offer_id":47534204846299,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266A66CN \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216562729179,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"267D00US \/ 2026-07-13T09:00:00 \/ San Francisco","offer_id":48216562794715,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AA02CN \/ 2026-10-01T09:00:00 \/ Ottawa","offer_id":48216562827483,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AA66US \/ 2026-10-05T09:00:00 \/ Austin","offer_id":48216562860251,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BA07CN \/ 2026-11-23T09:00:00 \/ Toronto","offer_id":48216562893019,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BA51US \/ 2026-11-09T09:00:00 \/ Herndon, VA","offer_id":48216562925787,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BA52US \/ 2026-11-30T09:00:00 \/ Aurora, CO","offer_id":48216562958555,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26CA45US \/ 2026-12-14T09:00:00 \/ New York","offer_id":48216562991323,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271A60US \/ 2027-01-04T09:00:00 \/ Bellevue, WA","offer_id":48216563024091,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"272A03CN \/ 2027-02-22T09:00:00 \/ Ottawa","offer_id":48291026895067,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273A44US \/ 2027-03-15T09:00:00 \/ Austin","offer_id":48363059478747,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273A45US \/ 2027-03-30T09:00:00 \/ Herndon, VA","offer_id":48523463557339,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274A05CN \/ 2027-04-26T09:00:00 \/ Toronto","offer_id":48669340270811,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"275A43US \/ 2027-05-17T09:00:00 \/ New York","offer_id":48778584883419,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"269D47US \/ 2026-09-03T09:00:00 \/ Online","offer_id":48837147525339,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"269D48US \/ 2026-09-14T09:00:00 \/ Online","offer_id":48837147623643,"sku":"US-1232-IL","price":1640.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/power-bi-hands-on-reports-and-dashboards-training","provider":"Learning Tree International","version":"1.0","type":"link"}