Loading 10 million rows of data into Excel
We believe it’s important that business users of Excel understand what it’s truly capable of.
Only then can they make informed decisions about if/where to invest in new software, what staff training is required and how the business can be more efficient.
Excel is capable of dramatically more powerful things than most users are aware of.
Understanding Modern Excel
The term Modern Excel generally refers to the Power Query and Power Pivot functionality of Excel, but we like to think of it as everything that’s happened to Excel in the last 10 years, including Tables, new formulas, and cool features such as 3D Maps.
The video below aims to raise that awareness bar a little higher, plus flags an important concept when it comes to loading data into Power Pivot.
That concept is one of only importing the columns of data you need, especially those with a high level of uniqueness such as time, or database ID keys etc. These bloat your model and slow things down. The golden rule when building a Power Pivot model is only bring in what you know you need. It’s pretty easy to include extra data later when you discover you need it.
Want to learn more
Take the next step and access your data seamlessly today with Microsoft Excel in Perth. Take a course or contact us on
+61 8 6210 8500 or by email or leave your details below.