Power BI

by Srikanth Technologies Claim Listing

This course teaches how to retrieve, analyse, clean, transform and model data to generate user-friendly reports, which can be exported, printed and shared, using Power BI. At the end of this course, you will have acquired the skills to bring data from different sources.

₹6000

Contact the Institutes

Fill this form

Advertisement

Srikanth Technologies Logo

img Duration

Please Enquire

Course Details

This course teaches how to retrieve, analyse, clean, transform and model data to generate user-friendly reports, which can be exported, printed and shared, using Power BI. At the end of this course, you will have acquired the skills to bring data from different sources, model and transform data, develop reports using different visuals, create dashboards and Apps to share with others.

 

Detailed Syllabus:

  • Introduction to Power BI
  • What is Business Intelligence (BI)?
  • Understanding Data Analytics
  • What is Power BI?
  • What is Power BI Desktop?
  • What is Power BI Service?
  • Power BI Pricing
  • Building Blocks - Data Models, Reports and Visuals, Workspaces, and Dashboards
  • Flow of Power BI
  • Getting started with Power BI Desktop and Power BI Service
  • How to install Power BI Desktop
  • Components of Power BI Desktop - Ribbons, Different Views, Pages, Visualizations and Fields panes
  • Loading data/Importing data
  • Understanding Data Model
  • Building a report with Visuals
  • Publishing report to Power BI Service
  • Creating a free account
  • Logging into Power BI Service
  • Creating Workspace
  • Creating Dashboard
  • Pinning report to Dashboard
  • Sharing report with others
  • Retrieving data
  • Understanding Connectors
  • Retrieving data from different sources
  • Getting data from files and folders
  • Getting data from databases like SQL Server
  • Getting data from other sources like Web and REST API
  • Understanding Storage Modes – Import, DirectQuery
  • Building Data Model
  • What is Data Model - Semantic Model?
  • Understanding Fact and Dimension tables
  • How to convert Flat Schema to Star Schema
  • How to convert Star Schema to Snowflake Schema
  • Selecting tables and columns
  • Specifying table and column properties - metadata
  • Creating new calculated columns based on DAX (Data Analysis Expressions)
  • Creating Measures
  • Using Quick Measures
  • Calculated columns vs. Measures
  • Creating Calculated Tables
  • Creating relationships between tables
  • Creating Date tables and role-playing dimensions
  • What is the difference between Active and Inactive relationship
  • Understanding Cross-filter and Cross-highlighting
  • Defining cardinality and cross-filter direction of relationship
  • Creating hierarchies
  • Performance issues to be considered while modelling data
  • Clean, Transform and Load Data
  • Filling data up and down
  • Using Power Query Editor
  • Understanding M Language
  • Working with Applied Steps
  • Column Profiling
  • Replacing null values
  • Replacing invalid values
  • Changing column names
  • Changing data types of columns
  • Removing duplicate rows
  • Splitting columns
  • Merging columns
  • Deleting unnecessary rows and columns
  • Applying auto update with AI
  • Transpose, Pivot and Unpivot data
  • Grouping data
  • Merging and Appending tables
  • Using Parameters
  • Data Analaysis Expressions (DAX)
  • DAX Formula
  • DAX Operators
  • How to reference tables, columns and measures
  • Using variables in DAX
  • Implicit vs. Explicit measures
  • Types of measures - additive and non-additive
  • Understanding Evaluating Context - Row Context and Filter Context
  • Aggregation functions
  • Date and Time Functions
  • Logical Functions
  • Filter Functions
  • Information Functions
  • Relationship Functions
  • Table Manipulation Functions
  • Text Functions
  • Time Intelligence Functions
  • Iterator Functions
  • Building Reports
  • Working with Bar and Column Chars
  • Working with Stacked Column and Bar Chars
  • Working with Line Charts
  • Working with Area Chart
  • Pie and Doughnut Chart
  • Working with Combination Charts
  • Ribbon, Waterfall and Funnel charts
  • Working with Map visuals
  • Using Table and Matrix visuals
  • Gauge and KPI charts
  • Using tooltips
  • Formatting data and titles
  • Styling the report
  • Working with Colors
  • Apply filtering
  • Creating and using Slicers
  • Conditional Formatting
  • Report Page formatting
  • Using Elements – textbox, images, shapes etc.
  • Ordering items on the report (Z-Order)
  • Drill through reports
  • Drill-down reports
  • Working with Analyses tab to create different lines
  • Creating what-if reports
  • Working with Power BI Service
  • Creating and using workspace
  • Creating Dashboard and Tiles
  • Editing details of a Tile
  • How to pin reports to Dashboard
  • Using Q&A feature
  • Using quick insights
  • Showing usage metrics and linage
  • Sharing dashboard with others
  • Using Focus mode
  • Understanding Power BI Apps
  • Configure Data Alerts
  • Applying Dashboard Theme
  • Subscribing to Dashboard
  • Vizag Branch

    304, Eswar Paradise, Beside SBI Dwarkanagar Branch, Vizag

Check out more Power BI courses in India

GVT Academy Logo

Power BI

Power BI Course is offered by GVT Academy. GVT Academy is the Best MIS & Data Analysis and Power BI Training Institute in Noida.

by GVT Academy [Claim Listing ]
Root IT Learning Center Logo

Advanced Big Data Analytics

Advanced Big Data Analytics course is offered by Root IT Learning Center. Hi-Tech Learning Environment to nurture the developer in you. Paperless and Clutter Free to help you concentrate on what you do.

by Root IT Learning Center [Claim Listing ]
  • Price
  • Start Date
  • Duration
MIIT Global Services Logo

Business Analytics and Intelligences

Business analytics is used by company that are committed to generating data-driven conclusions. Data-driven companies present their information as a corporate asset and actively consider methods to convert into a competitive lead. Successful business analytics of this Institutes relies on data cla...

by MIIT Global Services [Claim Listing ]
CAD PM Training Logo

Power BI

Power BI is a business platform that lets several technologies work together to deliver outstanding business intelligence solutions. It helps both technical and non-technical users with studying data and analyze it in a cost-effective manner.

by CAD PM Training [Claim Listing ]
MTA India Logo

Power BI Training

Power BI course is offered by MTA India for all skill level. MTA India has one clear vision. To provide quality IT Training that can be used in making a successful IT career.

by MTA India [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy