€221.40

Microsoft Power BI: An introductory course for Excel spreadsheet professio...

Event Information

Share this event

Date and Time

Location

Location

Marino Institute of Education

9 Griffith Avenue

D09 R232 Dublin

Ireland

View Map

Event description

Description

This 1-day course introduces you to Microsoft Power BI in the perfect learning environment of the Marino Institute www.mie.ie .

Power BI is a NEW program from Microsoft (launched in July ’15). BI is an acronym for Business Intelligence and the program involves getting insightful summary information from your data to boost your decision-making capabilities. The objective of our course is to extend your spreadsheet skills to Power BI; to get you up and running with the program as quickly as possible.

On the course you will start learning Power BI from scratch. This means, for example, we start with the familiar SUM function (same spelling as in Excel) to show you how it is similar but different in Power BI. A constant theme in Power BI when comparing it to Excel – similar but different!

There is no need to bring along a laptop on the day as computers (with FREE Microsoft Power BI Desktop pre-installed) are provided by the college in its excellent computer training room. Maximum class size is 8 people. Coffee breaks on campus in the Cloister Café.


Course Contents -

Data Model:

Columns | Tables | Relationships| Measures | Calculated columns

Two core concepts:

(1) Data tables + Lookup tables

(2) Filterins (What you see | Formula & Function | Context transition) + Row by Row iteration

Important functions in DAX (Data Analysis eXpressions formulas):

SUM | COUNT | COUNTROWS | MIN | MAX | DIVIDE

CALCULATE | Formula & Function Filterins | Context transition Filterins

FILTER | VALUES

ALL | ALLSELECTED

Time Intelligence | Actual v. Budget

IF | SWITCH | SELECTEDVALUE


Fantastic features:

Interactive Summary Visuals | Slicers | Q&A natural language | Drill down & up | Drillthrough | What-If Analysis | Bookmarks | Report page Tooltips | Explain the decrease/ increase | Quick Insights Machine Learning

So join us on Thursday, July 19th and start learning the program, Microsoft Power BI, which Excel professionals around the world are increasingly beginning to use.

YOU too can QUICKLY discover its "POWER"!

Share with friends

Date and Time

Location

Marino Institute of Education

9 Griffith Avenue

D09 R232 Dublin

Ireland

View Map

Save This Event

Event Saved