{"title":"Business Intelligence","description":null,"products":[{"product_id":"introduction-to-power-bi-training","title":"Introduction to Power BI Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eIntroduction to Power BI Training\u003c\/strong\u003e will give you all the skills you need to jump-start your Power BI journey. It discusses in depth the industry-recognized steps from raw data to detailed analysis via five main stages:\u003c\/p\u003e\r\n\u003cul\u003e\r\n\u003cli\u003eLoading data into Power BI from a wide range of data sources, such as CSV and XLS files\u003c\/li\u003e\r\n\u003cli\u003eTransforming data using Data Analysis Expressions (DAX), M, and Power Query languages\u003c\/li\u003e\r\n\u003cli\u003eCreating and extending a comprehensive data model with DAX\u003c\/li\u003e\r\n\u003cli\u003eVisualizing data in Power BI desktop using built-in tools\u003c\/li\u003e\r\n\u003cli\u003eSharing and collaborating with the Power BI service or Power BI server\u003c\/li\u003e\r\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to Power BI Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate interactive visualizations to deliver business insights.\u003c\/li\u003e\n\u003cli\u003eExtract business intelligence by using DAX, M, and Power Query.\u003c\/li\u003e\n\u003cli\u003eShare Datasets, Reports, and Dashboards in the Power BI Service.\u003c\/li\u003e\n\u003cli\u003ePre-format and import data from an Excel Report using Power Query and M.\u003c\/li\u003e\n\u003cli\u003eAdd value with measures, calculated columns, and calculated tables using DAX.\u003c\/li\u003e\n\u003cli\u003eImport data from relational databases and integrate it with other data sources.\u003c\/li\u003e\n\u003cli\u003eProfile, shape, and filter tables to prepare for analyses by fixing data issues.\u003c\/li\u003e\n\u003cli\u003eIntegrate data from CSV files and Excel Workbooks.\u003c\/li\u003e\n\u003cli\u003eExplore and extend a Power BI data model.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eTraining Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to Microsoft Power BI Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 1: Power BI Overview\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eVisual analysis and visual analytics\u003c\/li\u003e\n\u003cli\u003ePower BI Infrastructure\u003c\/li\u003e\n\u003cli\u003eLoading Data\u003c\/li\u003e\n\u003cli\u003eIntroduction to Power BI Desktop\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 1.1 Loading and Visualizing data\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 2: Transforming Data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eUsing Power Query to clean, transform and load data\u003c\/li\u003e\n\u003cli\u003eProfiling your data\u003c\/li\u003e\n\u003cli\u003eResolve data quality issues\u003c\/li\u003e\n\u003cli\u003eApply user-friendly names to Queries, tables, and columns\u003c\/li\u003e\n\u003cli\u003eImport data from an Excel formatted report\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 2.1 Transforming Data with Power Query\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 2.2 Appending, Merging, and Combining Queries\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 3: Creating a Data Model\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the role of the Data Model in Power BI\u003c\/li\u003e\n\u003cli\u003eCreate table relationships\u003c\/li\u003e\n\u003cli\u003eUnderstand Cardinality and Cross Filtering\u003c\/li\u003e\n\u003cli\u003eDiscuss Star and Snowflake schema\u003c\/li\u003e\n\u003cli\u003eCreate a Date Dimension\u003c\/li\u003e\n\u003cli\u003eBuild a Data Model from multiple Data sources\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 3.1 Creating a Data Model\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 4: Visualizing your Data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDiscuss Report settings\u003c\/li\u003e\n\u003cli\u003eChoosing the right visualizations\u003c\/li\u003e\n\u003cli\u003eCreating, formatting, and styling your reports\u003c\/li\u003e\n\u003cli\u003eUsing Hierarchies and Drilldown\u003c\/li\u003e\n\u003cli\u003eUtilizing Slicers and Filters\u003c\/li\u003e\n\u003cli\u003eAdding Custom Visualizations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 4.1 Creating Reports Part 1\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 4.2 Creating Reports Part 2\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 4.3 Creating Reports Part 3\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 5: Introduction to DAX, Calculated Columns and Measures\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eGain an Introduction to DAX\u003c\/li\u003e\n\u003cli\u003eDifferentiate between Calculated Columns and Measures\u003c\/li\u003e\n\u003cli\u003eCreate Calculated Columns\u003c\/li\u003e\n\u003cli\u003eCreate Measures\u003c\/li\u003e\n\u003cli\u003eUnderstand Filter and Row context\u003c\/li\u003e\n\u003cli\u003eUnderstand the power of the Calculate function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-on Exercise 5.1 Introduction to DAX\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eOptional Hands-on Exercise 5.2 Intermediate Level DAX\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDiscuss the Power BI Service and Power BI Server\u003c\/li\u003e\n\u003cli\u003eUnderstand the main components of the Power BI Service\u003c\/li\u003e\n\u003cli\u003ePublish a Power BI Project to the Power BI Service\u003c\/li\u003e\n\u003cli\u003eShare Reports\u003c\/li\u003e\n\u003cli\u003eBuild and Share Dashboards\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A96US \/ 2026-06-24T09:00:00 \/ Online","offer_id":47534192951515,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267A11CN \/ 2026-07-22T09:00:00 \/ Ottawa","offer_id":47534192984283,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267B21US \/ 2026-07-08T09:00:00 \/ Austin","offer_id":47534193049819,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267B22US \/ 2026-07-15T09:00:00 \/ Online","offer_id":47534193082587,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A12CN \/ 2026-08-05T09:00:00 \/ Toronto","offer_id":47534193115355,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A87US \/ 2026-08-12T09:00:00 \/ New York","offer_id":47534193180891,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A88US \/ 2026-08-19T09:00:00 \/ Herndon, VA","offer_id":47534193213659,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A84US \/ 2026-09-02T09:00:00 \/ Austin","offer_id":47534193311963,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A85US \/ 2026-09-09T09:00:00 \/ Washington, DC","offer_id":47572768391387,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A12CN \/ 2026-09-16T09:00:00 \/ Toronto","offer_id":47597098172635,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A13CN \/ 2026-09-23T09:00:00 \/ Ottawa","offer_id":47621793513691,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB47US \/ 2026-10-14T09:00:00 \/ Bellevue, WA","offer_id":48216535138523,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB48US \/ 2026-10-21T09:00:00 \/ Herndon, VA","offer_id":48216535171291,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB49US \/ 2026-10-28T09:00:00 \/ Austin","offer_id":48216535204059,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA21CN \/ 2026-11-18T09:00:00 \/ Ottawa","offer_id":48216535236827,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA22CN \/ 2026-11-23T09:00:00 \/ Toronto","offer_id":48216535269595,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB93US \/ 2026-11-04T09:00:00 \/ Washington, DC","offer_id":48216535302363,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CB34US \/ 2026-12-02T09:00:00 \/ New York","offer_id":48216535335131,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CB35US \/ 2026-12-09T09:00:00 \/ Aurora, CO","offer_id":48216535367899,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B75US \/ 2027-01-13T09:00:00 \/ Herndon, VA","offer_id":48216535466203,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B76US \/ 2027-01-20T09:00:00 \/ Austin","offer_id":48216535498971,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B77US \/ 2027-01-27T09:00:00 \/ Washington, DC","offer_id":48216535531739,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A17CN \/ 2027-02-03T09:00:00 \/ Ottawa","offer_id":48216535564507,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A18CN \/ 2027-02-17T09:00:00 \/ Toronto","offer_id":48270695039195,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B49US \/ 2027-03-03T09:00:00 \/ New York","offer_id":48313105350875,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B41US \/ 2027-04-07T09:00:00 \/ Herndon, VA","offer_id":48570238533851,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B42US \/ 2027-04-14T09:00:00 \/ Austin","offer_id":48591353970907,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B43US \/ 2027-04-21T09:00:00 \/ Washington, DC","offer_id":48619712839899,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A15CN \/ 2027-04-28T09:00:00 \/ Ottawa","offer_id":48696368595163,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B72US \/ 2027-05-05T09:00:00 \/ San Francisco","offer_id":48741609210075,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A16CN \/ 2027-05-12T09:00:00 \/ Toronto","offer_id":48762846642395,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B73US \/ 2027-05-26T09:00:00 \/ New York","offer_id":48805406507227,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"276B61US \/ 2027-06-02T09:00:00 \/ Aurora, CO","offer_id":48825876775131,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268D36US \/ 2026-08-26T09:00:00 \/ Online","offer_id":48837147754715,"sku":"US-1360-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"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}]},{"product_id":"introduction-to-dax-for-power-bi","title":"Introduction to DAX for Power BI","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eIntroduction to \u003cabbr title=\"Data Analysis Expressions\"\u003eDAX\u003c\/abbr\u003e for Power \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e\u003c\/strong\u003e presents Data Analysis Expressions (DAX) in Power BI from an intermediate to an advanced level. The journey starts with an introductory discussion about DAX, the syntax of DAX statements, and how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third-party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises.\u003c\/p\u003e\r\n\u003cp\u003eWe will discuss many of the functions in DAX and how they could be used in a Power BI Project including explaining the use of iterator functions vs standard statistical functions. There are discussions explaining Calculated Columns, Tables, and Measures discussing the differences. There is also an explanation about Quick Measures and how we can utilize those. We will explain DAX Context and where those contexts apply. There are separate discussions for the CALCULATE function, the usage of a Data Model and incorporating a Date Dimension, and also using Time Intelligence Functions. We will conclude with a discussion around utilizing DAX with Row Level Security.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to DAX for Power BI Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eStructure DAX with Power BI and DAX Studio\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eExtract business intelligence by using DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAdd value with measures, calculated columns and calculated tables using DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eUtilize the different types of Dax functions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAppreciate DAX context and where it applies\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eUnderstand the use of a Data Model and how to extend it\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCreate a Star and\/or Snowflake schema as your data model\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAdd a Date dimension to your model\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eImplement Row Level security with DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDevelop a Star Schema from a Flat File Schema\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDecide when to use M in Power Query or DAX in Power BI\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\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to DAX for Power BI Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eIntroduction to DAX for Power BI Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to Power BI Training\u003c\/li\u003e\n\u003cli\u003ePower BI: Hands-On Reports and Dashboards Training\u003c\/li\u003e\n\u003cli\u003ePower BI: Advanced Data Modeling and Shaping\u003c\/li\u003e\n\u003cli\u003eor equivalent working experience\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eAudience Profile\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eThis course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eExam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree Exam provided at the end of class\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eIntroduction to DAX for Power BI Course Outline\u003c\/h4\u003e\n\u003cp\u003eChapter 1: Introduction to DAX\u003c\/p\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat is \u003cabbr title=\"Data Analysis Expressions\"\u003eDAX\u003c\/abbr\u003e?\u003c\/li\u003e\n\u003cli\u003eDAX Functions\u003c\/li\u003e\n\u003cli\u003eCalculated Columns and Tables\u003c\/li\u003e\n\u003cli\u003eQuick Measures and Measures\u003c\/li\u003e\n\u003cli\u003eDAX Context\u003c\/li\u003e\n\u003cli\u003eWriting DAX in Power \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 1.1: Introduction to DAX\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 2: Working with a Data Model\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the role of the Data Model in Power BI\u003c\/li\u003e\n\u003cli\u003eDescribe the components of a Data Model\u003c\/li\u003e\n\u003cli\u003eWhat are Star and Snowflake schemas?\u003c\/li\u003e\n\u003cli\u003eFact and Dimension tables\u003c\/li\u003e\n\u003cli\u003eHow to build a Data Model from multiple Data sources\u003c\/li\u003e\n\u003cli\u003eWhy create a Date Dimension?\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 2.1: Working with a Data Model\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 3: Using DAX in Power BI\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWriting DAX with DAX Studio\u003c\/li\u003e\n\u003cli\u003eFormatting DAX with DAX Formatter\u003c\/li\u003e\n\u003cli\u003eSummarizing and Aggregating functions\u003c\/li\u003e\n\u003cli\u003eWorking with Joins\u003c\/li\u003e\n\u003cli\u003eFiltering with DAX\u003c\/li\u003e\n\u003cli\u003eOther useful Dax Functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-on Exercise 3.1 Working with DAX Functions – Part 1\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe the power behind the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eAdd filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eIgnore filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eUpdate filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eDescribe Time Intelligence and the Time Intelligence functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 3.2 Working with DAX Functions – Part 2\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 4: DAX and Row Level Security\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat is Row Level Security (\u003cabbr title=\"Row Level Security\"\u003eRLS\u003c\/abbr\u003e)\u003c\/li\u003e\n\u003cli\u003eUseful DAX functions for RLS\u003c\/li\u003e\n\u003cli\u003eDefining Roles for RLS\u003c\/li\u003e\n\u003cli\u003eCrating DAX Rules for RLS\u003c\/li\u003e\n\u003cli\u003eManaging Security and working with Members\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExercise 4.1 Implementing Row Level Security\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 5: Comparing DAX and M\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview of \u003cabbr title=\"Power Query M formula language\"\u003eM\u003c\/abbr\u003e in Power Query\u003c\/li\u003e\n\u003cli\u003eWhen to use M or DAX\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269A14CN \/ 2026-09-28T09:00:00 \/ Ottawa","offer_id":47634346049755,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266A75CN \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216573280475,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"268C90US \/ 2026-08-24T09:00:00 \/ Herndon, VA","offer_id":48216573313243,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BB97US \/ 2026-11-24T09:00:00 \/ Herndon, VA","offer_id":48216573346011,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271A22CN \/ 2027-01-04T09:00:00 \/ Ottawa","offer_id":48216573378779,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"272B27US \/ 2027-02-22T09:00:00 \/ Herndon, VA","offer_id":48291027419355,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273A18CN \/ 2027-03-30T09:00:00 \/ Ottawa","offer_id":48523464736987,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"275B76US \/ 2027-05-25T09:00:00 \/ Herndon, VA","offer_id":48804198056155,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true}]},{"product_id":"sql-server-integration-services-ssis-training-for-business-intelligence","title":"SQL Server Integration Services (SSIS) Training for Business Intelligence","description":"\u003cdiv\u003e\n\u003cp\u003eIn this \u003cstrong\u003eSQL server integration services\u003c\/strong\u003e course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. In addition, you will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML (Extensible Markup Language), ODBC (Open Database Connectivity), and OLE DB (Object Linking and Embedding Database) — and effectively and securely manage data migration across various platforms.\u003c\/p\u003e\r\n\u003cp\u003eIn this SSIS training course, you’ll gain the skills to migrate and transform data with SSIS. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence. Specifically, you learn to deploy packages to an SSIS server, assemble tasks to perform complex data migrations, and enhance package functionality with scripting.\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Integration Services (SSIS) Training for Business Intelligence Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this SSIS Training for Business Intelligence course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSolve data management problems by migrating and processing data. \u003c\/li\u003e\n\u003cli\u003ePerform nonstandard imports and exports using the Script component. \u003c\/li\u003e\n\u003cli\u003eAssemble tasks to perform complex data migrations. \u003c\/li\u003e\n\u003cli\u003eETL (Extract, Transform and Load) data. \u003c\/li\u003e\n\u003cli\u003eIncrementally migrate data from SQL (Structured Query Language) Server data sources using CDC (Change Data Capture). \u003c\/li\u003e\n\u003cli\u003eDeploy packages to an SSIS catalog. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eSQL Server Integration Services Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should have familiarity with relational database management systems, programming concepts, and SQL language. \u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSSIS Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Integration Services\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDefining SQL SSIS (Server Integration Services) \u003c\/li\u003e\n\u003cli\u003eExploring the need for migrating diverse data \u003c\/li\u003e\n\u003cli\u003eThe role of BI (Business Intelligence) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: SSIS Architecture and Tools\u003c\/h4\u003e\n\u003cp\u003eManaging heterogeneous data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eETL (Leveraging the Extract, Transform and Load) capabilities of SSIS \u003c\/li\u003e\n\u003cli\u003eRunning wizards for basic migrations \u003c\/li\u003e\n\u003cli\u003eCreating packages for complex tasks \u003c\/li\u003e\n\u003cli\u003eExplore other supported data sources, such as Hadoop and NoSQL (not only SQL) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIllustrating SSIS architecture \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing between data flow pipeline and package runtime \u003c\/li\u003e\n\u003cli\u003eExecuting packages on the client side or hosted in the SSIS service \u003c\/li\u003e\n\u003cli\u003eBulletproofing a package with package environments \u003c\/li\u003e\n\u003cli\u003ePackage restorability with checkpoint files \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSimplifying deployments\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing between project and package deployment modes \u003c\/li\u003e\n\u003cli\u003eDeploying packages to the SSISDB (SSIS Catalog Database) \u003c\/li\u003e\n\u003cli\u003eRunning packages from SQL Server \u003c\/li\u003e\n\u003cli\u003eLeveraging package parameters \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Implementing Tasks and Containers\u003c\/h4\u003e\n\u003cp\u003eUtilizing basic SSIS objects \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConfiguring connection managers \u003c\/li\u003e\n\u003cli\u003eAdding data flow tasks to packages \u003c\/li\u003e\n\u003cli\u003eReviewing progress with data viewers \u003c\/li\u003e\n\u003cli\u003eAssembling tasks to perform complex data migrations \u003c\/li\u003e\n\u003cli\u003eMigrating multiple files with FOREACH container \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOperating system-level tasks \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCopying, moving, and deleting files \u003c\/li\u003e\n\u003cli\u003eTransferring files with the FTP (File Transfer Protocol) task \u003c\/li\u003e\n\u003cli\u003eCommunicating with external sources \u003c\/li\u003e\n\u003cli\u003eSending messages through mail \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eProcessing XML \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIterating XML nodes \u003c\/li\u003e\n\u003cli\u003eWriting XML files from databases \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Extending Capabilities with Scripting\u003c\/h4\u003e\n\u003cp\u003eWriting expressions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaking properties dynamic with variables\u003c\/li\u003e\n\u003cli\u003eUtilizing expressions in loop iterations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eScript Task\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExtending functionality with the Script Task\u003c\/li\u003e\n\u003cli\u003eDebugging, breakpoints, and watches\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Transforming with the Data Flow Task\u003c\/h4\u003e\n\u003cp\u003ePerforming transforms on columns \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConverting and calculating columns \u003c\/li\u003e\n\u003cli\u003eTransforming with Character Map \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eProfiling, combining, and splitting data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMerge, Union, and Conditional Split \u003c\/li\u003e\n\u003cli\u003eMulticasting and converting data \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eManipulating row sets and BLOB data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAggregate, sort, audit, and look up data \u003c\/li\u003e\n\u003cli\u003eImporting and exporting BLOB data \u003c\/li\u003e\n\u003cli\u003eRedirecting error rows \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerforming database operations \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExecuting a SQL task \u003c\/li\u003e\n\u003cli\u003eBulk inserting data from text files \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Error Handling, Logging and Transactions\u003c\/h4\u003e\n\u003cp\u003eOrganizing package workflow \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining success, failure, completion, and expression precedence constraints \u003c\/li\u003e\n\u003cli\u003eHandling events and event bubbling \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDesigning robust packages \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChoosing log providers \u003c\/li\u003e\n\u003cli\u003eAdapting solutions with package configurations \u003c\/li\u003e\n\u003cli\u003eAuditing package execution results \u003c\/li\u003e\n\u003cli\u003eAccessing package data with ADO.NET (ActiveX Data Object) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A92US \/ 2026-06-15T09:00:00 \/ Herndon, VA","offer_id":47534218346715,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"268A86US \/ 2026-08-11T09:00:00 \/ Herndon, VA","offer_id":47534218379483,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269A77CN \/ 2026-09-01T09:00:00 \/ Ottawa","offer_id":48216562106587,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BA20CN \/ 2026-11-03T09:00:00 \/ Ottawa","offer_id":48216562139355,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CB10US \/ 2026-12-01T09:00:00 \/ Herndon, VA","offer_id":48216562172123,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272A16CN \/ 2027-02-09T09:00:00 \/ Ottawa","offer_id":48233010233563,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273B22US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377301500123,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275A15CN \/ 2027-05-11T09:00:00 \/ Ottawa","offer_id":48759289250011,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"microsoft-sql-server-training-course","title":"Microsoft SQL Server Training Course","description":"\u003cdiv\u003e\n\u003cp\u003eIn this intro to \u003cstrong\u003eMicrosoft SQL Server® training\u003c\/strong\u003e, you gain the introductory skills to maximize SQL Server's benefits. Learn how to use the various administrative and development tools within SQL Server, including the Microsoft BI (Business Intelligence) stack of Integration Services, Analysis Services, and Reporting Services. \u003c\/p\u003e\r\n\u003cp\u003eSQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence solutions. Attend this hands-on course and learn to leverage these features.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft SQL Server Training Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Microsoft SQL Server training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate and administer SQL Server databases.\u003c\/li\u003e\n\u003cli\u003eWrite Transact-SQL queries to retrieve and manipulate data.\u003c\/li\u003e\n\u003cli\u003eSecure, back up, and monitor databases with Management Studio.\u003c\/li\u003e\n\u003cli\u003eIntegrate SQL Server with Microsoft Office.\u003c\/li\u003e\n\u003cli\u003eTransform data into strategic information using Business Intelligence components.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eMicrosoft SQL Server Training Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis is SQL Server training for beginners, so no prior experience is needed to take this course. You will learn the basics of SQL Server and gain the introductory skills needed to maximize SQL Server’s benefits.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft SQL Server Introduction Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introducing SQL Server\u003c\/h4\u003e\n\u003cdiv\u003e\n\u003cp\u003eOverview of the SQL Server suite of products\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFundamentals of the relational database engine\u003c\/li\u003e\n\u003cli\u003eBenefits of the Business Intelligence stack\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSQL Server components and tools\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server Agent and Management Studio\u003c\/li\u003e\n\u003cli\u003eIntegration Services\u003c\/li\u003e\n\u003cli\u003eAnalysis Services\u003c\/li\u003e\n\u003cli\u003eReporting Services\u003c\/li\u003e\n\u003cli\u003eData Quality Services\u003c\/li\u003e\n\u003cli\u003eMaster Data Services\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Database\u003c\/h4\u003e\n\u003cp\u003eConstructing a relational database\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChoosing optimal file size and growth parameters\u003c\/li\u003e\n\u003cli\u003eWorking with database schemas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining tables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSpecifying appropriate data types\u003c\/li\u003e\n\u003cli\u003eIndexing tables with Management Studio\u003c\/li\u003e\n\u003cli\u003eAdding, modifying, or removing columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSafeguarding data with constraints\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnforcing uniqueness through primary key constraints\u003c\/li\u003e\n\u003cli\u003eValidating conditions with check constraints\u003c\/li\u003e\n\u003cli\u003eProtecting relationships with foreign keys\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Leveraging Server Programmability\u003c\/h4\u003e\n\u003cp\u003eRetrieving data with Transact-SQL \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying Query Designer to construct select statements \u003c\/li\u003e\n\u003cli\u003eRetrieving subsets of data from multiple tables using joins and the WHERE clause criteria \u003c\/li\u003e\n\u003cli\u003eAnalyzing data for aggregate functions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eModifying data with SQL commands \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInserting new rows into tables \u003c\/li\u003e\n\u003cli\u003eUpdating targeted data \u003c\/li\u003e\n\u003cli\u003eDeleting specific rows \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIntroduction to developing programming constructs \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating stored procedures for productivity \u003c\/li\u003e\n\u003cli\u003eWriting user-defined functions to simplify queries \u003c\/li\u003e\n\u003cli\u003eDeploying triggers to capture change events \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Administering SQL Server Databases\u003c\/h4\u003e\n\u003cp\u003eExecuting the Maintenance Plan Wizard\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefragmenting data and checking database integrity\u003c\/li\u003e\n\u003cli\u003eImproving performance by rebuilding indexes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAutomating administrative tasks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eScheduling repeating jobs\u003c\/li\u003e\n\u003cli\u003eImplementing a backup strategy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eMonitoring SQL Server resources\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDisplaying current activity and expensive queries\u003c\/li\u003e\n\u003cli\u003eRunning reports with Management Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSecuring the database infrastructure\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAuthenticating SQL Server and Windows logins\u003c\/li\u003e\n\u003cli\u003eAssigning users to database and server roles\u003c\/li\u003e\n\u003cli\u003eGranting or revoking permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Integrating External Applications\u003c\/h4\u003e\n\u003cp\u003eConnecting to Microsoft Office\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePulling data from SQL Server into Excel\u003c\/li\u003e\n\u003cli\u003eCreating a front-end interface with Access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTransferring business information\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImporting and exporting data from text files\u003c\/li\u003e\n\u003cli\u003eMigrating an Access database to SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Implementing Business Intelligence Solutions\u003c\/h4\u003e\n\u003cp\u003eExtracting data with Integration Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTransforming and cleaning data\u003c\/li\u003e\n\u003cli\u003eLoading data into a data warehouse\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInformation delivery with Reporting Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesign reports quickly with the Report Builder\u003c\/li\u003e\n\u003cli\u003eDeploying reports for centralized access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAggregating data with Analysis Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding multidimensional cubes\u003c\/li\u003e\n\u003cli\u003ePredicting trends with data mining\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping a Business Intelligence strategy\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging Excel and Power Pivot\u003c\/li\u003e\n\u003cli\u003eTransferring data into knowledge with BI functionality\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B58US \/ 2026-07-14T09:00:00 \/ Herndon, VA","offer_id":47534212219099,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269B02US \/ 2026-09-15T09:00:00 \/ Herndon, VA","offer_id":47595015635163,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"268A86CN \/ 2026-08-18T09:00:00 \/ Ottawa","offer_id":48216552669403,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC78US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216552702171,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CA30CN \/ 2026-12-15T09:00:00 \/ Ottawa","offer_id":48216552734939,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272B82US \/ 2027-02-16T09:00:00 \/ Herndon, VA","offer_id":48266084843739,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A34CN \/ 2027-03-16T09:00:00 \/ Ottawa","offer_id":48377302155483,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C56US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780665159899,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"power-bi-data-analyst-training-course-pl-300","title":"Design and Manage Analytics Solutions Using Power BI (PL-300)","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eDesign and Manage Analytics Solutions Using Power BI (PL-300)\u003c\/strong\u003e training course will discuss the various methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from various sources, including relational and non-relational data.\u003c\/p\u003e\r\n\u003cp\u003eThis course will also explore how to implement proper security standards and policies across the Power BI spectrum, including datasets and groups. Finally, the course will also discuss managing and deploying reports and dashboards for sharing and content distribution.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDesign and Manage Analytics Solutions Using Power BI (PL-300) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIngest, clean, and transform data.\u003c\/li\u003e\n\u003cli\u003eModel data for performance and scalability.\u003c\/li\u003e\n\u003cli\u003eDesign and create reports for data analysis.\u003c\/li\u003e\n\u003cli\u003eApply and perform advanced report analytics.\u003c\/li\u003e\n\u003cli\u003eManage and share report assets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eTraining Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eSuccessful Data Analysts start this role with experience of working with data in the cloud.\u003c\/p\u003e\n\u003cp\u003eSpecifically:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstanding core data concepts.\u003c\/li\u003e\n\u003cli\u003eKnowledge of working with relational data in the cloud.\u003c\/li\u003e\n\u003cli\u003eKnowledge of working with non-relational data in the cloud.\u003c\/li\u003e\n\u003cli\u003eKnowledge of data analysis and visualization concepts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eYou can gain the prerequisites and a better understanding of working with data in Azure by completing Learning Tree course 8566, Introduction to Cloud Infrastructure (AZ-900) before taking PL-300.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eCertification Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis course helps you prepare for \u003ca href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/pl-300\" title=\"Exam PL-300 | Microsoft Learn\" target=\"_blank\" rel=\"nofollow noopener\"\u003eExam PL-300: Microsoft Power BI Data Analyst\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eDesign and Manage Analytics Solutions Using Power BI Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Discover data analysis\u003c\/h4\u003e\n\u003cp\u003eWould you like to explore the journey of a data analyst and learn how a data analyst tells a story with data? In this module, you explore the different roles in data and learn the different tasks of a data analyst.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you'll:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn about the roles in data.\u003c\/li\u003e\n\u003cli\u003eLearn about the tasks of a data analyst.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Get started building with Power BI\u003c\/h4\u003e\n\u003cp\u003eLearn what Power BI is, including its building blocks and how they work together.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eLearn how Power BI services and applications work together.\u003c\/li\u003e\n\u003cli\u003eExplore how Power BI can make your business more efficient.\u003c\/li\u003e\n\u003cli\u003eLearn how to create compelling visuals and reports.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Get data in Power BI\u003c\/h4\u003e\n\u003cp\u003eYou'll learn to retrieve data from various sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIdentify and connect to a data source\u003c\/li\u003e\n\u003cli\u003eGet data from a relational database, like Microsoft SQL Server\u003c\/li\u003e\n\u003cli\u003eGet data from a file like Microsoft Excel\u003c\/li\u003e\n\u003cli\u003eGet data from applications\u003c\/li\u003e\n\u003cli\u003eGet data from Azure Analysis Services\u003c\/li\u003e\n\u003cli\u003eSelect a storage mode\u003c\/li\u003e\n\u003cli\u003eFix performance issues\u003c\/li\u003e\n\u003cli\u003eResolve data import errors\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Clean, transform, and load data in Power BI\u003c\/h4\u003e\n\u003cp\u003ePower Query has incredible features dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns to know which columns have the valuable data you're seeking for deeper analytics.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eResolve inconsistencies, unexpected or null values, and data quality issues.\u003c\/li\u003e\n\u003cli\u003eApply user-friendly value replacements.\u003c\/li\u003e\n\u003cli\u003eProfile data so you can learn more about a specific column before using it.\u003c\/li\u003e\n\u003cli\u003eEvaluate and transform column data types.\u003c\/li\u003e\n\u003cli\u003eApply data shape transformations to table structures.\u003c\/li\u003e\n\u003cli\u003eCombine queries.\u003c\/li\u003e\n\u003cli\u003eApply user-friendly naming conventions to columns and queries.\u003c\/li\u003e\n\u003cli\u003eEdit M code in the Advanced Editor\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Design a data model in Power BI\u003c\/h4\u003e\n\u003cp\u003eThe process of creating a complicated data model in Power BI is straightforward. If your data is coming in from more than one transactional system, you can have dozens of tables you have to work with before you know it. Building a great data model is about simplifying the disarray.\u003c\/p\u003e\n\u003cp\u003eA star schema is one way to simplify a data model, and you learn about its terminology and implementation in this module. You will also learn about why choosing the correct data granularity is essential for the performance and usability of your Power BI reports. Finally, you learn about improving performance with your Power BI data models.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate common data tables\u003c\/li\u003e\n\u003cli\u003eConfigure many-to-many relationships\u003c\/li\u003e\n\u003cli\u003eResolve circular relationships\u003c\/li\u003e\n\u003cli\u003eDesign star schemas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Add measures to Power BI Desktop models\u003c\/h4\u003e\n\u003cp\u003eThis module teaches you to work with implicit and explicit measures. You'll start by creating simple measures summarizing a single column or table. Then, you'll create more complex measures based on other measures in the model. Additionally, you'll learn about the similarities and differences between a calculated column and a measure.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDetermine when to use implicit and explicit measures.\u003c\/li\u003e\n\u003cli\u003eCreate simple measures.\u003c\/li\u003e\n\u003cli\u003eCreate compound measures.\u003c\/li\u003e\n\u003cli\u003eCreate quick measures.\u003c\/li\u003e\n\u003cli\u003eDescribe similarities and differences between a calculated column and a measure.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Add calculated tables and columns to Power BI Desktop models\u003c\/h4\u003e\n\u003cp\u003eBy the end of this module, you'll be able to add calculated tables and columns to your data model. You'll also be able to describe the row context used to evaluate calculated column formulas. Because it's possible to add columns to a table using Power Query, you'll also learn when it's best to create calculated columns instead of Power Query custom columns.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate calculated tables.\u003c\/li\u003e\n\u003cli\u003eCreate calculated columns.\u003c\/li\u003e\n\u003cli\u003eIdentify row context.\u003c\/li\u003e\n\u003cli\u003eDetermine when to use a calculated column instead of a Power Query custom column.\u003c\/li\u003e\n\u003cli\u003eAdd a date table to your model by using DAX calculations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: Use DAX time intelligence functions in Power BI Desktop models\u003c\/h4\u003e\n\u003cp\u003eBy the end of this module, you'll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDefine time intelligence.\u003c\/li\u003e\n\u003cli\u003eUse standard DAX time intelligence functions.\u003c\/li\u003e\n\u003cli\u003eCreate functional intelligence calculations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 9: Optimize a model for performance in Power BI\u003c\/h4\u003e\n\u003cp\u003ePerformance optimization, also known as performance tuning, involves changing the data model's current state so that it runs more efficiently. Essentially, when your data model is optimized, it performs better.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eReview the performance of measures, relationships, and visuals.\u003c\/li\u003e\n\u003cli\u003eUse variables to improve performance and troubleshooting.\u003c\/li\u003e\n\u003cli\u003eImprove performance by reducing cardinality levels.\u003c\/li\u003e\n\u003cli\u003eOptimize DirectQuery models with table-level storage.\u003c\/li\u003e\n\u003cli\u003eCreate and manage aggregations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 10: Design Power BI reports\u003c\/h4\u003e\n\u003cp\u003eBecause Power BI includes more than 30 core visuals, it can be challenging for a beginner to select the correct visual. This module will guide you through selecting the most appropriate visual type to meet your design and report layout requirements.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eLearn about the structure of a Power BI report.\u003c\/li\u003e\n\u003cli\u003eLearn about report objects.\u003c\/li\u003e\n\u003cli\u003eSelect the appropriate visual type to use\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 11: Configure Power BI report filters\u003c\/h4\u003e\n\u003cp\u003eReport filtering is a complex topic because many techniques are available for filtering a Microsoft Power BI report. However, with complexity comes control, allowing you to design reports that meet requirements and expectations. Some filtering techniques apply at design time, while others are relevant at report consumption time (in reading view). What matters is that your report design allows report consumers to narrow down to the data points that interest them intuitively.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDesign reports for filtering.\u003c\/li\u003e\n\u003cli\u003eDesign reports with slicers.\u003c\/li\u003e\n\u003cli\u003eDesign reports by using advanced filtering techniques.\u003c\/li\u003e\n\u003cli\u003eApply consumption-time filtering.\u003c\/li\u003e\n\u003cli\u003eSelect appropriate report filtering techniques.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 12: Enhance Power BI report designs for the user experience\u003c\/h4\u003e\n\u003cp\u003eThe features and capabilities covered in this module will help you enhance your reports to make them more refined.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDesign reports to show details.\u003c\/li\u003e\n\u003cli\u003eDesign reports to highlight values.\u003c\/li\u003e\n\u003cli\u003eDesign reports that behave like apps.\u003c\/li\u003e\n\u003cli\u003eWork with bookmarks.\u003c\/li\u003e\n\u003cli\u003eDesign reports for navigation.\u003c\/li\u003e\n\u003cli\u003eWork with visual headers.\u003c\/li\u003e\n\u003cli\u003eDesign reports with built-in assistance.\u003c\/li\u003e\n\u003cli\u003eUse specialized visuals\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 13: Perform analytics in Power BI\u003c\/h4\u003e\n\u003cp\u003eYou'll learn how to use Power BI to perform data analytical functions, identify outliers in your data, group data, and big data for analysis. You'll also learn how to perform time series analysis. Finally, you'll work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, and the Analyze feature.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you'll:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplore statistical summary.\u003c\/li\u003e\n\u003cli\u003eIdentify outliers with Power BI visuals.\u003c\/li\u003e\n\u003cli\u003eGroup and bin data for analysis.\u003c\/li\u003e\n\u003cli\u003eApply clustering techniques.\u003c\/li\u003e\n\u003cli\u003eConduct time series analysis.\u003c\/li\u003e\n\u003cli\u003eUse the Analyze feature.\u003c\/li\u003e\n\u003cli\u003eUse advanced analytics custom visuals.\u003c\/li\u003e\n\u003cli\u003eReview Quick insights.\u003c\/li\u003e\n\u003cli\u003eApply AI Insights.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 14: Create and manage workspaces in Power BI\u003c\/h4\u003e\n\u003cp\u003eLearn how to navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate and manage Power BI workspaces and items.\u003c\/li\u003e\n\u003cli\u003eDistribute a report or dashboard.\u003c\/li\u003e\n\u003cli\u003eMonitor usage and performance.\u003c\/li\u003e\n\u003cli\u003eRecommend a development lifecycle strategy.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot data by viewing its lineage.\u003c\/li\u003e\n\u003cli\u003eConfigure data protection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch4\u003eModule 15: Enhance Power BI report designs for the user experience\u003c\/h4\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 16: Manage datasets in Power BI\u003c\/h4\u003e\n\u003cp\u003eYou can use a single dataset to build many reports with Microsoft Power BI. Reduce administrative overhead with scheduled dataset refreshes and resolve connectivity errors.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUse a Power BI gateway to connect to on-premises data sources.\u003c\/li\u003e\n\u003cli\u003eConfigure a scheduled refresh for a dataset.\u003c\/li\u003e\n\u003cli\u003eConfigure incremental refresh settings.\u003c\/li\u003e\n\u003cli\u003eManage and promote datasets.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot service connectivity.\u003c\/li\u003e\n\u003cli\u003eBoost performance with query caching (Premium).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 17: Create dashboards in Power BI\u003c\/h4\u003e\n\u003cp\u003eMicrosoft Power BI dashboards are different from Power BI reports. Dashboards allow report consumers to create a single artifact of directed data personalized just for them. Dashboards can be composed of pinned visuals that are taken from different reports. Where a Power BI report uses data from a single dataset, a Power BI dashboard can contain visuals from different datasets.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eSet a mobile view.\u003c\/li\u003e\n\u003cli\u003eAdd a theme to the visuals in your dashboard.\u003c\/li\u003e\n\u003cli\u003eConfigure data classification.\u003c\/li\u003e\n\u003cli\u003eAdd real-time dataset visuals to your dashboards.\u003c\/li\u003e\n\u003cli\u003ePin a live report page to a dashboard.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 18: Implement row-level security\u003c\/h4\u003e\n\u003cp\u003eRow-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you'll learn how to implement RLS using a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eIn this module, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConfigure row-level security by using a static method.\u003c\/li\u003e\n\u003cli\u003eConfigure row-level security by using a dynamic method\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267A06CN \/ 2026-07-29T09:00:00 \/ Ottawa","offer_id":47534175551707,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268B93US \/ 2026-08-12T09:00:00 \/ New York","offer_id":47534175584475,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268B94US \/ 2026-08-26T09:00:00 \/ Herndon, VA","offer_id":47534175682779,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269B47US \/ 2026-09-09T09:00:00 \/ Austin","offer_id":47572768194779,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267D21US \/ 2026-07-08T09:00:00 \/ San Francisco","offer_id":48216543297755,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267D22US \/ 2026-07-22T09:00:00 \/ Washington, DC","offer_id":48216543330523,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268B00CN \/ 2026-08-05T09:00:00 \/ Toronto","offer_id":48216543363291,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA40CN \/ 2026-10-14T09:00:00 \/ Toronto","offer_id":48216543396059,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA41CN \/ 2026-10-21T09:00:00 \/ Ottawa","offer_id":48216543428827,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB18US \/ 2026-10-07T09:00:00 \/ Washington, DC","offer_id":48216543461595,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB24US \/ 2026-11-04T09:00:00 \/ New York","offer_id":48216543494363,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB25US \/ 2026-11-23T09:00:00 \/ Herndon, VA","offer_id":48216543527131,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA95US \/ 2026-12-02T09:00:00 \/ Austin","offer_id":48216543559899,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA96US \/ 2026-12-09T09:00:00 \/ Aurora, CO","offer_id":48216543592667,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA98US \/ 2026-12-16T09:00:00 \/ Bellevue, WA","offer_id":48216543625435,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A59CN \/ 2027-01-13T09:00:00 \/ Ottawa","offer_id":48216543658203,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A60CN \/ 2027-01-20T09:00:00 \/ Toronto","offer_id":48216543690971,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B34US \/ 2027-01-06T09:00:00 \/ Washington, DC","offer_id":48216543723739,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B35US \/ 2027-01-27T09:00:00 \/ New York","offer_id":48216543756507,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A90US \/ 2027-02-10T09:00:00 \/ Herndon, VA","offer_id":48236920864987,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A91US \/ 2027-02-24T09:00:00 \/ Austin","offer_id":48294630555867,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B16US \/ 2027-03-31T09:00:00 \/ Washington, DC","offer_id":48525735461083,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A50CN \/ 2027-04-07T09:00:00 \/ Ottawa","offer_id":48570238861531,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A51CN \/ 2027-04-14T09:00:00 \/ Toronto","offer_id":48591360852187,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B02US \/ 2027-04-21T09:00:00 \/ New York","offer_id":48619719033051,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B24US \/ 2027-05-05T09:00:00 \/ Herndon, VA","offer_id":48741608718555,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B25US \/ 2027-05-19T09:00:00 \/ Austin","offer_id":48783418261723,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269D26US \/ 2026-09-16T09:00:00 \/ Online","offer_id":48837148639451,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269D27US \/ 2026-09-23T09:00:00 \/ Online","offer_id":48837148672219,"sku":"US-8574-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"designing-data-models-in-excel-for-power-bi-reports-training","title":"Designing Data Models in Excel for Power BI Reports Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis course focuses on \u003cstrong\u003edesigning \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e Data Models\u003c\/strong\u003e to display in either an interactive Power BI report or an interactive Excel dashboard. This is both a fundamental Power BI course and an advanced Excel course that will take you through a data journey from importing, cleansing, and merging large amounts of data to analyzing the data to presenting strategic data in a PivotTable and a Power BI dashboard. This practical course provides flexibility and empowers you to choose how you want to present your business insights to help management make informed decisions.\u003cb\u003e\u003c\/b\u003e\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDesigning Data Models in Excel for Power BI Reports Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eTransform and present sophisticated data to provide Business Intelligence (BI)\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eActualize a data model from multiple sources with Power Pivot\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eShape and prepare your data with Power Query\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eMine and expose hidden information with Data Analysis eXpressions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCommunicate business and data insights with Power BI reports and dashboards\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\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eData Models in Excel for Power BI Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant course information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExperience with Excel at the level of:\n\u003cul\u003e\n\u003cli\u003eExcel Data Analysis Course • Course 195\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eThis course is applicable to all versions of Excel, from Excel 2010 to Excel 2021\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Identifying the Role of Power Pivot in Business Intelligence (BI)\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eIntroducing the Business Intelligence Tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExploring the Microsoft Business Intelligence tools\u003c\/li\u003e\n\u003cli\u003eDefining the requirements for a collaborative solution\u003c\/li\u003e\n\u003cli\u003eIdentifying the steps to create a Power BI dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power Pivot \u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNavigating the Power Pivot interface\u003c\/li\u003e\n\u003cli\u003eExtracting information from data with Power Pivot\u003c\/li\u003e\n\u003cli\u003eUncovering data interpretation issues\u003c\/li\u003e\n\u003cli\u003eCreating a simple dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Data Model with Power Pivot\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDefining a consolidated view of data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGenerating a data mashup from structured and unstructured data sources into a data model\u003c\/li\u003e\n\u003cli\u003eDeriving relationships from data sources with the Relationships tool and the Diagram View\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDenormalizing data to simplify usage within other BI reporting tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying the data model\u003c\/li\u003e\n\u003cli\u003eAcquiring data from related tables\u003c\/li\u003e\n\u003cli\u003eConsolidating information with calculated columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eQuerying SQL Server data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesigning queries to import data from \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server\u003c\/li\u003e\n\u003cli\u003eRelating tables with outer joins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFixing common data issues with Power Query\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExtracting, Transforming, and Loading (\u003cabbr title=\"Extracting, Transforming, and Loading\"\u003eETL\u003c\/abbr\u003e) data\u003c\/li\u003e\n\u003cli\u003eConverting data formats with Power Query steps\u003c\/li\u003e\n\u003cli\u003eParsing columns to aid analysis\u003c\/li\u003e\n\u003cli\u003eRemoving duplicates from a data set\u003c\/li\u003e\n\u003cli\u003eConstructing a single data set from multiple sources with the same field headings\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Shaping Data with Power Query\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power Query\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNavigating the Power Query interface\u003c\/li\u003e\n\u003cli\u003eExtracting, Transforming, and Loading (ETL) data\u003c\/li\u003e\n\u003cli\u003eConverting data formats with Power Query steps\u003c\/li\u003e\n\u003cli\u003eParsing columns to aid analysis\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCombining Data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMerging tables of data\u003c\/li\u003e\n\u003cli\u003eConstructing a single data set from multiple sources with the same field headings\u003c\/li\u003e\n\u003cli\u003eDevelop an automated solution to combining data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFiltering Data with Parameters\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeveloping queries\u003c\/li\u003e\n\u003cli\u003eRemoving duplicates from a data set\u003c\/li\u003e\n\u003cli\u003eDefining Excel tables as parameters for a Power Query\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDefining measures for business performance\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing the role of measures\u003c\/li\u003e\n\u003cli\u003eTranslating key business concepts into measures\u003c\/li\u003e\n\u003cli\u003eProviding context for measures within a PivotTable\u003c\/li\u003e\n\u003cli\u003eDetermining between implicit and explicit measures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImplementing DAX functions in Power Pivot\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExpressing information with measures\u003c\/li\u003e\n\u003cli\u003eExposing hidden information from data\u003c\/li\u003e\n\u003cli\u003eTroubleshooting and debugging DAX calculations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExploiting data analytics with aggregation\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuantifying and mining information with DAX functions\u003c\/li\u003e\n\u003cli\u003eSummarizing and aggregating data from other tables with the X functions\u003c\/li\u003e\n\u003cli\u003eEvaluating expressions with the CALCULATE() function and filter functions\u003c\/li\u003e\n\u003cli\u003eSubstituting values with the SWITCH() function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eMining for information with date and time analysis\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGrouping dates for time analysis\u003c\/li\u003e\n\u003cli\u003eComparing and categorizing time periods with Time Intelligence functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetting key business targets with KPIs\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAnalyzing performance with measures\u003c\/li\u003e\n\u003cli\u003eGauging performance against goals\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Designing Interactive Power BI dashboards\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power BI\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeciding on where to develop a dashboard\u003c\/li\u003e\n\u003cli\u003eImporting an Excel data model into Power BI Desktop\u003c\/li\u003e\n\u003cli\u003eDeveloping a data model in the Power BI Desktop\u003c\/li\u003e\n\u003cli\u003eCrafting visualizations from the analytics\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBuilding a Power BI dashboard\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConstructing Power BI visualizations\u003c\/li\u003e\n\u003cli\u003eDesigning visual-level, page-level, and report-level filter\u003c\/li\u003e\n\u003cli\u003eAssembling a Power BI Dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B23US \/ 2026-07-15T09:00:00 \/ Herndon, VA","offer_id":47534211072219,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C56US \/ 2026-09-09T09:00:00 \/ Herndon, VA","offer_id":48216585142491,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB95US \/ 2026-11-04T09:00:00 \/ Herndon, VA","offer_id":48216585175259,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B78US \/ 2027-01-13T09:00:00 \/ Herndon, VA","offer_id":48216585208027,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B51US \/ 2027-03-10T09:00:00 \/ Herndon, VA","offer_id":48334731149531,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B74US \/ 2027-05-12T09:00:00 \/ Herndon, VA","offer_id":48762886062299,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"advanced-visualization-with-power-bi-training","title":"Power BI: Data Visualization \u0026 Storytelling","description":"\u003cdiv\u003e\u003cp\u003e\u003cspan\u003eBecome a \u003cem\u003ereports and dashboards\u003c\/em\u003e expert with this 1-day Power BI Advanced Visualization course. In this \u003cstrong\u003ePower BI: Data Visualization \u0026amp; Storytelling\u003c\/strong\u003e, you will cover the Power BI report layouts and the agile process of creating Power BI data visualizations. In addition, learn about various design patterns within dashboards and reports and best practices for authoring great reports and dashboards!\u003c\/span\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePower BI: Data Visualization \u0026amp; Storytelling Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the art behind visualizations.\u003c\/li\u003e\n\u003cli\u003eUnderstand the implications behind choosing the right charts.\u003c\/li\u003e\n\u003cli\u003eUnderstand the impact of color.\u003c\/li\u003e\n\u003cli\u003eUnderstand the shape and size.\u003c\/li\u003e\n\u003cli\u003eUnderstand the use of Power BI custom visuals.\u003c\/li\u003e\n\u003cli\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eAttendees in this course should have experience with Power BI at the level of Learning Tree Course 1360, Introduction to Power BI Training.\u003c\/span\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePower BI: Data Visualization \u0026amp; Storytelling Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eTraining Content\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eModule 1: What is Story Telling with Data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eModule 2: The Science Behind Data Visualization\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eModule 3: The Process Behind Data Visualization\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eModule 4: Dashboards and Reports\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eModule 5: Chart Selection\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLab 05 Update and Format Charts\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 6: Accessibility and Custom Visuals\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLab 06 Add Accessibility and Custom Visual\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 7: Publishing and Formatting\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLab 07 Working with Visualizations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eModule 8: Report Authoring – Best Practices\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eModule 9: Dashboard and Goals Design\u003c\/strong\u003e\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"268C11US \/ 2026-08-17T09:00:00 \/ Online","offer_id":47534170603739,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269A10CN \/ 2026-09-14T09:00:00 \/ Online","offer_id":47591597670619,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"266D48US \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216545624283,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"267D30US \/ 2026-07-13T09:00:00 \/ Online","offer_id":48216545657051,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AB36US \/ 2026-10-05T09:00:00 \/ Online","offer_id":48216545689819,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AB37US \/ 2026-10-19T09:00:00 \/ Online","offer_id":48216545722587,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BA13CN \/ 2026-11-03T09:00:00 \/ Online","offer_id":48216545755355,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BB69US \/ 2026-11-16T09:00:00 \/ Online","offer_id":48216545886427,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26CB23US \/ 2026-12-14T09:00:00 \/ Online","offer_id":48216545919195,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271B55US \/ 2027-01-11T09:00:00 \/ Online","offer_id":48216545951963,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273B37US \/ 2027-03-02T09:00:00 \/ Online","offer_id":48310906519771,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274A09CN \/ 2027-04-01T09:00:00 \/ Online","offer_id":48531738624219,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B21US \/ 2027-04-14T09:00:00 \/ Online","offer_id":48591363047643,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B22US \/ 2027-04-26T09:00:00 \/ Online","offer_id":48669336273115,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"275B53US \/ 2027-05-18T09:00:00 \/ Online","offer_id":48780666536155,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269D28US \/ 2026-09-28T09:00:00 \/ Online","offer_id":48837148410075,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269D29US \/ 2026-09-21T09:00:00 \/ Online","offer_id":48837148442843,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269D30US \/ 2026-09-02T09:00:00 \/ Online","offer_id":48837148475611,"sku":"US-8648-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"power-bi-dashboard-training-one-day-course","title":"Power BI: Dashboard Training (One-Day Course)","description":"\u003cdiv\u003e\u003cp\u003eIn this one-day \u003cstrong\u003ePower \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e Dashboard Training\u003c\/strong\u003e workshop, you will learn how to navigate and use the Microsoft Power BI dashboard. In the last two hours of the workshop, you will learn how to build your own data reports and dashboards with the support of your instructor.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePower BI: Dashboard Training (One-Day Course) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eLearn how to connect to, import, and transform data from a variety of sources in Power BI\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eSimplify data with powerful visualization tools and build stunning reports\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLearn how to share dashboards with your team and publish them online\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eApply your knowledge in demo learning labs\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eFollow a curriculum based on Microsoft Official Courseware\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePower BI: Dashboard Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisite\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eAttendees in this course should have experience with Power BI at the level of Learning Tree Course 1360, Introduction to Power BI Training.\u003c\/span\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Accessing and Preparing Data\u003c\/h4\u003e\n\u003cp\u003eIn this module you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAccessing data\u003c\/li\u003e\n\u003cli\u003eData preparation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Data Modeling and Exploration\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExplore the Power BI Desktop layout\u003c\/li\u003e\n\u003cli\u003eUse joins and visuals\u003c\/li\u003e\n\u003cli\u003eCreate a formula to perform join of many to many\u003c\/li\u003e\n\u003cli\u003eShow result in visual\u003c\/li\u003e\n\u003cli\u003eFilter the visual to show top 5 manufactures by revenue\u003c\/li\u003e\n\u003cli\u003eLearn grouping\u003c\/li\u003e\n\u003cli\u003eMake a tree map and show filtering of other visuals\u003c\/li\u003e\n\u003cli\u003eFilter the page by group field\u003c\/li\u003e\n\u003cli\u003eCreate a date hierarchy visual\u003c\/li\u003e\n\u003cli\u003eEdit interactions\u003c\/li\u003e\n\u003cli\u003eAdd in a slicer\u003c\/li\u003e\n\u003cli\u003eAdd a date table for calculations\u003c\/li\u003e\n\u003cli\u003eMake a quick hierarchy on other fields\u003c\/li\u003e\n\u003cli\u003eAdd a matrix visual\u003c\/li\u003e\n\u003cli\u003eCalculate same period last year formula\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Data Visualization\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse the conditional format for the matrix visual\u003c\/li\u003e\n\u003cli\u003eChange dropdown to slicer buttons\u003c\/li\u003e\n\u003cli\u003eChange the revenue by year chart to a combo line and clustered\u003c\/li\u003e\n\u003cli\u003eMake a gauge visual\u003c\/li\u003e\n\u003cli\u003eTry out themes\u003c\/li\u003e\n\u003cli\u003eFormat country visual\u003c\/li\u003e\n\u003cli\u003ePractice page formatting\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Publishing\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn how to publish online\u003c\/li\u003e\n\u003cli\u003eCreate a workspace online and publish to the workspace\u003c\/li\u003e\n\u003cli\u003ePin visuals\u003c\/li\u003e\n\u003cli\u003eAsk a question on the dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Making an App\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will apply what you’ve learned to make an app.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267C47US \/ 2026-07-27T09:00:00 \/ Online","offer_id":47534171095259,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AA20US \/ 2026-10-02T09:00:00 \/ Online","offer_id":47640581898459,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"268A71CN \/ 2026-08-31T09:00:00 \/ Online","offer_id":48216547000539,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BB70US \/ 2026-11-12T09:00:00 \/ Online","offer_id":48216547033307,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26CB24US \/ 2026-12-15T09:00:00 \/ Online","offer_id":48216547066075,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271A11CN \/ 2027-01-19T09:00:00 \/ Online","offer_id":48216547098843,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273B38US \/ 2027-03-09T09:00:00 \/ Online","offer_id":48331762958555,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B23US \/ 2027-04-15T09:00:00 \/ Online","offer_id":48594348933339,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"275B54US \/ 2027-05-27T09:00:00 \/ Online","offer_id":48809992847579,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"266D96US \/ 2026-06-22T09:00:00 \/ Online","offer_id":48833436549339,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269D60US \/ 2026-09-17T09:00:00 \/ Online","offer_id":48837148573915,"sku":"US-8649-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"power-bi-administrator-in-a-day-training","title":"Power BI: Administrator in a Day Training","description":"\u003cdiv\u003e\n\u003cp\u003eIn this \u003cb\u003ePower BI Administrator in a Day training\u003c\/b\u003e course, you will learn how to manage the Microsoft Power BI platform within your organization, including how to:\u003c\/p\u003e\r\n\u003cul type=\"disc\"\u003e\r\n\u003cli\u003eConfigure access settings for different users\u003c\/li\u003e\r\n\u003cli\u003eMonitor the usage of the platform\u003c\/li\u003e\r\n\u003cli\u003eManage your organization's Power BI license\u003c\/li\u003e\r\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePower BI: Administrator in a Day Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cb\u003eIn this course, you will:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn how to use the admin tasks and tools of the Power BI admin portal.\u003c\/li\u003e\n\u003cli\u003eAutomate the admin tools by using PowerShell cmdlets.\u003c\/li\u003e\n\u003cli\u003eLearn how to securely share Power BI assets within your organization.\u003c\/li\u003e\n\u003cli\u003eAnalyze the Power BI audit log to identify and resolve problems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePower BI: Administrator in a Day Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModule 1: Introduction to Power BI\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePower BI Desktop and Power BI Service\u003c\/li\u003e\n\u003cli\u003eFostering and Managing Power BI in your organization\u003c\/li\u003e\n\u003cli\u003eUnderstanding the Admin roles: Global Admin, Power BI Administrator, Workspace Administrator\u003c\/li\u003e\n\u003cli\u003eTenant-wide settings \u003c\/li\u003e\n\u003cli\u003eRole of Administration and Governance \u003c\/li\u003e\n\u003cli\u003eExploring Data Sensitivity\u003c\/li\u003e\n\u003cli\u003eUsing the Power BI Admin portal \u003c\/li\u003e\n\u003cli\u003eLeveraging usage template apps\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eModule 2: Establishing a Power BI Environment\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eThe tenant\/your organization \u003c\/li\u003e\n\u003cli\u003eUsage metrics for dashboards and reports \u003c\/li\u003e\n\u003cli\u003eOffice 365 Audit logs vs. Power BI Acitivity Logs\u003c\/li\u003e\n\u003cli\u003eLicensing: Power BI Premium vs. Power BI Pro\u003c\/li\u003e\n\u003cli\u003eManager \u003cb\u003ew\u003c\/b\u003eorkspaces and assigning roles \u003c\/li\u003e\n\u003cli\u003eSharing  reports, dashboards, and apps\u003c\/li\u003e\n\u003cli\u003ePublishing to the web and managing embed code\u003c\/li\u003e\n\u003cli\u003eSharing with Sharepoint and Teams\u003c\/li\u003e\n\u003cli\u003eManaging capacity in Power BI Premium\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eModule 3: Automating Power BI Administration\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eManaging DataFlows\u003c\/li\u003e\n\u003cli\u003ePowerShell Power BI cmdlets\u003c\/li\u003e\n\u003cli\u003eScripting\u003c\/li\u003e\n\u003cli\u003eRow Level Security\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267C46US \/ 2026-07-06T09:00:00 \/ Online","offer_id":47534186823899,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"268A09CN \/ 2026-08-17T09:00:00 \/ Online","offer_id":47534186856667,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AA19US \/ 2026-10-01T09:00:00 \/ Online","offer_id":47638415671515,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BB67US \/ 2026-11-23T09:00:00 \/ Online","offer_id":48216534417627,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"272B06US \/ 2027-02-01T09:00:00 \/ Online","offer_id":48216534450395,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"272A10CN \/ 2027-02-18T09:00:00 \/ Online","offer_id":48273698586843,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273B35US \/ 2027-03-22T09:00:00 \/ Online","offer_id":48498606047451,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B19US \/ 2027-04-19T09:00:00 \/ Online","offer_id":48612316938459,"sku":"US-8645-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"hands-on-paginated-reports-with-power-bi","title":"Hands-On Paginated Reports with Power BI","description":"\u003cdiv\u003e\u003cp\u003eIn this \u003cstrong\u003ePower \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e Paginated Reports Training\u003c\/strong\u003e course, you will learn how to create, publish, and distribute paginated reports in Microsoft Power BI.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eHands-On Paginated Reports with Power BI Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eLearn how to design report layouts, visualize report data, add interactive features and implement query parameters\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eApply your knowledge in hands-on learning labs\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eFollow a curriculum based on Microsoft Official Courseware\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePower BI: Paginated Reports Courser Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Power BI Reporting\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroducing Power BI\u003c\/li\u003e\n\u003cli\u003ePower BI Reporting\u003c\/li\u003e\n\u003cli\u003ePaginated Reporting\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Designing Report Layouts\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroducing Report Builder\u003c\/li\u003e\n\u003cli\u003eDesigning report layouts\u003c\/li\u003e\n\u003cli\u003eSetting dynamic properties\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Retrieving Report Data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eCreating data sources\u003c\/li\u003e\n\u003cli\u003eCreating datasets\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Working with Parameters\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eIntroducing parameters\u003c\/li\u003e\n\u003cli\u003eCreating report \u0026amp; query parameters\u003c\/li\u003e\n\u003cli\u003eWorking with parameters\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Visualizing Report Data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eVisualizing report data\u003c\/li\u003e\n\u003cli\u003eCreating data regions\u003c\/li\u003e\n\u003cli\u003eCreating data visualizations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Adding Interactivity Features\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eToggling visibility\u003c\/li\u003e\n\u003cli\u003eInteractive Sorting\u003c\/li\u003e\n\u003cli\u003eAdding links and tooltips\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Beyond Report Development\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003ePublishing, consuming, delivering, embedding, and exporting reports\u003c\/li\u003e\n\u003cli\u003eUsing \u003cem\u003epaginated reports\u003c\/em\u003e\n\u003c\/li\u003e\n\u003cli\u003eMigrating \u003cabbr title=\"SQL (Structured Query Language) Server Reporting Services\"\u003eSSRS\u003c\/abbr\u003e reports\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"268C12US \/ 2026-08-24T09:00:00 \/ Herndon, VA","offer_id":47534217920731,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266D49US \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216567120091,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BB71US \/ 2026-11-12T09:00:00 \/ Herndon, VA","offer_id":48216567152859,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271B56US \/ 2027-01-19T09:00:00 \/ Herndon, VA","offer_id":48216567185627,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273B39US \/ 2027-03-24T09:00:00 \/ Herndon, VA","offer_id":48502326493403,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"275B33US \/ 2027-05-25T09:00:00 \/ Herndon, VA","offer_id":48804199301339,"sku":"US-8651-IL","price":1640.0,"currency_code":"USD","in_stock":true}]},{"product_id":"introduction-to-fabric","title":"Introduction to Microsoft Fabric","description":"\u003cdiv\u003e\n\u003cp\u003eUnlock the power of your data with our 2-day \u003cb\u003eIntroduction to Microsoft Fabric\u003c\/b\u003e course. Designed for professionals tasked with managing and analyzing data, this course provides a comprehensive introduction to Microsoft’s all-in-one analytics and data platform, Microsoft Fabric.\u003c\/p\u003e\r\n\u003cp\u003eYou’ll learn how to address the complexities of data spread across multiple systems, streamline data operations, and build scalable pipelines for business intelligence and analytics. Through hands-on exercises and expert instruction, participants will explore key Microsoft Fabric workloads, including Data Factory, Data Science, and Real-Time Analysis, all while focusing on efficiency, performance, and compliance.\u003c\/p\u003e\r\n\u003cp\u003eWhether you're a Data Scientist, BI Analyst, or Cloud Architect, this course will equip you with the skills to transform your data operations and leverage Microsoft Fabric to drive faster, more agile decision-making. Join us to gain practical knowledge of this cutting-edge platform and elevate your data strategy to the next level.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to Microsoft Fabric Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eThis course will benefit organizations:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eStruggling with managing data spread across multiple systems and platforms, leading to inefficiencies in data integration, analysis, and reporting.\u003c\/li\u003e\n\u003cli\u003eDifficulty building and maintaining scalable, reliable, and efficient data pipelines for analytics and business intelligence.\u003c\/li\u003e\n\u003cli\u003eJuggling between various tools for data storage, transformation, analysis, and visualization, and seeking a more streamlined, unified solution.\u003c\/li\u003e\n\u003cli\u003eFinding it challenging to scale data operations efficiently without compromising performance, security, or compliance, especially as data grows.\u003c\/li\u003e\n\u003cli\u003eLacking knowledge or experience in new technologies like Microsoft Fabric and looking for guidance on how to leverage it effectively.\u003c\/li\u003e\n\u003cli\u003eStruggling with consistent access to reliable, up-to-date data across teams, along with issues around data governance and compliance.\u003c\/li\u003e\n\u003cli\u003eNeeding to quickly get up to speed with Microsoft Fabric to support ongoing or upcoming data initiatives, while juggling other responsibilities.\u003c\/li\u003e\n\u003cli\u003eFacing pressure from stakeholders or leadership to speed up data-driven decision-making, requiring a faster, more agile analytics approach.\u003c\/li\u003e\n\u003cli\u003eDealing with isolated data sets that aren't easily accessible or integrated into broader analytics or reporting systems.\u003c\/li\u003e\n\u003cli\u003eNavigating the complexities of migrating data operations to the cloud, especially for teams transitioning from on-premises or hybrid environments.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to Power BI Training\u003c\/li\u003e\n\u003cli\u003eSome knowledge of Analytics and Data is beneficial.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to Microsoft Fabric Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003eChapter 1:  What is Microsoft Fabric?\u003c\/p\u003e\n\u003cp\u003eChapter 2:  Microsoft Fabric Core Concepts\u003c\/p\u003e\n\u003cp\u003eChapter 3:  The Microsoft Fabric Data Engineering and Data Science    Experiences\u003c\/p\u003e\n\u003cp\u003eChapter 4:  The Microsoft Fabric Databases and Data Factory   Experiences\u003c\/p\u003e\n\u003cp\u003eChapter 5:  The Real Time Intelligence and Power BI Experiences\u003c\/p\u003e\n\u003cp\u003eChapter 6:  The Microsoft Fabric Industry Solutions Experience\u003c\/p\u003e\n\u003cp\u003eChapter 7:  Administering Microsoft Fabric\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B59US \/ 2026-07-13T09:00:00 \/ Herndon, VA","offer_id":47534211137755,"sku":"US-1366-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB51US \/ 2026-10-05T09:00:00 \/ Herndon, VA","offer_id":48216573509851,"sku":"US-1366-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271B79US \/ 2027-01-11T09:00:00 \/ Herndon, VA","offer_id":48216573575387,"sku":"US-1366-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B45US \/ 2027-04-12T09:00:00 \/ Herndon, VA","offer_id":48586418127067,"sku":"US-1366-IL","price":1640.0,"currency_code":"USD","in_stock":true}]}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0691\/4143\/0491\/collections\/p02XUJy4SKGYyQce7Aa0_404d4c55-e6ff-4752-9939-a73154143780.webp?v=1780655643","url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/collections\/business-intelligence.oembed","provider":"Learning Tree International","version":"1.0","type":"link"}