Learn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft

Learn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft

Maximize your Excel skills and earn a learning certificate by participating in the UCOP Learning and Development Data Analysis Series.

Maximize your Excel skills and earn a learning certificate by participating in the UCOP Learning and Development Data Analysis Series.

Advance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use

Advance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use

Advance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual

Advance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive