082 940 0940
  • Home
  • Microsoft Power BI
    • Power BI Workshop
    • Microsoft Power BI User Group
  • Excel
    • What is Excel Business Intelligence?
    • Introduction to Excel
    • Intermediate Excel
    • Advanced Excel: PivotTables & Pivot Charts
    • Excel Powers Workshop
    • Excel BI Boot Camp
    • PowerPivot
    • Power View
    • Power Query
    • Online Excel Courses
  • Our Clients
  • Online Courses
    • ExcelBusinessIntelligence.com
    • Partners >
      • Udemy.com
      • Shaw Academy
      • Coursera
      • Ed2Go
    • Business Courses
    • Personal Courses
  • Contact Us

Dynamic Dashboards & Data Analysis with Power BI

Microsoft Power BI is a suite of business analytics tools designed for business people to analyse data and share their insights. It offers Data warehouse capabilities including data preparation, data discovery and interactive dashboards.

​Power BI was originally based on the Excel add-ins (Power Query, PowerPivot, Power View and Power Map) but over time Microsoft have added additional features, including Questions and Answers, enterprise level data connectivity and security options via Power BI Gateways.
On this two-day workshop will learn to use the cloud based BI services along with the desktop based interface, allowing you to monitor your business and get answers quickly, with rich dashboards that are available on many devices.

Workshop Content

Power BI Interface

Power BI Desktop
- Overview and Interface
- Accessing Data
- Power BI Workspaces
- Formatting Data in Power BI Desktop

Creating Reports in Power BI
- Creating a Table
- Formatting a Table
- Sorting Tables
- Creating Multiples Measures

Different Methods of Aggregation

Tables and Cards
- Creating a Matrix Table
- Creating a Multi Row Card
- Creating a Card

Filtering Data
- Slicers
- Filters
-  Visual Filters
- Page Filters & Report Filters

Visualisations
- Column Graphs
-  Stacked Bar Graphs
- Cross Filtering between Column & Bar graphs
-  Filtering & Highlighting

Graph Options

Trend Analysis - Time Intelligence

Additional Graph Types
- Combination Graph
-  Pie & Donut Graphs
- Treemap Graph
- Geographical Analysis
- ScatterPlots & BubblePlots

Creating an Interactive Dashboard
- Publishing the Dashboard
- Pinning Visuals to a Dashboard
- Q&A Feature
- Inviting other users
- Accessing a shared Dashboard
- Power BI on mobile

Enhancing Power BI - DAX Formulas
- DAX formula language
- Simple calculations in DAX
- Creating time intelligence functions
- Creating a date table

DAX Measures

Relationships
- Employee Master Challenge
- Creating Custom Visualisations
- Using the Related Function

Enhancing Your Power BI Data
- Aggregating Data into new Tables
- Working with Queries and Applied Steps
Duration
2 days
Requirements
Good understanding of Excel and the principals of operating Excel, preferably working with data on a regular basis, with knowledge of compiling reports.
Cost
R3 600 per person excluding VAT
Price is for training in Gauteng.
Price is for in-house training for 6 people or more.
Valid until 31 December 2017
ICP Training                                                                                                                                                                          Terms and Conditions
Tel: 082 940 0940
E-Mail: info@icptraining.co.za

MICT Seta Accreditation 2015/02/0005
​