POWER BI COURSE IN KANPUR

• 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)

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

• Data visualization

• Data Analysis

• Communication

• Problem-solving

• Data Science

• Project Management

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.

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.

Data visualization includes important tools such as:

• Charist

• Google

• Tableau

• Chartblocks

• Grafana

• FusionCharts

• Infogram

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

• Business Intelligence Manager

• Business Intelligence Analyst

• Data Analyst

• Business Analyst

• Power BI Developer

• Power BI Analyst

• Business Intelligence Developer

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

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 that overlooks the progress of the employees and how they reach their goals.

According to the Ambition Box report, the average salary of a Power BI professional in Kanpur ranges from INR 6.8 to INR 8.6 LPA.

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

Power BI is easy to learn because it is a Microsoft Excel and anyone can use it without having an experience in data reporting and data analysis. Power BI has many built-in features that make people use it easily and create interactive dashboards and reports. Power BI is a user-friendly interface that makes it easy to learn and use.