Big data in Excel : 100+ millions rows of data consolidation using power query & power pivot

preview_player
Показать описание
This video is about how to consolidate 100+ millions rows in MS Excel 2019 Office 365 using power query. This is more powerful inbuilt feature in ms excel. You don't need any add-ins for the same. And power pivot helps to analyse the combined data. Enjoy the power of excel !!

Join this channel to get access to perks:

#excel
#exceltutorial
#learnexcel
  1. Excel (A-Z)
  2. excel tutorial
  3. tutorial excel
  4. excel
  5. in ms excel
  6. tutorial ms excel
Рекомендации по теме
10 Million Rows 0:10:57

10 Million Rows of data Analyzed using Excel's Data Model

How to apply 0:10:06

How to apply VLOOKUP on Large / Big Data in Excel (Hindi)

Working with very 0:17:47

Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot | Big Data in Excel

Excel Tutorial - 0:03:23

Excel Tutorial - Using VLOOKUP with large tables

Excel: Quickly Select 0:02:20

Excel: Quickly Select a Large Amount Amount of Data/Cells

How To Apply 0:10:42

How To Apply VLOOKUP and XLOOKUP formula on Large / Big Data in Excel (Hindi)

Big Data 1: 0:01:41

Big Data 1: How to Open a Too- Large Data File in Excel

How To Apply 0:12:39

How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel

Guide to Becoming 1:10:01

Guide to Becoming a Power BI Developer in 2025 Part 2

Excel | How 0:00:39

Excel | How do print out a large worksheet on one page using Excel?

5 Tricks to 0:00:54

5 Tricks to Become an Excel Wizard

#shorts | VLOOKUP 0:00:56

#shorts | VLOOKUP with MATCH in Excel

Handle large data 0:00:59

Handle large data fast in Excel | Boss - Pappu series

EXCEL TRICK - 0:03:26

EXCEL TRICK - Select large data quickly in columns & rows WITHOUT click & drag or unwanted c...

How I use 0:00:38

How I use Excel as a Data Analyst 📊🤓

Excel Data Analysis 7:11:45

Excel Data Analysis Full Course Tutorial (7+ Hours)

Excel: Reduce the 0:05:00

Excel: Reduce the file size of your Excel workbook | Excel tips and tricks

Introduction to Pivot 0:14:48

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Cleaning Data in 0:21:04

Cleaning Data in Excel | Excel Tutorials for Beginners

Excel Tip: Sort 0:00:14

Excel Tip: Sort Grades Largest to Smallest

Copy Data Fast 0:00:25

Copy Data Fast in Excel! 🤩 #shorts

😨Print all data 0:00:48

😨Print all data in single page in Excel | how to print large excel sheet in one page 🤔Excel printing...

Data Analytics 3 0:00:31

Data Analytics 3 months roadmap #dataanalytics #datascience #upgradeskill #livetraining

Excel AI - 0:08:13

Excel AI - data analysis made easy

Комментарии
Автор

Super interesting. Thank you for making the video.

Is this Excel 32-bit? Or 64-Bit? How much memory does the pc have?

abf
Автор

Can I have that data to practice on my machine, please.

qasimjan
Автор

How much RAM do you have to process that much huge data?

qasimjan
Автор

I was producing 10 columns and 3.7 million rows but stoped at 1048576 rows ans 10 columns. how to carry forward stuck me without damaging my work?

mehmetdogu
Автор

Yeah right, but not all version of Excel are having Power Pivot, always confusing by Microsoft.

mirrrvelll