This intensive Microsoft PowerPoint training program covers the basics of Microsoft® PowerPoint and looks at advanced topics as well. Whether you are a beginner with Microsoft® PowerPoint, or have basic working knowledge, and would like to explore the various creative possibilities available in Microsoft® PowerPoint, this is the course for the likes of you. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.
- Understanding Power business intelligence
- Enabling participants to build reports
- Enabling participants to make merging, summarizing, and calculating data
- Enabling participants to work with CSV, TXT, and Excel Worksheets
·
· Understanding Relationships
LOOKUP, VLOOKUP & HLOOKUP
XLOOKUP & XMATCH
PIVOT TABLES
POWER PIVOT
RELATIONSHIPS
What is Power BI?
DATA ANAYSIS EXPRESSIONS (DAX)
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates
Installing Power BI Desktop
Exploring the Power BI Desktop Interface
Utilizing File Types; PBIX vs PBIT
Examining Data Sources
Discussing Data Refresh
Understanding Data Types
Importing, Transforming, and Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables
Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular
Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating
Creating Reports
Utilizing the Matrix Visualization
Utilizing the Map Visualization
Utilizing the Card Visualization
Utilizing the Chart Visualization
Utilizing Slicers
Publishing to Power BI Online
Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile
This programme is a designed for analysts, business seniors and financials who are interested in preparing financial and managerial reports, building dash boards, and cleaning and transforming data