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

Overview




 

Introduction

Power BI lets you create reports and dashboards that are visually appealing and understandable. In this course, you’ll learn to create insightful visualisations through built-in and customised charts and conditional formatting. A business can reach new heights by using the Power BI tool.

Power BI provides the ability to collaborate and share customised dashboards and interactive reports across colleagues and organisations, easily and securely. Power BI can be used for any department of a company, any size of company for data visualisation and gaining meaningful insight out of it in an interactive and understandable format. 

With the use of power BI, students can prepare and model data, create visualisation as well as do advanced data analysis. There are little to no prerequisites for using power BI and as anyone with some experience in using Microsoft office will be able to quickly pick up the skills required for power BI. Power BI is also compatible with multiple sources including excel, SQL and cloud-based data repositories which makes it an excellent choice for data scientist and analyst.

Benefits of Power BI

  • Power BI helps businesses to make data-driven decisions by way of interactive dashboards and Business Intelligence reports.
  • Making things visually appealing and the access of Drag and Drop features.
  •  Allows Analysis and Sharing of Big Data
  • Personalised Dashboards and Interactive Reports

Job opportunities for Power BI 

  • Data Analyst
  • Business Intelligence (BI) Analyst
  • Business Intelligence (BI) Developer
  • Software Engineer

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

  • Get Power BI Desktop
  • Getting started with Power BI Desktop
  • Data Sources in Power BI Desktop
  • Import Excel Workbooks
  • Data Type in Power BI Desktop
  • Explore Pivot Feature
  • Data Transformation
  • Unpivot feature in Power BI
  • Transforming Data (M Query Basics)
  • Advance Data Transformation
  • Introduction to Modeling Data
  • Data Mappping (Relationship between tables)
  • One to One
  • One to Many
  • Many to Many
  • Basics DAX
  • Creating Calculated Columns
  • Navigation Functions
  • Conditional and Logical Functions
  • Calculated tables
  • Working with Variables
  • Working with Filter Context (What is Filter Context?)
  • Creating Calculated Measures (Measure Basics)
  • Introduction to Visualization in Power BI Desktop
  • Branding (Size, Header, Spacing, Footer)
  • Introduction to Visualization in Power BI Desktop
  • Branding (Size, Header, Spacing, Footer)
  • Insert Image, Shape, Text Box
  • Creating Basic Reports with the Power BI Desktop
  • Start Data Visualization
  • 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
  • Dashboard Size
  • Layout
  • Spacing
  • Color Standards
  • Using the Power BI Service (Deploying to the Power BI Service)
  • Using the Power BI Service (Creating and Sharing Dashboards)
  • Using the Power BI Service (Setting up App Workspaces)
  • Using the Power BI Service (Subscriptions and Alerts)
  • Using the Power BI Service (Export and Embed Options)
  • Refreshing the Data (Refreshing Data Overview)
  • Refreshing the Data (Installing the Data Gateway)
  • Refreshing the Data (Scheduling a Data Refresh)

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.

Subash Manandhar

Software Engineer

Hello, It's me Subash Manandhar graduated as Computer Engineer from KEC Kalimati, Kathmandu. I am currently working as Software Engineer at Cotiviti Nepal Pvt. Ltd .

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Course Duration16 hrs
  • Course CostRs. 10,000