Data Analysis with Excel's Power Pivot

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

Course Description

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly.

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

You will:

  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.


Who this course is for:

  • People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Course content

6 sections • 16 lectures • 57m total length
  • Enable and Navigate Power Pivot
    04:26
  • Manage Data Relationships
    06:42

Instructor

  • 4.4 Instructor Rating
  • 4,626 Reviews
  • 27,985 Students
  • 77 Courses

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.

Expected Outcomes

  1. Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Requirements To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. Description Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Who this course is for: People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. Show more Show less Course content 6 sections • 16 lectures • 57m total length Expand all sections Getting Started with Power Pivot 4 lectures • 15min Enable and Navigate Power Pivot - Introduction Preview 00:23 Enable and Navigate Power Pivot 04:26 Manage Data Relationships - Introduction Preview 03:06 Manage Data Relationships 06:42 Visualizing Power Pivot Data 4 lectures • 11min Create a Power Pivot Report - Introduction 00:16 Create a Power Pivot Report 05:07 Create Calculations in Power Pivot - Introduction Preview 00:28 Create Calculations in Power Pivot 04:43 Working with Advanced Functionality in Power Pivot 2 lectures • 6min Create a Key Performance Indicator - Introduction Preview 00:44 Create a Key Performance Indicator 05:26 Work with Dates and Time in Power Pivot 5 lectures • 25min Work with Dates and Time in Power Pivot - Part 1 03:05 Work with Dates and Time in Power Pivot - Part 2 04:19 Work with Dates and Time in Power Pivot - Part 3 04:40 Work with Dates and Time in Power Pivot - Part 4 04:31 Create a Comparison Table with Power Pivot Preview 08:43 Quiz 0 lectures • 0min Quiz 5 questions Course Follow-Up 1 lecture • 1min Course Follow-Up 01:13 Instructor SONIC Performance Support - E-Learning Experts Training Company 4.4 Instructor Rating 4,626 Reviews 27,985 Students 77 Courses SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 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:'6781c02eaf60dbf3',m:'0079788b3ac114b1cd08116920dd7234700f5951-1627849055-1800-AXLB7id9TskuFDIu9hWM7bFXx2NtVLH7BkQNxD9eb68cwPuT+Uca12L6lusXO14XCidNtvsv+/9bN/z4yr/N2iFeAJBxyxPnG7RySsqpKmoS0+3SMxdGgXsuZqOuwjYhtnW3wBgzxRn4I99eJV3Po6E=',s:[0x1f1234897d,0x05c4e5389b],}})();
  2. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Requirements To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. Description Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Who this course is for: People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. Show more Show less Course content 6 sections • 16 lectures • 57m total length Expand all sections Getting Started with Power Pivot 4 lectures • 15min Enable and Navigate Power Pivot - Introduction Preview 00:23 Enable and Navigate Power Pivot 04:26 Manage Data Relationships - Introduction Preview 03:06 Manage Data Relationships 06:42 Visualizing Power Pivot Data 4 lectures • 11min Create a Power Pivot Report - Introduction 00:16 Create a Power Pivot Report 05:07 Create Calculations in Power Pivot - Introduction Preview 00:28 Create Calculations in Power Pivot 04:43 Working with Advanced Functionality in Power Pivot 2 lectures • 6min Create a Key Performance Indicator - Introduction Preview 00:44 Create a Key Performance Indicator 05:26 Work with Dates and Time in Power Pivot 5 lectures • 25min Work with Dates and Time in Power Pivot - Part 1 03:05 Work with Dates and Time in Power Pivot - Part 2 04:19 Work with Dates and Time in Power Pivot - Part 3 04:40 Work with Dates and Time in Power Pivot - Part 4 04:31 Create a Comparison Table with Power Pivot Preview 08:43 Quiz 0 lectures • 0min Quiz 5 questions Course Follow-Up 1 lecture • 1min Course Follow-Up 01:13 Instructor SONIC Performance Support - E-Learning Experts Training Company 4.4 Instructor Rating 4,626 Reviews 27,985 Students 77 Courses SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 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:'6781c02eaf60dbf3',m:'0079788b3ac114b1cd08116920dd7234700f5951-1627849055-1800-AXLB7id9TskuFDIu9hWM7bFXx2NtVLH7BkQNxD9eb68cwPuT+Uca12L6lusXO14XCidNtvsv+/9bN/z4yr/N2iFeAJBxyxPnG7RySsqpKmoS0+3SMxdGgXsuZqOuwjYhtnW3wBgzxRn4I99eJV3Po6E=',s:[0x1f1234897d,0x05c4e5389b],}})();
  3. Work with advanced functionality in Power Pivot. Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Requirements To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. Description Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Who this course is for: People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. Show more Show less Course content 6 sections • 16 lectures • 57m total length Expand all sections Getting Started with Power Pivot 4 lectures • 15min Enable and Navigate Power Pivot - Introduction Preview 00:23 Enable and Navigate Power Pivot 04:26 Manage Data Relationships - Introduction Preview 03:06 Manage Data Relationships 06:42 Visualizing Power Pivot Data 4 lectures • 11min Create a Power Pivot Report - Introduction 00:16 Create a Power Pivot Report 05:07 Create Calculations in Power Pivot - Introduction Preview 00:28 Create Calculations in Power Pivot 04:43 Working with Advanced Functionality in Power Pivot 2 lectures • 6min Create a Key Performance Indicator - Introduction Preview 00:44 Create a Key Performance Indicator 05:26 Work with Dates and Time in Power Pivot 5 lectures • 25min Work with Dates and Time in Power Pivot - Part 1 03:05 Work with Dates and Time in Power Pivot - Part 2 04:19 Work with Dates and Time in Power Pivot - Part 3 04:40 Work with Dates and Time in Power Pivot - Part 4 04:31 Create a Comparison Table with Power Pivot Preview 08:43 Quiz 0 lectures • 0min Quiz 5 questions Course Follow-Up 1 lecture • 1min Course Follow-Up 01:13 Instructor SONIC Performance Support - E-Learning Experts Training Company 4.4 Instructor Rating 4,626 Reviews 27,985 Students 77 Courses SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 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:'6781c02eaf60dbf3',m:'0079788b3ac114b1cd08116920dd7234700f5951-1627849055-1800-AXLB7id9TskuFDIu9hWM7bFXx2NtVLH7BkQNxD9eb68cwPuT+Uca12L6lusXO14XCidNtvsv+/9bN/z4yr/N2iFeAJBxyxPnG7RySsqpKmoS0+3SMxdGgXsuZqOuwjYhtnW3wBgzxRn4I99eJV3Po6E=',s:[0x1f1234897d,0x05c4e5389b],}})();
  4. Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Requirements To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. Description Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Who this course is for: People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. Show more Show less Course content 6 sections • 16 lectures • 57m total length Expand all sections Getting Started with Power Pivot 4 lectures • 15min Enable and Navigate Power Pivot - Introduction Preview 00:23 Enable and Navigate Power Pivot 04:26 Manage Data Relationships - Introduction Preview 03:06 Manage Data Relationships 06:42 Visualizing Power Pivot Data 4 lectures • 11min Create a Power Pivot Report - Introduction 00:16 Create a Power Pivot Report 05:07 Create Calculations in Power Pivot - Introduction Preview 00:28 Create Calculations in Power Pivot 04:43 Working with Advanced Functionality in Power Pivot 2 lectures • 6min Create a Key Performance Indicator - Introduction Preview 00:44 Create a Key Performance Indicator 05:26 Work with Dates and Time in Power Pivot 5 lectures • 25min Work with Dates and Time in Power Pivot - Part 1 03:05 Work with Dates and Time in Power Pivot - Part 2 04:19 Work with Dates and Time in Power Pivot - Part 3 04:40 Work with Dates and Time in Power Pivot - Part 4 04:31 Create a Comparison Table with Power Pivot Preview 08:43 Quiz 0 lectures • 0min Quiz 5 questions Course Follow-Up 1 lecture • 1min Course Follow-Up 01:13 Instructor SONIC Performance Support - E-Learning Experts Training Company 4.4 Instructor Rating 4,626 Reviews 27,985 Students 77 Courses SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 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:'6781c02eaf60dbf3',m:'0079788b3ac114b1cd08116920dd7234700f5951-1627849055-1800-AXLB7id9TskuFDIu9hWM7bFXx2NtVLH7BkQNxD9eb68cwPuT+Uca12L6lusXO14XCidNtvsv+/9bN/z4yr/N2iFeAJBxyxPnG7RySsqpKmoS0+3SMxdGgXsuZqOuwjYhtnW3wBgzxRn4I99eJV3Po6E=',s:[0x1f1234897d,0x05c4e5389b],}})();