קורס Power BI לאנליסטים ולמפתחים!

 

Power BI Course for Analysts and Developers

אקסלנדו בשיתוף פעולה עם נאיה קולג' מביאים את Chris Webb 

המומחה מספר אחד באירופה ל- Power BI, DAX & M

 

 

Dates: 14/3/2018 – 12/3/2018

Days: Mon-Wed

Hours: 9:00 – 17:00

Academic hours: 24 hrs

Course level: Basic + Advance

Course language: English

Place: Naya College, Herzliya

 

The Course

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.

The Trainer

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/

 

 

Course Contents

Monday 12.3.18

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

Tuesday 13.3.18

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

Wednesday 14.3.18

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

 

השאירו פרטים

או חייגו: 0772101924

יצירת קשר