X
Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
Advertisement

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

Advertisement

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


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 the NEW spreadsheet program from Microsoft (launched in July ’15). The BI stands for Business Intelligence which is all about getting insightful summary information from your data. It does not immediately replace Excel but it can be described as a more modern take on what a spreadsheet can actually do. The objective of our course is to extend your spreadsheet skills to Power BI.

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 (Visual | Formula | Transitioned) + Row by Row iteration



Important functions:

SUM | COUNT | COUNTROWS | MIN | MAX | DIVIDE

CALCULATE | Formula Filterins | Transitioned 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 why not join us on Thursday, July 19th and start learning the program, which Excel enthusiasts around the world are proclaiming as the next generation spreadsheet – Microsoft Power BI.



Also check out other Workshops in Dublin.

Liked this event? Spread the word :

Map Marino Institute of Education, 9 Griffith Avenue, Dublin, Ireland D09 R232, Dublin, Ireland
Loading venue map..
Report a problem

Are you going to this event?

Organizer

Spreadsheet Interaction
Advertisement
Create an Event