Learn Excel for working with large data sets.

Focused View

Innocent M

2:59:35

11 View

1. Loading data from various data sources

1. Introduction.mp4

05:42

2. Working with other data sources.mp4

03:33

3. Preparing Excel for loading large data..mp4

02:50

4. Using Power Query to load local files..mp4

07:44

5. Data manipulation and Errors troubleshooting..mp4

12:03

6. Multiple data sources and joining them.mp4

11:18

7. Loading data to the Datamodel.mp4

05:33

8. Using connection only to the data sources..mp4

05:00

2. Working with Data on Excel

1. Using Excel tables.mp4

08:24

2. Working with tables.mp4

09:05

3. Working with tables - anchors.mp4

06:56

4. Working with tables - filters.mp4

05:47

5. Data Models.mp4

07:41

6. Data modelling - relations.mp4

18:21

7. More Data modelling.mp4

05:27

8. Using measures on Data models.mp4

22:42

9. Data model measures and pivot tables.mp4

08:04

3. Data Visualization and Reports

1. Intro to power Bi.mp4

03:35

2. PowerBi loading data.mp4

08:24

3. PowerBi model and table views.mp4

10:04

4. PowerBi Data visualizations and Reports making.mp4

11:22

Description

Learn simple ways to use excel to work with millions of rows of data. Excel, PowerQuery, PowerBi, Data Visuals.

What You'll Learn?

Understanding data sources and Mastering data Importation and Cleaning
Understanding Data models and modelling.
Effective uses of excel tables and pivot tables.
Best practices for working with large data.
Intro to Data visualization and best alternative to Excel.
Using measures to summarize your data.

Who is this for?

Anyone who frequently uses excel for office work.

Beginner data analysts.

Anyone interested in Excel and PowerBi features.

What You Need to Know?

Basic understanding of Excel

More details

Description
Welcome.
This course will teach you on how to become more effective in working with large datasets using Excel.
You will learn various ways to load data from various several sources, to import your data into excel, to summarize your data in excel using various techniques and to understand and use best practices when working with large data sets.
You will learn how to use data models to organize your large data set, to use excel tables and pivot tables to summarize your data. You will also learn the basics of using Microsoft Power Bi to load large data, to model your data and using great visuals provided by Power BI to visualize your data and make reports.
After successful completion of this course, you will be able to spend the shortest amount of time to work with your large data sets and create amazing insights from your data.
You will be able to quickly take large data and make summaries and reports from it, within minutes.

Areas you will cover:
Loading data.
Data manipulation and clean up.
Using Excel tables.
Using Pivot Tables.
Summarizing, searching and filtering data.
Data Modeling.
Creating and using measures.
Power Bi Basics.
Data Visualization.

Who this course is for:
Anyone who frequently uses excel for office work.
Beginner data analysts.
Anyone interested in Excel and PowerBi features.

User Reviews

Rating

average 0

Total votes0

Focused display

Analyst with strong backgrounds in Business Intelligence and Finance at financial institutions.I understand the importance of data in modern industries and appreciate the applications and potentials that data analytics can provide.I like to share my knowledge about data for others to understand data and analysis and leverage the use of it to achieve better performance.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.