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

Our Trainer is an BI & AI Subject Matter Expert, a Microsoft Azure Data Platform MVP and lead consultant  with over 10 years’ experience.

He is a  Global Board Advisor of PowerBIUG, run & teach regular Azure AI & BI evening community classes in London and his background is in BI & business finance ACMA.

He has developed, engineered & more recently hands-on lead of end to end MS hybrid Azure solutions architecture for data & advanced analytics, AI, ML, IoT, SAP, D365 CRM/F&O & Power BI solutions and applications.

Our Expert has worked closely with C-level & product owners, agile methodology engaging team members both professionally, academically and socially.

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