Відео

This is the Part 9 of the Excel for Data Analysis: Practical Examples Series. Part 9 - Data Cleaning with Power Query In this part, I explained what data cleaning is why it is important for data analysis, and how we can use it effectively from our practical example. 0:00 Introduction 00:48 Why it is important? 01:47 Dataset 01:58 Load data into Power Query 02:36 Remove Duplicates 04:19 Handle M...

This is the Part 8(2) of the Excel for Data Analysis: Practical Examples Series. Part 8(2): Advanced Excel Formulas 0:00 INDEX-MATCH 03:15 AVERAGEIF 04:52 DATEDIF In the second part of this video, we’ll continue mastering Advanced Excel Formulas by diving into AVERAGEIF and INDEX-MATCH. See how to use these formulas effectively with real-world datasets to gain actionable insights.

This is the Part 8(1) of the Excel for Data Analysis: Practical Examples Series. This video is Part 8 and for a complete understanding, be sure to check out Part 8(2) where I continue the explanation Part 8(1): Advanced Excel Formulas 0:00 Introduction 01:51 Dataset 02:50 CONCATENATE 03:52 YEAR&TODAY 05:11 Conditional Formatting 06:37 Advanced IF 09:18 Pivot Table 09:57 COUNTIF 11:30 AVERAGEIF ...

This is the Part 7 of the Excel for Data Analysis: Practical Examples Series. Part 7: Basic Data Visualization In this part, I explained what data visualization is why it is important for data analysis, and how we can use it effectively to get the insights from our data practical example. Part 1: ua-cam.com/video/DjainSJqnN8/v-deo.htmlsi=TV7tTkjwuOcr7KLU Part 2: ua-cam.com/video/EPAVUa4mFeE/v-d...

This is the Part 6 of the Excel for Data Analysis: Practical Examples Series. Part 6: Pivot Tables In this part, I explained what pivot table is why it is important for data analysis, and how we can use it effectively to get the insights from our data practical example. Part 1: ua-cam.com/video/DjainSJqnN8/v-deo.htmlsi=TV7tTkjwuOcr7KLU Part 2: ua-cam.com/video/EPAVUa4mFeE/v-deo.htmlsi=kXt69ahFR...

This is the Part 5 of the Excel for Data Analysis: Practical Examples Series. Part 5: Conditional formatting for Insights In this part, I explained what conditional formatting is why it is important, and how we can apply conditional formatting with practical example. Part 1: ua-cam.com/video/DjainSJqnN8/v-deo.htmlsi=TV7tTkjwuOcr7KLU Part 2: ua-cam.com/video/EPAVUa4mFeE/v-deo.htmlsi=kXt69ahFRsy1...

Part 4: Working with Excel Formulas (Basics) In this part, we will cover Basic Excel formulas like- SUM, IF, AVERAGE, and CONCATENATE that is used for analysis. 0:00 Introduction 0:30 SUM 0:56 AVERAGE 01:14 IF 01:51 CONCATENATE Part 1: ua-cam.com/video/DjainSJqnN8/v-deo.htmlsi=TV7tTkjwuOcr7KLU Part 2: ua-cam.com/video/EPAVUa4mFeE/v-deo.htmlsi=kXt69ahFRsy1ksmE Part 3: ua-cam.com/video/wpBSrDZjds...

In this video, we’ll explore how analyzing 5 years of business data (FY2018-FY2022) reveals key trends and actionable insights. From improving gross margins to understanding regional sales performance, this project showcases the transformative impact of data-driven decision-making. Perfect for business enthusiasts and data analysts, tune in to see how analytics can reshape strategies and drive ...

This is Part 3 of the Excel for Data Analysis: Practical Examples Series. Part 3: Sorting and Filtering Tricks In this part, I explained what is sorting and filtering and why it is important, and what are the advanced sorting and filtering techniques we can use to make our analysis effective. Part 1:ua-cam.com/video/DjainSJqnN8/v-deo.html Part 2: ua-cam.com/video/EPAVUa4mFeE/v-deo.html Download...

This is the Part 2 of the Excel for Data Analysis: Practical Examples Series. Part 2: Data Cleaning Essentials In this part, I explained what data cleaning is and why it is important, and how we can clean messy data with practical example

In this series, we'll explore powerful Excel tools, techniques with practical examples to help analyze data effectively. Part 1: Introduction to Data Analysis in Excel In this part, I explained what data analysis is and why it is important, and why use Excel for data analysis with basic data preparation example

Explore my GoodCabs Services Analysis project, where I tackle real-world challenges in the transportation domain using Power BI, SQL, and data modeling. Key insights include trip trends, passenger satisfaction, and revenue growth strategies. Watch to learn how data drives impactful decisions!