Enable Technology

Data Analytics 

Microsoft Power BI

Course Overview

This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop. 

Duration: 2 day course

Course Content

Topics covered include-

Introducing Power BI
The Power BI Interface
Overview of the Power BI Data Model.

Using Power BI
Connecting to Power BI data
Create a Power BI dashboard
Using Excel as a data source for Power BI
Using databases as a data source for Power BI
Importing data into Power BI
Importing different data sources into Power BI
Viewing reports from Excel files

Shaping and Combining Data
Power BI desktop queries
Shape data using formatting and transformations.
Combine data together from tables in your dataset.

Modeling data
Create relationships between data tables.
Understand the DAX syntax and use DAX functions to enhance your dataset.
Create calculated columns, calculated tables and measures.

Interactive Data Visualisations
Creating Power BI reports
Managing a Power BI solution
Use Power Bi desktop to create interactive data visualisations.

Direct Connectivity
Direct connectivity from Power BI desktop
Direct connectivity from the Power BI service
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode.

The Developer API
The developer API
Custom visuals

Power BI mobile app
Using the Power BI mobile app
Power BI embedded

Email us about this courses         Telephone on 01952 305730

Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.

West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;