Need Help? Chat with us

Power BI Training in Delhi, Gurgaon, Noida

Excel Next conducts an Extensive Training Program on Power BI. Power BI brings to you an introduction and also the glimpse of the World BI.

In the Training session organized by Excel Next on Power BI in Delhi, you’ll get to learn about Power BI desktop, how you can connect your Data with the help of Power BI Desktop.

The most important part is to Visualize the Data. This helps to derive useful insights for the Business. There are many Tools using which you can Visualize the Data.  Power BI out of all is the one which stands out. It has helped many Organizations to Transform its Data into Rich Visuals. It gives Transparent views about the Working of the Business letting users pay proper heed to the insights.

The Transformative Visuals from Power BI Application is accessible to all the Team members of the Organization. It helps them keep Updates and take decisions keeping the Organization’s Goal in their Mind.

In the Corporate Training Session of Power BI, you’ll learn, ‘How to share and collaborate your data with Power BI, what is Power BI Data Analysis Expression (DAX), and what are its functions?

Power BI is a pure Business Analytics Tool which imparts skills and Knowledge.

Enquiry For Corporate Training:  +91-8080042523

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

Why choose Excel Next for Power BI Training?

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

Excel Next is Popularly known for delivering Microsoft Power BI Training in Delhi, India.

It is also famous for delivering Corporate Training in Mumbai, Delhi, Gurgaon, Chennai, Bangalore, Kolkata & Pune.

In our Corporate Training Session, Meet our Experts from the industry. Get Power BI Certification and give your career a Boost.  Our Trainers will help you get a better knowledge about the essential components of Power BI.

These components include: Exploring the Data with Dashboard, Publishing and sharing the Data. DAX functionality, Modelling and Visualizations.

Few of the reassuring clients of Excel Next are: Exl Service, Flipkart, Wildcraft, PWC, Tata Motors and Consulates of Canada in Bangalore where we provide Trainings on Regular basis.

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

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.

Don’t waste any more time and schedule your Corporate Training with Excel Next Now.

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