Create basic PowerPivot workbooks for Microsoft Excel
Create PowerView reports from PowerPivot workbooks that they have created and either upload to SharePoint sites or export into PowerPoint
Understand the full features of Power Query to easily select and manipulate data from any sources
Able to create Power Map tours and use them as rich and impressive geographical data visualizations.
Microsoft Excel 2010 and 2013 users
Understanding of basic Microsoft Excel usage and functionality.
All Microsoft Excel users from any background that has concerns to data handling.
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
Introduction To Microsoft Business Intelligence – What is Business Intelligence? – Enterprise Business Intelligence – Team Business Intelligence – Self-Service Business Intelligence
Introduction To Excel 2013 Powerpivot – Best Things That PowerPivot Brings to Excel – What Will PowerPivot Do for the Analyst – Introduction to PivotTables (Optional) – PowerPivot Versions – New 2013 PowerPivot Features – VLOOKUP Not Required (Use Relationships) – Architectural Changes in Excel 2013 – PowerPivot and Excel 2013 – PowerPivot and SharePoint – Enterprise Business Intelligence and PowerPivot – Importing Data – Data Models – Relationships – Simple PivotTable Reports – Calculated Columns and Calculated Fields – Refreshing Data – Calculations – SharePoint Sharing
Introduction To Power View – Report Design Principles – New 2013 Power View Features – Microsoft Power View User Interface – Tables – Charts – BI Semantic Models – Saving and Sharing
Introduction To Power Query – Power Query and Power Query Formulas – ETL with Power Query – Online Search – Data Refresh – Managing Data Sources and Queries
Introduction To Power Map – What is Power Map and How Does It Work? – Data Visualizations and 3D Mapping Using Power Map – What is a Tour?
Introduction To Power BI – Install PowerBI Windows App – Configure PowerBI – Working with Power BI in O365
Contact us for more information
PREFER TO SPEAK TO US?
CHAT ONLINE – PHONE – EMAIL – SET UP A MEETING
Training.com Asia has been established for over a decade as a human capital training powerhouse. We equip our clients with leading corporate soft skills solutions, coupled with a unique approach to human capital development.
Registered as a Class A training provider with HRDF, there is quality assured in every course designed by our training specialists. Located within prime areas in Kuala Lumpur and Penang, we provide that added advantage of greater coverage to ensure quality and consistency for our clients