Power Pivot Workshop Complete Bundle

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.

Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course.

The course includes almost 10 hours of video in 73 lectures, divided in these sections:

  • Introduction to Self-Service Business Intelligence
  • Introduction to Power Pivot
  • Loading Data
  • Data Modeling
  • DAX Language
  • Table Functions and CALCULATE
  • Basic Time Intelligence
  • Power BI and SharePoint
  • Creating Reports and KPI
  • Advanced DAX Concepts
  • Advanced DAX Functions
  • DAX as a Query Language
  • DAX Patterns

Who this course is for:

  • Advanced Excel Users
  • Business Analysts
  • Business Intelligence Developers
  • Data Scientists
  • You will learn how to create simple models in Power Pivot, loading data from different data sources. You will learn how to write DAX expressions performing calculations such as Ratio-to-Parent, Year-to-Date, Year-Over-Year and so on. You will learn how to use advanced DAX functions and to create complex data models in Power Pivot. You will learn how to solve typical business issues by applying predefined patterns in DAX. Requirements Power Pivot for Excel 2010 or Excel 2013 Description This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course. The course includes almost 10 hours of video in 73 lectures, divided in these sections: Introduction to Self-Service Business Intelligence Introduction to Power Pivot Loading Data Data Modeling DAX Language Table Functions and CALCULATE Basic Time Intelligence Power BI and SharePoint Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns Who this course is for: Advanced Excel Users Business Analysts Business Intelligence Developers Data Scientists Show more Show less Course content 15 sections • 75 lectures • 9h 45m total length Expand all sections Introduction to Self-Service Business Intelligence 5 lectures • 21min Self-Service BI Preview 03:51 Power Pivot Preview 02:09 Power Query Preview 06:13 Power View Preview 04:42 Power Map Preview 03:55 Introduction to Power Pivot 7 lectures • 47min PivotTables in Excel 07:53 PivotTables in Excel 2013 05:07 Using Power Pivot 09:08 Calculated Columns 10:49 Linked Tables 05:02 Calculated Fields 05:08 Publishing to Power BI 03:46 Loading Data 14 lectures • 1hr 4min Loading Data in Power Pivot 04:56 Loading from SQL Tables 06:52 Loading from SQL Queries 08:33 Loading from Access 04:13 Loading from Analysis Services 07:47 Using Linked Tables 04:59 Loading from Excel 03:37 Loading from Text Files 01:23 Loading from the Clipboard 04:01 Loading from Reports 04:23 Loading from Data Feeds 02:01 Loading from Azure Marketplace 03:55 Loading from SharePoint 02:19 Data Connection Properties 04:39 Data Modeling 4 lectures • 39min Introduction to Data Models 12:06 Normalization and Denormalization 09:08 Star Schemas 07:11 Over Denormalization 10:25 DAX Language 4 lectures • 56min Introduction to DAX 13:37 Calculated Columns and Calculated Fields 19:01 DAX Error Handling 04:17 Overview of DAX Functions 18:50 Table Functions and CALCULATE 4 lectures • 39min RELATED and RELATEDTABLE functions 10:55 FILTER and ALL functions Preview 12:40 CALCULATE function 11:12 Visual Totals and ALLSELECTED 03:58 Basic Time Intelligence 5 lectures • 44min What is Time Intelligence 04:51 Calendar Table 16:14 Counting Working Days 05:49 Multiple Calendar Tables 05:10 Aggregations Over Time 11:58 Power BI and SharePoint 6 lectures • 45min Power BI and SharePoint Introduction 02:54 Using Power Query 14:52 Using Power View 10:09 Using Power Map 04:49 Publishing on Office 365 07:17 Publishing on SharePoint 04:35 Creating Reports and KPI 3 lectures • 46min Using KPI in Power Pivot 12:00 Advanced Excel Features for Power Pivot 20:49 Optimizing the User Experience with the Data Model 13:29 Advanced DAX Concepts 7 lectures • 56min Important DAX Concepts 01:11 Filter Context 06:05 CALCULATE 18:13 Row Context 08:57 Evaluation Contexts and Relationships 06:52 Context Transition 06:33 ALLSELECTED 08:18 5 more sections Instructors Marco Russo Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Alberto Ferrari Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678144e93dde53c8',m:'dd1f1f755a85be6d11763e2df41e43829b597c45-1627844006-1800-AbFIPAZV21BDIbrhSZ0NtAhw2Pfw/j7EzR0/JKWvedY119jYbTVQY++L7Rqdz+PzTb59ROvugD2wxsCEk8dbTsoMEkvFtIjkjK8ZSU8G/x0Wcc9Lv69T+wCc6AGr7X7gWLxBk3IAp6B0OUCTIoBvPOS+bdFhAwi7dtGmM+z+S+cD',s:[0x6586d68bed,0x9339e6b071],}})();
  • You will learn how to write DAX expressions performing calculations such as Ratio-to-Parent, Year-to-Date, Year-Over-Year and so on. You will learn how to use advanced DAX functions and to create complex data models in Power Pivot. You will learn how to solve typical business issues by applying predefined patterns in DAX. Requirements Power Pivot for Excel 2010 or Excel 2013 Description This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course. The course includes almost 10 hours of video in 73 lectures, divided in these sections: Introduction to Self-Service Business Intelligence Introduction to Power Pivot Loading Data Data Modeling DAX Language Table Functions and CALCULATE Basic Time Intelligence Power BI and SharePoint Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns Who this course is for: Advanced Excel Users Business Analysts Business Intelligence Developers Data Scientists Show more Show less Course content 15 sections • 75 lectures • 9h 45m total length Expand all sections Introduction to Self-Service Business Intelligence 5 lectures • 21min Self-Service BI Preview 03:51 Power Pivot Preview 02:09 Power Query Preview 06:13 Power View Preview 04:42 Power Map Preview 03:55 Introduction to Power Pivot 7 lectures • 47min PivotTables in Excel 07:53 PivotTables in Excel 2013 05:07 Using Power Pivot 09:08 Calculated Columns 10:49 Linked Tables 05:02 Calculated Fields 05:08 Publishing to Power BI 03:46 Loading Data 14 lectures • 1hr 4min Loading Data in Power Pivot 04:56 Loading from SQL Tables 06:52 Loading from SQL Queries 08:33 Loading from Access 04:13 Loading from Analysis Services 07:47 Using Linked Tables 04:59 Loading from Excel 03:37 Loading from Text Files 01:23 Loading from the Clipboard 04:01 Loading from Reports 04:23 Loading from Data Feeds 02:01 Loading from Azure Marketplace 03:55 Loading from SharePoint 02:19 Data Connection Properties 04:39 Data Modeling 4 lectures • 39min Introduction to Data Models 12:06 Normalization and Denormalization 09:08 Star Schemas 07:11 Over Denormalization 10:25 DAX Language 4 lectures • 56min Introduction to DAX 13:37 Calculated Columns and Calculated Fields 19:01 DAX Error Handling 04:17 Overview of DAX Functions 18:50 Table Functions and CALCULATE 4 lectures • 39min RELATED and RELATEDTABLE functions 10:55 FILTER and ALL functions Preview 12:40 CALCULATE function 11:12 Visual Totals and ALLSELECTED 03:58 Basic Time Intelligence 5 lectures • 44min What is Time Intelligence 04:51 Calendar Table 16:14 Counting Working Days 05:49 Multiple Calendar Tables 05:10 Aggregations Over Time 11:58 Power BI and SharePoint 6 lectures • 45min Power BI and SharePoint Introduction 02:54 Using Power Query 14:52 Using Power View 10:09 Using Power Map 04:49 Publishing on Office 365 07:17 Publishing on SharePoint 04:35 Creating Reports and KPI 3 lectures • 46min Using KPI in Power Pivot 12:00 Advanced Excel Features for Power Pivot 20:49 Optimizing the User Experience with the Data Model 13:29 Advanced DAX Concepts 7 lectures • 56min Important DAX Concepts 01:11 Filter Context 06:05 CALCULATE 18:13 Row Context 08:57 Evaluation Contexts and Relationships 06:52 Context Transition 06:33 ALLSELECTED 08:18 5 more sections Instructors Marco Russo Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Alberto Ferrari Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678144e93dde53c8',m:'dd1f1f755a85be6d11763e2df41e43829b597c45-1627844006-1800-AbFIPAZV21BDIbrhSZ0NtAhw2Pfw/j7EzR0/JKWvedY119jYbTVQY++L7Rqdz+PzTb59ROvugD2wxsCEk8dbTsoMEkvFtIjkjK8ZSU8G/x0Wcc9Lv69T+wCc6AGr7X7gWLxBk3IAp6B0OUCTIoBvPOS+bdFhAwi7dtGmM+z+S+cD',s:[0x6586d68bed,0x9339e6b071],}})();
  • You will learn how to use advanced DAX functions and to create complex data models in Power Pivot. You will learn how to solve typical business issues by applying predefined patterns in DAX. Requirements Power Pivot for Excel 2010 or Excel 2013 Description This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course. The course includes almost 10 hours of video in 73 lectures, divided in these sections: Introduction to Self-Service Business Intelligence Introduction to Power Pivot Loading Data Data Modeling DAX Language Table Functions and CALCULATE Basic Time Intelligence Power BI and SharePoint Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns Who this course is for: Advanced Excel Users Business Analysts Business Intelligence Developers Data Scientists Show more Show less Course content 15 sections • 75 lectures • 9h 45m total length Expand all sections Introduction to Self-Service Business Intelligence 5 lectures • 21min Self-Service BI Preview 03:51 Power Pivot Preview 02:09 Power Query Preview 06:13 Power View Preview 04:42 Power Map Preview 03:55 Introduction to Power Pivot 7 lectures • 47min PivotTables in Excel 07:53 PivotTables in Excel 2013 05:07 Using Power Pivot 09:08 Calculated Columns 10:49 Linked Tables 05:02 Calculated Fields 05:08 Publishing to Power BI 03:46 Loading Data 14 lectures • 1hr 4min Loading Data in Power Pivot 04:56 Loading from SQL Tables 06:52 Loading from SQL Queries 08:33 Loading from Access 04:13 Loading from Analysis Services 07:47 Using Linked Tables 04:59 Loading from Excel 03:37 Loading from Text Files 01:23 Loading from the Clipboard 04:01 Loading from Reports 04:23 Loading from Data Feeds 02:01 Loading from Azure Marketplace 03:55 Loading from SharePoint 02:19 Data Connection Properties 04:39 Data Modeling 4 lectures • 39min Introduction to Data Models 12:06 Normalization and Denormalization 09:08 Star Schemas 07:11 Over Denormalization 10:25 DAX Language 4 lectures • 56min Introduction to DAX 13:37 Calculated Columns and Calculated Fields 19:01 DAX Error Handling 04:17 Overview of DAX Functions 18:50 Table Functions and CALCULATE 4 lectures • 39min RELATED and RELATEDTABLE functions 10:55 FILTER and ALL functions Preview 12:40 CALCULATE function 11:12 Visual Totals and ALLSELECTED 03:58 Basic Time Intelligence 5 lectures • 44min What is Time Intelligence 04:51 Calendar Table 16:14 Counting Working Days 05:49 Multiple Calendar Tables 05:10 Aggregations Over Time 11:58 Power BI and SharePoint 6 lectures • 45min Power BI and SharePoint Introduction 02:54 Using Power Query 14:52 Using Power View 10:09 Using Power Map 04:49 Publishing on Office 365 07:17 Publishing on SharePoint 04:35 Creating Reports and KPI 3 lectures • 46min Using KPI in Power Pivot 12:00 Advanced Excel Features for Power Pivot 20:49 Optimizing the User Experience with the Data Model 13:29 Advanced DAX Concepts 7 lectures • 56min Important DAX Concepts 01:11 Filter Context 06:05 CALCULATE 18:13 Row Context 08:57 Evaluation Contexts and Relationships 06:52 Context Transition 06:33 ALLSELECTED 08:18 5 more sections Instructors Marco Russo Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Alberto Ferrari Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678144e93dde53c8',m:'dd1f1f755a85be6d11763e2df41e43829b597c45-1627844006-1800-AbFIPAZV21BDIbrhSZ0NtAhw2Pfw/j7EzR0/JKWvedY119jYbTVQY++L7Rqdz+PzTb59ROvugD2wxsCEk8dbTsoMEkvFtIjkjK8ZSU8G/x0Wcc9Lv69T+wCc6AGr7X7gWLxBk3IAp6B0OUCTIoBvPOS+bdFhAwi7dtGmM+z+S+cD',s:[0x6586d68bed,0x9339e6b071],}})();
  • You will learn how to solve typical business issues by applying predefined patterns in DAX. Requirements Power Pivot for Excel 2010 or Excel 2013 Description This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course. The course includes almost 10 hours of video in 73 lectures, divided in these sections: Introduction to Self-Service Business Intelligence Introduction to Power Pivot Loading Data Data Modeling DAX Language Table Functions and CALCULATE Basic Time Intelligence Power BI and SharePoint Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns Who this course is for: Advanced Excel Users Business Analysts Business Intelligence Developers Data Scientists Show more Show less Course content 15 sections • 75 lectures • 9h 45m total length Expand all sections Introduction to Self-Service Business Intelligence 5 lectures • 21min Self-Service BI Preview 03:51 Power Pivot Preview 02:09 Power Query Preview 06:13 Power View Preview 04:42 Power Map Preview 03:55 Introduction to Power Pivot 7 lectures • 47min PivotTables in Excel 07:53 PivotTables in Excel 2013 05:07 Using Power Pivot 09:08 Calculated Columns 10:49 Linked Tables 05:02 Calculated Fields 05:08 Publishing to Power BI 03:46 Loading Data 14 lectures • 1hr 4min Loading Data in Power Pivot 04:56 Loading from SQL Tables 06:52 Loading from SQL Queries 08:33 Loading from Access 04:13 Loading from Analysis Services 07:47 Using Linked Tables 04:59 Loading from Excel 03:37 Loading from Text Files 01:23 Loading from the Clipboard 04:01 Loading from Reports 04:23 Loading from Data Feeds 02:01 Loading from Azure Marketplace 03:55 Loading from SharePoint 02:19 Data Connection Properties 04:39 Data Modeling 4 lectures • 39min Introduction to Data Models 12:06 Normalization and Denormalization 09:08 Star Schemas 07:11 Over Denormalization 10:25 DAX Language 4 lectures • 56min Introduction to DAX 13:37 Calculated Columns and Calculated Fields 19:01 DAX Error Handling 04:17 Overview of DAX Functions 18:50 Table Functions and CALCULATE 4 lectures • 39min RELATED and RELATEDTABLE functions 10:55 FILTER and ALL functions Preview 12:40 CALCULATE function 11:12 Visual Totals and ALLSELECTED 03:58 Basic Time Intelligence 5 lectures • 44min What is Time Intelligence 04:51 Calendar Table 16:14 Counting Working Days 05:49 Multiple Calendar Tables 05:10 Aggregations Over Time 11:58 Power BI and SharePoint 6 lectures • 45min Power BI and SharePoint Introduction 02:54 Using Power Query 14:52 Using Power View 10:09 Using Power Map 04:49 Publishing on Office 365 07:17 Publishing on SharePoint 04:35 Creating Reports and KPI 3 lectures • 46min Using KPI in Power Pivot 12:00 Advanced Excel Features for Power Pivot 20:49 Optimizing the User Experience with the Data Model 13:29 Advanced DAX Concepts 7 lectures • 56min Important DAX Concepts 01:11 Filter Context 06:05 CALCULATE 18:13 Row Context 08:57 Evaluation Contexts and Relationships 06:52 Context Transition 06:33 ALLSELECTED 08:18 5 more sections Instructors Marco Russo Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Alberto Ferrari Business Intelligence expert at SQLBI - SSAS Maestro & MVP 4.3 Instructor Rating 2,605 Reviews 46,284 Students 4 Courses Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678144e93dde53c8',m:'dd1f1f755a85be6d11763e2df41e43829b597c45-1627844006-1800-AbFIPAZV21BDIbrhSZ0NtAhw2Pfw/j7EzR0/JKWvedY119jYbTVQY++L7Rqdz+PzTb59ROvugD2wxsCEk8dbTsoMEkvFtIjkjK8ZSU8G/x0Wcc9Lv69T+wCc6AGr7X7gWLxBk3IAp6B0OUCTIoBvPOS+bdFhAwi7dtGmM+z+S+cD',s:[0x6586d68bed,0x9339e6b071],}})();