toggle menu

Data Analysis And Visualization – Python, Excel, Power Bi, Tableau

Buy Course Now
Study Mode: Online / Offline
Enrolled: 732 students
Course view: 2956
Duration: Self-Paced Learning
Lectures: 89
Course Materials: Downloadable Videos
Video: 9 Hour 4 Minutes
Course type: All Levels
Certificate of Completion: FREE
Data Analysis And Visualization - Python, Excel, Bi, Tableau

Course Overview:

“Data Analysis and Visualization – Python, Excel, Power BI, Tableau” is a comprehensive course that provides learners with the essential skills and knowledge to perform data analysis and visualization using a combination of Python, Excel, Business Intelligence (BI) tools, and Tableau. The course is divided into several sections, each focusing on a specific tool or technology, including Python, Excel, Power BI, and Tableau.

Who Needs This Course:

This course is suitable for a diverse range of individuals, including:

Data Analysts and Data Scientists: Data analysts and data scientists who want to enhance their data analysis capabilities and leverage multiple tools for comprehensive data exploration and visualization will find this course valuable. It covers both Python, a versatile programming language for data analysis, and popular BI and visualization tools like Excel, Power BI, and Tableau.

Business Professionals: Business professionals who work with data and want to gain insights from their datasets can benefit from this course. They will learn how to use Excel, Power BI, and Tableau to analyze and visualize data, enabling them to make data-driven decisions and effectively communicate findings to stakeholders.

Students and Aspiring Data Professionals: Students pursuing a career in data analysis, business intelligence, or data visualization can take this course to acquire a solid foundation in multiple data analysis tools. The course covers Python, Excel, Power BI, and Tableau, providing a well-rounded skill set that is highly sought after in the industry.

Managers and Decision-Makers: Managers and decision-makers who rely on data for strategic decision-making will benefit from this course. They will learn how to leverage various tools to analyze, visualize, and present data in a meaningful way, empowering them to gain insights and drive informed decisions.

How Learners Will Benefit:

Comprehensive Data Analysis Skill Set: By completing this course, learners will acquire a comprehensive skill set in data analysis using Python, Excel, Power BI, and Tableau. They will gain proficiency in performing tasks such as data cleaning, data manipulation, data visualization, and storytelling.

Python for Data Analysis: Learners will be introduced to Python, one of the most popular programming languages for data analysis. They will learn how to work with Jupyter Notebook, explore and manipulate data using Pandas, and perform basic data cleaning and visualization tasks.

Excel for Data Analysis: The course covers data analysis with Excel, including using Power Pivot and Power Query to connect to data sources, clean and transform data, create data models, and generate visualizations such as pivot tables and charts.

Power BI for Data Analysis: Participants will learn how to use Power BI Desktop and Power BI Service to connect to data sources, clean and transform data, create interactive visualizations, and publish reports to share with others.

Tableau for Data Analysis: The course includes an introduction to Tableau, a popular data visualization tool. Learners will learn how to connect to data sources, clean and prepare data, explore Tableau’s interface, and create visualizations and interactive dashboards.

Data Cleaning and Transformation: Learners will gain practical skills in data cleaning and transformation techniques using various tools. They will learn how to handle inconsistent fields, split text into multiple columns, change data types, remove/reorder columns, and perform other data cleaning tasks.

Data Visualization and Storytelling: The course emphasizes data visualization techniques and storytelling principles. Learners will explore different visualization types and learn how to create impactful visualizations, arrange fields in visualizations, and present data effectively to convey insights.

Practical Hands-on Experience: Throughout the course, learners will have the opportunity to apply their knowledge and skills through hands-on exercises and projects. This practical experience will help solidify their understanding and prepare them for real-world data analysis tasks.

 

By completing the “Data Analysis and Visualization – Python, Excel, Power BI, Tableau” course, learners will gain a strong foundation in data analysis using multiple tools, enabling them to tackle diverse data challenges, uncover valuable insights, and communicate findings with clarity and impact.

SECTION 1: INTRODUCTION TO PYTHON

1
Introduction
41 Sec
2
What Is Python
5 Min 17 Sec
3
What Is Jupyter Notebook
1 Min 20 Sec
4
Installing Jupyter Notebook Server
6 Min 45 Sec
5
Running Jupyter Notebook Server
8 Min 44 Sec
6
Common Jupyter Notebook Commads
7 Min 28 Sec
7
Jupyter Notebook Components
4 Min 27 Sec
8
Jupyter Notebook Dashboard
4 Min 20 Sec
9
Jupyter Notebook Interface
5 Min 45 Sec
10
Creating A New Jupyter Notebook
6 Min 46 Sec

SECTION 2: DATA ANALYSIS WITH PYTHON

