Microsoft Power BI Training Course

In this course, you will learn through a series of lectures complete with hands-on labs. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Plus, learn to create dashboards and share with business users—on the web and on mobile devices.

This course is designed to enable you get started as Power BI Consultant or Power BI Developer. It extensively covers the key components of Power BI which includes Power BI Desktop, Power BI Service, Power BI Query Editor, Power BI Mobile. The course sufficiently covers concepts to help you clear the Microsoft 70-778 ‘Analyzing and Visualizing Data with Microsoft’ Power BI exam.

ABOUT POWER BI

Power BI is a business analytics service that delivers insights to enable fast, informed decisions. It is recognized among professionals in BI & data science as a cloud-based service that helps them easily visualize and share insights from their organizations’ data.

Microsoft is recognized as a leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms–for 12 consecutive years.

What Power BI Offers:

  • Transform data into stunning visuals and share them with colleagues on any device.
  • Visually explore and analyze data—on-premises and in the cloud—all in one view.
  • Collaborate on and share customized dashboards and interactive reports.
  • Scale across the organizations with built-in governance and security.

WHAT YOU WILL LEARN

  • Connecting to multiple data sources
  • Data transformation & data modelling
  • Building powerful visualizations, reports & dashboards
  • Writing custom calculations
  • Deploying reports and dashboards for user consumption
  • Power BI cloud administration

PRE-REQUISITES

  • Knowledge of relational databases, SQL
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business terminologies such as sales, expenses, revenue and profitability is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

WHO SHOULD TAKE THIS COURSE

  • Individuals who are looking to start careers as Business Analysts, BI Consultants, BI Developer, Data Analysts
  • Currently working MIS executive
  • IT professionals who wish to switch their career to Data Analytics stream

Background: Background in Computers & Information Technology

Education: BE Computers, BE IT, MSc, BSc, MCA, BCA, MBA IT

WHY YOU SHOULD TAKE THIS COURSE

Data Science and Data Analytics are the key words in industry. Our course enables you to embrace it.

Average Salary of Power BI Developers in India: 6 LPA (Payscale.com)

COURSE CONTENT

Week 1
Understanding key concepts in business intelligence, data analysis, and data visualization
Understanding the BI architecture
Understanding Power BI Desktop interface
Connecting to and importing your data from multiple data sources including Excel and SQL Server
Shaping, Transforming & Cleaning the data using Query Editor
Enriching your data with business calculations using DAX & M Query
Developing multiple interactive reports with practical use cases
Formatting the reports
Deploying / publishing reports to Power BI service
Assignments
 
Week 2
Working with advanced DAX functions & M Query options
Working with advanced Query Editor options
Working with time intelligent functions
Working with hierarchies, groups, embedded tooltips, bookmarks
Working with data from multiple databases or data sources
Working with joins & relationships
Implementing filters & slicers
Using custom visuals
Developing multiple reports with different uses cases
Exploring live connections to data with Power BI
Sharing dashboards across your organization
Consuming dashboards in mobile apps
Implementing row-level security
Creating dashboards based on reports and natural language queries
Assignments
 
Week 3
Overview of Power BI Service, Dashboards, Workspaces, Apps
Creating Dashboards in Power BI Service
Creating and managing Workspaces & Power BI Apps
Embedding reporting in external portals like Sharepoint and using export options
Authoring reports within Power BI Service
Connecting to Power BI published datasets
Power BI Service administration
Scheduling automated refresh of your reports using Data Gateway
Mini project aligned with practical use case

OTHER DETAILS

  1. Students need to bring their own laptops to the training


For more details call us on 7888034000