POWER BI COURSE IN DHANBAD

• What is PowerBI?
• Download and Install Power BI Desktop
• Quick Interface Tour
• Mini Project: Transform Data
• Mini Project: Visualize Data
• Mini Project: Creating a Data Model

• Exploring Query Editor
• Connecting to our DataSource
• Editing Rows
• Changing DataTypes
• Replacing values
• Close and Apply
• Connecting to a CSV File
• Connecting to a Webpage
• Extracting Characters
• Splitting and Merging Columns
• Creating Conditional Columns
• Creating Columns from Examples
• Merging Queries
• Pivoting and Unpivoting
• Appending Queries
• Practice and Solution:Population Table
• The Fact-Dimension-Model
• Practice:Load the Dimension Table
• Organizing Our Querires in Groups
• Entering Data Manually
• Creating an Index Column
• Workflow and More Transformation
• Module Summary
• Practice Assignment 1

• Advanced Editor-Best Practices
• Performance: References Versus Duplicating
• Performance: Enable/Disable Load and Report Refresh
• Group By
• Mathematical Operations
• Run Python Script
• Using Parameters to Dynamically Transform Data
• M Formula Language:Basics
• M Formula Language:Values, Lists, and Tables
• M Formula Language: Functions

• Why a Data Model?
• Create and Edit Relationships
• One-to-Many and One-to_One Relationship
• Many-to-Many(m:n) Relationship
• Cross-Filter Direction
• Activate and Deactivate Relationships
• Practice Assignment 2

• Our First Visual
• The Format Tab
• Understanding Tables
• Conditional Formatting
• The Pie Chart
• All about the filter Visual
• The Filter Pane for Developers
• Cross Filtering and Edit Interactions
• Practice Assignment 3
• Synching Slicers across Pages
• Creating Drilldowns
• Creating Drill-Throughs
• The Treemap Visual
• The Decomposition Tree
• Understanding the Matrix Visual
• Editing Pages
• Buttons and Actions
• Bookmarks to Customize Your Report
• Analytics and Forecasts with Line Charts
• Working with Custom Visuals
• Get Data Using Python Script

• Python in Power BI
• Setting Up Python for Power BI
• Transforming Data Using Python
• Creating Visualizations Using Python
• Violin Plots, Pair Plots and Ridge Plots Using Python
• Machine Learning (BayesTextAnalyzer) Using Python

• Introduction
• The Project Data
• Measures Versus Calculated Columns
• Automatically Creating a Data Table in DAX
• Calender
• Creating a Complete Data Table with Features
• Creating a Key Measure Table
• Aggregation Functions
• The Different Versions of COUNT
• SUMX- Row-Based Calculations

• CALCULATE- The Basics
• Changing the Context with FILTER
• ALL
• ALLSELECT
• ALLEXCEPT

• Introduction - Best Practices
• Show Emphaty and Identify the Requirements
• Find the Most Suitable KPIs
• Choose and Effective Visual
• Make Use of Natural Reading Patters
• Tell a Story Using Visual Cues
• Avoid Chaos and Group Information

• JSON and REST API
• Setting UP a Local MYSQL Database
• Connecting to a MYSQL Databased in Power BI
• Connecting to a SQL Database (PostgreSQL)

Power BI is a data visualization platform that is primarily used for business intelligence purposes. Power BI dashboard is capable of visualizing and reporting data in a wide range of various styles that include maps, graphs, charts, scatter plots etc.

The key skills that need to be adapted by Power BI Professionals are:

• Data visualization

• Data Analysis

• Communication

• Problem-solving

• Data Science

• Project Management

Data visualization includes important tools such as:

• Google

• Tableau

• Grafana

• Charist

• FusionCharts

• Infogram

• Chartblocks

Power BI is designed to empower the business world and some common use of Power BI are:

• Creating dashboards to present data sets in multiple visual formats

• Connecting data sources such as Excel sheets, data warehouse, and cloud-based data storage and turning them into business insights.

• Turning data into different visuals including Pie charts, Gauge charts, KPIs, Combo charts, Column charts, Decomposition trees etc.

The core components of Power BI are:

• Power Query

• Power Pivot

• Power View

• Power Map

• Power Q&A

• Power BI Desktop

• Power BI Mobile Apps

• Power BI Website

There are several job roles under Power BI in Dhanbad such as:

• Business Intelligence Manager

• Business Intelligence Analyst

• Data Analyst

• Business Analyst

• Power BI Developer

• Power BI Analyst

• Business Intelligence Developer

The salary of a Power BI developer in India reaches up to INR 5.6 LPA according to the Ambition Box report.

Power BI is significantly used by data analysts and BI professionals who craft the data models before disseminating reports through the organisations. Power BI is used both in the department and management and overlooks the progress of the employees and how they reach their goals.

Power BI can be relatively easy to learn for individuals who have prior experience with data analysis and visualization tools. However, like any software tool, there is a learning curve involved in mastering Power BI's features and capabilities. Power BI offers a user-friendly interface that allows users to drag and drop various visualizations, and the tool also has a variety of built-in templates and pre-made visuals that make it easy to create professional-looking reports and dashboards.

The key features of Power BI are quick insights, common data model support, artificial intelligence, hybrid deployment support, cortana integration, customization etc.