POWER BI

Power BI for Excel (2010, 2013) is a powerful tool which allows you to consolidate and mine
data from multiple sources, investigate trends, create dashboards and make sense of your
business data. This can be done with just a few clicks in the familiar environment of Excel. Now it is possible to
process millions of rows of data in Excel enabling deeper business insight and shorter decisionmaking cycles.

Request a Meeting

WHY IS IT CRUCIAL TO TRAIN YOUR EMPLOYEES?

Increase in Productivity
Performance Management
Product Quality
Employee Retention

COURSE PREREQUISITES

  • A very good knowledge of Excel, including a working knowledge of PivotTables.

LEARNING OUTCOMES

  • The definition of BI
  • Why is BI important?
  • Preview a BI stack
  • Apply font and paragraph attributes
  • Navigate and search through a document
  • Apply indentation and tab settings to paragraphs
  • Differentiate between business groups that consume BI
  • Understand the typical progression of BI
  • Determine the best BI tools for your needs
  • Working with Classic Excel PivotTables
  • Working with PivotTables in PowerPivot
  • Importing, Querying Data and Creating a Data Model
  • Create and manipulate page backgrounds
  • Create and modify headers and footers
  • Using the PivotTable to Produce Reports
  • Adding Calculated Columns
  • Extending the Data Model relationships using Excel, PowerPivot and DAX
  • Understanding Calculation in DAX
  • DAX Syntax, DAX Data Types, DAX Operators & DAX Values
  • Understanding Calculated Columns and Measures
  • Create Map-based PowerView reports
  • Incorporate Internet Data, and Set Power View Report Defaults
  • Create Amazing Interactive and Animated Power View Reports
DOWNLOAD SYLLABI

PUBLIC COURSE SCHEDULE

Venue: Holistic Technologies Ltd, Fgura

Training Date Time Price
Thursday 26th April ’18 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW

ON-SITE TRAINING

Holistic Technologies On-site Training is a flexible, cost-effective option that allows you to train as many or as few employees as you need—from a single team or department to everyone in your organization.

On-site Training courses can be delivered “off-the-shelf,” slightly modified or completely customized for your learning needs. They’re designed to meet your most important goals and produce immediate, measurable results.

Your employees and your business benefit because:

  • Courses are planned around the individual’s and department schedules, and delivered in any format
  • Teams will learn with real-world, mission specific examples to ensure your project’s success
  • You maintain productivity with flexible course scheduling
  • You can train groups of employees to significantly reduce expenses
  • You can tailor the course material to fulfill corporate needs and expectations.
Request a quote