Microsoft Excel - Data Analysis & Visualization

Ms Excel Hands-On Data Analysis & Visualization Using:Power Pivot, Pivot Tables,Pivot Charts, DAX

4.35 (21 reviews)
Udemy
platform
English
language
Microsoft
category
2,258
students
2 hours
content
Jun 2021
last update
$44.99
regular price

What you will learn

Prepare data with Power Query

Transform Data with Power Query

Connect to data source

Cleanse and transform data

Create data model

Create Pivot Tables

Create Pivot Charts

Refresh Data Source

Update Queries

Analyse Data

Description

Excel definition: a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning.

The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel.

As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.

For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.

With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.

The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.

However, having data alone is not enough. You need to be able to act on the data to effect change within the business. That action could involve reallocating resources within the business to accommodate a need, or it could be identifying a failing campaign and knowing when to change course. These situations are where telling a story with your data is important.


Content

Excel Setup (Optional )

Introduction
Office 365 Setup
Activating Office 365 Apps
Logging into Office 365
What is Power Pivot
Office Versions of Power Pivot
How to enable Power Pivot in Excel

Data Preparation and Transformation

What is Power Query
PLEASE READ
Connecting to a data source
Preparing your query
Cleansing Data
Enhancing your query

Data Visualization and Analysis

Creating a data model
Import more data and build relationships
Create lookups as new fields with DAX
Analyze data using Pivot Tables
Analyze data using Pivot Charts
Refreshing Source Data
Updating Queries
Creating new reports

Screenshots

Microsoft Excel - Data Analysis & Visualization - Screenshot_01Microsoft Excel - Data Analysis & Visualization - Screenshot_02Microsoft Excel - Data Analysis & Visualization - Screenshot_03Microsoft Excel - Data Analysis & Visualization - Screenshot_04

Reviews

Nelson
December 21, 2022
O curso oferece o que se espera de um curso intermediário. Eu esperava um pouco mais de complexidade na abordagem e um passo a mais nos processos descritos.

Coupons

DateDiscountStatus
12/14/2021100% OFF
expired
1/8/2022100% OFF
expired

Charts

Price

Microsoft Excel - Data Analysis & Visualization - Price chart

Rating

Microsoft Excel - Data Analysis & Visualization - Ratings chart

Enrollment distribution

Microsoft Excel - Data Analysis & Visualization - Distribution chart

Related Topics

4132170
udemy ID
6/18/2021
course created date
6/20/2021
course indexed date
Bot
course submited by