Overview

4 Day Power BI – Data Analytics & Business Intelligence is a hands-on workshop on business analytics using Power Query, Power Pivot and Power BI. Every business user should know how to perform sophisticated business analysis, create unique dashboards using Power BI and develop powerful data models. 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, lookups etc)

It 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, the course will introduce the use of DAX (Data Analysis Expressions) functions for simple and complex calculations.

Trainer Profile

He is an internationally recognized London-Greece based consultant specializing in financial modeling, data analytics, business intelligence, firm valuation and risk analysis.

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.

He has provided training to more than 1100 banking and business professionals including recent trainings in the caribbean.

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.
 

Course Key Takeaways

Learn how to install and use Power Query, Power Pivot and Power BI and realize the differences depending on your version of Microsoft Excel.

Produce valuable measures for your firm and advance your analysis by incorporating the power of Data Model into your day-to-day data analysis.

Automate data import from various sources and create relationships in your data model.

Learn how Excel and Power BI are better-together in order to perform advanced business analysis.

Who should Attend?

  • Business & Financial Analysts
  • CFOs & Finance Managers
  • Risk Managers and Portfolio Managers
  • Financial Controllers and Accountants
  • BI consultants
  • Business analysts
  • Business Intelligence Manager
  • Business Development and Marketing
  • Data Scientists
  • Intensive users of excel, especially those responsible for reporting and analysis.
  • Database professionals looking to increase their professional agility

PRICING & REGISTRATION

    Pricing is coming soon

Get Brochure

CONTACT PERSON

In-house opportunity

We can come to you too! If you have a team of six or more, why not hold a private course?

For more details:

Call +1 780 851 8729 (Canada) 
Email : inhouse@biiworld.com