Power BI Data Analytics and Data Visualization Platform

Name: Power BI Data Analytics and Data Visualization Platform
Rating: 4.2 (4 reviews)

Power BI is a self driven data visualization tool. Drive insight discovery with the data visualization app

Created byAmit Kumar

Last updated 8/2022

English

What you'll learn

Power BI Business Intelligence Platform
Able to develop dashboard as per the business needs
Able to be expert in data analytics
The career path will be wider so that a student can achieve a successful position in IT industry

Course content

1 section • 20 lectures • 17h 53m total length

Introduction to Power BI, Workflow, Power BI Desktop, ETL Process1:00:37
Explore Power BI Desktop workflow, ETL processes, and data visualization capabilities, connecting diverse data sources, publishing dashboards, and deploying across cloud and on-premises environments.
Connecting & shaping Data, Power-Query Editor1:02:32
Connect to data sources and transform data with Power Query Editor to extract, shape, and load into a relational model for Power BI dashboards.
Power Query, Grouping Aggregating Data, Conditional Columns, Custom Column1:03:07
Defining Hierarchies, Creating Relationship, Managing Editing & Relationship1:00:19
Power BI DAX, Date Functions, String Functions1:01:59
Master DAX, date functions, and string functions in Power BI to build custom columns, calendars, and dynamic insights for data analytics and visualization.
If Else, Nested If, IfError, And, Or, Sum, Max, Avg, Count, Min, Count, Distinct1:01:59
Master Power BI conditional calculations using if else, nested if, iferror, and, or; apply sum, max, avg, count, min, distinct, and the calculate function to visualize data with filters.
SumX, Time Intelligent fun,Reports Interface,Page Setting, KPI, Card, Image, Pie1:02:08
Master Power BI time intelligence functions, SUMX, and calculated measures to create conditional logic and dynamic date ranges, then design dashboards with KPI cards, pies, and reports interfaces.
Bar graph, Stack bar graph, Clustered bar graph, %100 clustered, slicer, line ch1:03:06
Learn to design Power BI dashboards using bar, stacked bar, clustered bar, and 100% stacked charts, with slicers and line charts, plus dimensions, measures, and data labels.
Area, Stacked Area, Stacked bar & Line, Clustered bar & line, Ribbon, Waterfall1:00:28
Discover how to build area, stacked area, stacked bar and line, cluster bar and line, ribbon, and waterfall visuals in Power BI to analyze revenue and trends.
Scatter Plot, Tree map, Symbol map, filled map, gauge chart, multi row card1:00:58
Create and analyze dashboards in Power BI using scatter plot, tree map, symbol map, filled map, gauge chart, and multi row card to visualize orders, profitability, and geographic patterns.
Table box, Matrix, calculated column, conditional formatting, parameter1:00:30
Tree Map chart, Bookmark, Drill through, Managing Viewing, Desktop vs Phone View1:01:37
Explore tree map charts and drill through in Power BI to navigate to summary reports. Utilize bookmarks and desktop versus mobile viewing to tailor dashboards and access marketplace visuals.
Drilldown chart with Hierarchy, Objects of market place, DAX functions, Text fun1:02:59
Explore Power BI drilldown charts by building hierarchies from marketplace objects, and use DAX and text functions to transform data, join fields, and enable multi-dimensional analysis.
Power BI Landing Page, Server Overview, Power BI Service1:01:26
Learn to build a Power BI landing page with navigation to dashboards such as sales, stock, and geography, and publish to the Power BI service with on-premises and cloud deployments.
Data Connection, Setting A Personal Gateway, Creating user & secy., Subscription1:00:24
Deploy Power BI dashboards in the service, configure data sources, and connect on-premises data with a gateway. Set up user access, automatic refresh, and email subscriptions.
Introduction to using Excel data in Power BI, Exploring live connections, SQL25:58
Explore how to connect Excel data to Power BI using live connections and SQL Server Analysis Services, enabling real-time dashboards and seamless data visualization.
Reading vs Editing, Power BI Development API, Import Power View and Power Pivot35:27
Publish dashboards to Excel, use analyze in Excel, and import Power View and Power Pivot; compare reading versus editing modes and explore the Power BI development API.
Row Level Security, Pin to Dashboard, Pining tiles to Dashboard26:59
Master row-level security in Power BI to restrict data by role and region, publish and verify access, and learn how to pin visuals and tiles to dashboards.
Comparison between Power BI and Tableau31:12
Compare Power BI and Tableau as leading business intelligence platforms, assessing ease of use, data source support, visualizations, cost, and performance to identify the market leader.
R Integration in Power BI Desktop and using R visuals in Power BI29:51
Learn how to integrate the R programming language in Power BI Desktop and use R visuals to create advanced analytics, import data, and build visuals.

Requirements

Basic Knowledge on SQL
Basic knowledge on Data Warehousing
Basic knowledge on OOPs concept

Description

Power BI is a complete data analytics platform that sets the benchmark for a new generation of analytics. With its one-of-a-kind associative analytics engine, sophisticated AI, and high performance cloud platform, you can empower everyone in your organization to make better decisions daily, creating a truly data-driven enterprise.

Power BI is for all of us – executives, decision-makers, analysts... you. Enable any BI use case and let users freely search and explore to uncover insights they won’t find with query-based BI tools.

Insight Advisor, your AI assistant in Power BI, instantly raises the data literacy of every user through insight generation, task automation, and search & natural-language interaction.

Get the convenience of on-premise for the most demanding enterprises. Scale confidently with powerful data integration, open APIs, and flexible governance.

Power BI can easily combine, load, visualize, and explore your data, no matter how large (or small). Ask any question and follow your curiosity. Search, select, drill down, or zoom out to find your answer or instantly shift focus if something sparks your interest. Every chart, table, and object is interactive and instantly updates to the current context with each action. Smart visualizations reveal the shape of your data and pinpoint outliers. And get faster time to insight with assistance from Insight Advisor for chart creation, association recommendations, and data preparation.

Who this course is for:

Beginners
Business Analysts
Programmers
Project Managers
HR professionals
Accounts Processionals
MIS executives