Power Pivot and Power BI – Tools for Data Analysis and Dissemination

Location
UAE, Dubai
Dates
04 - 08 Nov 2018 (5 days)
Course Type
Professional Training Course
Accreditation
-
Language
English
Price
$4,390

Special prices available

Course Overview

Almost every organization, whatever its size, is drowning in data. Businesses need to analyze accounting data, marketing data, service data, budget data, human resources data, manufacturing data, and organizational data, among others. Organizations need to: »» Analyze historical performance data vs budgets; »» Measure, track and predict sales »» Finding issues before they escalate »» Develop their customer relationship »» Optimize processes and operational performance Finance, marketing, HR and production teams in most organizations spend hours and hours of time crunching data in Excel. There is never enough time to fully analyze the data. By using PowerPivot and Power BI you can analyze data in ways that go way beyond “regular Excel”. You can get more done in less time. PowerPivot is arguably said to be the best new feature to hit Excel in 20 years. This went extra miles with the introduction of Power BI in Sept 2015. PowerPivot is a free ad-in only available in Excel 2010 any edition) or Excel 2013/16 (professional edition). It enables users to manipulate huge data sets coming from different sources in the most efficient way. Power BI is a dashboarding tool that generates the most dynamic and amazing reports at an end user level. It has taken the word by storm.

Who should take this course

»» Financial Analysts »» Chief Financial Officers »» Budgeting and planning specialists »» Accountants »» Financial government officials »» Marketing officers »» Insurance specialists and actuarists »» Credit analysts »» Treasury »» Chief Executive Officers »» Internal auditors »» Venture capitalists »» Corporate finance analysts »» Risk managers »» Board members »» Investment bankers »» Regulators »» Private equity managers »» Strategic planners »» Trustees »» Compliance officers »» Management consultants »» Bank lending officers »» Compliance officers »» Management consultants »» Corporate Finance lawyers

Course content

PART 1: Working with classic Pivot Tables: PART2: First practical example of Power Pivot (only Excel 2013 Professional Plus) PART3: Starting with the infrastructure to build a dash board using Power Pivot from scratch PART4: Building the Dashboard in PowerPivot from scratch step by step PART 5: Very important notes in building dashboards using DAX PART 6: Creating Calendar Tables PART 7: Conditions; IF(), SWITCH(), BLANK(), etc. PART 8: Power BI Desktop

About Course Provider

Built upon the strong experience in the manufacturing sector, which its founders developed in Sweden during the 90’s global expansion, LEORON evolved into the dominant training institute that offers a comprehensive set of training and development solutions.

Today, we are globally recognized as one of the leading educational providers of American and International certification programs.

LEORON’s courses are delivered by unrivaled global experts and facilitated by the best training managers in the industry. Our training programs offer a comprehensive suite of knowledge that is accredited by relevant industry institutions. Through powerful content, gamification and applied learning, our program offers a great way of building professional skills and competencies.

We offer training and development solutions in all strategic corporate functions, including corporate finance, HR, Supply Chain, operations, engineering and quality, etc. Our content-based programs are certified by leading institutes and academies, both on a local and global level.

We are locally accredited by KHDA and TVTC, whereas our list of global partners includes APICS, APMG International, AFP, IIA, ASQ, PMI, HRCI, IFMA, IABFM, CAIA, CISI, GARP, IACCM, ILM and many more.

HR Consultancy - we offer competency framework development, training needs analysis, capability and capacity building, strategic talent acquisition and much more. Our clients can gain more, whether they are facing difficulties re-organizing their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure.