Employers and Manufacturers Association (EMA) Northern - Business Intelligence Using Excel

Business Intelligence Using Excel

Manage and analyse your business using Excel


This is a practical half-day workshop focusing on how you can use Excel to understand more about your business. Learn to analyse data and extrapolate information for making projections useful for the growth of your business.


If you want to analyse your business data and produce meaningful reports and dashboards using Excel, this workshop is ideal.


• What is Business Intelligence (BI)?
• Excel 2013 and BI.
• Format data as a table.
• Using sort, filter and search.
• Conditional formatting.
• Working with Sparklines, Quick Analysis, Flash Fill, Pivot Tables and Charts.
• Analysing with PowerPivot, Pivot Slicers and Timelines.
• How to use Power View.


• Format and analyse tables of data.
• Highlight key data with Conditional Formatting.
• View trends with Sparklines.
• Analyse data with Pivot Tables and Pivot Charts.
• Add multiple tables to a Data Model and create relationships between the tables.
• Analyse your Data Model with PowerPivot Tables and PowerPivot Charts.
• Create interactive reports with Power View.

For any queries contact learnit@ema.co.nz

Join Us.

Together we're building businesses, communities and opportunities for all
New Zealand

Download PDF form here
View subscription rates

Related Events & Training

If you feel constantly stressed by your workload and consider yourself time-poor, this workshop will get you back in control. Brush up on your time management skills or send a colleague.
Find out more
This introductory to intermediate-level workshop is designed for anyone responsible for managing employee leave records. It will equip you to ensure full compliance with current employment legislation, reducing risks to your organisation.
Find out more
This introductory to intermediate workshop is designed for people new to HR as well as managers, HR advisors and business partners. Certain employer obligations are essential under the Act and this workshop provides the working knowledge you need.
Find out more
If you need to be more effective in finding out-of-the-box solutions to problems, this challenging and interactive workshop is just what you need.
Find out more
If you are responsible for managing people, an HR Advisor or Business Partner, this practical course is for you. To get the most out of this course, participants should already have a working knowledge of procedural fairness.
Find out more

Related Services

AdviceLine is our front line employment relations service. Available between 8am to 8pm to advise and guide you through your issues to find effective solutions.
Read full story
EMA members can be actively involved in advocacy through our Policy, Employer and Manufacturing Forums.
Read full story
Using a non-technical approach, our practical workshops give you a thorough understanding of the various components of better business management, arming you with the latest techniques to help give your business a competitive edge.
Read full story
Our Human Resources and Employment Law workshops will show you how to provide direction and shape your workplace culture and environment using the correct processes and procedures.
Read full story
No one wants to miss out on a great opportunity. Find out what your offer should be, what the rest of the market is doing, and how to position yourself as the top choice for top talent.
Read full story