Power BI Training

Excel Next Provides Power BI Classroom Training / Power BI Corporate Training in Mumbai, Delhi-NCR, Gurgaon, Chennai, Bangalore & Pune.

Power BI is a business analytics service provided by Microsoft. It is an amazing Tool with self-service business intelligence capabilities, very helpful for the Data Scientists. If you’re fond of Big Data, Data analysis, statistics and Project Management, Power BI multiplies your chances to flourish and achieve expertise in these fields easily.

Power BI is one of the components of the umbrella which also has Power Pivot, Power Query, Power Map and Power View.

Enquiry For Corporate Training:  +91-8080042523

Power BI consists of in-memory analysis technology along with DAX scripting language, both are absolutely an eccentric showcase of balance between simplicity and performance.

With Microsoft Power BI Certification, you’ll be able to analyze and Visualize Report Data. This helps in making effective and right Business decision. You’ll get to see this in the Power BI Classroom Training.

Now Become Power BI Certified with our highly certified and professional trainers at Excel Next. Power BI Training in Bangalore, Mumbai, Delhi, Gurgaon, Chennai, Bangalore, Hyderabad & GOA.

We offer training courses to learners, companies and consultants so that they can meet all the challenges they face while dealing with their respective technologies.

Few of our reassuring clients are Exl Service, Flipkart, Wildcraft, PWC, Tata Motors and Consulates of Canada where we provide Training on Regular basis.

In Power BI Training, we are delighted to help you master the concepts about

  • Power BI Desktop
  • Power BI Embedded
  • Power BI Map
  • Power BI DAX
  • Power BI SSRS
  • Power BI Integration
  • Power Pivot for Data Modelling.

If you’re a Business Intelligence Professional, choosing Power BI would be the best decision of your life. The entire session is carried out by Power BI Working Professionals offering 100 % Quality Assurance.

Power BI Course Outline (Level 1 to 2)

Program Name: Power BI Desktop
Software Application: Microsoft Power BI Desktop
Level: Beginner to Intermediate (Level 1 to 2)
Duration: 2 days

Introduction:

Note: This program is ideal for Beginners / 1st time users, who aim to use Power BI to make visually rich and insightful dashboards.

  • Self-Evaluation Checklist (3-mins.) – Advanced Excel and Power BI features
  • Showing a Demo of the final Dashboards
  • Excel mindset vs. Power BI mindset (Ref: Case Study – 3y sales)
  • Relationship between Excel, Power BI Desktop and Power Query
  • Fast Recap of selected Excel Tricks: FlashFill, Pivot Table, VLOOKUP & Limitations, Fill Blanks
  • Exploring Power BI Interface: Report (Dashboard), Data (Tables), Relationships
  • Importing Data
  • Data Preparation for Power BI Visualisation (ref: Case Study – 3y sales)
    • Column formatting – excess characters, concatenation, split text, case, trim, clean
    • Remove blank rows, duplicate rows
    • Use first row as headers
    • Unpivot Columns to convert Crosstab data set to columnar table
    • Fill down – to fill cells values to neighbouring empty cells in the selected column
    • Choosing the right Data Type – Nos. vs. Text vs. Date
    • Overview of M-Query language (View > Formula Bar)
    • Generate the full list of M-Query commands
    • Applied Steps – How to interpret it and use it
  • Column from Examples (~FlashFill) = Programming by Example (PBE)
  • Basic Overview of Power BI Visual Dashboard
  • What is a Data Model?
  • Data Tables (FACT or Transactions Tables) vs. Lookup Tables (DIM or Master Table)
  • Database Normalization: Concepts & Rules (1NF, 2NF, 3NF)
  • What is Denormalization?
  • Key Types: Primary, Foreign, Composite
  • What are Table relationships?
  • Table Relationship Concepts:
  • Relationship Cardinality – Uniqueness of Values in Columns
    • One to Many
    • One to One
    • Many to Many
  • Relationship vs. Merge Queries
  • “Snowflake” Schemas vs Star Schema
  • Merge Queries vs Append Queries
  • Relationship vs. Merge Queries vs. RELATED DAX
  • Merge Queries with multiple JOIN types –
    • LEFT, RIGHT, INNER, OUTER; ANTI
    • Example 1 – Wedding Invitation – Invitees vs Present
    • Example 2 – Own Mfgd Catalog vs In-Stock items (own + agencies)
  • Append Queries:
    • Merge multiple CSV files from a Folder with auto-refresh option
    • Merge multiple CSV files vs. XLSX files from a Folder
    • Merge multiple XLSX files from a Folder with auto-refresh option
  • Power Query features are CASE SENSITIVE
  • What is DAX?
  • Calculated Columns & Measures
  • Implicit Measures (Drag-Drop existing fields) vs Explicit Measures (DAX)
  • New Measure or New Column – Which one to use when?
  • Evaluation Context = [Filter + Row] Context
  • Why create a measure for a simple thing as SUM?
  • Basic – SUM
  • Basic – Unique Date Table Concept – Using two DAX functions i.e. CALENDAR and DATE
  • Basic – CALCULATE, DATEADD (compare sales of different periods)
  • Basic – DISTINCTCOUNT (unqiue customers, products etc.)
  • Basic – COUNTROWS (total transactions)
    • (Showing results in Power BI – Table to help understand validity of answers)
  • Measures – Right click – Properties > Desc. (documentation)
  • Essential Formatting settings: Color, Data Labels, Axis, Placement, Legends, Value
  • Table View vs. Matrix View
  • Conditional Formatting in Table View
  • Basic Charts: Line, Bar Chart, Column Chart, Treemap, Pie, Doughnut, Area
  • Tooltips – On hover Text
  • Color Saturation in Column Chart
  • Slicers: Vertical list vs. Horizontal tiles
  • Text Cards
  • Date Slicers (Year)
  • Ask a Question (Natural Language) – just type what you want with specific key terms
  • Conditional Columns: Writing multi-layered IF conditions
  • Segmentation: Use “Group By” to calculate aggregated calculation based on clusters
  • Segmentation: Use “Binning” to categorize values into equally sized groups
  • KPI & Gauge Chart
  • Time series Visuals (Multi-line, Ribbon, Animated Bubble, Forecast, Trend-line)
  • Map Visuals
    • Preview Features > Shape Map Files > Activate this map by putting some Values (Saturation)
  • CustomVisuals – Downloadable Charts
  • Control Report Interactions (Controller vs Controlled)
  • Understanding Hierarchies and Adding Drill-Down
  • Use Drill down/up feature to specify chart behaviour – granular view
  • Show/Expand next level
  • Filter level: Report level vs Page level vs Visual level
  • Extra Case Studies
  • View > Selection Pane > Eye sign (Visible vs Hidden)
  • TopN feature (in-built)
  • TOTALYTD
  • DATESYTD
  • ALL
  • FILTER
  • DISTINCT – Create Table of Unique values ~ Remove Duplicates
  • Capturing data from Tables in a PDF
  • Column Profiling (Data Quality Preview)
  • Fuzzy Merge (connecting same data with spelling differences) – E.g. Rajeev vs Rajiv, Pvt vs Private
  • Pulling data from the web (e.g. MF NAVs) with single-click refresh feature
    • Add to Data Model to generate Pivot Table (as Query and not as Table)

