Data Analysis using Microsoft Power BI

Data Analysis using Microsoft Power BI

Duration:
2 Days
Aims:

The main purpose of this course is to give delegates a good understanding of data analysis using Microsoft Power BI. The course includes creating visualisations using Power BI Desktop, Power BI Service and building reports for the Power BI Mobile App.

Objectives:
  • Perform Power BI Desktop data imports and various transformations.
  • Create a Power BI Desktop visualisation.
  • Publish reports to the Power BI Service.
  • Connect to an Excel file and an Odata feed.
  • Collaborate with colleagues using the Power BI Service.
  • Understand the difference between Power BI Reports and Power BI Dashboards.
  • Understand how to use Workspaces in the Power BI Service.
  • How to configure RLS (row level security) to restrict users from accessing data that’s outside their authorised levels.
  • Use natural language queries.
  • Create real-time dashboards.
  • Start using some of the most common DAX functions to create Measures and Calculated Columns.
Pre-Requistites
  • An understanding of relational databases and reporting.
  • Some experience of using functions like those used in Excel.
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
What will I learn?
Module One
  • - An introduction and the history of data analytics.
  • - Learn the difference between IT lead BI and Self-service BI.
  • - Review Microsoft’s tools for Self-service BI.
  • - What is Power BI and who is it aimed at.
  • - Understand the advantages of Self-service BI over traditional IT lead BI.
Module Two
  • - Become familiar with navigating around Power BI Desktop and understand the difference between ‘design mode’ and ‘query mode’.
  • - Learn how to connect to Excel and import data into Power BI Desktop and perform various transformations on the data.
  • - Learn how to connect to an Odata feed and import data into Power BI Desktop and perform various transformations on the data.
  • - Learn the basic principles of data modelling and relationships.
  • - Build a data model using data imported from an Excel file and an Odata feed.
  • - Learn the difference between ‘data types’ and ‘data formats’ and apply the correct ‘data types’ to the imported data.
  • - Learn about Power BI ‘data categories’ and default methods of aggregation.
  • - Learn about the basics of ‘data compression’ and understand the importance of removing unwanted columns from the data model.
  • - Learn about the various methods of filtering data in Power BI Desktop.
Module Three
  • - Understand the difference between a Measure and a Calculated Column and when to use them.
  • - Learn some best practices when creating Measures and Calculated Columns.
  • - Create various Measures using some of the most common DAX functions to manipulate the data model.
  • - Create several Calculated Columns to extend tables in the Data Model.
  • - Learn the difference between ‘Filter Context’ and ‘Row Context’.
  • - Understand why totals sometimes return incorrect values and how to correct them.
Module Four
  • - Learn how to create various charts and tables using Measures and Calculated Columns.
  • - Learn about the default range of Power BI charts and tables available in the ‘Visualisations library’.
  • - Learn about choosing the right type of visualisation, ensuring it matches the information that’s been generated – for example, is the output information based over time or a percentage of a whole?
  • - Learn about the ‘Field Well’ in Power BI Desktop and how to manage tables and fields as the data model grows.
  • - Experiment with searching the data model for fields and how and when to hide tables and fields.
  • - Moving Measures that are residing in the incorrect table.
  • - Learn about the difference between a ‘standard table’ and a ‘matrix table’ and how to use drill-down as a method of seeing data at a more granular level.
  • - Learn how to use the various methods of conditional formatting in Power BI Desktop.
  • - Use the Power BI Desktop mobile app design tools to build a mobile ready report.
  • - Leverage custom visuals and how to access them.
Module Five
  • - How to publish reports from Power BI Desktop to the Power BI Service and how to use Workspaces.
  • - Understand the difference between Power BI Desktop and the Power BI Service and when to use them.
  • - Learn about the purpose of Workspaces in Power BI Service and how to create them.
  • - Learn the difference between Power BI Reports and Power BI Dashboards.
  • - Build a dashboard based on reports in the Service.
  • - Learn about Live Dashboards and how to build them.
  • - Learn how to share reports / dashboards once published to the Service.
  • - Learn how to navigate in the Service to locate: dashboards, reports, workbooks and data sets.
  • - Learn about the purpose of ‘Apps’ in the Service and how to create one.
  • - Review the Admin portal and the Settings for the Service.
  • - Learn about the two types of Gateways and why they’re needed.
  • - Learn how to establish a refresh schedule.

Note: We will work with you to select appropriate topics from Module 6 as it isn’t possible to cover all of these within the 2-day programme. If a one-day course is required, then the content will be modified to suit your key requirements.

Module Six – (Optional / Time Permitting)
  • - Bookmarks, selection pane and buttons.
  • - Advanced tool tips.
  • - Learn about parameters and when to use them.
  • - Ask questions of your data.
  • - Report drill-through.
  • - Columns from Examples.
  • - Quick Measures.
  • - Synchronising Slicers.
  • - Q&A Explorer.
 
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot