Description

Power BI is a radical new tool within the hands of business enterprises who are overpowered with the quantity of knowledge at hand and thus far didn't have a reasonable tool to extract insights from it. On successful completion of Power BI, students can get access to a set of tools and applications that allows them to extract data from multiple unrelated sources and convert it into organised & systematically managed coherent set of knowledge, visually appealing insights, interactive knowledge, charts, graphs and reports. Furthermore, students will get official course materials issued by Microsoft for analyzing data with Power BI.

This particular course, Power BI, is an instructor-led course with a mean batch size of ten students. Within the 45 hours of online training, students will obtain theoretical & practical knowledge/information required to make the required skills. The trainer’s holistic approach is stemmed to satisfy the long-run wants of the scholar. They facilitate 100% job/placement post the successful completion of the course & also provide the students with an option to take a demo class before enrolling for the course.

What Will I Learn?

  • You will be given an introduction to Data Visualization, Reporting & Business Intelligence (BI)
  • You will learn Data Transformation, Benefits of Data Transformation & Shape or Transform Data using Power Query
  • You will learn Power BI Data Modelling – Relationship ViewData Modelling Introduction and Relationship

Specifications

  • Free Demo
  • Learn from Experts
  • Interactive Learning
  • Missed Class Recovery
  • Instalment Facility

Power BI Introduction

  • Data Visualization
  • Reporting
  • Business Intelligence (BI)
  • Flow of Work in Power BI Desktop
  • Flow of Work in Report server Power BI Desktop
  • Power BI Report Server, Power BI Service 
  • Power BI Mobile
  • The flow of Work in Power BI / Power BI Architecture

 

PBI Desktop Installation, PBI Desktop & Service Overview

  • Power BI Desktop Installation
  • Datasets, Visualizations
  • Reports 
  • Dashboards
  • Power BI Desktop User Interface
  • Fields Pane, 
  • Visualizations pane 
  • Ribbon
  • Views 
  • Pages Tab
  • Overview of Power Query / Query Editor - Extract, Transform & Load Data
  • Connecting to Data Sources, Establish a connection to the Excel source 
  • Importing Data into Power BI or Query Editor
  • Transforming the Data using Power Query
  • Creating new measures, new columns  & tables using DAX – Data View
  • Saving & Publishing the Visuals or Reports
  • Logon to Power BI Service
  • View the Reports in PBI Service and Share the reports

 

Power Query

 Introduction to Power Query – Extract, Transform & Load

  • Data Transformation, 
  • Benefits of Data Transformation
  • Shape or Transform Data using Power Query
  • Overview of Power Query / Query Editor
  • Query Editor User Interface
  • The Ribbon (Home, Transform, Add Column, View Tabs)
  • The Queries Pane, The Data View / Results Pane 
  • The Query Settings Pane 
  • Formula Bar
  • Advanced Editor – Complete ETL Code
  • Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
  • Power Query Conceptually

 

Datatypes and Filters in Power Query

  • Datatypes, 
  • Changing the Datatype of a Column
  • Filters in Power Query
  • Filter a Column using Text Filters
  • Filter a Column using Number Filters
  • Filter a Column using Date Filters
  • Filter Multiple Columns

 

Inbuilt Column Transformations

  • Remove Columns / Remove Other Columns
  • Name / Rename a Column
  • Reorder Columns or Sort Columns
  • Add Column / Custom Column
  • Split Columns
  • Merge Column
  • PIVOT, 
  • UNPIVOT Columns
  • Transpose Columns
  • Header Row or use first row as headers
  • Keep top rows, keep bottom rows
  • Keep Range of Rows
  • Keep Duplicates, Keep Errors
  • Remove Top Rows, Remove Bottom Rows
  • Remove Alternative Rows
  • Remove Duplicates, Remove Blank Rows
  • Remove Errors
  • Group By

 

Combine Queries (Append Queries & Merge Queries)

  • Append Queries / Merge Queries
  • Query Options
  • Copy Query, Paste Query
  • Delete Query, Rename Query
  • Enable Load, Include in report Refresh
  • Duplicate Query, Reference Query
  • Move to Group, Move Up, Move Down

 

Power Pivot

  • Power BI Data Modelling – Relationship View
  • Data Modelling Introduction
  • Relationship
  • Need for Relationship
  • Relationship Types / Cardinality in General
  • One-to-One, One-to-Many (or Many-to-One)
  • Many-to-Many
  • AutoDetect the relationship
  • create a new relationship
  • Edit existing relationships
  • Make Relationship Active or Inactive
  • Delete a relationship

 

