Business Strategy

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

Data Analytics and Business Intelligence using Power BI and Power Pivot for Excel (Limassol)2018-10-12T05:39:12+00:00

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

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

Deliver critical information and gain important insights from your data by visualizing your work with Microsoft Power BI and Power Pivot for Excel converting them into meaningful information.

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.

Designed for

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

Programme Focus

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

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

Key Outcomes

  • 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.
  • Learn how to create dynamic dashboards, filter your data and perform easy drill-downs to your data so that to perform sophisticated business intelligence.

Benefits for you

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

Benefits for your organisation

  • Produce valuable measures for your firm and advance your analysis by incorporating the power of Data Model into your day-to-day data analysis.
  • Build interactive reports, perform business intelligence and analyse your data so that you can make well-timed business decisions.

Details


Dates:
27-28 September 2018

Time:
8:30 – 17:00

Duration:
14 hours

Venue:
CIIM Limassol, 3-5 Chaidariou Str. (view map)

Language of Instruction:
English

Instructor:
Dimitris Leimonis

Participation fees


Fee: € 380

HRDA Subsidy: € 0

Final Fee: € 380

* Click here to find out about special discounts that are available

Apply Now

To proceed with your registration, please complete the form below. Participation is subject to availability.

Please enter the details of the person who submits this registration:
*
*
*
*

Please select one of the following options:

*
*

Please select the number of participants who will join this programme. You may register up to 10 participants on the same application.

*
Invoice Details
*
*
*
*

1st Participants Details

*
*
*
*
*

3rd Participants Details

*
*
*
*
*

5th Participants Details

*
*
*
*
*

7th Participants Deatils

*
*
*
*
*

9th Participants Details

*
*
*
*
*

2nd Participants Details

*
*
*
*
*

4th Participants Details

*
*
*
*
*

6th Participants Details

*
*
*
*
*

8th Participants Details

*
*
*
*
*

10th Participants Details

*
*
*
*
*
Terms and Conditions (“Terms”)
Last updated: January 26, 2015

Please read these Terms and Conditions (“Terms”, “Terms and Conditions”) carefully before registering to our programmes (“programmes”) and accessing our online application form (the “Service”), both operated by the Cyprus International Institute of Management (“CIIM”, “Executive Education”, “us”, “we”, or “our”). Your access to the Service is conditioned on your very acceptance of and compliance with these particular Terms. Effectively, these terms apply to all visitors, users and others constituents (“you”, “your”, "persons", “customer”, “participant”, or “company”) who may demonstrate interest in our Service. By accessing this Service, you actually agree to be legally bounded by these Terms. In contrast, if you are in disagreement with these Terms and Conditions, we kindly advise you to exit this Service immediately.

1. Personal Information

By using this Service, you in effect agree that CIIM is empowered with full authority to maintain an internal record of your personal details. Your personal details are collected when registering to the CIIM programmes and enquiry forms.

In particular, for the purpose of promoting CIIM's programmes and activities, you are kindly informed that your personal information including current and former participation to programmes, testimonials, full name, position, company and company logo may be used without your prior concent or consultation with you. If you do not wish CIIM to have your details included in our promotional activities, please notify us of your objections by writing to execedu@ciim.ac.cy or to Cyprus International Institute of Management, 21 Akademias Avenue, Aglandjia, P.O. Box 20378, 2151 Nicosia, Cyprus.

We wish to assure all persons interested in our Service that we will not sell, distribute or lease any of your personal information to third parties unless we have your permission or we are required by law. At the same time, we wish everybody know that we are committed to ensuring that access to personal information in our records is completely secured. Therefore, for the purpose of preventing unauthorised access or disclosure of classified information, we have put in place adequately safe physical, electronic and managerial procedures to control all access to our information databases.

2. Registrations

This Service is intended to collect information for your participation in our programmes. However, we cannot guarantee your automatic participation or seat reservation to our programmes, considering that practical limitations may arise. CIIM reserves the right to change or cancel the dates of the programme, without your consent. In the event of cancellation or modification of the time schedule of the programme, it will be our duty to give you adequate notification for the any schedule changes.

3. Tuition and Programme Fees

Tuition is due upon your acceptance by the CIIM into the programme you have applied for. However, prices are subject to change without notice. Furthermore, if you fail to settle your invoice prior the commencement of the programme, CIIM reserves the right to cancel/withdraw your application and refuse your participation. Additionally, if you fail to settle your invoice,  even after the commencement of the programme, CIIM reserves the right to proceed with legal actions for damages.

4. Cancellation of Registration

Cancellations must be received in writing. Cancellations received more than seven (7) days prior to a program’s start date will not incur penalties. On the other hand, for cancellations received less than seven (7) days prior to a program’s start date, you will incur a charge of 100 percent of the full tuition. In this case though, substitutions may be welcomed considering the service capabilities of CIIM. If a participant or a participating company fails to attend the programme they have applied for without any prior notification, even if a withdrawal occurs on or after a program start date, full tuition may be forfeited.

5. Refunds and Transfers of Registrations

Participants who would like to request a full refund for their participation, or need to transfer their participation to another CIIM programme, may be eligible to do so considering that the start date of the original programme is no less than seven (7) days. Requests to refunds received less than seven (7) days prior to the start date of the programme, will be forfeited. However, in this case though, transfers of registrations may be welcomed considering the service capabilities of CIIM. If a participant or a participating company fails to attend the programme they have applied for without any prior notification, even if a withdrawal occurs on or after a program start date, full tuition may be forfeited.

6. HRDA Subsidy

The Human Resource Development Authority (HRDA) provides a subsidy i.e. partial or full tuition coverage, to organisations participating with their employees in the Authority's programmes, only if they can meet the Authority's criteria. In order to confirm your eligibility to participate in the Authority's programmes, we provide you with the Authority's programme form for which you need to return to CIIM fully completed. If for whatever reason, the HRDA refuses to provide a subsidy for your attendance to our programmes, you and your company will be liable to immediately reimburse CIIM with the gross fees, which were supposed to be covered by the HRDA subsidy. If you fail to meet your legal costs to CIIM, we reserve the right to proceed with legal actions for damages.

Additional Policies

1. Termination of Service

We may terminate or suspend access to our Service immediately, without our prior notice or any liability on our part, for any reason whatsoever, if you breach the Terms included in this agreement. All provisions of the Terms which by their nature should survive termination shall survive termination, including, without limitation, ownership provisions, warranty disclaimers, indemnity and limitations of liability.

2. Governing Law

These Terms shall be governed and construed in accordance with the laws of Cyprus, without regard to its conflict of law provisions. Our failure to enforce any right or provision of these Terms will not be considered a waiver of those rights. If any provision of these Terms is held to be invalid or unenforceable by a court, the remaining provisions of these Terms will remain in effect. These Terms constitute the entire agreement between CIIM and you regarding our Service, and supersede and replace any prior agreements we might have between CIIM and you regarding the Service.

3. Changes

We reserve the right, at our sole discretion, to modify or replace these Terms at any time. What constitutes a material change will be determined at our sole discretion.

4. Insurance Coverage

CIIM requires that all participants maintain their own insurance for medical care, illness, and injury. CIIM is not responsible for medical expenses incurred while attending a program. Please make sure that any private insurance provides valid coverage in Cyprus.

Contact Us

If you have any questions about these Terms, please feel to contact us using the information below:

Telephone: +35722462246
E-mail: execedu@ciim.ac.cy
*