Training Date 17 Jul - 20 Jul, 2025
Training Mode Physical
Venue Maarifa Consult office
Apply Now

Microsoft Power BI is a powerful analytics tool that helps both non and profit organisations of all sizes analyze data and share insights. With this technology, enterprises can monitor their business more closely and get instant answers with rich dashboards available for every device. Power BI is data/business analytic solution, which is used to analyze data from a wide range of data sources. It is simple to use as well as user-friendly. The insights obtained can be shared across an organization and can be rooted in the organization’s app or website. With Power BI, you can create as well as productive with the reports and analytics.  With Power BI, you can mash up data as per your need as it has a very powerful mashup engine.  With In-Memory super fast engine in Power BI, you can model the data, add measured or calculated columns or build a star schema on your own. With the help of data visualization elements, visualize data and customize it to tell a story behind the data. Furthermore, Power BI is a suite of interactive data visualisation tools that deliver insights throughout your organisation. You can use Power BI to connect to hundreds of data sources, simplify data preparation, and drive ad hoc analysis. Power BI produces beautiful reports, then publish them for your organisation to consume on the web and across mobile devices.

Who Should Attend?

This Power BI training is intended for beginners to intermediate and it is crucial for analysts, managers, reporting professionals, business owners, executives, and anyone who need to derive and share insights with business data. This training is highly recommended for: Directors, General Managers, Finance Managers, Business Analysts, Sales Managers, HR Managers, Data Analytics Manager, Business Owners, Researchers,M&E specialists among others.

Certification

Upon successful completion of this training, participants will be issued with a certificate of completion.

objectives

By the end of the Power BI course, participants will:

  1. Clean and transform data, model it and build KPIs and metrics that answer specific business questions
  2. Use DAX effectively to build time intelligence reports, slice reports by measures and filter according to context
  3. Access data from supported on-premises and cloud-based sources with automated, incremental refreshes
  4. Combining multiple data sources into one dataset
  5. Perform forecasting
  6. Apply security rules and share content
  7. Create stunning reports with interactive data visualisations
  8. Perform analytics and find patterns with Power BI features like quick measures, grouping, forecasting and clustering.

Outline

  • Working with an Excel Workbook
      • Understanding your data
      • Creating Tables of data to put into the Power BI service
      • Where your workbook file is saved makes a difference
      • Uploading your Workbook data into Power BI
      • Importing your Workbook data into Power BI
  • Working with the Power BI service
      • The User Interface My Workspace
      • Menus
      • The Fields Pane Field Icons
      • Visualisations Pane
  • Visualisations
      • Overview of Visualisations
      • Creating and working with Visualisations
      • Creating a Bar Chart Visualisation
      • Creating a Column Chart Visualisation
      • Creating a Line Chart Visualisation
      • Some basic formatting of Visualisations
      • Consistency of Style Focus Mode
      • Creating a Card Visualisation
      • Giving Cards some impact
      • Creating a Table Visualisation
      • Creating a Matrix Visualisation
  • Working with Formats in a Visualisation
      • Axes
      • Data Labels
      • Titles Sizing & Alignment
      • Data Colours,
      • Backgrounds and Borders
  • From Visualisations to Reports
      • Saving a Report
      • Adding Pages to your Reports
      • Renaming Pages
      • Re-using Visualisations
      • Building a Narrative in your report
      • Editing & Reading Modes
      • Pie Chart Visualisations
      • Text Boxes
      • Shapes
  • Using Visual Interactions
      • Introducing Visual Interaction
      • Turning Interaction On or Off
      • Interacting by Filtering,
      • Highlighting or None
  • Working with Filters
      • Creating a Slicer
      • Filtering in the Visualisation pane
      • Creating a Visual Field filter
      • Creating a Top N Filter
      • Adding a page level Filter
      • Creating pages from page level filters
      •  Add a report level Filter
  • Working with Reports
      • Printing your Reports
      • Exporting to PowerPoint
      • Using a Power BI created
      • PowerPoint file
      • Publishing to the Web – embed codes
      • Interacting with a Power BI created web page Generating a QR code
      • Pasting and scanning a QR code
      • Possible uses for a QR code versus a web-link
  • Working with Dashboards
      • Adding Visualisations to your dashboard
      • Adding Visualisations from multiple reports
      • Pinning a Live Page
      • Web Content tiles
      • Text box Tiles
      • Video tiles
      • Generating Alerts from Cards and KPIs
      • Renaming Dashboards
      • Favourite Dashboards
      • Featured Dashboard
      • Printing Dashboards
      • Generating Alerts from Cards and KPIs

Approach

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies. Training manuals and additional reference materials are provided to the participants.

Tailor-Made

We can also do this as a tailor-made course to meet organization-wide needs. Contact us to find out more: training@maarifaconsult.com / and cc    maarifaconsult@gmail.com

OR Call us on +256774361213

Fees & Payment

Fees Ugandans: UGX500000 International: USD199

The training fee covers tuition fees, learning materials, Lunch & Breakfast. Payment should be sent to our bank account before start of training and proof of payment sent to training@maarifaconsult.com /or maarifaconsult@gmail.com

 

Bank Account can be Requested.