Cobalt Analytics Logo

The absolute beginners guide to power BI

This one day course has been designed for users who have never worked with Power BI and would like to create simple reports, attendees will learn how to create and publish their own reports allowing from a truly self-service experience.


Details

  • Duration : 1 Day
  • Experience : None
  • Requirements : Laptop with Power BI installed

# Power BI can be installed from here

Agenda

  • About Power BI
    • Understanding the power BI Ecosystem
    • Understanding the Power BI licensing model
    • Building your first report
  • Connecting to data
    • Connecting to multiple data sources
    • Cleansing and transforming data
  • Modelling your data and building calculations using simple DAX
    • Principals behind building a star schema
    • Creating Calculated columns, tables and measures
    • Introduction to time intelligence
    • Using Relationships
  • Building Interactive reports
    • Principals behind power BI visualisation
    • Cross filtering for interactive reports
  • Publishing your report to the power BI service
    • Creating a Power BI App workspace
    • Creating dashboards
    • Sharing reports with colleagues
    • Setting up the Power BI gateway
    • Scheduling report refreshes

Register for our next course:

Power BI 3-day Workshop

This 3-day course will take you through the full Power BI report creation life-cycle beginning with connecting to data, shaping data such that it is easy to report off, creating beautiful interactive reports, finally publish the report to the Power BI service and sharing them with our team and organization.


Details

  • Duration : 3 Days
  • Experience : Basic understanding of report
  • Requirements : Laptop with Power BI installed

# Power BI can be installed from here

Agenda

  • Module 1: Introduction to Power BI
    • What is Business Intelligence?
    • Power BI components
    • Creating your first report
  • Module 2: Importing Data
    • Connecting to data sources
    • Cleansing and transforming data
  • Module 3: Modelling your data
    • Introduction to star schema
    • Getting started with intermediate DAX
    • Creating calculated columns and measures
  • Module 4: Visualizing data
    • Creating reports using visuals and interactive filtering
    • Using custom visuals
    • Customizing the report look and feel
  • Module 5: Publishing you report
    • Publishing and sharing reports
    • Managing report access with Workspaces and APPS
    • Refreshing data

Register for our next course: