Categories

Our Workshops

Microsoft Power BI

Microsoft Office Suite

Description

Struggling with complex Excel reports which contain hundreds of formulas?

This training is designed for analysts or organizational teams who need to derive and

share insights with business data.

We’ll show you how, without data analysis training or the need to learn another

language, you can be build and share reports and dashboards.

Learn how Power BI enables anyone to visualize and analyze data, with better speed and efficiency. It is a powerful as well as a flexible tool for connecting with and analyzing a wide variety of data.

This Course Focuses On;

Enabling users to interact with corporate information, to extract the reports and information they need as well as how to create compelling visualizations and reports that provide deep insights into your data.

Who should attend this course?

Anyone who wants to become familiar with Microsoft’s Power BI product, whether you are a beginner, intermediate or advanced user.

DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. DAX helps you create new information from data already in your model.

Why is DAX so important?

It’s quite easy to create a new Power BI Desktop file and import some data into it. You can even create reports that show valuable insights without using any DAX formulas at all. But, what if you need to analyze growth percentage across product categories and for different date ranges? Or, you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well.

Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is the power in Power BI, and DAX will help you get there.

Workshop Outline

  • What is Power BI?
  • The parts of Power BI
  • Getting Data
    1. Connecting to a data source
    2. Edit Data before loading
    3. Editing Data in the Power Editor Query window
  • Advanced data sources and data transformation
    1. Connect to an additional data source
    2. Remove additional columns and combine data
    3. Advanced data transformations
    4. Combine data from different sources
    5. Creating Custom Columns
    6. Cleaning irregularly formatted data
    7. Transpose Data
  • The Power BI Desktop
    1. Select a View
    2. Collapse/Expand the Visualizations and Fields pane
  • Create Visualizations
    1. Add Fields
    2. Remove Fields
    3. Resize a Visualization
    4. Move a Visualization
    5. Convert between Visualizations
    6. Accessing tooltips
    7. Formatting Visualizations
  • Modelling Data
    1. Managing Relationships
    2. Autodetect during load
    3. Create a relationship by using Autodetect
    4. Create a relationship manually
    5. Edit a relationship
    6. Create Calculated Columns
  • Optimising Data models
    1. Hiding fields
    2. Unhide Fields
    3. Sorting visualization data by another field
    4. Formatting fields
    5. Change method of aggregation
    6. Quick Calculate
    7. Quick Measures
  • Creating Calculated Measures
    1. DAX Syntax
    2. Create a Measure
    3. Create Calculated Tables
    4. The Distinct Function
    5. Exploring Time based Data
    6. Drill-Down into data
    7. Drill-Up out of data
  • Visualizations
    1. Combination Charts
    2. Slicers
    3. Maps
    4. Matrixes and Tables
    5. Scatter charts
    6. Waterfall and Funnel Charts
    7. Gauges and single-number charts
    8. Cards
    9. Formatting Charts and Visuals
    10. Adding Shapes, Images and Textboxes
    11. Page Layouts and Orientation
    12. Group interactions
    13. Duplicate a report page
    14. Adding Summaries
    15. Create Hierarchies
  • Introduction to the Power BI Service
    1. Create an account
    2. Uploading Data into the Power BI service
    3. Publish data
    4. Share dashboards
    5. Create Power BI Apps
    6. Collaborating in App Workspace
  • Working with Power BI Mobile App
  • Practical
  • Consolidated Exercise including what was learnt

________________________________________________________________________________________________________________________________________________________________

On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material

________________________________________________________________________________________________________________________________________________________________

Workshop Dates