• logo
  • 9762422336
  • 9861600203
  • 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 Benefits of Using Power BI

  • Centralising your data – Power BI offers unparalleled insight into your business via easy-to-use BI dashboards. Even if you have disparate systems, you’ll still be able to aggregate this data into one location.
  • Better decision making – Having all your data in one place on BI dashboards will help you to make better decisions such as, for example, having a real-time view of current sales and your sales pipeline. Marketing and sales statistics can all be fed into Power BI, equipping you with the information you need to make strategic and intelligent decisions.
  • Anywhere, anyplace access – You can take Power BI anywhere on your tablet or laptop. You’ll be able to export insights gleaned easily with a touch of a button.
  • Low cost – Power BI is available on a monthly subscription at various price points to suit your needs and budget compared to other solutions available in the marketplace.
  • Meaningful future planning– Thanks to technologies such as machine learning capabilities, which are included in Power BI premium licenses and allow you to connect it to your Microsoft Azure machine learning models, it can help base future planning on more solid intelligence as opposed to vague crystal ball gazing.
  • Data handling capacity– The increasing amounts of data gathering means less comprehensive platforms cannot easily process it: Power BI provides high data processing capabilities to meet the challenges of increased data capture.

With Power BI, Microsoft has brought data warehouse technologies into desk-based applications, thus providing businesses an affordable and – thorough initial setup help and training from an experienced BI consultant – a ‘hands-on’ way for you to grow your Business Intelligence.

 

Course Content

  • Download latest Power BI software
  • Install Power BI
  • Overview on Power BI
  • Types of Data Sources
  • Get data from Excel, CSV and Folder
  • Get data from Database (My Sql, Sql Server)
  • Introduction to Canvas, Visualizations, Fields, Formatting
  • Create table and matrix visuals
  • Data refresh
  • Transpose, Header Row Promotion
  • Data Type Changes & Detection
  • PIVOT
  • UNPIVOT
  • Merge
  • Append
  • Move Column and Split Column
  • Extract, Format and Numbers
  • Date & Time Transformations
  • Deriving Year, Quarter, Month, Day
  • Introduction to Entity Relation diagram
  • Normalization
  • Data Mapping
  • Relationship
  • One to One
  • One to Many
  • Many to One
  • Many to Many
  • DAX : Importance in Real-time
  • Real-world usage of Excel, DAX
  • DAX Architecture, Entity Sets
  • DAX Data Types, Syntax Rules
  • DAX Measures and Calculations
  • ROW Context and Filter Context
  • DAX Operators, Special Characters
  • DAX Functions, Types in Real-time
  • Vertipaq Engine, DAX Cheat Sheet
  • Creating, Using Measures with DAX
  • Creating, Using Columns with DAX
  • Quick Measures and Summaries
  • Validation Errors, Runtime Errors
  • SUM, AVERAGEX, KEEPFILTERS
  • Dynamic Expressions, IF in DAX
  • Introduction to Visualization in Power BI Desktop
  • Branding (Size, Header, Spacing, Footer)
  • Insert Image, Shape, Text Box
  • Design Thinking
  • Prepare a Power BI Dashboard
  • Stacked Charts and Clustered Charts
  • Line Charts, Area Charts, Bar Charts
  • 100% Stacked Bar & Column Charts
  • Map Visuals: Tree, Filled, Bubble
  • Cards, Funnel, Table, Matrix
  • Scatter Chart : Play Axis, Labels
  • Nepal map in Power BI
  • Why Power Bi Service?
  • Comparison Power BI Free & Premium
  • Logging into Power BI Service
  • Interface overview
  • Importing data from Desktop to Service
  • Working on reports
  • Workspace & Gateways
  • Installing Gateways - Personal & On-premise
  • Working alone or collaborating with colleagues
  • Collaborating in App Workspace
  • Project Requirement Analysis
  • Requirement Gathering
  • PBIX Report Design
  • Visualizations, Properties
  • Analytics and Formatting
  • Data Modeling, Power Query
  • DAX Requirements, Analysis
  • Preparing Dashboard
  • Sharing report with the team

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 .
reviewer image

Yadev KC

It was a pleasent experience, the tutor was well prepared and sufficient resources were provided as well.

reviewer image

Deepak Bhattrai

Trainer has a very strong mastery on the subject  matter with sofft voice. I enjoyed.
The Technical subject matter was very Interesting.


Write a Message

Security Check
2 + 2 =

    Course Features

  • Class20 hrs
  • Project Submission (Mandatory)10 hrs
  • Total Credit Hours30 hrs
  • Course Cost12,000/-