DATA ANALYSIS VISUALIZING AND REPORTS CREATION WITH POWER BI

1 year ago Posted By : User Ref No: WURUR135390 0
  • Image
  • TypeTraining or Development Class
  • Image
  • Location Nairobi, Kenya
  • Price
  • Date 06-02-2023 - 10-02-2023
DATA ANALYSIS VISUALIZING AND REPORTS CREATION WITH POWER BI, Nairobi, Kenya
Training or Development Class Title
DATA ANALYSIS VISUALIZING AND REPORTS CREATION WITH POWER BI
Event Type
Training or Development Class
Training or Development Class Date
06-02-2023 to 10-02-2023
Location
Nairobi, Kenya
Organization Name / Organize By
FineResults Research
Organizing/Related Departments
FineResults Research Services Training Center
Organization Type
Organization
Training or Development ClassCategory
Both (Technical & Non Technical)
Training or Development ClassLevel
All (State/Province/Region, National & International)
Related Industries

Education/Teaching/Training/Development

Research/Science

Business Development

Administration/Management

Accounting/Financial/Banking/Insurance

Location
Nairobi, Kenya

FineResults Research Services would like to invite you to take part in our upcoming workshops on Research at our FineResults Research Services training facilities in Nairobi, Kenya or online.

DATA ANALYSIS VISUALIZING AND REPORTS CREATION WITH POWER BI

6th March 2023 to 10th March 2023

Introduction

Microsoft power BI, an analytics tool developed by Microsoft, collects unstructured data, processes, analyzes and produce reports. It consists of the Power BI Desktop, the SaaS Power BI Service, and a range of mobile apps (iOS and Android compatible). These tools help an organization to read the information, get a clear idea of what to do, and produce reports that help in making a real time decision.

Duration

5 Days

Who should attend?

Managers, business analysts, decision makers and anyone who need to analyze and visualize data using Microsoft Power BI.

Training objectives

Upon completion of this course participants will be able to:

· Use Power BI Desktop to produce reports,

· Learn how to connect to and query data from different sources using the Query Editor.

· Use the datasets built with Query Editor to create Reports and Visualizations or dashboards within Power BI Desktop.

· Create and share dashboards based on reports in Power BI desktop

· Learn how to collaborate on dashboards, and share insights both inside and outside their organization

· Understand Power BI Data Analysis Expression(DAX), and its functions

· Gain Knowledge on application of business intelligence tool in the real world problems and analysis

Course outline

Module 1: Introduction Miscrosoft Power BI tools

· Introduction to tools that are used to inform on business intelligence

· Components of Power BI

· Overview of Power BI use

· Self-service BI

· Setup and Configuration of Power BI

 

Module 2: Data management

· Connecting to Data Sources in Excel, Online sources and SQL

Data Transformation

· Rename fields & replacing data values in cells, rows

· Basic Table Transformations

· Changing data types & change order of columns

· Un-pivoting columns

· Grouping & Aggregating Data

· Modifying, Merging & Appending Queries

· Grouping and splitting column into multiple

· extract feature (before /after delimiter)

· Defining Hierarchies & Categories

· Adding new columns

· Filters and parameters

· View native queries vs unfold queries

· Connecting to Folders

 

Module 3: Modeling data

· Creating Table Relationships

· Table relationship (one to one, one to many, many to many)

· Connecting Multiple Data Tables

· Data Analysis Expression (DAX)

· Measures and calculated Columns

· Mastering DAX using quick measures

 

Module 4: Data Visualization

· Stacked bar chart and stacked column chart

· Clustered bar chart and clustered column chart

· Line chart & area chart

· Line and clustered column chart

· Line and stacked column chart

· Ribbon & waterfall chart

· Funnel & tree map visuals

· Pie-chart and doughnut chart

· Table chart and matrix chart

· Slicer, gauge, card visuals

· Map and filled map

· ArcGIS maps for Power BI

· KPI

· Q & A visual

· Fine tune your visualization using parameters and slicers

· Deciding on when to use a particular visual

Module 5: Producing reports

· Intro to the Power BI Report View

· Matrix Visuals

· Cards & KPIs

· Map Visuals (Basic, Fill, ArcGIS)

· Treemaps, Lines, Areas & Gauges

· Editing Report interactions

· Adding Drillthrough Filters

· Linking to Report Bookmarks

· Using “What-If” Parameters

· Managing & Viewing Roles

· PREVIEW: Publishing to Power BI Service

Building and Sharing a Dashboard

· Workspace

· Datasets

Reports

Create Dashboard

Modify and update Dashboard

Share your Dashboard

Data Security in Power BI

Configuring row level security

Setting up user roles

Configuring Data Refresh

Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)

Understand & configure data management gateways

Configuring & scheduling data refresh

Power BI for Mobile

Configuring Power BI for Mobile

Visualize dashboards and report on Power BI Mobile

Commenting on eports and dashboards in Power BI Mobile

Excel Power BI

Power Query and Power Pivot on Excel

Visualize and Edit Power BI reports using excel analyzer

Building reports on Excel and Publishing to Power BI service

TRAINING CUSTOMIZATION

This training can also be customized for your institution upon request. You can also have it delivered your preferred location.

For further inquiries, please contact us through Mobile: (+254 759 285 295) or Email: [email protected] 

REQUIREMENTS

Participants should be reasonably proficient in English.  During the trainings, participants should come with their own laptops.

TRAINING FEE

Cost:

In-person USD 900

Payment should be transferred to FineResults Research Services bank account one week prior to the training date and proof of payment sent to [email protected]

For any registration of 3 or more participants; we offer a discount of up to 10%.

This course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits for in-person training.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through Mobile: (+254 759 285 295) or Email: [email protected] 

PAYMENT

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: [email protected] 

CANCELLATION POLICY

  • All requests for cancellations must be received in writing.
  • Changes will become effective on the date of written confirmation being received.

Visit our website for more details

View Other Research Courses

Registration Fees
Available
Registration Fees Details
USD 900
Registration Ways
Email
Phone
Website
Other
Address/Venue
FineResults Research Services Training Center  FAHARI PALACE HOTEL AND SERVICED APARTMENTS 
Landmark
Church Rd.
Official Email ID
Contact
Edith Wairimu

[email protected]

   +254 759 285 295