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

Elysium Academy Logo

Big Data Course

Hadoop Bigdata is an open-source software framework that support data intensive distributed Applications. Actually Hadoop is a MapReduce process in which the application is divided into many small fragments of work each of which may be executed on the nodes of Hadoop Clusters.

by Elysium Academy [Claim Listing ]
ACTE Logo

Power BI Training

Power BI is a business intelligence platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data.

by ACTE [Claim Listing ]
Analystmate Academy Logo

Power BI (Advance)

With the help of our Power BI Advanced Analystmate course, realize the complete potential of your data. Explore the depths of analytics, data visualization, and business intelligence. Our extensive programme will improve your Power BI skills regardless of your degree of expertise as an analyst.

by Analystmate Academy
Techdata Solutions Logo

Power BI Course

Power BI is a platform for business intelligence from Microsoft. It is similar to Microsoft Excel in terms of user interface but is an advanced integration with Microsoft’s other products.

by Techdata Solutions [Claim Listing ]
Rays Edutech Private Limited Logo

Data Analytics

In today's data-driven world, the ability to analyze and interpret data is crucial. Our Data Analytics Course is designed to provide you with the skills and knowledge needed to transform raw data into actionable insights.

by Rays Edutech Private Limited [Claim Listing ]

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