Data Analytics and Business Intelligence using Power BI and Power Pivot for Excel

Registration Deadline: 29 May 2018

Training Dates: 05 & 06 June 2018

Training Hours: 08:30 - 17:00

Location: CIIM Nicosia ( View Map )

Language of Instruction: English


Overview

This 2-day hands-on workshop on business analytics uses Microsoft’s Power Pivot for Excel and Power BI tools. Every business user should know how to perform sophisticated data analysis, create unique dashboards using Power BI and develop powerful data models.

Microsoft Power BI and Power Pivot for Excel converting them into meaningful information. We will teach you how you can take your analysis one step further using two versatile business intelligence tools.
Big Data is growing exponentially due to an increase in the usage of mobile technology and internet. Those that they can analyse data efficiently unlock potential wealth in their business and can contribute in the improvement of business results.

Free Takeaway: Participants will receive sample worksheets, dashboards and templates that will allow them to review the models discussed during the seminar and adjust them to their own day-to-day needs. Participants will also receive 2 hours of video tutorials, available to watch 24/7 at their own pace.

Important Note: Participants are required to bring their own laptop and have Excel 2013 installed as a minimum requirement.


Key Outcomes

This is a highly practical two-day training seminar that will allow you to:

  • Learn how to install and use Power Query, Power Pivot and Power BI and realize the differences depending on your version of Microsoft Excel.
  • Automate data import from various sources and create relationships in your data model.
  • Build interactive reports, perform business intelligence and analyse your data so that you can make well-timed business decisions.
  • Produce valuable measures for your firm and advance your analysis by incorporating the power of Data Model into your day-to-day data analysis.
  • Learn how to create dynamic dashboards, filter your data and perform easy drill-downs to your data so that to perform sophisticated business intelligence.

Anyone that uses Excel lookup functions, works with big data and wants to enhance his output and analysis will benefit from this hands-on seminar.


Designed for

This hands-on workshop is designed for junior to senior business students and professionals as well as general managers who need to enhance your data analysis skills and measure business performance, including:

Directors, GMs, VPs, Senior Managers, Managers, with responsibility in the following functional areas:

  • Business & Financial Analysts
  • CFOs & Finance Managers
  • Risk Managers and Portfolio Managers
  • Financial Controllers and Accountants
  • MBA’s and Business Undergraduates
  • Anyone seeking to improve their data analytics skill set   
  • Industry Consultants
  • Project Managers and Risk Analysts
  • Corporate Finance and Business Development Professionals
  • Finance & Accounting staff
  • Heads of Business Units & Business Planners

Topics to be covered

You will learn how to use Power Pivot and Power BI by applying the concepts taught to a real business situation.

A real-life case study will help you examine how the analysis of Sales and Expenses can become more efficient, dynamic and advanced by using Microsoft’s Power BI and Power Pivot vs. more “traditional” methods of Excel analysis (pivots, vlookups etc).

We will demonstrate how to avoid time-consuming and repetitive data manipulation, allowing us to focus on more important aspects and explore the new capabilities Excel has to offer to improve the quality of our analysis.

Additionally, we will introduce the use of DAX (Data Analysis Expressions) functions for simple and complex calculations. (Basic DAX functions (Aggregate, Logical, Table and Relational Functions), Time Intelligence Functions and Calculations, Calculate, Practice Implementation of DAX Functions with Examples)

Power BI is a cloud-based business analytics service that enables anyone to visualize and analyse data with greater speed, efficiency, and understanding. Learn how you can deliver critical information and get important insights from your data by visualizing your work with Microsoft Power BI.  It connects to a wide range of data sources and can help you firm create valuable insights and be ahead of the competition. Here is a sample of a dynamic dashboard created with Power BI and you should expect to learn how to create similar ones once you have concluded with this workshop: http://bit.ly/powerbidashboardsample

Power Pivot is an Excel add-in which allows you to integrate your data using table relationships and perform powerful data analysis by creating simple and advanced measures using DAX language. By using the power of Data Analysis Expressions (DAX) language you will upgrade the data manipulation capabilities of Excel and thus allow the user to create more sophisticated and complex measures and highlight key business performance e.g. perform advanced time intelligence, combine and filter your data etc.


Trainer

All CIIM Executive Education programmes are developed and taught by CIIM resident and visiting faculty who are widely recognised as skilled professional trainers with local and international business experience. Through many years of business consulting and teaching experience, CIIM faculty develop innovative long-lasting practical concepts that shape the practice of your daily professional responsibilities. The result is a practical educational experience which is designed to have an immediate effect in your business environment.

dimitris leimonis
Mr. Dimitris Leimonis
(Bio)

 

Mr. Dimitris Leimonis

Mr. Leimonis is the Managing Director of Financial Arena, a London-based consultancy specializing in financial modeling, data analytics, business intelligence, firm valuation and risk analysis. He attained in becoming one of the first financial modelling experts globally to be accredited on the 2 major financial modelling standards.  He is an experienced finance professional with an in depth 20-year experience in financial markets and has hands-on experience in a number of industry sectors, including financial services, education and retail. In the business training area, he has provided training to more than 1000 banking and business professionals focusing on financial modelling, data analytics, asset allocation, portfolio management and risk analysis. His core skill set includes applied financial analysis, and development of business intelligence solutions using Power BI, resulting in better decision making. These skills incorporate design and construction of sophisticated financial models and communication of the outcomes in the form of high quality reports and presentations. Partnered with Microsoft to run bespoke training camps on Data Analytics and Financial Modelling in Greece and Cyprus. He is also an adjunct finance lecturer at ALBA Graduate Business School at the American College of Greece and had been a module leader at advanced Finance courses at Deree college from 2008 till 2015.

He holds an MBA from Drexel University, specializing in Management Information Systems and Investment Management and a BSc in Banking and Financial Management from the University of Piraeus. He is also a certified Financial Modeller, Portfolio Manager and Investment Consultant.


Programme Fee

Per Participant: €380

No VAT is charged due to CIIM’s non-profit status. Fees include tuition, educational materials, lunch, coffee-breaks and refreshments.


Application

To proceed with your registration, please click the button below to apply online. Participation is subject to availability.

Apply here

Join our Mailing List!


Name:*
Occupation:*
Company:
Direct Number:
E-mail:*

Contact us

aiqz5yXkT

Local: 77772446
International: +35722462246

jcxEraGgi execedu@ciim.ac.cy