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

TechGeecs Logo

Data Analyst Course

TechGeecs Data Analyst Training Course can provide you with the skills and knowledge you need to effectively analyze data. This type of course can be beneficial for those who want to pursue a career in data analysis or for those who simply want to improve their data analysis skills.

by TechGeecs [Claim Listing ]
Siriam Logo

Microsoft Power BI Data Analyst Course

The PL-300T00: Microsoft Power BI Data Analyst certification is an essential credential for those who work with Power BI to analyze and visualize data.

by Siriam [Claim Listing ]
  • Price
  • Start Date
  • Duration
Koenig Solutions PVT. LTD. Logo

Introduction to Power BI

Enroll for our 1-day Introduction to Power BI from Koenig Solutions. In this course you will learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations.

by Koenig Solutions PVT. LTD. [Claim Listing ]
edForce Logo

Data Visualization With Tableau

Tableau allows you to create insightful and informative, perform scripting by integrating multiple databases, design network graphs in Nodexl for Facebook and Twitter, and perform numerous other functions that look appealing and creative.

by edForce [Claim Listing ]
Sami Infotech Logo

Power BI Certification

Power BI Certification course is offered by Sami Infotech. We believe in shaping the lives of students or candidates by not only offering them professional courses but also giving placement assistance in the same field.

by Sami Infotech [Claim Listing ]

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