Microsoft Power BI Training



Course Overview

Microsoft Power BI training course is designed to help you master Data visualization and Power BI tool. This course will help you master the skill of creating powerful and interactive Dashboards using Power BI desktop, DAX, Power BI Q&A, Integrations and many more. This instructor-led live online course is a 100% hands-on course from Techcanvass with real-life use cases, exercises, and projects.

Who should attend this course?


  • Developers who wish to upskill and add Data visualization and Power BI certification to their profile/resume
  • Business Analysts who wish to work on Data Science and Business Analytics projects
  • Project Managers who would like to manage the data science and business analytics projects
  • Any other professional who would like to upskill

The top companies hiring PowerBI and Tableau professionals include Accenture, SAP, Capgemini, Infosys, Sony, Larsen & Toubro, Wipro, Nissan and so on.
Microsoft Power BI is the leading Data visualization tool in the market and is in the Magic Quadrant by Gartner. This means industry demand for Power BI skills is extremely high.
The average salary of Power BI Data Analyst is $91,731. This is as per Ziprecruiter, a job search engine.


What You'll Learn


In this course, you will learn the importance of data in business and the power of visual story telling

  • The data analytics concepts and life cycle with real-life use cases
  • Importance of Data visualization and its role in Business decisions
  • Using data analysis to help organization make better business decisions
  • Creating powerful and interactive dashboards
  • Connecting to various data sources, data manipulation and cleaning
  • Using Power BI Desktop, Power BI Q&A, Custom visuals, DAX basics, Power BI integrations and more.


Course Certification

At the end you will get course certification from Techcanvass and assessment report on your assignment and projects

In order to get certification of completion:


  • Submit the all class assignment
  • Complete and submit training project
case_study



Microsoft Power BI Course Syllabus



Module 1: Introduction to Power BI and Business Intelligence

• Introduction to Business Intelligence

• Why Business Intelligence

• Characteristics of Business Intelligence

• Introduction to Data Analytics

• Types of Data Analytics

• Data Analytics Life cycle

• Data Visualization in Data Analytics

• Introduction to Data Visualization

• Overview of Self-Service BI

• Power BI Overview

Module 2: Getting started with Power BI

• Power BI Environment

• Components of Power BI

• Architecture of Power BI

• Power BI product portfolio

• Connecting to Data sources in Power BI

Module 3: Data loading and transformation in Power BI

• Data load in Power BI

• Introduction to Query Editor

• Working with columns

• Addressing errors

• Adding a calculated column

• Ordering Columns

Module 4: Power BI Data Model

• Overview of Data Modelling

• Why use data model?

• Introduction to Schema

• Star Schema

• Snowflake Schema

• Galaxy Schema

• Fact Constellation Schema

• Managing data relationship in Power BI

• Overview of Cardinality

• Cross filter Direction

Module 5: Data Analysis Expressions (DAX)

• Introduction to DAX

• Functions in DAX

DAX Syntax

• Creating Measures

• Adding measures in Report

• Introduction to Calculated tables

• Creating Calculated tables

DAX Operators

DAX parameter naming

Module 6: Interactive Data Visualizations

• Types of visualizations in Power BI

• Clustered Column Chart

• Matrix Visual

• Pie Chart

• Gauge Chart

• Card Visual

• Scatter Chart

• Funnel Chart

• Visual Map

• Overview of Filters and Slicers

• Filter pane

• Adding Filters

• Creating visuals Using Filters

• Overview of Slicers

• Creating a slicer

• Overview of Bookmarks

• Adding Bookmarks

• Applying Bookmarks

Module 7: Publish and Share Using Power BI Services

• Introduction to Power BI Service

• Elements of Power BI service

• Building blocks of Power BI

• Dashboards in Power BI

• Reports in Power BI

• Workspaces, Capacities and Data sets

• Working with Workspaces in Power BI

• Publishing Reports on Power BI Service

• Creating Power BI Dashboard

Module 8: Power BI Dashboard and Custom Visuals

• Creating Dashboards from reports

• Working with Dashboard Tiles

• Customize the URL and Title

• Configuring a dashboard

• Sharing Dashboards in Power BI

• Enabling Natural Language Queries

• Filtering content in Dashboard

• Best practices in Dashboard

• Scheduling refresh for

• Overview of Custom Visuals

• Getting Custom visuals

Developing Custom visuals in Power BI (module 4)

Module 9: Creating and Publishing Power BI Apps

• Overview of Power BI Mobile App

• Features of Power BI Mobile Apps

• Create reports for Mobile View

• Features of Mobile view layout

• Publishing an app in Power BI

• Accessing an app in Power BI

• Updating an App

Module 10: Power BI APIs, Power BI Embedded & SSAS

• Overview of Power BI API

• REST APIs

• Pushing data into datasets using Power BI APIs

• Overview of Power BI Embedded

• How to embed content

• Overview of SSAS

• Connecting SSAS Model

• Gateways

Module 11: Data Security and Administering Power BI

• Data security capabilities in Power BI

• Overview of Row level security (RLS)

• Roles and Rules

• Defining and validating roles

• Power BI admin portal overview

• Settings in Admin portal

Course project

Retail Store chain transformation

Business Intelligence (BI) tools are adopted by more and more companies in the current environment that requires companies to operate as efficiently as possible. The case study investigates a BI adoption in a retail chain. Based on qualitative research methods, it analyses the Business Intelligence life cycle; it evaluates factors impacting the adoption from the Diffusion of Innovations perspective.

The present study tried to help the upcoming retail store to solve the problem of transformation from traditional way of doing business to the digital way. Automate the data collection where available and create integrated set of dashboards that will free up time for the business analysts to get away from some report production time and spend more time on analysis that will greatly benefit the business in the long-term.

Microsoft Power BI Course fee details



Microsoft Power BI Course
(Live Online Training)
  • Live online training (Weekends)
  • 4 weekends course
  • TechEdge portal access – 1 year
  • Case study
  • Course Projects




Course Price (GST Extra)

Currency:



₹ 14,000

₹ 16,000

(2000/- OFF)

Call Me Back

Why you should choose this course?

Image

Real-life Case studies

The course not only covers “How to” of each visualization and dashboards but goes beyond that. We cover several real-life case studies from the Industry to discuss how Data visualizations have helped organizations across the World.



Image

Application of visualizations in real-life scenarios

It is important to learn how to create a doughnut chart, but is that enough? Absolutely not, you should also understand when to use doughnut? Which chart type should be used to compare data or see trend lines or to solve a business problem? This course will help you learn the usage of data visualization in real-life scenarios.



Image

Interview preparation and Resume assistance

Our course will also help you in preparing for job interviews with one-to-one mock interview and detailed feedback session. Our team will also assist you in giving you feedback on your resume so that you can make it industry ready.

Know More


Upcoming Batches Schedule




Time Zone:



Start Date Days Timings
19 September 2020 Sat - Sunday (4 Weeks) 07:30 PM - 09:30 PM ( IST ) Live Online Training
10 October 2020 Sat - Sunday (4 weeks) 07:30 PM- 09:30 PM (IST) Live Online Training
07 November 2020 Sat - Sunday (4 weeks) 07:30 PM - 09:30 PM ( IST ) Live Online Training
05 December 2020 Sat - Sunday (4 Weeks) 07:30 PM- 09:30 PM (IST) Live Online Training




Our Business/Data Analytics Courses