Business Intelligence Using Power BI
Business Intelligence Using Power BI

Course Overview

Power BI is a business intelligence tool that brings all together all the organization’s data in one place so one can visualize it as a whole and gain valuable insights. It transforms company’s data into rich visuals to collect and organize in a way that one can focus on what really matters. Power BI helps you stay in the know, spot trends as they happen, and push your business further.

This virtual instructor-led training empower participants to build strong understanding of Power BI to integrate, make use of data, and build compelling and interactive reports.

Course Takeaways

  • Connect MS Power BI to simple datasets in MS Excel and SQL
  • Build simple data models within MS Power BISelect and execute appropriate Visualizations within MS Power BI
  • Create a dashboard to explore data and answer queries using MS Power BI
  • Publish and share insightful reports to stakeholders using MS Power BI
  • Run fundamental analytics using the DAX language.

Who Should Attend

Senior executives, department/ functional heads and business managers, project managers, business analysts, IT executives, data analysts and scientists looking to enhance strategic thinking in building their business intelligence/ analytics function.

Prerequisite

There are no prerequisites for this program. Prior knowledge on any of the topics is not required. Upon successful completion of the course, every participant will receive a Certificate of Participation.

Course Outline

Introducing Power BI

  • Getting started with Power BI
  • Uploading data to Power BI
  • Introduction to reports
  • Introducing Visual Interactions

Using Power BI Desktop

  • Connecting to a database
  • Loading from multiple sources
  • Using Query Editor
  • Hiding or removing tables
  • Handling seasonality and sorting months

Consuming and transforming data by using Power BI Desktop

  • Data connectivity modes
  • Importing data
  • Connecting to a Folder
  • Import from Excel

Developing Power BI reports

  • Choosing the right visualizations
  • Choosing between standard visuals.
  • First steps with custom visualizations
  • Improving reports by custom visualizations
  • Identifying conditions when custom visualizations are required
  • Using DAX in data model

Using Microsoft Power BI in your company

  • Publish Excel data models in Power BI
  • Consume Power BI content from Excel
  • Pushing real-time data to Power BI dashboards

Create calculated columns, calculated tables, and measures

  • Create DAX formulas for calculated columns
  • Calculated tables
  • Using Measures
  • Use What-if parameter

Create hierarchies and format interactive visualizations

  • Create date hierarchies
  • Create hierarchies based on business needs
  • Add columns to tables to support desired hierarchy
  • Select a visualization type
  • Configure page layout and formatting
  • Configure interactions between visuals
  • Category of columns
  • Position, align, and sort visuals
  • Format measures
  • Use bookmarks and themes for report

Create hierarchies and format interactive visualizations

  • Add text and images
  • Filter dashboards
  • Dashboard settings
  • Introducing data refresh
  • Publishing to Power B

Gallery

Course Materials

It is very important to analyze the need for Training along with the level of knowledge you require. This session give you a liberty to choose the modules you need, discuss it with the trainer how you want to be delivered, decide the place at your convenience and allocate number of hours to solve your problem. This does not include any development as a consulting but will include solution if you are facing a particular problem.