1
Kaggle Datasets
3 Min 6 Sec
2
Tabular Data
8 Min 1 Sec
3
Exploring Pandas DataFrame
2 Min 20 Sec
4
Analysing And Manipulating Pandas Dataframe
12 Min 57 Sec
5
What Is Data Cleaning
3 Min 28 Sec
6
Basic Data Cleaning
22 Min 42 Sec
7
Data Visualization
2 Min 35 Sec
8
Visualizing Qualitative Data
12 Min 1 Sec
9
Visualizing Quantitative Data
13 Min 50 Sec

SECTION 3: DATA ANALYSIS WITH POWER BI

1
What Is Power Bi
5 Min 48 Sec
2
What Is Power Bi Desktop
3 Min 40 Sec
3
Installing Power Bi Desktop
7 Min 39 Sec
4
Power Bi Desktop Tour
6 Min 7 Sec
5
Power Bi Overview Part 1
4 Min 24 Sec
6
Power Bi Overview Part 2
4 Min 6 Sec
7
Power Bi Overview Part 3
4 Min 49 Sec
8
Components Of Power Bi
2 Min 58 Sec
9
Building Blocks Of Power Bi
9 Min 32 Sec
10
Exploring Power Bi Desktop Interface
6 Min 6 Sec
11
Exploring Power Bi Service
4 Min 29 Sec
12
Power Bi Apps
3 Min 56 Sec
13
Connecting To Web Data
5 Min 7 Sec
14
Clean And Transform Data Part 1
7 Min 13 Sec
15
Clean And Transform Data Part 2
9 Min 46 Sec
16
Combining Data Sources
7 Min 59 Sec
17
Creating Visualization Part 1
6 Min 10 Sec
18
Creating Visualization Part 2
5 Min 23 Sec
19
Publishing Reports To Power Bi Service
4 Min 47 Sec
20
Importing And Transporting Data From Access DB File
12 Min 59 Sec
21
Changing Locale
1 Min 48 Sec
22
Connecting To MS Access DB File
7 Min 10 Sec
23
Power Query Editor And Queries
6 Min 50 Sec
24
Creating And Managing Query Groups
4 Min 36 Sec
25
Renaming Queries
4 Min 55 Sec
26
Splitting Columns
7 Min 7 Sec
27
Changing Data Types
5 Min 47 Sec
28
Removing And Reordering Columns
6 Min 54 Sec
29
Duplicating And Adding Columns
3 Min 32 Sec
30
Creating Conditional Columns
6 Min 19 Sec
31
Connecting To Files In Folder
7 Min 17 Sec
32
Appending Queries
6 Min 58 Sec
33
Merge Queries
5 Min 35 Sec
34
Query Dependency View
4 Min 33 Sec
35
Transform Less Structured Data Part 1
9 Min 10 Sec
36
Transform Less Structured Data Part 2
9 Min 50 Sec
37
Creating Tables
3 Min 48 Sec
38
Query Parameters
9 Min 28 Sec

SECTION 4: DATA ANALYSIS WITH EXCEL

1
Office 365 Setup (Optional)
13 Min 19 Sec
2
Activating Office 365 (Optional)
3 Min 34 Sec
3
Logging Into Office 365 (Optional)
5 Min 34 Sec
4
What Is Power Pivot
1 Min 3 Sec
5
Office Versions Of Power Pivot
1 Min 33 Sec
6
Enable Power Pivot In Excel
1 Min 29 Sec
7
What Is Power Query
3 Min 30 Sec
8
Connecting To A Data Source
4 Min 27 Sec
9
Preparing Query
4 Min 56 Sec
10
Cleansing Data
7 Min 37 Sec
11
Enhancing Query
9 Min 22 Sec
12
Creating A Data Model
6 Min 2 Sec
13
Building Data Relationships
6 Min 57 Sec
14
Create Lookups With DAX
7 Min 1 Sec
15
Analyse Data With Pivot Tables
8 Min 43 Sec
16
Analyse Data With Pivot Charts
8 Min 14 Sec
17
Refresh Source Data
7 Min 34 Sec
18
Update Queries
9 Min 19 Sec
19
Create New Reports
7 Min 19 Sec

SECTION 5: DATA ANALYSIS WITH TABLEAU

1
What Is Tableau
4 Min 13 Sec
2
Tableau Data Sources
2 Min 19 Sec
3
Tableau File Types
3 Min 45 Sec
4
Tableau Help Menu
1 Min 24 Sec
5
Connect To A Data Source
3 Min 26 Sec
6
Join Related Data Sources
9 Min 4 Sec
7
Join Data Sources With Inconsistent Field
6 Min 28 Sec
8
Data Cleaning
6 Min 28 Sec
9
Exploring Tableau Interface
4 Min 47 Sec
10
Reorder Fields In Visualization
4 Min 14 Sec
11
Change Summary
2 Min 55 Sec
12
Split Text Into Multiple Columns
4 Min 21 Sec
13
Presenting Data Using Stories
6 Min 18 Sec

Be the first to add a review.

Please, login to leave a review
Data Analysis And Visualization – Python, Excel, Power Bi, Tableau
Price:
₦50,000 ₦5,000
Layer 1
Login Categories