{"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}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/designing-data-models-in-excel-for-power-bi-reports-training","provider":"Learning Tree International","version":"1.0","type":"link"}