Enhancing the Data Model – DAX

  • What is DAX
  •  Measures
  • DAX Table and Column Name Syntax
  • Creating Calculated Columns 
  • Creating Measures
  • Calculated Columns Vs Measures
  • DAX Syntax & Operators
  • DAX Operators
  • Types of Operators
  • Arithmetic Operators
  • Comparison Operators
  • Text Concatenation Operator
  • Logical Operators

 

 DAX Functions Categories

  • Date and Time Functions
  • Logical Functions
  • Text Functions
  • Math & Statistical Functions
  • Filter Functions
  • Time Intelligence Functions
  • DAX Date & Time Functions
  • Information Functions

 

Date and Time Functions

  • Year
  • Month
  • Day
  • Weekday
  • Weeknum
  • Format (Text Function) Month Name
  • Weekday Name
  • Date
  • Today
  • Now
  • Hour
  • Minute 
  • Second
  • Time
  • Davidoff
  • Calendar
  • Date value 
  • Time value
  • Utcnow 
  • Utctoday

 

DAX Text Functions

  • Len 
  • Concatenate
  • Left 
  • Right 
  • Mid
  • Upper 
  • Lower
  • Trim 
  • Substitute 
  • Blank
  • Code 
  • Exact
  • Find
  • Fixed
  • Trim 
  • Unichar
  • Search
  • Value
  • Format

 

DAX Logical Functions

  • If 
  • True 
  • False
  • If error
  • In
  • Switch 
  • And
  • Not

 

DAX Math and Statistical Functions

  • Currency
  • Rand
  • Int
  • Abs
  • Round 
  • Roundup 
  • Rounddown
  • Rand Between
  • Divide
  • Even 
  • Odd
  • Sqrt 
  • Fact
  • Sum 
  • Sumx
  • Min
  • Minx
  • Count 
  • Countx
  • Average
  • Averagex
  • Countrows
  • Countblank
  • Crossjoin
  • Distinctcount
  • Median 
  • Rankx 
  • Topn

 

Other Functions

  • Converet
  • Datatable
  • Generateserie 
  • Groupby
  • Union
  • Var

 

DAX Filter Functions

  • Calculate
  • Allxecpt
  • All 
  • Distinctcount
  • Filter 
  • Hasonefilter
  • Hasonevalue
  • Selectedvalue

 

DAX Time Intelligence Functions

  • Time Intelligence Introduction
  • Closingbalancemonth
  • Dateadd
  • Datesbetween
  • Datesinperiod
  • Datesmtd
  • Datesytd
  • Totalmtd
  • Totalytd
  • Endofmonth
  • Firstdate
  • Lastdate 
  • Startofmonth
  • Sameperiodlastyear

 

Information Functions

  • Contains
  • Isblank
  • Iserror
  • Iseven
  • Isnontext
  • Istext
  • Isodd 
  • Isnumber
  • Username

 

Power Bi Desktop

Tool Tips

  • Felid level tool tips
  • Default tool tips
  • Page level tool tips
  • Text level tool tips
  • Visual header tool tips

 

Conditional Formatting 

  • Text conditional formatting
  • Border conditional formatting
  • Background conditional formatting
  • Font conditional formatting
  • Data bars conditional formatting
  • Conditional formatting icons

 

Other Options

  • Buttons
  • shapes
  • Images 
  • New parameter
  • What if parameter 
  • Gridlines
  • Lock objects
  • Bookmarks
  • Selection 
  • Performance analyser
  • Sync slicers 
  • edit interactions
  • Enter data
  • recent sources
  • refresh
  • Data grouping
  • visual analysing

 

Visualizations

  • Stacked bar chart
  • Stacked column chart
  • Clustered bar chart
  • Clustered column chart
  • 100% stacked bar chart
  • 100% stacked column chart
  • Line chart, Area chart
  • Stacked area chart
  • Line and stacked column chart
  • Line and clustered column chart
  • Ribbon chart
  • Waterfall chart
  • Scatter chart
  • Pie chart, 
  • Donut chart
  • Treemap
  • Filled map
  • Map, Funnel
  • Introduction to office 365
  • What is office 365
  • Download custom visuals

 

Custom Visuals

  • Bar chart, 
  • Chartaccentbarchart
  • Hierarchy slicer
  • Linedotchart
  • Multi slicer
  • Pivotslicer table heatmap
  • Tornado chart

 

Filters in Power View

