€184.50

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 , Dublin.

[Price quoted includes VAT @ 23% of €34.50. Price excluding VAT is €150. Total price = €184.50]


What's it all about:

Power BI is a NEW program from Microsoft (launched in July 2015). It was recently awarded Editors’ Choice in PCMag.com’s self-service BI tools review roundup.

BI is an acronym for Business Intelligence and so the program assists you in getting insightful summary information from your data to boost your organisation’s 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.


The 2 trainers:

Microsoft Excel certified spreadsheet expert (MOS) and accountant, Martin Loughman, who has been a trainer since 2015 is delighted to be joined for this training day by Mary Fealty - a leading light in the UK & Ireland’s burgeoning Power BI community and an extremely enthusiastic and knowledgeable Power BI professional. Her recent engagements as a Power BI speaker included a session entitled "The Evolution of Power BI" at this year’s inaugural international Data & BI Summit (Dublin), SQL Saturday (Cork) and Power BI User Group Meetup (London).

Mary is a Pro User of Power BI and as such uses Power BI on a daily basis in her own very successful business providing valuable data insights to insurance brokers: https://www.broadtreesolutions.co.uk/services/ . From time to time she gets the opportunity to publish videos on her YouTube channel as well – see this month’s video showcasing Power BI’s Q&A feature: https://youtu.be/a7wWw6U3x_8 - and tweets quite regularly about Power BI matters from @Br0adtree .

Together, Martin and Mary will help demystify Power BI for you and get you started!


We start with ...

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


Practicalities:

There’s no need to bring along a laptop on the day as computers (with Microsoft Power BI Desktop pre-installed) are provided by the institute in its excellent computer training room. You can always download the program for free from https://powerbi.microsoft.com/en-us/desktop/ for your own laptop as well of course.

You will receive a full set of course notes and training files to work through on the day itself – learn by doing! Maximum class size is 8 people and with two trainers present, individual attention is assured. Free car parking is also available on site for course attendees. Coffee breaks on campus in the Cloister Café.

What you will learn …

A. Fantastic features:

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

B. Core concepts:

  • Get Data (Power Query)
  • Data Model - Columns | Tables | Relationships
  • Lookup tables | Data tables
  • Measures | Calculated Columns
  • FilterIn(s) - What you see | Formula & Function | Context transition (via Row by Row iteration)

C. Formulas & Functions:

(DAX - Data Analysis eXpressions)

  • SUM | COUNT | COUNTROWS | MIN | MAX | DIVIDE
  • CALCULATE | Formula & Function FilterIn(s) | Context transition FilterIn(s)
  • FILTER | VALUES
  • ALL | ALLSELECTED
  • IF | SWITCH | SELECTEDVALUE
  • Time Intelligence functions | Actual v. Plan

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 and appreciating what it can do for them.



YOU too can QUICKLY discover its "POWER"!



Note:

1. Earn a potential 6 hours of CPD on the day.

2. Certificates of Attendance upon course completion.

3. Phone Martin Loughman on (090) 962 1006 if you have any queries about this 1-day course.


[Price quoted includes VAT @ 23% of €34.50. Price excluding VAT is €150. Total price = €184.50]


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