New Excel skills for New Jobs

Excel to Power BI Ninja

Learn everything advanced in Excel from Dashboarding to Data Visualization. Take the Power BI Live ‘Online Training and learn all the Ninja Techniques.

  • Live Lessons = 16 Hrs
  • Lab Session = 12 Hours
  • Completion Certificate
  • Projects = 8

Online Live Training Power BI

Live Training Details:

Date

Duration

Price

Details

Nov 22 – Dec 22
Every Wed-Thu

19:00 – 21:00 IST
06:30 – 08:30 PST

$ 299

Nov 17 – Dec 05
Every Sat-Sun

19:00 – 23:00 IST
06:30 – 10:30 PST

$ 349

Looking out for a convenient schedule?

Take our expertise help to help yourself find a Batch. It will help you find a batch that meets your needs

DEMO SESSION PREVIEW

Course Description

What are the objectives of our Power BI Live Online Training Course?

Microsoft Power BI Live Online Training by Yoda Learning is an Instructor-Led Program. It will be managed by Professionals industry experts to help you become a Certified Power BI Practitioner. Microsoft Power BI Live Online Training will help you to:
1. Describe Power BI Desktop and Power Query
2. Discuss Power BI, Power Pivot, Power View, Power Map
3. Explain Data Visualization and work on Custom Visualizations
4. Learn about how to Work on the Data and how to enhance Data Models
5. Learn to answer Power BI Q&A and Data insights
6. Discuss Power BI Embedded
7. Importing Data with Power Query
8. Analyzing Data with Power View and Power Map
9. State Power BI Administration
10. Create real-time dashboards
11. Learn Dax
12. What is Power BI Service
13. Publish reports/dashboards and share them with others
14. Directly connect to Azure SQL, HD Spark, SSAS
15. Integrate Power Bi with Azure ML
Not just this but you get to learn a lot with Power BI Course.

Who needs Power Pivot and Why?

People that need this tool are typically Microsoft Excel users/report authors that analyze or report on data,
particularly when the following conditions apply:

  • There are lots of data that stretch the capacity of traditional Excel (file size, re-calculation speed etc.) If you
    use Pivot Tables a lot to analyze your data.
  • If you are writing a lot of VLOOKUP (or INDEX/MATCH) formulas to join data from different tables so you
    can analyze in a Pivot Table.
  • If you have had to create bespoke reports in traditional Excel, but then have to spend hours rebuilding the
    report when asked for a different view of the data (e.g. you have a report that shows sales by half year, and
    then you are asked to produce the same report by month – and have to start again almost from scratch).
  • Anyone that wants to start using Power BI for anything more than the most simple aggregation reports.
    The “out of the box” capabilities of data modelling in Power BI are limited, and you will quickly realize that
    you need to learn some new skills (Power Pivot/DAX) to be able to leverage the strengths of Power BI.

Who needs Power Query and Why?

