Over View

This three-day instructor-led course provides students with the knowledge and skills analyze data with Power BI. Because this is a Microsoft-developed and authorized course, organizations can use Software Assurance Vouchers for payment.
Prerequisites

This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Familiarity with Microsoft Office applications – particularly Excel.
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Querying Data with Transact-SQL

At course completion

After completing this course, students will be able to:

  • Describe key features of a self-service BI solution
  • Describe Power BI and its data sources  (Import data)
  • Shape, and combine data (Power Queries)
  • Modeling Data(Relationships, DAX)
  • Interactive Power BI data visualizations
  • Managing and Sharing your work
  • Managing Roles

 

MS Power BI Course Content

1) Overview of Advanced Excel

(1.1) Lookup Functions

  • Vlookup Functions
  • HLookup Functions
  • Match & Index Functions

(1.2) Pivot Table

  • Creating Pivot Table
  • Working with calculated field
  • Working with Slicers and timelines 

2) Introduction to Power BI Desktop, Accounts, BI Service

(Introduction to Self-Service BI Solutions)
In this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution. 

  • Overview to Power BI
  • Power BI Desktop
  • Power BI Website
  • Difference between Microsoft Business Intelligence (MSBI) and MS Power BI
  • Introduction to Power BI Components : Power Query, Power Pivot, Power View, Power Map
  • Installing Power BI, BI Service
  • Create Power BI account
  • Download and install Power Pivot Add-ins, Power Query Add-ins, Power View Add-ins, Power Map Add-ins.

3)Power Pivot for Data Modelling Using Excel Add-ins

(3.1) Understanding Power Pivot

  • What is Power Pivot
  • Why use Power Pivot
  • Excel versus Power Pivot
  • Installing Power Pivot add-in
  • Pivot Table Examples with Excel Data
  • Power Pivot Examples with a Data Model

(3.2) Working with Data

  • Working with an Excel List
  • Working with an Excel Table
  • Cleaning up Tables

(3.3) Importing Data into Power Pivot

  • Understanding Acceptable Data Types
  • Adding Excel Tables to Power Pivot
  • Importing Access Tables
  • Saving the File

Adding and Maintaining Data in Power Pivot

4) Introducing Power BI

  • Power BI Desktop
  • The Power BI service
  • Power BI mobile apps
  • Lab : Cresting a Power BI dashboard

5) Power Query for Data Transformation

(5.1) Introduction:

  • What is Power Query
  • Different versions of Power Query
  • Installing  Power Query
  • Interface

(5.2) Data Source

  • From Web
  • From Excel File
  • From Current Workbook
  • From CSV or Text File
  • From Folder
  • From Database (SQL)

(5.3) Combining Multiple Source

  • Multiple Excel Tables or Named Ranges
  • Worksheets not Correctly Formatted
  • Appending Queries
  • Merging Queries

(5.4) Transforming and Cleaning Data

  • Query Editor
  • Editing Queries
  • Calculations and measures
  • Working with DAX Functions
  • Data Types
  • Fixing Dates with the Locale Setting
  • Columns – Move, Remove, Rename & Duplicate
  • Splitting Columns
  • Merging Columns
  • Filtering Rows
  • Remove Duplicates & Errors
  • Sorting
  • Replace & Fill
  • Transforming Text & Numbers
  • Transforming Dates
  • Adding Custom & Index Columns
  • Adding Custom Calculated Columns
  • Adding Custom Date & Time Columns
  • Grouping
  • Unpivot
  • Transpose
  • Duplicating & Referencing Another Query
  • Parameter Table/Function

6) Interactive Data Visualizations
        This module describes Power BI visualizations.
Creating Power BI reports
Managing a Power BI solution
Lab :  Creating a Power BI report

7) Q&A
Understanding simplicity of Q&A

Examples of Q&A

8) Sharing your Work

  • Publish from Power BI Desktop
  • Dashboards in Power BI
  • Share a dashboard from Power BI

9) Schedule Refresh

  • Install Gateway
  • Types of Gateways
  • Loading to the Data Model or Power Pivot
  • Load Settings & Automatic Refresh
  • Schedule Refresh

10) BI Roles

  • Createing Roles
  • Managing Roles
  • Row Level Securities

11)Power BI Administration 

  • Creating Power BI Account with official ID
  • Deployment of files into Power BI website
  • Building dashboards in Power BI website
  • Mobile apps for Power BI on Apple, Android, and Windows Phone
  • Groups in Power BI
  • Creating Groups
  • A new workplace, Publish contents to group

 

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us

Enquiry Now..!!

Contact Details :

    Address: # 4110 Rainy Creek Ln, Cedar Park, TX, 78613, USA.

    Contact us: +1(772)777-1557

    Email ID: info@monstercourses.com

     

    Popular Courses We Offered :

     

    4110 Rainy Creek Ln, Cedar Park,

    TX USA, 78613.

    Phone: +1(772)777-1557

    Email : info@monstercourses.com

     

    We are very much benefited from Business objects online training program. Handouts are very useful and very nicely given so that at-least by seeing the handouts we can practice and get knowledge. We have been taught many topics from this Training, nice to getting trained from “MonsterCourses

    Govardhan Bhaskar….

    Vijay Naresh, Monster Courses

    I felt OBIEE online training was very informative as compared to other online training providers. The faculty of MonsterCourses are very efficient in their subject and gave quality training. They covered each and every topic clearly elaborated them with examples.

    Vinay K…

    Govardhan Bhaskar, Monster Courses

    The Training Classes what i have attended from MonsterCourses was quite beneficial.Good way of diving modules and covering important topics in each module. Overall the training from MonsterCourses was very good and useful to me.

    Vijay Naresh…

    Raju K, Monster Courses