Self-Service Business Insights With Microsoft Excel Power 4 | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Self-Service Business Insights With Microsoft Excel Power 4

Location

Format What’s this?
Starting From
RM 1000.00
  1. 2 Day with 08 hours per day
  1. Mon 17 May 09:00 - Tue 18 May 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  1. 2 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Self-Service Business Insights With Microsoft Excel Power 4

WHAT YOU WILL LEARN

This 2 days training focuses on the business intelligence platform from Microsoft that empowers end users to embrace concepts and capabilities of self-service business intelligence. Armed with the most popular tool ever, Microsoft Excel 2013 today offers a myriad of excellent and easy to adopt tools which would open everyone's eyes into the world of advanced data analysis and reporting, with ease and at everybody's fingertips!

AUDIENCE

All Microsoft Excel users from any background that has concerns to data handling.

PREREQUISITES

  • Microsoft Excel 2010 and 2013 users
  • Understanding of basic Microsoft Excel usage and functionality.

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

COURSE OBJECTIVES

Upon completion of this program, participants should be able to :

  • 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.

Expand All

Modules

Introduction To Microsoft Business Intelligence
Microsoft Business Intelligence Vision
Lessons
  • What is Business Intelligence?
  • Enterprise Business Intelligence
  • Team Business Intelligence
  • Self-Service Business Intelligence


Introduction To Excel 2013 Powerpivot

In this module we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sound powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing

Lessons

  • 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

Lab 1: Excel 2013 PowerPivot

  • Pivot Tables (Optional)
  • PowerPivot User Interface
  • Importing Data
  • Importing Large Datasets
  • Importing Data with a Query
  • Creating Relationships
  • Creating a Cascading Relationship
  • Creating a Relationship Between Tables From Different Sources
  • Hiding Columns, Change Data Type, Sorting, and Filtering
  • Calculated Column and Calculated Field
  • Add a Calculated Field From the PivotTable
  • Filter Context Using One Table
  • Row Context and Dynamic Selection
  • FILTER Function
  • CALCULATE Function
  • Build a Date Table
  • Relate a Table to an Excel Calendar Table
  • Time Intelligence
  • Perspectives
  • Hierarchies
  • KPIs

After completing this module, students will be able to:

  • Understand pivot tables (optional)
  • Explore the PowerPivot user interface
  • Import data
  • Import large datasets
  • Import data with a query
  • Create relationships
  • Create a cascading relationship
  • Create a relationship between tables from different sources
  • Hide columns, change data types, sort, and filter.
  • Create and configure calculated columns and calculated fields
  • Add a calculated field from the pivot table
  • Filter context using one table
  • Understand row context and dynamic selection
  • Use FILTER function
  • Use CALCULATE function
  • Build a date table
  • Relate a table to an Excel calendar table
  • Create and configure Time Intelligence
  • Create and configure perspectives
  • Create and configure hierarchies
  • Create and configure KPIs


Introduction To Power View

In this module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will have you ready to visualize your data in a variety of ways

Lessons

  • Report Design Principles
  • New 2013 Power View Features
  • Microsoft Power View User Interface
  • Tables
  • Charts
  • BI Semantic Models
  • Saving and Sharing

Lab 1: Power View

  • Power View

After completing this module, students will be able to:

  • Create a report using Power View.


Introduction To Power Query

This module explains how to use Power Query effectively

Lessons

  • Power Query and Power Query Formulas
  • ETL with Power Query
  • Online Search
  • Data Refresh
  • Managing Data Sources and Queries

Lab 1: Power Query

  • Explore and Connect to Data Sources Using Power Query
  • ETL Using Power Query
  • Online Search
  • Managing Data Sources and Queries

After completing this module, students will be able to:

  • Explore and connect to data sources using Power Query
  • Extract, transform, and load data using Power Query
  • Perform online searches
  • Managing data sources and queries


Introduction To Power Map

This module explores Power Map, a new 3D visualization add-in for mapping, exploring, and interacting with geographical and temporal data, enabling users to discover and share new insights

