Learn how to use Microsoft Excel’s Power Query and Power Pivot to model data in this free online data science course. Excel’s Power Query and Power Pivot are business intelligence tools for data extraction, transformation and analysis. This data science course explains how to import multiple data files into an Excel sheet and reshape them with Power Query and Power Pivot. We show you how to consolidate files, create performance measures and display processed data in a pivot table. We also study key DAX functions used for data manipulation and analysis.
| College | Alison |
| Course ID | 195480 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 3-4 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • Identify Power Query and Power Pivot as data modelling engines in Microsoft Excel • Outline the application of Power Query and Power Pivot tools in data analysis • Describe the advantages of the Power Query tool in data cleaning and task automation • Identify the arithmetic operators and logical functions used in Power Query • Select the appropriate Power Query operators and functions for your data analysis project • Analyse data via the performance measures and KPI features of the Power Pivot data model • List the key DAX query functions used for data analysis in the Power Pivot tool • Generate DAX query functions and logical statements for data analysis and manipulation • Create a single power pivot table using the tables obtained from multiple data sources |
| Course Code | 6291 |
A free online course that covers general cargo ships, the classification of charters and signing charter agreements.
Case management involves organizing and executing tasks to address a child's needs appropriately, systematically, and promptly through direct support and referrals.
Study electrochemical reactions in corrosion, as well as the oxidation mechanisms of corrosion, in this free course.
Learn how to leverage AI algorithms to detect, prevent, and mitigate cyber threats in this free online course.
