Analyzing and Visualizing Data with Power BI

Master Microsoft Power BI. Specialize in analyzing Business data using the Power BI Business Analytics tools. Create custom visualizations in dashboards and reports. Microsoft Power BI transforms data into rich visuals in the cloud and build robust, reusable models over your data to provide consistency across reporting and analysis.

  • 12 hours of Live Online Instructor-led Classes by Industry Experts
  • Explore, analyze, and visualize data using Microsoft Power BI
  • Empower in Data Analytics and Visualization
  • Verified Certificate from NIIT
Call Me

Online Instructor-Led

batch loading...

Course Features

Related Courses

About Analyzing and Visualizing Data with Power BICourse

Power BI is the most popular cloud based service amongst data science professionals. It helps you visualise and derive insights from the data of an organization.

In this course you will learn from the Power BI product team at Microsoft with a series of short, lecture-based videos, complete with demos, quizzes, and hands-on labs. Throughout the course, you will gain fair, in-depth knowledge. You will learn activities such as connecting to and importing your data, authoring reports using Power BI Desktop and publishing those reports to the Power BI service. You will also learn to create dashboards and share it with business the users through mobile and web services.

Course Objectives
  • Connect, import, shape, and transform data for business intelligence (BI)
  • Visualize data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop and Excel
  • Use natural language queries
  • Create real-time dashboards
Curriculum
Module 1:

Begin with the Course

  • Course overview
  • Installation of Power BI
  • Pre-course Survey
Module 2:

Introduction

  • What is Power BI?
  • Meet the Presenters
  • Introduction
  • Overview of Power BI
  • Connecting to SaS
  • Power BI Community
  • Summary
Module 3:

Power BI Desktop DataTransformations

  • Power BI Desktop DataTransformations
  • Quiz
  • Lab
Module 4:

Power BI Desktop Modeling

  • Introduction
  • Managing Data Relationships
  • Creating Calculated Columns
  • Optimizing Models for Reporting
  • Creating Calculated Measures
  • Creating and Managing Hierarchies
  • Using Calculated Tables
  • Time Intelligence
  • Manually Typing in a Data Table
  • Include / Exclude
  • Grouping / Binning
  • Summary
  • Quiz
  • Lab
Module 5:

Power BI Desktop Visualization

  • Introduction
  • Pie and Treemap
  • Hierarchical Axis and Concatenating
  • Filter (Including TopN)
  • Bar Chart with Line (Combo Chart)
  • Analytics Pane, Clustering (and Machine Learning). Slicer
  • Focus Mode and See Data
  • Date Slicer
  • Map Visualizations
  • ESRI Map
  • Table and Matrix
  • Table Styles
  • Scatter Chart
  • Waterfall
  • Gauge
  • Card and KPI Coloring Charts
  • Shapes
  • Textboxes and Images
  • Gridlines and Snap to Grid
  • Quiz

  • Working with Multiple Visualizations:

  • Page Layout and Formatting
  • Visual Relationship
  • Duplicate Page
  • Categories with No Data
  • Default Summarization and Categorization
  • Positioning
  • Aligning and Sorting Visuals
  • Date Hierarchy
  • R - Visual Integration
  • Summary
  • Quiz
  • Lab
Module 6:

Power BI Service

  • Working with Power BI Service: Introduction
  • Overview of Dashboards and Service
  • Uploading to Power BI Service
  • Quick Insights
  • Configuring a Dashboard
  • Adding Textbox
  • Image Widgets
  • Featured and Favorite Dashboard
  • Filtering Dashboard
  • Dashboard Settings
  • Natural Language Queries
  • Featured Questions
  • Sharing a Dashboard
  • In-Focus Mode
  • Pinning a Live Page
  • Custom URL and Title
  • TV Mode and Collapse Navigation
  • Printing Dashboard and Exporting Data
  • Export to CSV and Excel
  • Power BI Notifications
  • Alerts in the Power BI Service
  • Personal Gateway
  • Publishing to Web
  • Admin Portal
  • Quiz

Viewing Power BI Dashboard:

  • Viewing in Windows App
  • Viewing in Android App
  • Viewing in Ipad
  • Viewing in iPhone
  • Summary
  • Lab
Module 7:

Working with Excel

  • Connecting and Collaborating with Excel current section: Introduction
  • Importing Excel Data using Simple Table
  • Excel Workbook with Excel Data Model
  • Connecting to Excel Workbook on OneDrive for Business
  • Pinning Excel Tables or Visuals
  • Analyzing Data in Excel
  • Summary
  • Quiz
  • Lab
Module 8:

Organization Packs, Security and Groups

  • Working with Others: Introduction
  • Creating a Group
  • Creating a Content Pack
  • Using a Content Pack
  • Editing a Content Pack
  • OneDrive for Business Integration
  • Row Level Security
  • Data Classification
  • Summary
  • Quiz
  • Lab
Module 9:

Direct Connectivity

  • Direct Connectivity current section: Introduction
  • Direct Connectivity to SQL Azure
  • Direct Connectivity to SQL Database
  • Direct Connectivity to SSAS
  • Using SSAS Connector
  • SSAS Multi-Dimensional Preview
  • SAP HANA, Summary
  • Quiz
  • Lab
Module 10:

Developer API

  • Developer API: Introduction
  • Interactive API Console
  • Registering a Client App and Embedding a Tile
  • Using PubNub to Push Data to a Tile
  • Creating Custom Visuals
  • Using Custom Visuals
  • Power BI Embedded
  • Summary
  • Quiz Lab
Module 11:

Mobile App

  • Identifying Project Stakeholders
  • Managing Project Stakeholders
Instructor

Instructors are handpicked from a selected group of industry experts and mentors and trained to deliver the best online learning experience. All training.com instructors have at least ten years of industry experience and extensive functional expertise in the field they train.

Certification

A test will be conducted at the end of the course. On completion of the test with a minimum of 70% marks, training.com will issue a certificate of successful completion from NIIT.

One re-attempt will be provided in case the candidate scores less than 70%.

A Participation certificate will be issued if the candidate does not score 70% after two attempts.

In addition, the NIIT certification will serve as attendance certificate for PMP Examination Study Facilitation which is one of the pre-requisites for appearing for the PMI-PMP credential.

Pre-requisites

Some experience in working with data from Excel, databases, or text files.

FAQs

Who should join this course?

We would recommend this path strongly for professionals in the following roles:

  • IT professionals
  • Analytics Managers
  • Business Analysts
  • Banking and Finance professionals
  • Marketing Managers
  • Supply Chain Network Managers
  • Freshers into data analytics domain
  • Students in UG/ PG Analytics Programs

Why should I join this course?

If you have interest in data analytics and you want to become a data scientist, then this is the perfect course for you. It is preferable for both the freshers and experienced professionals. This course will help you gain expertise in analytics.

What is your refund policy?

Upon registering for the course, if for some reason you are unable or unwilling to participate in the course further, you can apply for a refund. You can initiate the refund any time before start of the second session of the course by sending an email to support@training.com , with your enrolment details and bank account details (where you want the amount to be transferred). Once you initiate a refund request, you will receive the amount within 21 days after confirmation and verification by our team. This is provided if you have not downloaded any courseware after registration.

What are the minimum system requirements to attend the course?

    Minimum system requirements for accessing the courses are:

  • Personal computer or Laptop with web camera
  • Headphone with Mic
  • Broadband connection with minimum bandwidth of 1 Mbps .However, recommend is 2 Mbps.
  • A self-diagnostic test to meet necessary requirements to be done is available at

    https://na1cps.adobeconnect.com/common/help/en/support/meeting_test.htm

    Please note that webcam, mike and internet speed cannot be verified through this link.

Course Features

batch loading...

Related Courses

AI and Deep Learning with TensorFlow
AWS Certification and Training Program
Administration Essentials for New Admins- Salesforce
Advanced Data Mining projects with R
Advanced Pay Per Click
Advanced Program in Data Sciences
Advanced Social Media Marketing
Analyzing and Visualizing Data with Excel
Analyzing and Visualizing Data with Power BI
Android Game Development for Beginners
Application Development with Swift 2
Automated UI Testing in Java
Big Data Analytics with R
Big Data Applications using Hadoop
Building Android Games with OpenGL ES
Building Applications with Ext JS
Building Applications with Force.com
Building a Data Mart with Pentaho Data Integration
Building iOS 10 Applications with Swift
Builiding web application with spring MVC
Business Analytics using R from KPMG
Certified Digital Marketing Professional
Complete Web and Social Media Analytics
Data Quality 9.x: Developer, Level 1
Data Science Orientation
Data Science with R
Data Science with Spark
DevOps Certification Training
Developing Microsoft SharePoint® Server 2013
Enabling and Managing Microsoft Office 365
Executive Program in Applied Finance
Executive Program in Digital and Social Media Marketing Strategy
Getting Started with R for Data Science
Getting started with Apache Solr Search Server
IBM Cognos Connection and Workspace Advanced
Implementing Microsoft Azure Solutions-70-533
Informatica PowerCenter 9.x Level 1
Introducing Rails 5 Learning Web Development the Ruby Way
Introduction to ITIL
Java Enterprise Apps with DevOps
Joomla Certification Training Program
Julia for Data Science
LEAD (Learn. Enhance. Aspire. Deliver)
Learning Android N Application Development
Learning Data Mining with R
Learning Joomla 3 Extension Development
Learning MongoDB
Learning R for Data Visualization
Learning Spring Boot
Learning Swift 2
Linux shell scripting solution
Machine Learning with Python
Master AngularJS 2
Mastering Magento
Open Source Web App Development using MEAN Stack
PMI® Agile Certified Practitioner Training
Pentaho Reporting
Post Graduate Certificate in General Management (PGCGM)
Programming Using Python
Programming with Python for Data Sciences
Project Management Professional (PMP®) Training
R Data Mining Projects
R for Data Science Solutions
Reactive Java 9
SAS Certification Training Program
Secrets of Viral Video Marketing
Selenium with Java
Six Sigma Certification Training Program
Spring Security
Supply Chain Management(SCM) Training Program
Teradata Certification Training
Test Driven Android
UNIX Shell Scripting Training
Web Apps Development using Node.js along with Express.js and MongoDB
Web Apps Development with HTML5, CSS3, jQuery & Bootstrap
Web Development with Node.JS and MongoDB
iOS App Development Certification Training
jquery UI Development