Skip Main Navigation
Page Content

Save This Event

Event Saved

Available Dates

Ticket Information

Ticket Type Sales End Price Fee
Quantity
RSVP - Microsoft Power BI 1 hour before event starts $500.00 $0.00

Share Microsoft Power BI

Event Details

Microsoft Power BI

Why learn Power BI

We live in the world of data. In business, we receive various reports, charts, emails, and even printed handouts that contain a lot of information. As the data accumulates, it becomes very challenging to get required information instantly. Power BI is a smart solution that can connect to almost any source of information. It helps you to:

  • Collect and clean data in an automated manner.
  • Analyze and examine data with powerful DAX functions.
  • Transform your enterprise data into rich visuals and provide business intelligence for enhanced decision making.
  • Setup automated data refresh and publish reports to provide latest information to users.
  • Propel organization into a data driven culture.

 Who should attend?

  • Data Analytics professionals
  • Business Intelligence Managers
  • Data Scientists
  • Accountants
  • Financial Analyst
  • Project Managers
  • Business Analysts
  • New Graduates
  • All other Analysts

Prerequisites

  • Intermediate knowledge of Microsoft Excel 2013 or later.

Duration

  • Five sessions of 2 hours each, Tuesdays & Thursdays

 

Session Type

 

  • Classroom setting, Seats are limited to maximum of 5

 

 

What you will learn:

Module 1        Introduction

  • Data Analysis, Data Analytics and Business intelligence
  • Data Analytics Process – IMPACT Model
  • Overview of Power BI
  • Connecting to various data sources
  • Basic data transformation
  • Merge and Append queries

 

Module 2        Optimizing data models for reporting

  • Creating and managing data relationships
  • Creating and managing hierarchies.
  • Creating calculated columns and measures
  • Calculate tables on the fly
  • Time intelligence analysis
  • Including, excluding and grouping of data
  • Data Analysis Expressions

 

Module 3        Data Visualization

  • Visualize data using Line, bar and column charts.
  • Measure business performance using Gauge, Card and KPI visuals.
  • Analytics pane and Slicers
  • Edit visuals relationship and adding custom tooltips
  • Understanding combined visualizations and waterfall chart.
  • Visual level, page level and report level filters.
  • Cross report filters.
  • Question and Answer Visual.
  • Page view and page size.
  • Bookmark and slide show.

 

Module 4        Working with Power BI Service

  • Publishing reports and analysis to Power BI service
  • Quick Insights
  • Configuring a dashboard
  • Featured and favorite dashboards
  • Adding live contents to dashboards
  • In focus and TV mode
  • Natural language queries and featured questions
  • Exporting data to CSV or Excel
  • Configuring personal gateway
  • Sharing and Annotating in Power Bi Mobile
Have questions about Microsoft Power BI? Contact Crux International Canada

Save This Event

Event Saved

When & Where


Crux International Canada
2155 Leanne Boulevard
Unit 201
Mississauga, ON L5K 2L6
Canada

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.