Lessons

  • What is Power Map and How Does It Work?
  • Data Visualizations and 3D Mapping Using Power Map
  • What is a Tour?

Lab 1: Power Map

  • Power Map Reports
  • Create a Tour

After completing this module, students will be able to:

  • Create and configure a Power Map report
  • Create and configure a Tour


Introduction To Power BI

Lessons

  • Power BI

Lab 1: Use Power BI

  • Install PowerBI Windows App
  • Configure PowerBI
  • Working with Power BI in O365

After completing this module, students will be able to:

  • Utilize Power BI for report delivery
  • Describe how Power BI works with Office 365
  • Setup a Power BI O365 Instance
  • Install and configure the Power BI Windows 8 App


Anne Teoh Hui San

Anne Teoh Hui San

A rising and highly engaging trainer, Anne Teoh represents a new face for Microsoft Office training. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel and Office PowerPoint trainings, having most of the occasion delivering beyond client expectations of what defines a training.Focusing heavily on delivering hands-on experience to her participants, she instils a robust understanding of the fundamentals for Microsoft Office training; as she strongly views that traditional delivery of training should be phased out and delivered in a lively manner that reflects the everyday routine of a given professional.Besides training, she is also as a deeply involved the development of Windows Phone Applications, mostly handling the UI/UX portion.


Read More

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Gerald Hoong Seng Kah

Gerald Hoong Seng Kah

Gerald has 19 years of information technology experience and on community service and event experiences, he excels impressively. He was invited as a speaker for 3 break-out sessions for Microsoft TechED SEA 2008 on SQL Server 2008 at Kuala Lumpur Convention Center.

He even participated at the “Ask-The-Expert" booth for Microsoft Visual Studio 2008 and Microsoft SQL Server 2008 at the Heroes Launch 2008 and conducted a Microsoft Visual Studio Team System 2008, formerly code-named “Orcas" Metro workshop for Microsoft Certified Partners and independent software vendors (ISVs).

He was invited as a speaker on various occasions such as during the 2 break-out sessions and 3 instructor-led sessions at Microsoft TechED SEA 2007 on SQL Server 2008 and Office SharePoint Server 2007 respectively at Kuala Lumpur Convention Center. He was also a speaker for an instructor-led session at Microsoft TechEd SEA 2006 on development of web parts using Windows SharePoint Services Version 3.0 at Kuala Lumpur Convention Center.

He conducted a few Microsoft Office 2007 Touchdown workshops for Microsoft Certified Partners and independent software vendors and Microsoft Windows Vista Beta 1 Touchdown workshop and Microsoft Windows Vista Beta 1 Touchdown workshop for Microsoft Certified Partners and ISVs. He also conducted a Microsoft Windows Server code-named “Longhorn" Touchdown workshop and Microsoft Visual Studio Team System workshop for Microsoft Certfied Partners and ISVs.

He was invited as a guest speaker on Microsoft Office 2007 development for the MIND community, which is an active IT community under the helm of Microsoft. He is a committee member of SQL Practitioners Alliance Network (SPAN).

He was the co- speaker and tag team presenter at the recently concluded World SharePoint Conference 2014 at Las Vegas, USA. He was the only Malaysian presenter among the other presenters from Asia.

In March 2014, he participated as co-speaker and tag team presenter at the World SharePoint Conference 2014 at Venetian Hotel and Resorts, Las Vegas, USA.

Recently, he conducted a specialized Microsoft SharePoint training and consultancy for a team of 17 people from Carlsberg Group at Carlsberg & Jacobsen Brewhouse in Copenhagen, Denmark.

Read More

Ricky Chan Chee Ho

Ricky Chan Chee Ho

Ricky have extensive knowledge in software application, management skills, leading edge technology planning and implementation as well as superior strategic thinking & communication skills.His expertise are in Exchange Server, SQL Server 2000, 2005, 2008, 2012, Windows 2000, Microsoft Windows Server 2003, 2008, 2012, Window XP, Vista, 7, 8, Window NT server, Microsoft offices 2003, 2007, 2010, Microsoft Project 2013, 2007 and 2010.


Read More

Course Reviews

No Remarks

0

0 Ratings