fbpx

MICROSOFT POWER BI WORKSHOP FOR PROFESSIONALS

Come and join us on Sep 15th 2018

Time: 9:30 AM – 5:30 PM

Venue: Marol, Andheri East, Mumbai

FOR ENQUIRY

Call: +91-91678-47797
Email: [email protected]

Add to Calendar
09/15/2018 09:30 AM
09/15/2018 05:30 AM
India/Mumbai
Microsoft Power BI Workshop
Finance For Non-Finance (1 Day), Sep 15, 2018
Marol, Andheri (East)
Enquiry: Call: +91-91678-47797
Email: [email protected]

What is Microsoft Power BI?

Power BI is one Big Umbrella of Data Visualization Tool which is also termed as a cloud-based data analysis. It is used by the business analysts and power users of BI. A simple and User-Friendly Tool which helps in reporting and for data analysis from wide range of data sources.

Power BI 001

You can visualize and Customize your data using great range of data visualization elements which helps in providing support to the story behind the Data.

Power BI helps you connect with many Data Sources. The on-premises as well as Azure/cloud-based data sources. It has a very powerful data mash up engine where you can mash up the data as per your wish. With Power BI, you’ll be able to Model the Data, measures and calculated columns and you’ll be able to: build your star schema with the help of the in-memory Super-Fast Engine.

MICROSOFT POWER BI (1 DAY)

Workshop Details

Venue: Marol, Andheri (East)
Date: Sep 15, 2018| Time: 09:30 AM – 5:30 PM
Fees: 4,720 INR including GST (Lunch incl.)
Discounts: EARLYBIRD (
20% off if registered by 7-Sep-2018)

Watch Our Demo

Quick Walkthrough

  • Core Views of Power BI
    • Demo with a simple data set and exploring the user interface
  • Power BI Workflow
    • Demo with a simple data – 1. Connect, shape and transform raw data 2. Build table relationships to tie sources together 3. Design interactive reports to explore and visualize data
  • Data Model Basics
    • Connecting multiple Tables using Primary Key
    • Making a Pivot Table report
    • RELATED() DAX function vs Excel’s VLOOKUP() function
    • Remove duplicates to make One-to-Many relationship
    • 2D Lookup using Many-to-Many relationship through Merge Query
    • Create a Basic Visualisation

 

Power BI 004

Transformation

  • Basic of Data Transformation
  • Fill Down, Text to Columns, Change Cases, Format
  • Data Table Transformation: Unpivot Columns
  • Make the Data set Pivot Table friendly

Picture3Data Blending

  • Snowflake Schemas
  • Connecting multiple Tables
  • Merge Queries vs. Append Queries
  • Join Types – Basic Examples
  • Merge Queries
  • Many-to-Many relationship i.e. 2 or more variables
  • Append Queries
  • Multiple files in a folder (automatically)

Pre-requisite:

Concepts of Excel: VLOOKUP, MATCH, SUMIF, PIVOT TABLE, CHARTS

Who is this Program for:

1. Build & Automate Interactive Visual Dashboards

2. Update themselves with Microsoft’s BI (Business Intelligence) Application

3. Learn the best of MS Power BI Technologies in one day

Instructor

Picture1

Instructor: JK Nair

  • Regularly trains professionals at PwC, EY, ITC, Tata Motors etc.
  • He Taught 25,000+ Corporate professionals
  • 7.5+ yrs. of work experience in IT Training & Consultancy

Fill the Form For Enquiry

and we will get back to you.