Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Power BI Essentials

By: Habanero Data Solutions - Business Intelligence Training

Lagos State, Nigeria

01 - 02 Feb, 2017  2 day

Follow Event

  

NGN 150,000

This 2 day course will give delegates a thorough introduction with practical exercises to using the Microsoft Power BI. This hand on course is ideal for beginners.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Syllabus:

Day 1
Getting started with Microsoft Power BI

  • What is Power BI
  • Understanding BI
  • Understanding Microsoft Power BI

Power BI Designer

  • Basic concepts of Power BI
  • Using Microsoft Power BI to get data
  • Types of Microsoft Power BI Datasources
  • Connecting to Data Sources
  • Merging Queries

Power BI Reports

  • Creating Power BI Reports
  • Saving a Power BI Report
  • Uploading Power BI Designer files
  • Difference between Report and Dashboards

Refreshing Data in Power BI

  • Data sources that support refresh in Power BI
  • Setting up a refresh schedule

Power BI features in Tablets and Mobile

  • Accessing your report and dashboards from Mobile

Data Alerts

  • Setting up Data driven alerts
  • Using Annotations

Day 2
Transforming and shape your Data

  • Query Overview in Power BI Designer
  • Shape and Combine Data in Power BI Designer
  • Common Query Tasks in Power BI
  • Using Variables under Queries
  • Error Handing in Queries

Data Modelling within Power BI

  • Create and manage relationships in Power BI Designer
  • Calculated Columns in Power BI Designer
  • Measures in Power BI Designer
  • Data Types in Power BI
  • Sort by Columns in Power BI Designer

Visualisation types in Power BI

  • Creating a column chart
  • Creating Bar, Line and Pie Charts
  • Creating a scatter chart

Power BI Dashboards

  • Creating a dashboard
  • Sharing a dashboard

Working with Natural Language using Q and A

  • How to ask questions in Power BI Q and A
  • Preparing a workbook for Q and A

Size limit in Power BI

  • Limitation of the free Power BI subscription
Lekki, Lagos Course Schedule: 2 Days, 16 Academic Hours Feb 01 - 02 Feb, 2017
NGN 150,000.00
(Convert Currency)

07035368449

Microsoft Power BI trainer with real world experinece