UrbanPro
true

MS Power BI Certification Training Course

LIVE
10 Hours

Course offered by Talent Magnifier

2 reviews

Power BI Desktop, Custom Visuals, Introduction to Power BI:- Power BI Component, Types of Reports in Real-time Usage, Power BI Tools and Implementation Plan Power BI Licensing and Excel Analytics. Power BI

Desktop Tool:-

  • Report Visuals, Fields, Pages and Filters
  • Data and Relationship Option, PBI Canvas
  • Get Data from DAT Files, Excel Files, Access Files
  • PBIX and PBIT Files And Re-Using Reports
  • Data Import Options Designing Simple / Basics Reports in PBI
  • Visual Interactions in Power BI - Options Spotlight Options with Visuals, Real-time Use
  • Slicer Visual in Power BI and Data Filters

Hierarchies & Filters:-

  • Grouping and Binning with Fields, Bin Size and Biz Limits (Max, Min)
  • Creating Hierarchies. Drilldown, Drill Up Reports
  • Filters : Types and Usage in Real-time, Conditional Filters, Visual Filters, Page Filters, Report Filters
  • Drill-thru Filters with Hierarchy Levels TOP N Filters – Usage Filtering at Category Level, Import and Direct Query with Power BI.

Power Bi Visuals:-

  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Data Bar and Data Scaling Options
  • Divergent Colors and Data Labeling Matrix : Sub Totals, Grand Totals
  • Row Groups and Column Groups in Matrix
  • Slicer Visual - Properties, Alignment Single Select and All Options
  • Chart Reports - Common Properties Axis, Legend Types- Stacked Bar, Column, Line charts Clustered Bar, Column, Line Chart

Power Bi Visuals with Different Types:-

  • Tree Map, Funnel and Gauge Reports, Map Reports
  • Single Row Card and Multi Row Cards
  • Callout Values in KPI Reports and Use, Indicator, Trend and Target Goals in KPIs
  • Using Buttons, Images in Power BI Canvas
  • Bookmarks in Power BI Desktop – Usage Using Bookmarks for Visual Filters

Module 4.2 - Data Modeling with Power Query Power Query Basic Operations:-

  • Power Query Usage & Operation Types, QUERY Concept, Properties, Validations
  • Power Query - Data Mash Up Operations
  • Basic Data Types, Literals and Values, Expressions
  • Primitives in M Language, Structured Data Values in Power Query
  • LIST, RECORD, TABLE, Connection Format Settings let, source, in statements in M Lang Functions, Parameters in Power Query
  • INVOKE Functions & Execution Results
  • Power BI Canvas: Edits, Applied Steps, Frowns, Query Header Row Formatting

Power Query Usage:-

  • Power Query Transformations Categories
  • Query Combine & Merge Transformations, Join Options In Merge Transformation
  • Truncate, Replace, Split, Reduce Rows, Manage Columns, Hide / Show Columns Grouping, Aggregations, Column Formats
  • Transpose, Reverse Rows Transformations
  • Power Query - Row Count And Replace, Data Type Detection - Scenarios, Use
  • Data Type Conversions And Value Replace Fill Up And Fill Down,Pivot And Unpivot Transformations
  • Move, Filter And Converttolist() Split, Format, Merge, Extract, Parse, Date,Time

Module 4.3 - Data Modeling with DAX DAX Functions: -

  • DAX as library of Functions, Types, Variables, Operators Dax Formula With Excel, Limitations
  • DAX Architecture and Entity Sets
  • Rules OF DAX, Working Options, Syntax, Functions
  • ROW Context and Filter Context, DAX Structures and Syntax Options
  • Creating and Measuring with DAX Creating and Using Columns with DAX

Advance DAX Functions:- 

  • Data Modeling Options in DAX, Detecting & Adding Relations for DAX
  • Power BI DAX Functions - Types, Usage, Cheat Sheet
  • Power BI Reports - DAX Functionalities Calculated Columns, Aggregated Measures
  • Quick Measures in DAX - Auto validations, DAX Performance Date and Time & Text Functions, Logical & Mathematical Functions
  • Data Modeling with DAX. Creating Roles
  • SELECTEDVALUE, FORMAT Functions RELATED, COUNTROWS CALCULATE, SUM, ALL
  • Report Development
  • Live Project Session

Gallery (6)

About the Trainer

4.5 Avg Rating

2 Reviews

3 Students

7 Courses

Talent Magnifier

B Tech, M Tech,

DATA Analyst at Corporate Industry. Having 15+ years exp. in MIS & Data Analyst in Different Industries. (IT, E-Commerce, Retail)

Students also enrolled in these courses

LIVE
20 Hours

Course offered by Lokesh Lalwani

548 reviews
LIVE
50 Hours

Course offered by Rohit Gupta

23 reviews
LIVE
3 Hours

Course offered by Gajanand

0 review
LIVE
15 Hours

Course offered by Pankaj Tiwari

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

MS Power BI Certification Training Course by Talent Magnifier

Abhishek picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

MS Power BI Certification Training Course by Talent Magnifier

Abhishek picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more