Skills Demonstrated:
- Understanding of the Excel environment
- Creating Business Models in Excel
- Commonly used functions in Excel
- Visualization in Excel
- Using Analysis Toolpak
- Using Solver in Excel
- Using Power Pivot in Excel to summarize data
- Using Power Query in Excel to import data
- Creating Visualizations in Power BI Desktop
- Enriching Data in Power BI desktop using DAX
- Using SQL to query data
- Using SQL to alter data
|
Examinations Successfully Completed:
- Unit Test #1: Introduction to Business Modeling and Building Models In Excel
- Unit Test #2: Basics in Power BI for Excel
- Unit Test #3: Advanced Functions with MS Power BI Tools for Excel
- Unit Test #4: Introduction to Power BI Desktop
- Unit Test #5: Data Analysis with Power BI and Power Pivot for Excel
- Unit Test #6: Introduction to SQL Server Concepts
|