Power BI

Live Online (VILT) & Classroom Corporate Training Course

Power BI has been gaining popularity for offering cutting edge tools that help transform an organisation's data into rich visuals and offer a panoramic view of the business to users helping them gauge updates in real time.
Power BI

How can we help you?

  • CloudLabs
    CloudLabs
  • Projects
    Projects
  • Assignments
    Assignments
  • 24x7 Support
    24x7 Support
  • Lifetime Access
    Lifetime Access
Box

Overview

Power BI training course is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop

Box

Objectives

At the end of Power BI training course, participants will learn

  • About BI and how it will transform data and business
  • About the Power BI desktop and managing and utilizing data with it
  • Connecting data from different sources and data modelling with Power BI desktop
  • How to custom create data visualizations and style reports for lucid data representation
  • The working of Power BI and Excel
  • How to share and collaborate with data with Power BI
  • Power BI Data Analysis Expression(DAX), and its functions
Box

Prerequisites

Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.

Box

Course Outline

  • Guided Learning for Power BI
  • Using Power BI
  • Building Blocks of Power BI
  • A quick look at the Power BI service

  • Getting Started with Power BI Desktop
  • Connect to Data Sources in Power BI Desktop
  • Clean and Transform your data with the Query Editor
  • More Advanced Data Source and Transformation
  • Type natural-language questions about your data on a dashboard
  • Cleaning Irregularly Formatted Data

  • How to Manage Your Data Relationships
  • Create Calculated Columns
  • Optimizing Data Models for Better Visuals
  • Create measures and work with time-based functions
  • Create Calculated Tables
  • Explore Time-Based data

  • Create and Customize Simple Visualizations
  • How to use combination charts
  • Create and format slicers
  • How to use Map Visualizations
  • How to use Tables and Matrixes
  • How to use Scatter Charts
  • How to use Waterfall and Funnel Charts
  • How to use Gauges and Single Number Cards
  • How to modify colors in charts and visuals
  • Style your Reports with Shapes, Text Boxes and Images
  • Page Layout and Formatting
  • Duplicate a page report
  • Show categories with No Data
  • Customize Visuals with Summarization and Category Options
  • Arrange the Z-order of Report Elements
  • Visual hierarchies and drill down behaviour
  • R visuals in Power BI

Transforming data with Relational Operators

  • The Power BI service
  • Create and Configure a Dashboard
  • Create Custom Q&A Suggestions
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full Screen
  • Edit Tile Details
  • Get More space on your Dashboard
  • Install and Configure a personal gateway

  • Import and Excel table into Power BI
  • Import Excel files with data models and Power View sheets
  • Connect One Drive for business to Power BI

  • Publish Reports from Power BI Desktop to the Power BI Service
  • Print and Export Power BI Dashboard
  • Manually Republish and Refresh your Data
  • Introducing Power BI Mobile
  • Create a group in Power BI
  • Create a content pack in Power BI
  • Connect to a content pack in Power BI
  • Connect to a content pack from  group in Power BI
  • Edit a content pack in Power BI
  •  Integrate OneDrive for business with Power BIPublishing and Sharing
  • Publish Reports from Power BI Desktop to the Power BI Service
  • Print and Export Power BI Dashboard
  • Manually Republish and Refresh your Data
  • Introducing Power BI Mobile
  • Create a group in Power BI
  • Create a content pack in Power BI
  • Connect to a content pack in Power BI
  • Connect to a content pack from  group in Power BI
  • Edit a content pack in Power BI
  •  Integrate OneDrive for business with Power BI

  • DAX Calculation types
  • DAX Functions
  • Using Variable in DAX expressions
  • Table Relationships and DAX
  • DAX Tables and Filtering
Box

Testimonials

Shamsudeen Bawa

Synergific Software Team has been very supportive, and working with them has been a best decision that we could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!

Shamsudeen Bawa

Vice President, J.P Morgan, CIS, USA

Farhan Hafiz

Synergific Software has been of great help and I plan to continue to use your services in the future for my business needs.

Farhan Hafiz

Data Architect, Fiserv

Dr. Sahdev Singh

I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.

Dr. Sahdev Singh

Under Secretary, Ministry of Law & Justice, Govt. of India

M Chikanna Swamy

I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.

M Chikanna Swamy

Director & Learning Head, Mindtree