large dataset modeling

Google BI Interview: Optimize Power BI for 200M+ Rows

by

Google: How Do You Optimize a Power BI Data Model and DAX Queries to Perform Efficiently on Datasets Exceeding 200 Million Rows? Google is known for working with some of the largest datasets on the planet. Even internal BI and analytics teams handle billions of transactions, logs, events, impressions, and user interactions across Search, YouTube, … Read more

EY Power BI Interview: Reduce Memory Footprint for 80M+ Rows

by

EY: How Do You Reduce Memory Footprint in Power BI When Importing Fact Tables Above 80 Million Rows? This is one of the most frequently asked questions in EY (Ernst & Young) Power BI, BI Architect, Data Engineering, and Analytics interviews. EY handles large-scale enterprise analytics implementations across banking, taxation, audit, insurance, global finance, supply … Read more