Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.
Identify DAX syntax and common DAX formula use cases, including stats, logical, text, filter, iterator, and time intelligence functions
Identify characteristics of a "Power" PivotTable, the differences between measures and calculated columns, and examples of filter and row context Identify Excel's Data Model interface and best practices, including normalization, relationships, hierarchies, cardinality, and filter flow Identify common Power Query tools for connecting, transforming, and loading data, including text, dates, grouping, pivoting, merging, and appending Identify the capabilities of Excel's "Power" workflow, including importing data, building models, automating ETL processes, and creating DAX calculations Microsoft Office 365 for PC/Windows or Mac, or a version of Excel compatible with Power Query & Power Pivot (2016+)Įxperience with Excel PivotTables and formulas is strongly recommended Excel users who are looking for an introduction to advanced analytics and data modeling tools, or preparing to transition into a business intelligence roleĪnalysts or BI professionals using Excel to analyze large datasets (>1mm rows), connect to external sources, or build relational data modelsĪnyone seeking to explore Excel's business intelligence capabilities
0 kommentar(er)
