Dates: 14/3/2018 – 12/3/2018
Hours: 9:00 – 17:00
Academic hours: 24 hrs
Course level: Basic + Advance
Course language: English
Place: Naya College, Herzliya
The goal of the course is to teach you how to load data from multiple data sources, clean it and model it appropriately, create simple DAX calculations, so you can build the reports and dashboards you need in Power BI.
This course will cover building reports and dashboards in Power BI Desktop, Excel 2013/2016 and via browser on PowerBI.com. The course will include several hands-on labs. Attendees should bring along a laptop with Power BI Desktop and Excel 2013 or 2016 installed and should also have a Power BI subscription.
A three-day course aimed at anyone who is interested in building reports and dashboards in Power BI, including BI developers, existing Power Pivot users, analysts and report writers.
Chris Webb is the owner of Crossjoin Consulting, and is a consultant specializing in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", and blogs at http://blog.crossjoin.co.uk/
What is Power BI? A high-level description of the service and how you use it
Loading data: connecting to data sources using the Query Editor
Loading data: using the built-in transformations
Loading data: advanced topics including the M language, privacy levels, parameters and functions
Modelling data: tables and relationships
Modelling data: introduction to DAX
Modelling data: DAX row context and filter context, and the Calculate() function
Modelling data: implementing common calculations in DAX, including date calculations
Building reports and dashboards in Power BI Desktop and Power BI.com
Building reports in Excel 2013/2016 using PivotTables, cube formulas and Analyze In Excel
Sharing, collaboration using apps and applying security
Configuring and scheduling refresh of data
Power BI Premium, administration and auditing