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.
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 |