Live Seminar: Data Analytics Using Microsoft Excel's Enrollment Cover
Live Seminar: Data Analytics Using Microsoft Excel
Live Seminar: Data Analytics Using Microsoft Excel
Training Details
Conducted by a Certified Microsoft Trainer, this 2-day program is designed for advanced Excel Users to take their Excel Skills to the next level. Learn how to use the set of Power BI tools for powerful data analysis and data modelling in Microsoft Excel. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly and share insights easily. Use Power View to bring your data to life with visuals such as charts, graphs, maps and tables.

Pre-requisites​
-Participants must have attended the Advanced Microsoft Office Excel

Hardware/Software Requirements​
-Microsoft Excel 2016 / 2019 Office 365 version
-At least 8GB RAM (Memory)
-Mac laptop/ Mac book version is not allowed

What You Will Learn
At the end of the course, participants will be able to:

-Explore the Excel Power tools
-Work with the Power Query Editor
-Handle Data Shaping with Power Query Editor
-Recognize Excel’s Data Model
-Connect Multiple Tables
-Create Powerpivot and Data Analysis Expressions
-Use DAX syntax and operators
-Use Advance Data Analysis Expressions
-Explore Data Visualization Using Pivot Chart, Power Map and Power View
-Demonstrate Different Visuals in Power View
Outline
1. Introduction to Excel Power Tools
2. The Power Excel Workflow
3. When to Use Power Query and Power Pivot in Excel
4. The Query Editor Interface
5. Options for Loading Data in Excel
6. Basic Power Query Table Transformations
7. Data Shaping with Power Query Editor
8. Merging and Appending Queries
9. Connecting Excel to Folder of Files
10. Data vs Diagram Views
11. Data Tables vs Lookup Tables
12. Relationships vs Merge Tables
13. Creating, Modifying Table Relationships
14. Relationship Cardinality
15. Connecting Multiple Tables
16. Filter Direction
17. Defining Hierarchies
18. Powerpivot and data analysis expressions
19. Power Pivot Best Practices
20. Common DAX Functions and Categories
21. Advance DATA Analysis Expressions
22. The Calculate Function
23. Time Intelligence Functions
24. Speed and Performance Configuration
25. Exploring Pivot Chart, Map, View
26. DEMO: Matrix Visuals, Date Slicers, Cards and KPI’s, Text Cards, Map Visuals, Tree Maps, Line and Area Charts, Trend-lines and Forecast, Gauge Charts
372 Courses • 2 Events
Business maker Academy, Inc. is an Education Center for Business, Finance, Human Resources and Corporate Skills Development. We offer a simple, direct and practical approach to business training.

Our primary purpose is to teach people how to improve their professional, personal and financial lives through experience-based learning.

We are an Accredited Training Provider for the Civil Service Commission (CSC) & Philippine Government E-Procurement System (Philgeps). Since 2003, Business Maker Academy has conducted numerous seminars and has served over 100,000++ highly satisfied clients and counting…
Contact Us
1503A PSEC, West Tower, Ortigas Center Pasig City,
Pasig, Metro Manila, Philippines 1605
86874445
Sending Message
Please wait...
Loading...