Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Power BI for Excel Users Training

By: McTimothy Associates Consulting LLC  

Nasarawa State, Nigeria

10 - 12 May, 2022  3 days

Follow Event

  

NGN 125,000

Venue: The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos.

Other Dates

Venue Date Fee  
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 24 - 26 Aug, 2022 NGN125000
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 01 - 03 Dec, 2022 NGN125000

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.

Targeted Audience

The course is individuals who are not IT professionals but need to easily create and publish reports with Power BI.

Prerequisites

Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus but is not required.

Course Outline

  • Getting started
  • Introducing Power BI
  • Using Power BI
  • A quick look at Power BI Desktop
  • A quick look at the Power BI service

Power BI and Excel

  • Introduction to using Excel data in Power BI
  • Upload Excel data to Power BI
  • Import Power View and Power Pivot to Power BI

Getting Data

  • Overview of Power BI Desktop
  • Getting started with Power BI Desktop
  • Connect to data sources in Power BI Desktop
  • More advanced data sources and transformation

Shaping and Transforming Data

  • Introduction to the Query Editor
  • Clean and transform your data with the Query Editor
  • Cleaning irregularly formatted data

Modelling

  • Introduction to modelling your data
  • How to manage your data relationships
  • Create calculated columns
  • Optimizing data models
  • Create calculated measures
  • Create calculated tables
  • Explore your time-based data
  • Introduction to DAX
  • DAX calculation types
  • DAX functions

Visualizations

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Modify colours in charts and visuals
  • Shapes, text boxes, and images
  • Page layout and formatting
  • Group interactions among visualizations
  • Visual hierarchies and drill-down
  • Using custom visualizations
  • R integration in Power BI Desktop

Publishing and Sharing

  • Introduction to the Power BI service
  • Quick insights in Power BI
  • Create and configure a dashboard
  • Ask questions of your data with natural language
  • Create custom Q and A suggestions
  • Share dashboards with your organization
  • Install and configure a personal gateway
  • Introduction to content packs, security, and groups
  • Publish Power BI Desktop reports
  • Print and export dashboards and reports
  • Manually republish and refresh your data
  • Create groups in Power BI
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos. May 10 - 12 May, 2022
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 24 - 26 Aug, 2022
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 01 - 03 Dec, 2022
NGN 125,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants

Related Courses

Tableau Data Visualizations Course Tableau Data Visualizations Course

3 days, 14 - 16 Apr, 2022 

2022-04-14 12:04:00 2022-04-14 12:04:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

This two-day Tableau Data Analytics class provides techniques for going beyond spreadsheets and tables mechanics and helps you design a visual that really makes an impact and are easy to understand. ...

Training on Business Management Skills for Warehouse Supervisors Training on Business Management Skills for Warehouse Supervisors

3 days, 24 - 26 Feb, 2022 

2022-02-24 12:02:00 2022-02-24 12:02:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Warehousing operations are at the heart of the supply chain of any organization. The ability to secure the storage and flow of supplies with an eye on balancing costs with desired service levels ...

Succession Planning and Mentoring Workshop for Managers Succession Planning and Mentoring Workshop for Managers

2 day, 25 - 26 Feb, 2022 

2022-02-25 12:02:00 2022-02-25 12:02:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

60% of organizations have no process for succession planning. This interactive course will enable you to consider the latest methodologies and strategies related to successful engagement, career ...

IOSH Managing Safely IOSH Managing Safely

3 days, 13 - 15 Apr, 2022 

2022-04-13 12:04:00 2022-04-13 12:04:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

IOSH Managing Safely is an ideal course for any individual in a supervisory or management position to understand why and how to manage safety within their organization effectively. IOSH Managing ...