Interactive Visual Reporting and Analysis with Microsoft Excel Date: 15-16 January 2015 Course Fees: RM1300 / RM1200 (MEF members) Venue: Pentawise IT Training Centre, The Boulevard, Mid-Valley City Data Visualisation is increasingly becoming an essential need in enhancing business decisions. This course brings users to the forefront on the technology of data visual display to enhance reporting, analysis and performance management. With visual analytics, users can spot business issues and problems needing attention at a glance and take action on a timely manner. Microsoft Excel is an ideal tool in putting all these data together, making meaning out of it and displaying the analysis easily in an interactive dashboard form. Using case studies as a framework, this course will enable users to create appropriate, informative, easy to understand and interactive visual dashboards. Step 1-Understanding the concepts of creating dashboards and visual displays Step 2-Identifying the essential techniques and methods of visual reporting Sales Interactive Visual Reports

Step 3-Integrating all the critical components in data analysis by using the relevant functions and formulas Step 4-Applying the creative combinations of dashboard charting techniques and design in analysis of data.

Key Performance Indicator/Index (KPI)

Who Should Attend This course is relevant to data analysts, managers in Sales, Human Resources, Finance who need to analyse, design and present meaningful dashboards. Participants are required to have the knowledge of Excel Functions prior to attending this course.

In this 2 day course, you will learn: Lesson 1: What is Visual Reporting o Outlining the steps of creating reports o Identifying what to do and what to avoid in creating reports Lesson 2: Identifying the Right Charts in Visual Reporting o Excel Charts as the key element in visual reporting o Identifying the different charts:-Thermo-meter charts, Tornado Charts, Indexed Charts, Funnel Charts, Sparklines and Interactive Chartings Lesson 3: Form Controls o Leveraging Form Control, an interactivity tool in creating interactive, user friendly and powerful reports. o Uncovering the `big mystery’ of Form Controls. o Exploring and mastering the usage of the 5 important Form Controls.

Lesson 4: Conditional Formatting o Extending the functional capabilities of Conditional Formatting in creating Visual Reporting. o Leveraging on the 5 conditional formatting `tips and tricks’ in transforming your reports into impressive visual reports. Lesson 5: Applying Functions in Visual Reporting o Applying the relevant functions in Visual Reporting. o Leveraging the creative combination/fusion of Excel Functions and Form Controls in creating a visual report. Lesson 6: Evaluating Case Studies o With the practical approach in using both the KPI (Key Performance Indicators) and Sales Interactive Visual Reports (SIVR) case studies throughout the class, users evaluate and learn the applicability of Visual Reporting at their own environment.

PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft Excel Date: 22-23 JANUARY 2015 Course Fees: RM1800 / RM1700 (MEF members) Venue: Pentawise IT Training Centre, The Boulevard, Mid-Valley City

With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous amount of data/records into meaningful information. It helps to generate rich and interactive analysis solutions. It is an extension to things you already know about Excel and it comes FREE with the software (Excel 2010 and above) Who Should Attend This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data. Knowledge and experience in using Excel PivotTable is assumed. Participants are required to have the Microsoft Excel version 2010 and above.

`PowerPivot is the best new feature in Excel in 20 years - Billl Jelen’. Here is why: 

1 – Load massive volume of data from different data sources.

2 – PowerPivot combines data & create relationship of data forming a data model.

3 – Report: A collection of table and their relationships show the real world relation in Business Intelligent. E.g. Ho demographic / gender / age / salary relates to sales / market trends,

4 – PowerPivot: to generate rich, interactive and analytical business information







Data from Different Sources- With PowerPivot, you can import data virtually from any data source e.g. from SQL Server, XML and even web based data. These mixed and mashed up data from different data sources are combined. Relationships of data from these different data sources can be easily be created and be generated into a single report or a data model. There is no need to use any Excel Functions e.g. VLookup to `join’ these data. Large Volume of Data-Microsoft Excel 2010 has a maximum of about 1 million rows of data. PowerPivot can store and process unlimited capacity of data. Create Visually Appealing Analytical ModelsAnalysis will be made easier by presenting the output in variety of visual forms. You can present your data in PivotTable and PivotCharts. PowerPivot allows further enhancement of data analysis into Business Intelligence Dashboards. Use the powerful new analytical capabilities, the Data Analysis Expressions (DAX)

In this 2 day course, you will learn: Lesson 1: Introduction to PowerPivot o Accessing the PowerPivot add-in o Navigating the interface Lesson 2: Load data into PowerPivot o Uncovering data interpretation issues Lesson 3: Table Relationships o Create relationships from data sources using relationship tool and the diagram view. Lesson 4: Familiarize with the features and functions of PowerPivot Windows o Navigate the PowerPivot Windows.

Lesson 7: Communicate Visually Appealing data insights with Dashboards Lesson 8: Create simple Data Analysis Expression (DAX) and Key Performance Indicators (KPI) o Create powerful new analytical capabilities using the (DAX) Function o Determining performance against goals, objectives and business processes using KPI Lesson 9: Create a hierarchy in a table o Define Hierachies in a Table which enable users to interact different reporting layers and bring in existing fields into a natural table of hierarchy.

Lesson 5: Calculated Column Lesson 6: Use PowerPivot to generate PivotTables o Articulating and analyzing data using PivotTables

Lesson 10: Create and manage data with perspectives

PUBLIC COURSE REGISTRATION FORM MEF ACADEMY SDN BHD P.O. Box 11026, 50732 Kuala Lumpur Attn: Ms. Zana / Ms. Eina E-mail: [email protected];[email protected] Tel: 03-7955 7778 ext. 144 Fax: 03-7955 1945

TO:

We would like to enrol: Mr. / Ms.: FULL NAME

Designation

E-mail & Tel. No. (Trainee)

Course

Date & Venue

Company

: ______________________________________________________________________________

Address

: ______________________________________________________________________________

_____________________________________________________________________________________________ Tel. No

: ___________________________________

Fax No

: ___________________________

Contact person : ___________________________________ Designation

: ___________________________

Signature

: ___________________________

:_______________________

E-mail Contact Person

Attached is our cheque no. : _____________________ payable to : Malaysian Employers Federation (MEF members only) MEF Academy Sdn Bhd (non-members) NO CASH PAYMENTS / CASH CHEQUES ACCEPTED. For further information on the courses please contact the MEF Academy.