Filter Types

  • Visual Level Filters
  • Page Level Filters
  • Report Level Filters 
  • Drill Through Filters
  • Filter Sub Types
  • Basic Filtering
  • Advanced Filtering
  • Top N
  • Relative Date Filtering
  • Numeric field filters
  • Text field filters 
  • Date and Time field Filters

 

Hierarchies and Drill-Down Reports

  • Hierarchy Introduction,
  • Default Date Hierarchy,
  • Creating Hierarchy,
  • Creating Custom Date Hierarchy
  • Change Hierarchy Levels
  • Drill-Up and Drill-Down Reports,
  • Drill Down, 
  • Drill Up, 
  • Show Next Level, 
  • Expand Next Level
  • Drilling filters other visuals option

 

Visualizing KPI Data

  • Create and Format Gauge Visual
  • KPI Visual
  • Create and Format Card Visualization 
  • Multi Row Card
  • Create and Format Table Visual
  • Matrix Visualization
  • Create and Format Map Visual
  • Filled Map Visual

 

Power BI Service

  • Power BI Service Introduction
  • Power BI Service Introduction
  • Power BI Cloud Architecture
  • Creating Power BI Service Account
  • SIGN IN to Power BI Service Account
  • Publishing Reports to the Power BI service
  • Import / Getting the Report to PBI Service
  • My Workspace / App Workspaces Tabs
  • Working with Datasets
  • Creating Reports in Cloud using Published Datasets
  • Power BI Datasets Live Connection using Desktop
  • working with Reports
  • Sharing Reports
  • Creating new reports in services
  • Embedding to web
  • share report link

 

Dashboards Development

  • Creating Dashboards Pin Visuals and Pin LIVE Report Pages to Dashboard
  • Advantages of Dashboards
  • Interacting with Dashboards
  • Formatting Dashboard
  • Sharing Dashboard

 

Data Gateways

  • Introduction to Data Gateways
  • How Data Gateways work
  • Connect to an on-premise Data Source by using a Data Gateway
  • Download Data Gateway
  • Installing a Data Gateway
  • Types of Gateways
  • On-premises Data Gateway, On-premises Data Gateway (personal mode)
  • Manage Data Gateway
  • Refresh on Premise Data

 

Configuring Automatic Refresh using Schedules

  • Collaboration in Power BI using App Workspace
  • Introduction to App Workspaces
  • Create an App Workspace
  • Add Members to App Workspace to Collaborate
  • App Workspace Access
  • Admin, Member,
  • Contributor

 

Sharing Power BI Content using Apps and Content Packs

  • Introduction to App
  • Publish an App
  • Update a Published App
  • Manage Content in App
  • Entire Organization, 
  • Specific individuals or group
  • Content Pack Introduction
  • Create Content Pack
  • Sharing Content Packs
  • Specific Groups
  • My Entire Organization
  • Selecting the Content / Items to Publish or Share
  • Row Level Security in Power BI
  • Introduction to Row Level Security

Mr.Siraj

The trainer is a software engineer having 6+years of IT experience in SQL Server, ETL & reporting tools.
 

No reviews found

Batch Start Date End Date Timings Batch Type
No video found

Description

Power BI is a radical new tool within the hands of business enterprises who are overpowered with the quantity of knowledge at hand and thus far didn't have a reasonable tool to extract insights from it. On successful completion of Power BI, students can get access to a set of tools and applications that allows them to extract data from multiple unrelated sources and convert it into organised & systematically managed coherent set of knowledge, visually appealing insights, interactive knowledge, charts, graphs and reports. Furthermore, students will get official course materials issued by Microsoft for analyzing data with Power BI.

This particular course, Power BI, is an instructor-led course with a mean batch size of ten students. Within the 45 hours of online training, students will obtain theoretical & practical knowledge/information required to make the required skills. The trainer’s holistic approach is stemmed to satisfy the long-run wants of the scholar. They facilitate 100% job/placement post the successful completion of the course & also provide the students with an option to take a demo class before enrolling for the course.

What Will I Learn?

  • You will be given an introduction to Data Visualization, Reporting & Business Intelligence (BI)
  • You will learn Data Transformation, Benefits of Data Transformation & Shape or Transform Data using Power Query
  • You will learn Power BI Data Modelling – Relationship ViewData Modelling Introduction and Relationship

Specifications

  • Free Demo
  • Learn from Experts
  • Interactive Learning
  • Missed Class Recovery
  • Instalment Facility

No Comments

Please login to leave a review

Related Classes