MS Power BI Online Course Training

Key Features

  • 1. Explore the Power BI Desktop panels
  • 2. Explore all the data sources and connecting to excel file, text file, folder source, sql server database
  • 3. What is Load and edit? Can we do edit after loading to the model?
  • 4. HOME ribbon
  • What you will learn MS POWER BI

    Course Details:
    Introduction to Power BI and Power BI Products. Also, pricing of Power BI
    Installing Power BI desktop and sign-in to Power BI app service from Desktop
    1. Explore the Power BI Desktop panels
    i. Options window (left to Home Menu) ii. Top Ribbon with different data sources
    ii. Left side vertical panel iv.Right side vertical panels (Visualizations, Fields)
    Data Cleansing

    2. Explore all the data sources and connecting to excel file, text file, folder source, sql server database
    3. What is Load and edit? Can we do edit after loading to the model?
    4. HOME ribbon
    I) Choose & Remove columns
    ii) Keep & remove rows
    iii) Remove duplicates & Error rows
    iv) Sorting
    v) Split column (by delimiter / by no. of characters) vi) Group by
    vi) data type change
    vii) First row as headers
    viii) Replace values
    ix) Merge queries & Append Quires

    Transform ribbon
    i) Transpose, Reverse and Count Rows
    ii) Fill
    iii) Pivot and Un-pivot
    iv) Format
    v) Merge columns and Extract vi) statistics / standard/ Scientific / Trigonometry / Round/ Information
    vi) Date/ Time / Duration

    Add Column ribbon Add Custom columns / Index column
    View ribbon
    i) Query settings
    ii) Advanced editor
    iii) Formula bar (M-Query)
    iv) Mono spaced v) Show whitespace

    Left / RightPanels
    i) Left side vertical panel (Queries) Table and options
    ii) Left side vertical panel (Query settings) Properties and Applied steps with gear icons

    5. How to load the cleansed and transformed data to the data model (Close and Apply option)?
    Data Modelling
    6. What is relationship window and Data window from Left side vertical panel
    7. Relationship window
     Explore Table properties and Field properties
    & manage relationships from ribbon
    Data window Explore the field properties from the right side vertical panel (Fields)
    Difference between new measure & New columns

    8. Create multiple measures and columns with DAX functions
    9. What is reports windows from Left side vertical panel and explore the options of reports window
    i. Top ribbon with report options  New page, visuals, Text box, image, shapes and page view
    ii. Right side panel(Fields options) Rename, hide/Unhide, delete, Hierarchy and filters
    (Visualizations) around 25+ styles with formatting options

    10. Different report styles and apply formatting options
    i. Table, Matrix, Card, Multi row card,
    ii. Bar charts, Line charts
    iii. Dual style charts (Line and bar)
    iv. Pie charts, Donut charts, Tree maps and geographical maps (Globe and Filled Map)
    App Service
    v. Scatter plot, Funnel, Gauge, KPI and Slickers.
    vi. R based charts

    11. After adding 4 visuals to page, explore the below options
    i. Ribbon (Home)  Format painter
    ii. Ribbon (Format) Edit interactions, Align, distribute and bring forward, send backward
    iii. Visual options Focus mode, sort by, export data

    12. How to create drilldown charts?
    13. How to publish the files Power BI App service and what are the options while publishing?
    14. Explore Power BI App service window with top ribbon and panels
    i. Top black ribbon
    1. Full focus mode with print option while in focus mode option
    2. Gear iconContent packs, settings, gateways, Dev tools and embed code
    3. Downloads, support, feedback and account info
    ii. white ribbon under black ribbon

    1. Add widget (Web content, image, video and Textbox)
    2. Share
    3. …  Duplicate / print / refresh/ featured dashboard
    iii. question bar below white ribbon provide business question, answered in a report format
    iv. Left side ribbon (from bottom)

    1. Datasets: Explore data set options
    Types of gateways and what are those?
    refresh the data from on-premise to Cloud App service

    RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

    RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

    The course begins in a few days, and I still do not have my login information. What do I do?
    Once your registration for a course is completed, we will send activation link to start your sessions.

    What happens if I miss my training date, do I have any options?
    In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch.

    How does the online training work?
    All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class.

    How do I receive the course materials?
    You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc;

    Will I be able to view the sessions again at a later time?
    Yes, We provide recorded sessions.

    Who are your trainers?
    All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience.

    Can I get the same in-class experience at home or work?
    Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications.

    What should I bring to class?
    You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course.

    Where can I get more information?
    If you need more information, please call us at +91-970 39 767 53 or send mail to . Rize Trainings Advisors will be happy to assist you.

    Do you offer placements?
    We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    What happens if I have technical problems during my class?
    If you have technical difficulties, you call us at +91-970 39 767 53 . Our support team will resolve any issues you might encounter.

    Back to top