• 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 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

  • Download latest Power BI software
  • Install Power BI
  • Comparing Tableau and Power BI
  • Types of Reports in Real-World
  • Interactive & Paginated Reports
  • Data Sources Types in Power BI
  • Power BI Licensing Plans - Types
  • Power BI Dev & Prod Environments
  • Understanding the Power BI Tools
  • Types of Data Sources
  • Get data from Excel, CSV and Folder
  • Introduction to Canvas, Visualizations, Fields, Formatting
  • Create table and matrix visuals
  • Disabling Visual Interactions
  • Edit Interactions - Format Options
  • SPOTLIGHT & FOCUSMODE
  • Data refresh
  • Data Connection to MySql Database
  • Data Connection to SQL Server Database
  • Data Connection to Oracle Database
  • Create, Alter and Drop Table Insert
  • Update and Delete Statement Truncate Statement
  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc…keywords
  • Using String and Arithmetic Expressions
  • Exploring Where Clause with Operators
  • Using Advanced Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries
  • Introduction to Joins Cross Joins
  • Inner Join
  • Outer Join
  • Self Join
  • Co-related Sub Queries
  • Set Operations using Unions, Intersect and Except
  • Introduction to Entity Relation diagram
  • Normalization
  • Data Mapping
  • Relationship
  • One to One
  • One to Many
  • Many to One
  • Many to Many
  • Introduction to Visualization in Power BI Desktop
  • Branding (Size, Header, Spacing, Footer)
  • Insert Image, Shape, Text Box
  • Design Thinking
  • Template in Power BI
  • Prepare a Power BI Dashboard
  • Hierarchies and Drilldown Options
  • Hierarchy Levels and Drill Modes – Usage
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Options
  • Aggregates with Bottom/Up Navigations. Rules
  • Multi Field Aggregations and Hierarchies in Power BI
  • DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
  • SEE DATA and SEE RECORDS Options. Differences
  • Toggle Options with Tabular Data. Filters
  • Drilldown Buttons and Mouse Hover Options @ Visuals
  • Dependent Aggregations, Independent Aggregations
  • Automated Records Selection with Tabular Data
  • 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
  • Power Query M Language Purpose
  • Power Query Architecture and ETL
  • Add Conditional Column
  • Add Custom Column
  • Power Query Functions, Parameters
  • Advanced Editor
  • Query Step Inserts and Step Edits
  • ETL Operations with Power Query
  • Replace Columns: Text, NonText
  • Replace Nulls: Fill Up, Fill Down
  • Remove Duplicate
  • Group By and Advanced Options
  • Aggregations with Power Query
  • Introduction to API & API Testing.
  • HTTP Methods & Fundamentals.
  • Authentication & Cookie basics.
  • Approach of API Testing, Writing Test Plan and Test Cases
  • Performance Testing Plan and Execution
  • Best Practices of API Testing
  • GET Request
  • Path variable
  • POST Request
  • Global variable
  • Environment
  • 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
  • Data Modeling Options in DAX
  • Detecting Relations for DAX
  • Using Calculated Columns in DAX
  • Using Aggregated Measures in DAX
  • Working with Facts & Measures
  • CALCULATE Function Conditions
  • CALCULATE & ALL Member Scope
  • RELATED & COUNTROWS in DAX
  • Entity Sets and Slicing in DAX
  • Dynamic Expressions, RETURN
  • Date, Time and Text Functions
  • Logical, Mathematical Functions
  • Running Total & EARLIER Function
  • Connection with CSV, MS Access
  • AVERAGEX and AVERAGE in DAX
  • KEEPFILTERS and CALCUALTE
  • COUNTROWS, RELATED, DIVIDE
  • PARALLELPERIOD, DATEDADD
  • CALCULATE & PREVIOUSMONTH
  • USERELATIONSHIP, DAX Variables
  • TOTALYTD , TOTALQTD
  • DIVIDE, CALCULATE, Conditions
  • IF..ELSE..THEN Statement
  • SELECTEDVALUE, FORMAT
  • SUM, DATEDIFF Examples in DAX
  • TODAY, DATE, DAY with DAX
  • Time Intelligence Functions – DAX
  • Creating Hierarchies in Power BI
  • Independent Drill-Down Options
  • Dependant Drill-Down Options
  • Conditional Drilldowns, Data Points
  • Drill Up Buttons and Operations
  • Expand & Show Next Level Options
  • Dynamic Data Drills Limitations
  • Show Data and See Records
  • Filters : Types and Usage in Real-time
  • Visual Filter, Page Filter, Report Filter
  • Basic, Advanced and TOP N Filters
  • Category and Summary Level Filters
  • DrillThru Filters, Drill Thru Reports
  • Keep All Filters" Options in DrillThru
  • CrossReport Filters, Include, Exclude
  • Prerequisites for the implementation
  • Configuration in Power BI
  • Get Data using R Script
  • Using an R Script to Create Visualizations
  • 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
  • Waterfall Chart
  • Color Saturation, Sentiment Colors
  • Column Series, Column Axis in Lines
  • Display Units, Data Colors, Shapes
  • Series, Custom Series and Legends
  • Nepal map in Power BI
  • Creating Parameters in Power Query
  • Parameter Data Types, Default Lists
  • Static/Dynamic Lists For Parameters
  • Removing Columns and Duplicates
  • Convert Tables to List Queries
  • Linking Parameters to Queries
  • Testing Parameters and PBI Canvas
  • Multi-Valued Parameter Lists
  • Define roles and rules in Power BI Desktop using enhanced row-level security editor
  • Validate the roles within Power BI Desktop
  • Manage security on your model
  • Working with members
  • Validating the role within the Power BI service
  • Using the username() or userprincipalname() DAX function
  • Need for Report Server in PROD
  • Install, Configure Report Server
  • Report Server DB, Temp Database
  • Web service URL, Webportal URL
  • Creating Hybrid Cloud with Power BI
  • Using Power BI DesktopRS
  • Uploading Interactive Reports
  • Report Builder For Report Server
  • Report Builder For Power BI Cloud
  • Designing Paginated Reports (RDL)
  • Deploy to Power BI Report Server
  • Data Source Connections, Report
  • Power BI Report Server to Cloud
  • Create report bookmarks
  • Arranging bookmarks
  • Using the Selection pane
  • Assign bookmarks to buttons
  • Why Power Bi Service?
  • Comparison Power BI Free & Premium
  • Logging into Power BI Service
  • Interface overview
  • Importing data from Desktop to Service
  • Dataset menu
  • Working on reports
  • Dashboard overview
  • Workspace & Gateways
  • Installing Gateways - Personal & On-premise
  • Working alone or collaborating with colleagues
  • Collaborating in App Workspace
  • Sharing the results
  • Publishing the app
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering
  • PBIX Report Design
  • Visualizations, Properties
  • Analytics and Formatting
  • Data Modeling, Power Query
  • Dynamic Connections
  • Parameters and M Lang Scripts
  • DAX Requirements, Analysis
  • Cloud and Report Server
  • Project FAQs and Solutions
 

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

  • Class40 hrs
  • Project Submission (Mandatory)20 hrs
  • Total Credit Hours60 hrs
  • Course CostRs. 25,000/-