Microsoft Power BI


 Rating
         
 Duration
24 Hrs.
 Eligible For
Any professional , fresher Students
Course Price at    10000

Get a Globally Accepted Certification

Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.

It is 80% practical with industry used case studies.

Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.

Image/

Course Features


Introduction

LEARN HOW TO EXCEL IN BUSINESS INTELLIGENCE

BY CREATING ARTIFICIALLY INTELLIGENT DASHBOARDS

USING MICROSOFT POWER BI,        

ALL WITHOUT THE NEED FOR CODING OR PRIOR KNOWLEDGE


POWER BI COURSE CONTENT:

This course is intended to provide the basic level curriculum. The idea of this course is conceptual understanding and hands-on learning. At the end of this course, everyone must feel they are at ease working with Power BI from basic to advanced areas.

 


Course Details

Course duration: Intensive 24 Hrs.


MODULE 1: GET STARTED WITH MICROSOFT DATA ANALYTICS

Getting Started

 Why Power BI

 The interface of Power BI

 Different Parts of Power BI

 Components of Power BI

 Power BI Workflow

 

MODULE 2: PREPARE DATA IN POWER BI

 How to Import Tables and Ranges in Power BI?

 How to Import CSV, PDF, and Web in Power BI?

 Power BI output format?


MODULE 3: CLEAN, TRANSFORM AND LOAD DATA IN POWER QUERY

Functions using the menu:

 Various text functions prepare data for data visualisation.

 Various Date functions to prepare data for data visualisation.

 Various functions prepare data for data visualization. 


MODULE 4: DATA CLEANING TECHNIQUES

 Transformation of data in Power Query without coding

 Promote and Demote Headers

 Add, Remove, Rename, Delete, Move Column

 Ignore Top/Bottom Rows and extract relevant data in middle

 Keep and Remove Top and Bottom Rows

 Transpose, Pivot and Unpivot

 Fill up and Fill down

 Remove Duplicates, blank rows, null values, and errors

 Collect and add data to a single file in Power Query

 Appending Clean Data

 Append Multiple CSV files from a folder in a fraction of second

 Append Multiple Excel Tables

 Append Multiple Excel files from the folder

 Append Multiple PDF files from the folder

 Merging data in Power Query – Without VLOOKUP

 Merging data from two tables in Excel

 Merging data from two Excel files

 Merging data from two data sources

 

MODULE 5: MORE WITH POWER QUERY EDITOR

 Creating Columns using Conditional Columns

 Creating Custom Columns with M Functions

 Creating Columns from Examples

 Creating Index Column

 Creating parameters and using them in custom functions

 Creating Custom Functions and invoking them

 

MODULE 6: ADVANCED VISUALIZATION IN POWER BI

  Getting data in Power BI Data Visualization

  Bar chart, Area Chart, Stacked Area Chart, Line vs Column Chart

  Creating Pie, Donut, Guage Chart, Funnel, Ribbon Chart

  Creating a Maps

  Creating a Single Card for text, date, and numbers

  Creating multi-row card for text, date, and numbers

  Creating a decomposition tree

  Creating a Table and Matrix

  Conditional formatting of Table and Matrix

 

MODULE 7: ENHANCE POWER BI REPORTS

   How to format each element of charts like Legends, Title, Background, Border X  Axis, Y Axis, Secondary Axis, Data Labels

   Conditional formatting to charts

   Customized Tooltip



Pre-Requisites

BASIC COMPUTER SKILLS: You should have basic computer skills such as using a mouse, and keyboard, and navigating around a computer. This includes file management skills such as creating, saving, and opening files.

 

FAMILIARITY WITH MICROSOFT OFFICE: Power BI is a Microsoft tool, so it's helpful to have some experience with Microsoft Office tools such as Excel and PowerPoint.

 

BASIC DATA ANALYSIS SKILLS: Some basic knowledge of data analysis concepts such as data types, data structures, and data visualization can be helpful.

 

BASIC PROGRAMMING SKILLS: Some knowledge of programming concepts such as loops, conditional statements, and variables can be helpful. However, this is not always necessary for beginner courses.

 

A WILLINGNESS TO LEARN: Most importantly, a willingness to learn and practice is essential to successfully complete the course and become proficient in Power BI. 






Target Audience

Any commerce Graduates & Post Graduates (BBA, BCOM, BBM, MCOM), Non-Commerce Graduate or Post Graduate (BSC, Engineers, B.E., B. Tech, M.E., After MBA or During MBA, CFA or any degree in Finance, MBA/CFA/CA Aspirants, CPAs, ICWA, CS, Back office/operations working professionals, accounting working professionals, KPOs/BPOs professionals, Financial Analysts, Business Analysts, Startup founders, Bankers, Financial Controllers, CFOs, CEOs, Fund Managers, PE Fund Managers, Account Receivables (AR), Accounts Payables (AP), Record To Report (R2R), Reconciliation background professionals, housewives after a long gap of marriage or kids to make a career in the Finance field, Businessman / Entrepreneur.


Research Companies

.

Course Content


  • 39 sections
  • 211 lectures
  • 17h 24m total length

Browse All Courses

TRENDING


4.7

Financial Planning & Analysis (FP&A)

<p class="MsoNormal" style="text-align: justify; "...

52970

41224



Financial Planning & Analysis (FP&A)

DURATION : 4.5 months

ACCESS : Lifetime

ELIGIBLE FOR : Completion Certificate

COURSE FEE : 30000/-

TRENDING


4.7

Excel Expert

FINXL Advance MS Excel program empowers the partic...

6341

2039



Excel Expert

DURATION : 30 Hours

ACCESS : Lifetime

ELIGIBLE FOR : Any graduate

COURSE FEE : 3000/-

TRENDING


4.7

Financial Analyst

<div><span style="font-family: Arial; font-weight:...

90673

25718



Financial Analyst

DURATION : 12 Mns. on Job Training

ACCESS : Lifetime

ELIGIBLE FOR : BCom, BBA, BMS, BE, BSC,, BA, CA, CFA, MBA

COURSE FEE : 199000/-

TRENDING


4.7

Investment Banking (IB)

<p style="text-align: justify; "><span style="font...

7456

9864



Investment Banking (IB)

DURATION : 4.5 months

ACCESS : Lifetime

ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA, BBA, Mcom

COURSE FEE : 30000/-

TRENDING


4.7

Financial Modelling & Equity Research (FM&ER)

<span style="color: rgb(0, 0, 0);"><span style="fo...

10052

1291



Financial Modelling & Equity Research (FM&ER)

DURATION : 4 MONTHS

ACCESS : Lifetime

ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA

COURSE FEE : 20000/-

TRENDING


4.7

Microsoft Power BI

<p class="MsoNormal"><b><span lang="EN-IN" style="...

30318

25154



Microsoft Power BI

DURATION : 24 Hrs.

ACCESS : Lifetime

ELIGIBLE FOR : Any professional , fresher Students

COURSE FEE : 10000/-

 Enquiry