People that need this tool typically are trying to solve the following problems:

  • They regularly receive file extracts from someone (or some system) and need to manually manipulate
    this data before they can use it.
  • They want to use Power BI/Power Pivot but can’t get the IT department to shape the data they need
    prior to loading it into Power BI/Power Pivot.
  • People that are doing repetitive tasks such as matching invoices on a remittance advice against a bank
    statement (or similar) – Power Query eats this kind of work.
  • Anyone that is given data in the wrong shape (example below). And yes I quickly used Power Query to
    un-pivot the data in the blue table so it looked like the green table. It is worth getting and using Power
    Query just to get this un-pivot feature alone!
  • Who needs Power BI and why?

    Power BI will add value to people who:

    • Have problems sharing reports with others because the file size is too large.
    • Need to share data with people on the go, that maybe only have a Tablet or a Mobile phone.
    • Have large data sets that can’t be managed in traditional Excel.
    • Are spending too much time each week/month manually maintaining reports with new source data
      and/or new visualization requests.
    • Can’t get the (timely) support they need from their IT department using traditional Enterprise BI tools.

    Why should you go for Power BI Live Online Training?

    In this Power BI Live Online Training, you’ll learn simple report creation, and fast publishing to the Power BI service. It can even be integrated with various popular and widely used Microsoft business tools like Microsoft Excel, Azure, and SQL Server.

    Power BI Live Online Training will help you create stunning interactive reports you can share with wide audiences. Power BI Training will make you an expert at disseminating information in the easiest possible way. This is done by extracting insights and creating stunning visualizations and interactive dashboards. The interactive Reports provide a consolidated live view of where your enterprise is and how is its performance going. If you were born with the heart of an analyst, Power BI Desktop delivers a free-form canvas using which you can drag-and-drop. This is for data navigation and for creating extensive library of interactive visualizations.

    What are the skills that you will be learning with our Power BI Live Online Certification Training?

    With this, Microsoft Power BI Live Online Training you can become a Power BI expert. Learn and get your hands-on experience in solving real-time industry-based Power BI projects

    The Power BI instructor-led Training will help you to:
    • Learn Data Visualization and Integration the most efficient way
    • Learn Power Pivot, Power View, Power Map etc.
    • DAX Data Analysis Function
    • Make your own Custom Visuals
    • Perform Data Binding and Formatting
    • Master Power BI Embedded and Workspace Collection
    • Create attractive Dashboards Power BI content packs for a large number of applications
    • Do consistent analysis across your organization

    How will Power BI Live Online Training help your career?

    The Microsoft Power BI Live Online Training at Yoda Learning is for enthusiastic professionals who are crazy about business intelligence, data analytics and data visualization.
    Power BI Live Online Training opens Multiple Career Options for the Professionals such as:
    1. Business Analysts
    2. Business Intelligence Manager
    3. Data Scientists
    4. Project Managers
    5. Statisticians and Analysts
    Whether you’re a Beginner or an Expert Power BI Live Online Training is for everyone.

    Program Objectives

    Supercharge your analytics and reporting skills with Microsoft’s dynamic family. Designed to handle huge volumes of data, these tools will transform the way you work! Four Days in our class and you are EMPOWERED!

     Not just the “hard” skills, but also the “soft” stuff (when and why to use it, how to get the best results for your organization, etc.)

    ✓ Learn Microsoft’s secret weapon behind Power Pivot & Power BI: DAX

    ✓ 
    This class will teach you how to connect to all of your data (no matter where it lives), shape it so DAX can run automagically, and have your computer remember the steps so you never have to do it again


    ✓ 
    You don’t need to be an IT professional – most of our students come from an Excel background

    Don’t know about Power BI?

    Yoda Learning’s eBook comes with basic guidelines & Installation steps for People to get familiar with Power BI

    BONUS

    Enroll and Check out the Unexpected Bonus coming with Power BI Live Online Training

    Advanced Excel Course Online

    BONUS #1 Excel Ninja

    •  Lessons = 177+ (11 Hrs)
    •  Lifetime Access
    •  Lifetime Support
    •  4.8/5 Rating

    Price: $̶9̶9̶  FREE| Download Curriculum

    Excel VBA Tutorial Course Online

    BONUS #2 Excel VBA Tutorial

    •  Lessons = 127+ (8 Hrs)
    •  Lifetime Access
    •  Lifetime Support
    •  4.9/5 Rating

    Price: $̶9̶9̶ FREE | Download Curriculum

    Excel Modeling Course

    BONUS #3 – Excel Modeling

    •  Lessons = 20+ (2 Hrs)
    •  Lifetime Access
    •  Lifetime Support
    •  4.7/5 Rating

    Price: $̶9̶9̶ FREE | Download Curriculum

    Excel Dashboard Course Online

    BONUS #4 – Excel Dashboard

    •  Lessons = 111+ (6 Hrs)
    •  Lifetime Access
    •  Lifetime Support
    •  4.7/5 Rating

    Price: $̶9̶9̶ FREE | Download Curriculum

    Power BI PRE Live Training Videos

    BONUS #5 – Pre-Live Training

    •  Tips & Tricks
    •  Basic Use of PowerBI Desktop
    •  Data Transformation
    •  Data management

    Price: $̶1̶5̶ FREE

    PowerBI Ebook

    BONUS #6 – PowerBI Ebook

    •  Tips & Tricks
    •  19 Practice File
    •  Download & Install
    •  Data management

    Price: $̶3̶5̶ FREE

    Excel Ninja $99 + Excel VBA Tutorial $99 + Excel Modeling $99 + Excel Dashboard $99 + Pre Training Video $15 + Post Training Video $15 + Power BI eBook $35 on Power BI Live Online Training

    Total Worth = $461 (Absolutely FREE)

    Curriculum

    What you'll learn in Live Training

    Module 1: Introducing PowerPivot

    • PowerPivot overview
    • Understanding corporate and personal BI
    • Understanding PowerPivot models

    Introducing PowerPivot for Excel

    • Lab 1: Creating a basic PowerPivot model
    • Introducing PowerPivot for SharePoint
    • PowerPivot usage scenarios and limitations
    • Lab 2: Sharing PowerPivot models

    Module 2: Working with Data

    • Importing from relational data sources
    • Importing from multi-dimensional data sources
    • Lab 1: Importing data from databases
    • Importing flat files
    • Importing from Excel
    • Copying and pasting data
    • Importing from reports and data feeds
    • Lab 2: Importing from other data sources

    Module 3: Enhancing the Data Model

    • Understanding PowerPivot data types
    • Performing column operations
    • Lab 1: Working with columns
    • Understanding table relationships
    • Understanding data refresh
    • Lab 2: Working with relationships

    Module 4: Analyzing Data

    • Understanding PowerPivot data analysis
    • Understanding PivotTable and PivotChart
    • Understanding PowerPivot Field List
    • Lab 1: Creating PivotTable and PivotChart
    • Reports Understanding slicers
    • Handling metadata issue and changes
    • Using other Excel features
    • Lab 2: Implementing dashboards
    • Working with dates, hierarchies, and perspectives
    • Lab 3: Implementing enduser features

    Visualizations

    • Create Simple Visualizations
    • Combination Charts
    • Slicers
    • Map Visualizations
    • Tables & Matrix
    • Scatter Charts
    • Waterfall & Funnel Charts
    • Gauges & Single Number
    • Cards
    • Styling the Visualizations
    • Categories with no Data

    Module 5: Data Analysis Expressions (DAX)

    • Understanding Data Analysis Expressions
    • Understanding row and filter context
    • Understanding calculated columns
    • Lab 1: Implementing calculated columns
    • Understanding measures
    • Understanding measure functions
    • Lab 2: Implementing measures and KPIs

    Module 6: Publishing and Managing PowerPivot Models

    • Understanding PowerPivot for SharePoint
    • Publishing to SharePoint
    • Viewing published models
    • Lab 1: Publishing models and authoring reports
    • Managing data refresh
    • Understanding PowerPivot Management
    • Dashboard
    • Lab 2: Managing PowerPivot models

    Module 7: Importing Data with Power Query

    • Introducing Power Query
    • Understanding Power Query elements
    • Viewing published models
    • Lab 1: Importing and transforming data
    • Understanding query sharing
    • Discovering queries
    • Demo: Sharing and discovering queries

    Module 8: Analyzing Data with Power View and Power Map

    • Introducing Power View
    • Understanding Power View visualizations
    • Understanding Power View filtering options
    • Implementing Power View reports
    • Introducing Power Map
    • Preparing geospatial data
    • Understanding Power Map

    Module 9: Introduction to Power BI Service

    • Sign up for Power BI Service
    • Parts of the Power BI Service
    • Datasets
    • Reports
    • Dashboards

    Project

    Project #1Industry/Domain: Multiple Industries / Finance

    Industry/Domain: Multiple Industries / Finance
    Description: Use Top 25 Power Query features to transform data and make it analysis ready.
    Actions Performed (indicative list):
    a) Unpivot Column
    b) Transpose
    c) Fill Down
    d) Merge / Append Queries using Join concept
    e) Column by Examples
    Level: Intermediate
    Duration: 4.0 hrs.

    Project #2Industry / Domain: Multiple industries / Domains - IT, HR, Finance, Sales

    Description: Explore when to use which chart. The nature of data (comparison, volume, trend, part of whole, lifecycle etc.) will decide the visualization strategy. Each chart type in Power BI is accompanied with customization settings. Some are common across all the charts and some are E.g. Set a pointer in the Gauge chart
    Learn how to Import a Power BI Custom Visual. Custom visuals are created by developers, using the custom visuals SDK, to enable business users to see their data in a way that fits the business best.
    Actions Performed:
    a) Exploring multiple charts, their customization settings and use cases
    b) Import new types of charts (custom visual)
    Level: Intermediate
    Duration: 2.5 hours

    Project #3Industry/Domain: Consulting/HR Survey Response Data (Last year vs. Current year)

    Description: Employees of a consulting firm have been asked to fill up a survey form of 150+ questions. The data will be in a cross-tab format (e.g. Google Form). The data must be transformed to columnar format for easy analysis and visualization. The responses will be compared with that of last year.
    Actions Performed:
    a) Using Power Query features clean & transform the data sets
    b) Connect two table sets using Relationships and snow-flake schema
    c) Create Dashboard in Power BI
    Level: Basic to Intermediate
    Duration: 1.0 hour

    Project #4Industry/Domain: Retail e-commerce / Sales

    Description: To be able to gather useful insights about performance of SKUs (Stock Keeping Unit) across locations, and time period, one needs the knowledge of DAX of Power Pivot.
    Actions Performed:
    a) Introduction to DAX measure – Data Analysis Expressions
    b) Essentials of DAX #1 – RELATED, CALCULATE, FILTER, ALL
    c) Essentials of DAX #2 – Date & Time Intelligence
    d) Understand data granularity
    e) Use visualization to understand the impact of the DAX on visualization
    Level: Advanced
    Duration: 4.0 hrs.

    Project #5Industry / Domain: Retail e-commerce / Sales

    Description: This industry sample analyzes retail sales data of items sold via web platform. The metrics compare this year’s performance to last year’s in these areas: sales, units, gross margin, and variance. Other variables include analysis of returns, refunds and exchange.
    Actions Performed:
    a) Pull data from multiple sources (csv, xlsx)
    b) Prepare data for further processing (Clean, Transform, Mash-up)
    c) Connect Table using Relationships, and Merge/Append Queries
    d) Create calculated measures / columns to be used for preparing Dashboards, KPIs
    e) Create multi-tab Dashboard in Power BI
    Level: Advanced
    Duration: 3.0 hours

    Live Training Details:

    Date

    Duration

    Price

    Details

    Nov 22 – Dec 22
    Every Wed-Thu

    19:00 – 21:00 IST
    06:30 – 08:30 PST

    $ 299

    Nov 17 – Dec 05
    Every Sat-Sun

    19:00 – 23:00 IST
    06:30 – 10:30 PST

    $ 349

    Clients

    We build trusted relationships and work with Clients to create the value they’re looking for

    Features

    Online Live Training

    Fast-paced, Live online training courses. Live interaction; Practical skills for immediate application, Learn the fundamentals of Power BI, focusing on personal transformation, Expert Educators; 24X7 Support and the best part is the Flexible Schedule

    Industry Expert with 10+ Year Exp.

    Live Interactive Sessions by our industry Professionals having 10+ Years of Exp. Step-by-step live demonstrations and live Q&A covered in the instructor led training by Certified-industry experts having hands-on live online and visual training experience.

    Industry Projects with Support

    Industry driven Projects. Best Practical scenarios and industry supportive case studies. Expert guidance from the beginning of your career itself. Learn everything about the project from scratch. It offers comprehensive assistance with 24*7 Support

    Supportive eBooks

    The quintessential to learn Power BI. A free eBook should be used as a point of reference to get started with Power BI. The Top BI Solutions for the beginner to advanced Excel Users. The eBook contains key business and reference topics and Top BI Functions for Free.

    Pre-& Post Training Video

    You get the access to the pre-recorded Videos in case if you’ve missed any session. This helps to enhance student learning and bridge the learning gap in the classrooms. Get the Instructor-Led Live Online Training and achieve your personal and professional goals.

    Certification

    Certification Program by instructor led training. It will provide you professional recognition in the field of BI. Once you’ve completed all the Modules of the Power BI Live Online Training, you’ll be getting a Course Completion Certificate. It is beneficial for you as it certifies you as a Power BI Proficient.

    FAQ's

    Can I Attend a Demo Session before Enrolment?

    Joining hands with Yoda Learning means preparing for a class session which is guaranteed to be effective, engaging, and memorable class session. You can attend your Demo session, before you Enroll for our Course. This gets you the complete attention of the Course Instructor who promises to deliver the best experience possible for learning.
    We encourage Learners to take the complete learning Session. Yoda Learning’s Live Online Training guarantees, 100% refund policy after you attend the first session.
    In case, if you’re covered with this Guarantee you don’t need any other assurance for your learning Path. In our Learning Sessions, you’ll come across helpful instructors and dedicated Personal Learning Managers.

    How many students are there in One Batch?

    We do not take more than 5 students per batch. This helps the instructors to put complete attention on their Students.

    Who is the Instructor at Yoda Learning?

    Our instructors are expert professionals of Power BI. They’ve a Proficient knowledge of more than 10 + years in this field. It isn’t just the knowledge and expertise in Power BI. The instructors are driven by passion, joy and teaching.

    What if I have more queries?

    You don’t have to worry, if you’re unable to understand a section or have a doubt or query in regards to the section. We have experts who are happy to teach and are Ridiculously Committed to make you learn. So, if you’re interested and keen in learning, you get the instructor’s Support 24*7. You’ll enjoy to the lengths of solving your doubts via screen sharing.

    What is the Live Instructor-led Session?

    Live Instructor-led Sessions are face to face sessions in between the Student and the Industry Experts Online. We are providing Live Online Training options and Instructor-led Classes to our students. Our Live Trainings are conducted by Power BI Working Professionals with 100 % Quality Assurance & provides Learning Management System access. Weekend class: 8 sessions of 4 hours each and Weekday class: 16 sessions of 2 hours each. & provides Learning Management System access.

    What if I miss a class?You’ll get to view the recorded session of the class in Yoda Learning's Learning Management System (LMS). You can view it anytime.

    You’ll get to view the recorded session of the class in Yoda Learning’s Learning Management System (LMS). You can view it anytime.

    Will I Get Placement Assistance?

    The Certification you’ll get from Yoda Learning is well recognized and has helped Learners gain Career Growth in life. We provide industry intensive and real – life based practical learning to the Power BI Users to help them understand the Problems and make effective decisions.

    Do I get the Lifetime Access?

    We have Live Online Training for Power BI that can be viewed Online. Here, you get lifetime access to the Live Online Power BI recorded videos. Live Online training by Certified & industry expert Trainers & On Demand Dedicated time for doubt solving

    Do I get the Power BI Certificate?

    Yoda Learning’s stand out vision and validation process of knowledge and skills is much more powerful than most traditional methods of Training.
    Once you’ve completed all the Modules of the Power BI Live Online Training, you’ll be getting a Course Completion Certificate. It is beneficial for you as it certifies you as a Power BI Proficient.
    The Live Instructor Led Training will get you the required credibility which will be later passed on to our certifications.

    Contact Me

    Ask Us

     Email [email protected]

     Call Now! +91 80800 42523 / +1-203-349-9909