Skip Main Navigation
Eventbrite
Browse Events
Organize
  • Why Eventbrite?
  • Pricing
  • Resources
Help
  • Find your tickets
  • Contact an event organizer
  • Visit the help center
Create an event
Menu
  • Organize
  • Help
  • Create an event
  • Log in
  • Sign up
  • Help
  • Create an event
  • Log in
  • Sign up
Log in Sign up
Page Content
Power BI Training-Data Analysis & Business Intelligence Using Power BI

Jun

23

Power BI Training-Data Analysis & Business Intelligence Using Power BI

by UrBizEdge

Actions and Detail Panel

Sales Ended

Date and time

Thu, Jun 23, 2022, 9:00 AM –

Sat, Jun 25, 2022, 5:00 PM WAT

Location

URBIZEDGE LIMITED

70b, Olorunlogbon Street

Anthony, Lagos 100001

Nigeria

View map

Data Analysis & Business Intelligence Using Power BI

About this event

Data is the new crude oil. And business success in the 21st century is heavily reliant on the ability to mine and use relevant data about consumers, internal operations, financial operation and industry trend to drive business decisions.

UrBizEdge Limited, Nigeria’s leading business data analysis company is putting together this special training for proactive business professionals who already have some experience with business reporting and quantitative data analysis.

We will be focusing on Business Intelligence and how to create BI reports that leverage participant’s current data analysis skills using Microsoft’s Power BI. Power BI enables organizations to have a wholesome understanding of what is happening at all operational levels of the company.

It covers our industry-recognized certificate, practice materials, required software, tea break + lunch and other training materials.

