Excel Power Tools for Data Analysis
In this course, we will learn about the three power tools and their use in the transformation, analysis and presentation of data.
Intermediate
Online
2 Weeks
1,699 INR Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Course Overview
The Excel Power Tools for Data Analysis Training course will teach us about the power analysis tools such as Power Query, Power Pivot and Power BI. How to use these tools in the process of importing and preparing data for analysis, making an analytical database inside the excel workbook and creating interactive reports and dashboards in MS Excel.
The Excel Power Tools for Data Analysis Online Course will be of 2-weeks duration and will be instructed by Nicky Bull, lecturer and lead content designer at Macquarie Business School and Dr. Prashan S.M. Karunaratne, senior lecturer, Macquarie Business School.
This Excel Power Tools for Data Analysis Course is the third and final course part of the excel skills for data analytics and data visualisation specialisation. This course will teach us about the use of these three powerful tools in MS Excel and what DAX means.
The Highlights
- Coursera certificate
- 2 weeks duration course
- Course Videos
- Module Quizzes
- Module assessment
- Data analysis
- Microsoft excel
- Data visualisation
Programme Offerings
- Coursera course
- Certificate of completion
- Module Assessment
- Big data
- Data Analysis
- data visualisation
- Macquarie university.
- 2-week duration
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | Coursera |
Excel Power Tools for Data Analysis Fee Structure
Course Name | Fees |
Certificate mode, 1 month | Rs. 1,699 |
Certificate mode, 3 months | Rs. 3,499 |
Certificate mode, 6 months | Rs. 5,199 |
Eligibility Criteria
Students who have prior experience working on Microsoft Excel can take admission to this course.
What you will learn
The topics you will learn in the Excel Power Tools for Data Analysis Certification Course are:
- About excel power tools
- What is the power query
- Getting data from excel, database, folder
- About query editor and its use
- Pivoting and unpivoting of the data
- How to group data
- How to work with columns in excel and office
- What is data modelling
- About DAX
- About Power BI
- Creating power BI reports
- How to add time intelligence
Who it is for
The Excel Power Tools for Data Analysis Online Course helps students to use these tools for big data and visualise data in a proper manner. Arrangement of data using tools like Power Query, Power Pivot and Power BI makes it more interesting for the students to use in data representation. People in the organisation can use data analysis tools to gather data at one place from different places.
Admission Details
- Candidates who are willing to take admission in the Excel Power Tools for Data Analysis Online Course have to register on the Coursera portal using this link - https://www.coursera.org/learn/excel-power-tools
- After opening the link click on ‘Enroll for Free’
- Next, candidates are required to provide necessary information such as name, email address and set up a password
- Join the Coursera portal using the same id password used for registration.
- Enroll for the Excel Power Tools for Data Analysis Training Course.
The Syllabus
Readings
- Welcome to Excel Power Tools for Data Analysis
- Course goals and weekly learning objectives
- Important information about versions and regions
Discussion Prompt
- Set your goals and be successful
Videos
- Week 1 Introduction
- Introduction to Power Query
- Get and transform data from Excel
- Get data from a database
- Get data from a folder
- Append queries with 2 datasets
- Append queries with 3 or more datasets
- Merge queries — Left Outer join
- Merge queries — Inner and Anti joins
Readings
- Read me before you start: Quizzes and Navigation
- Download the Week 1 workbooks
- Week 1 Practice Challenge
- Week 1 Toolbox
Assignments
- Introduction to Power Query
- Get and transform data from Excel
- Get data from a database
- Get data from a folder
- Append queries with 2 datasets
- Append queries with 3 or more datasets
- Merge queries — Left Outer join
- Merge queries — Inner and Anti joins
Videos
- Week 2 Introduction
- Applying transformations with the Query Editor
- Unpivoting data
- Pivoting data in the Query Editor
- Grouping data
- Working with columns in Office 365
- Working with columns in Excel 2016
Readings
- Download the Week 2 workbooks
- Working with columns — difference in versions
- Week 2 Practice Challenge
- Week 2 Toolbox
Assignments
- Applying transformations with the Query Editor
- Unpivoting data
- Pivoting data in the Query Editor
- Grouping data
- Working with columns
- Test your skills: Weeks 1 and 2
Videos
- Week 3 Introduction
- Adding data to the Data Model
- Data Modelling
- Analysing data with Power Pivot
- Visualising data with Power Pivot and Cube Functions
- Introduction to DAX measures
- Applying Time Intelligence and CALCULATE
Readings
- Download the Week 3 workbooks
- Week 3 Practice Challenge
- Week 3 Toolbox
Assignments
- Adding data to the Data Model
- Data Modelling
- Analysing data with Power Pivot
- Visualising data with Power Pivot and Cube Functions
- Introduction to DAX measures
- Applying Time Intelligence and CALCULATE
- Test your skills: Week 3
Videos
- Week 4 Introduction
- Introducing Power BI
- Adding a Calendar using DAX
- Creating a Power BI report
- Working with reports
- Adding time intelligence
- Sharing Power BI reports
Readings
- Download the Week 4 workbooks
- Week 4 Practice Challenge
- Week 4 Toolbox
Assignments
- Introducing Power BI
- Adding a Calendar using DAX
- Creating a Power BI report
- Working with reports
- Adding time intelligence
- Sharing Power BI reports
- Test your skills: Week 4
Instructors
Macquarie University, Sydney Frequently Asked Questions (FAQ's)
Students who have prior experience working with Microsoft Excel can take admission to the Excel Power Tools for Data Analysis Online Course.
The Excel Power Tools for Data Analysis Certification Course will be instructed by Nicky Bull who is a lecturer and lead content designer at Macquarie Business School and Dr. Prashan S.M. Karunaratne who is a senior lecturer at Macquarie Business School.
The Excel Power Tools for Data Analysis Course is of a 2-weeks duration offered by Coursera.
The course will be taught in the English language and English subtitles will be included in the videos of every module of this course.
Students will have to take a subscription to the Coursera portal to take admission in the course.