• logo
  • 9861600203
  • 5555545
  • info@mentorit.com.np
header-logo.png

Overview

The following shows what power BI is especially valuable for:

  • Better business decision making
  • Enlightened business planning
  • Improved data quality
  • Better-quality business transparency
  • Monitoring process performance
  • Optimising processes
  • Improving cross department working
  • Improving customer interactions
  • Improving customer satisfaction and loyalty
  • Reducing risks and improving compliance
  • Gaining competitive advantage
  • Coping with growing data sets

While Power BI can perform a multitude of intelligence-related business tasks, how you use it depends on your particular needs. Maybe you wish to focus on one aspect of your business such as customer relationships? Or perhaps improve production processes?

An experienced Power BI consultant can help you achieve your objectives through effective use of this powerful platform.

Course Content

  • Installing Power BI Desktop
  • Exploring the Power BI Desktop Interface
  • Examining Data Sources
  • Discussing Data Refresh
  • Understanding Data Types
  • Importing, Transforming, and Loading Data from offline and online file
  • Appending Operations
  • Working with Folders and Files
  • Using Pivot Tables
  • Importing data from database (Access, Mysql, Oracle, Sql Server)
  • Working with Relational Data
  • Understanding Relationships
  • Relationships
  • Understanding the Issues with Merges
  • Performing Merges
  • Grouping Options
  • Summarizing
  • Calculating
  • Basic functions that we use in excel
  • SUM ()
  • SUMX ()
  • AVERAGE ()
  • AVERAGEX()
  • MIN ()
  • MAX()
  • CALCULATE ()
  • Filter ()
  • ALL
  • MINX () / MAXX ()
  • Creating Reports
  • Bar Chart
  • Column Chart
  • Line Chart
  • Area Chart
  • Ribbon Chart
  • Pie Chart
  • Combo Chart
  • Bubble Chart
  • Scatter Chart
  • Donut Chart
  • Gauge Chart
  • Funnel Chart
  • Waterfall Chart
  • Single Number Chart
  • Multi row Chart
  • KPI Chart
  • Table Chart
  • Matrix Chart
  • Map
  • Filled Map
  • Tree Map
  • Slicer
  • Image
  • Introduction to Power BI Online
  • Importing Data
  • Creating Reports
  • Configuring Dashboards
  • Sharing Reports and Dashboards
  • Exploring Power BI Mobile

About the instructor

DIPU MAHARJAN

BI Solution Architect

Hi I am Dipu Maharjan. I am working as BI Solution Architect. I have experience more than 10 years as Data Analyst, Database Programmer, Developer and Trainer.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Course Duration20 hrs
  • Course CostRs. 14,000