What is Power BI and why you should learn it?

Power bi is a visualisation and analytics tool which helps you aggregate and present your data in the form of stories so the end users understand the data patterns and can make better data driven decisions in the business

In Today’s world, where time is money, Power BI allow users to quickly create and publish report which is instantly available for all users in the network. Big companies are moving on PowerBI to view dashboard. Power BI have huge job markets.

You will learn it all

Introduction

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Power BI vs. SSRS Report
  • Configure tools

Getting Started

  • SQL Query Syntax
  • Data Types
  • Joins
  • Inner Join
  • Left Join
  • Right Join Aggregates
  • Grouping

Creating Data Model

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Import data into Power BI
  • Transforming Data

Data Operations

  • Creating Relationships
  • Defining New Columns
  • Concatenating Columns
  • Performing Lookup
  • Translating
  • Adding Date Table

Enhancing Model

  • Defining Hierarchies
  • Configuring Properties e.g. Data Categories, Formatting
  • Creating Measures

DAX (Data Analysis Expression)

  • Introduction to DAX Functions
  • Types of DAX (DAX Calculations)
  • Working with DAX Studio
  • It All Begins With EVALUATE
  • EVALUATE Options
  • Controlling Query Row Output: The Basics
  • Controlling Query Row Output: More about Filters
  • Controlling Column Output and Grouping Basics
  • Controlling Output Grouping: More with SUMMARIZE
  • Special Output Needs: Cartesian Products
  • More Sophisticated Cartesian Products
  • Special Output Needs: Scalar Values
  • Working with Inline Measures

Building Dashboard

  • Visualizing Data
  • Adding Visuals
  • Filtering
  • Slicer Filtering
  • Highlighting
  • Setting Properties
  • Drilling within the Hierarchy

Publishing Dashobard Online

  • Publishing Data Sets
  • Refreshing Data
  • Power BI Mobile Apps
  • Using Power BI Gateway
  • Power BI Pro vs. Free
  • Publishing To Power BI
  • Setting Up Auto-Refresh
  • Securing Data

A Live Project

At this point, we will be doing one live with you. we will see some more advanced features when working on live project.

Duration : One Week – 2 Hours/Class

Method : TeamViewer Screen/Audio Share

Training Fee : Rs. 12000/-

Payment Option : Online/PayTM

Live Screen sharing

We do live screen sharing for our session for 40-60 minutes, that enable you to ask questions at the same time.

Session Video

We records entire session and send you for your practice reference.

On Job Support

We help you on your projects after completion of training.

Contact Now!!

1
×
Welcome! How can i help you?
Loading...