Power BI

Master Power BI course online with Golive Classes. We provide the best Power BI course online in Hyderabad and other states in India.

What is Power BI?

Power BI is a user-friendly data analytics and visualization tool developed by Microsoft. It enables users to connect to various data sources, create interactive reports and dashboards, and share their findings with others. Its intuitive interface and extensive range of features make it an excellent choice for beginners in the field of data analysis.

Power BI

Power BI +SQL+ Azure Basics Online Training Course Content

Data ware house basics

• Data warehouse introduction
• DWH definitions
• DWH Architecture
• Schemas
• Types facts
• Types DIM
• OLTP VS OLAP

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
• Flow of Work in Power BI / Power BI Architecture
• A Brief History of Power BI

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 connection to the Excel source,
• SQL

• Importing Data into Power BI or Query Editor
• Transforming the Data using Power Query
• Creating New Measures and New Columns and tables using DAX – Data View
• Saving and 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,

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

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
• DATADIFF
• CALENDAR
• DATAVALUE
• 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
• IFERROR,
• 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

DAX Filter Functions

• CALCULATE,
• ALLXECPT
• ALL,
• DISTINCTCOUNT
• FILTER
• HASONVALUE
• SELECTEDFILTER

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

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 analyzer,
• Sync slicers,
• edit interactions
• Enter data,
• recent sources,
• refresh
• Data grouping,
• visual analyzing

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,

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
• DATASETS,
• WORKBOOKS,
• REPORTS,
• DASHBOARDS
• Working with Datasets,
• Creating Reports in Cloud using Published Datasets
• Power BI Datasets Live Connection using Desktop
• Working with Workbooks,
• working with Reports,
• Sharing Reports
• Creating new reports in services
• Embedding to web,
• share report link
• Row Level Security in Power BI
• Introduction to Row Level Security

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

SQL Basics

• SQL Introduction
• Installation
• DDL Commands
• DML Commands
• DRL Commands
• Types Joins
• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Select ,Case ,Switch,IF statement

Azure Basics

• Azure basics
• Azure Subscription
• Azure SQL,
• Blob Storage
• ADF Basics

Power BI Course Content Download Link

Want to book a Demo for this awesome Splunk Admin Course? Click Register.