Power BI - Data Visualization & BI

Fortune Business estimates that the global data visualization market size stands at USD 8.85 billion in 2019 and is projected to reach USD 19.20 billion by 2027, exhibiting a CAGR of 10.2% during the forecast period.

Microsoft wants to seize this large market and has created a data visualization and business intelligence tool which is better known as Power BI. This is a business intelligence platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool that requires little upfront training.

More more that 10 million jobs require knowledge of Power BI in the management world. The digital transformation that has taken place during the Covid lockdown has accelerated the process of automation. It is not a surprise, therefore, that marketing, finance, and operations roles are asking for management graduates who are trained on Power BI.

USP of this Course

Guaranteed Internship

Learn from faculty who have experience in Data Visualization using Power BI

Live Project using Power BI

One-on-one mentoring from faculty

Career Support

Applications

Data visualization in marketing, operations and finance

Use Power BI to generate Business Intelligence

Create a storyboard for managers, venture capitalists, investors etc.

Course Content

Module 1:

Connecting to excel and different data sources

Data Types

Basic formatting and charting

Basic reporting with different charts (Bar, Line, Scatter)

Report Formatting – colour, size, font

Module 2:

Query Editor and M query

Clean up and transformation in Power Bi desktop

Transform, Combine, Manage Rows & Columns, Pivot Columns,

Data Type Transformations, Data Quality, Distribution and Profiling

Merge and Append Query

Create calculated & conditional columns

Module 3:

DAX functions

Working with basic functions of DAX – MIN, AVG, MAX, DIVIDE

Creating measures using DAX functions

Advanced DAX functions CALCULATE/CALENDAR/FILTER/SUMMARIZE

Time Intelligence functions

Module 4:

Introduction to relationships (Star Schema and Snowflake Schema)

Working with AI charts in Power Bi

Advanced filters – Drill through, Report, Page visual levels, Row Level Security

Guest Lectures

Industry veterans’ former students of EdLightened would share their experience in the industry. This will be an opportunity to ask questions and network with experience professionals.

Evaluation

Live Project will be provided and evaluated by CXOs. Our CXOs have been in data visualization and power BI for many years and have mentored many professionals and students.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 12 hours to complete. 

Pay the registration fees and you will get registered.