This webinar will discuss best practices for importing data into Excel from external sources, creating relationships in Power Pivot, DAX formulas in Power Pivot, Power Query data sources, and more.
Why Should You Attend:
Do you work with "Big Data"? Do you import, manipulate and analyze massive datasets in Excel? If so you’ll already be familiar with the limitations of Excel.
Power Pivot and Power Query, two free add ins for Excel, are designed to get you past these limitations, allowing you to import and work with 1-million-plus-row datasets from virtually any source. If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query and Power Pivot is a must.