The training will be facilitated by an officially awarded Microsoft Most Valuable Professional (MVP) who has also published a best-selling book on Power BI (https://www.amazon.com/dp/B078NF5XYP). And we have had participants of our training from Chevron, Global Accelerex, Unilever, Promasidor, Citi Bank, Dalberg, SaveTheChildren, Mobil, Total, Vodacom, Nestle, Guinness Nigeria, Nigerian Breweries, Delta Afrik, LATC Marine, Broll, Habanera (JTI), SABMiller, IBM, Airtel, Diamond Bank, ECOWAS, Ministry of Finance, Palladium Group, Nokia Siemens Networks and DDB.

Time: 9:00am – 5:00pm each day

Cost: N120,000

The cost covers your training materials, after training support, weekly/monthly practice projects/tasks, practice materials, certificate and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.

Payment Details

Account Name: URBIZEDGE LIMITED

Bank: FCMB

Account No: 2888666014

Branch: Onipanu

The training will cover:

Introduction to Power BI and self-service Business Intelligence

• Power BI’s strength and weakness compared to the other popular BI tools

• Important concepts of Power BI

• Power BI Architecture

• Power BI Service

• Power BI Desktop

• Power BI Mobile

• Power BI Data Gateway

Get Data (bringing in your data for analysis)

• Data Sources in Power BI Desktop

• Connect to web data and web apps

• Import Excel Workbooks

• Connect to enterprise Databases

• Connect to enterprise applications

• The rule of no intermediary for best benefits

Data Transformation, Power Query and DAX

• Get Data - Knowing whether to Load or Edit

• Model section of the report builder (Power BI Desktop)

o Creating Relationships

o Cardinality

o Direction

• Data section of the report builder (Power BI Desktop)

o Data Type

o Data Format

o DAX

 New Column

 New Measure

 New Table

 Must know DAX formulas

 DAX formula reference guide

o Row level Security

• Report section of the report builder (Power BI Desktop)

o Report creation

o Native Visuals

o Custom Visuals

o Menu Tools for professional looking reports

o Edit Interactions

o Report creation from scratch

• Power Query

o Transforming and Combining Data pre-loading to Model

o Common Power Query tasks

 Unpivot

 Split Column

 Append Tables

 Merge Tables

 Remove rows

 Use first row as header

 Parameters

 Add Columns

 Group By

 Extract

 Fill

 Transpose

 Advanced Query for M code editing

 Blank Query (M code writing)

• Understanding when to use Power Query or M code and when to use DAX

• Sample Projects

Report Publishing, Dashboards and Power BI Service

• Understanding the concept of Workspaces

• Publishing report (from Power BI desktop to Power BI service for consumption)

• Controlling access to aspects of the report by role (region, department or level)

• Published Report options

o Exporting to PowerPoint or PDF

o Embedding in SharePoint

o Embedding in a website

o Making it available via a web link

o Sharing with specific users

o Editing the report – adding new visuals, changing visuals used and creating new report pages

o Adding comments and tagging users

o Scheduling the report to send our daily or weekly to specific people

• Creating a Dashboard

o Can be created from one or more reports to show management useful analysis

o Can incorporate data and visuals from other people’s dashboards or reports shared with you

o Add Tile or Streaming data (APIs)

o Set Alerts to be instantly notified when a KPI is reached or an SLA is breached

o Add actionable comments

o Schedule the dashboard to be sent out daily or weekly to specific people

o Share the dashboard with final users

• Best practices

• Setting automatic/scheduled refresh so new data is ingested automatically

• Data Gateway configuration

o The type of data sources that require data gateway

AI in Power BI and Apps

• Q&A for autogenerating charts and tables in answer to questions

• Quick Insights for autogenerating reports from datasets

• Creating Apps

• Installing Apps to hasten report creation and prototypes or connect to non-native data source

• Integrating with Python and R

Lots of hands-on practice/projects from day 1 to day 2 and after training weekly/monthly tasks/projects to help internalize skills acquired.

Don’t forget to register early!--

Power BI Training-Data Analysis & Business Intelligence Using Power BI image
event ended

Power BI Training-Data Analysis & Business Intelligence Using Power BI

View Details
View Details

Follow this organizer to stay informed on future events

Organizer Image

UrBizEdge

Event creator

Events you might like:

Power BI Training-Data Analysis & Business Intelligence Using Power BI tickets
Free
Thu, Jul 21 9:00 AM
Power BI Training-Data Analysis & Business Intelligence Using Power BI
URBIZEDGE LIMITED, Anthony
#Business #Class
Power BI Training-Data Analysis & Business Intelligence Using Power BI tickets
Free
Thu, Sep 1 9:00 AM
Power BI Training-Data Analysis & Business Intelligence Using Power BI
URBIZEDGE LIMITED, Anthony
#Business #Class
Power BI Training-Data Analysis & Business Intelligence Using Power BI tickets
Free
Thu, Oct 13 9:00 AM
Power BI Training-Data Analysis & Business Intelligence Using Power BI
URBIZEDGE LIMITED, Anthony
#Business #Class
Power BI Training-Data Analysis & Business Intelligence Using Power BI tickets
Free
Thu, Nov 24 9:00 AM
Power BI Training-Data Analysis & Business Intelligence Using Power BI
URBIZEDGE LIMITED, Anthony
#Business #Class
Big Data Analysis, Power Query, Power Pivot and VBA in Excel tickets
Free
Fri, Sep 23 9:00 AM
Big Data Analysis, Power Query, Power Pivot and VBA in Excel
URBIZEDGE LIMITED, Anthony
#Business #Class
Big Data Analysis, Power Query, Power Pivot and VBA in Excel tickets
Free
Fri, Aug 5 9:00 AM
Big Data Analysis, Power Query, Power Pivot and VBA in Excel
URBIZEDGE LIMITED, Anthony
#Business #Class
Big Data Analysis, Power Query, Power Pivot and VBA in Excel tickets
Free
Fri, Aug 12 9:00 AM
Big Data Analysis, Power Query, Power Pivot and VBA in Excel
URBIZEDGE LIMITED, Anthony
#Business #Class
In-depth Excel Training, Executive Dashboards & Business Data Analysis tickets
Free
Fri, Dec 2 9:00 AM
In-depth Excel Training, Executive Dashboards & Business Data Analysis
URBIZEDGE LIMITED, Anthony
#Business #Class

Site Navigation

Use Eventbrite

  • How it Works
  • Pricing
  • Event Blog

Plan Events

  • Online Registration
  • Sell Event Tickets
  • Event Management Software

Find Events

  • Browse Ojo Events
  • Get the Eventbrite App

Connect With Us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite

© 2022 Eventbrite