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

Overview

The Benefits of Using Power BI

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

  • Get Power BI Desktop
  • Getting started with Power BI Desktop
  • Overview of Power BI
  • Data Sources in Power BI Desktop
  • Import Excel Workbooks
  • Data Type in Power BI Desktop
  • Explore Pivot Feature
  • Data import from Folder
  • Append multiples files
  • Transforming Data (Combine Files)
  • Joins (Left, Right, Inner, Outer)
  • Transforming Data (Merging Queries)
  • Refresh the data
  • Data Connect from multiple source
  • Delimited text files
  • JSON file
  • XML file
  • Connect to web data
  • Data Transformation
  • Transforming Data (Appending Queries)
  • Transforming Data (M Query Basics)
  • Connect to API
  • We will take some available examples
  • Pivot feature in Power BI
  • Unpivot feature in Power BI
  • Advance Data Transformation
  • Introduction to Modeling Data
  • Data Mappping (Relationship between tables)
  • One to One
  • One to Many
  • Many to Many
  • Introduction to Database connection from Power BI Desktop
  • Connect Access Database
  • Connect Oracle Database (If available in your machine)
  • Connect MySQL Databas (If available in your machine)
  • Connect SQL Server Database (If available in your machine)
  • Basics DAX
  • Creating Calculated Columns
  • Navigation Functions
  • Conditional and Logical Functions
  • Calculated tables
  • Creating Calculated Measures (Measure Basics)
  • Creating Calculated Measures (Time Intelligence Functions)
  • Advanced DAX
  • Working with Variables
  • Working with Filter Context (What is Filter Context?)
  • Working with Filter Context (CALCULATE)
  • Working with Filter Context (Overriding Filter Context)
  • Working with Filter Context (FILTER)
  • Working with Filter Context (FILTER and ALL)
  • Working with Filter Context (ALLEXCEPT)
  • Working with Filter Context (Totals)
  • Advanced DAX Function (CONTAINS)
  • Advanced DAX Function (FIND)
  • Advanced DAX Function (SEARCH and SUBSTITUTE)
  • Advanced DAX Function (ALLSELECTED)
  • 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
  • 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
  • Tree Map
  • Slicer
  • Map
  • Filled Map
  • 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 (Concept of Report, Dashboard, Power BI App)
  • Using the Power BI Service (Concept on development environment and production environment)
  • 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.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Course Duration30 hrs