Power BI Course Outline (Level 3)

Program Name: Power BI Desktop
Software Application: Microsoft Power BI Desktop
Level: Beginner to Intermediate (Level 3)
Duration: 1 day

Introduction:

Note: This program is ideal for users who have completed our 2-days workshop and spent handson practice after the workshop. 

  • CROSSJOIN
  • FastTrack Recap of L1 & L2 concepts
    • (IMPORTANT: This recap session can stretch to 120 mins. if participants have not done hands-on
      practice after the 2-day workshop)
  • M-Query language Case Studies – ERP Data, Budget Sheets, Financial Statements
  • Section 9 of Power BI (L1 & L2) workshop if not completed before
  • TOTALYTD
  • DATESYTD
  • ALL
  • FILTER
  • DISTINCT – Create Table of Unique values ~ Remove Duplicates
  • FORMAT (~ TEXT in Excel)
  • Deep-dive: CALCULATE with ALL
  • Deep-dive: CALCULATE with FILTER
  • Deep-dive: CALCULATE with other DAX functions
  • RELATED vs. RELATEDTABLE
  • TOPN
  • RANKX
  • SUM vs SUMX
  • MAX vs MAXA
  • SUMMARIZE
  • CROSSJOIN
  • Using Variables (VAR)
  • ALLEXCEPT
  • HASONEVALUE
  • Other Date & Time Intelligence DAX – DATESBETWEEN, SAMEPERIODLASTYEAR etc.

Use-cases in Power BI Visualization

Top Benefits of Power BI Training:

Power BI lets you:

  • Encounter and Visualize Data. Transforms your enterprise data into rich visuals without depending upon any information from technology staff or database administrator
  • Make new Discoveries and learn Effective ways to analyze your Data and meet your Business Goals
  • Furnishes intuitive representations that suffice with the business knowledge capacities
  • The Crowning Feature of Power BI helps you in making Dashboards. You get to Customize it the way you want to. Easy Embedding of the dashboards with the BI reports in the applications. This will provide a unified user experience
  • Extracting business intelligence information rapidly and accurately which helps in enhanced decision making
  • Get the access to your information and Report whenever you wish to using Power BI Mobile applications. It refreshes naturally with any progression to your information
  • Publishes reports securely allowing all the users to avail the most updated information
  • It has the capacity to load custom representations

We focus on providing in-depth course material which has Real Time Scenarios of each topic with its Solutions for Power BI Online Training.

Get your session Scheduled based upon your comfort with the Highly Qualified Trainers and Real-time Experts of Power BI.

Get in touch with Excel Next and master the Power BI Training Online

We deliver Microsoft Power BI Training in Delhi, Mumbai, Pune, Bangalore, Chennai and also in Goa India.

Get to know your cheerful team of enthusiasts who’ll love to train you and make you a Power BI Expert. Whether you’re looking for customized onsite Microsoft Power BI training for a private group or for an Instructor-led online Training, Excel Next would be the Best.

Request Callback

how can we help you?

Drop Email For Corporate Excel Training Across India

Company Profile

“We had endorsed services of Rishabh Pugalia last month for a learning group within the Tata Sky Customer Operations team. His feedback from the learner group has been fantabulous where they found his courseware easy to grasp and retain, trainer skills great and the overall program design relevant to their work area”

Swati Saha Gosh
Lead-Training, Tata Sky