B1 - 4.jpg

Business Intelligence

with

Microsoft Power BI

Three Days Power BI Training Program

In a Classroom

Live Online

Your Company Location

Your Company Location

Gear up your decision making to the next level!

Take a deep dive into the insights of Microsoft Power BI & drill your business analysis skills with advance reporting
 

Next Classroom Sesion :

As a part of ACS's continued commitment to the development of the most promising and bright human resource.

This is the Full 3 Days version of the program to provide detailed insights into Business Intelligence with Microsoft Power BI.

Image by Scott Graham

Scheduled to be delivered by one of the finest trainers on the subject area in Pakistan.

 
 

Program Overview & Objectives

Modern financial & business professionals are inundated with relevant and irrelevant business information & data. The core focus of the training program is on exploring in detail how to convert data into insights and insights into better business decisions.

Microsoft Power BI enables analysts and business decision makers to connect directly with many data sources, extract, transform and model data and create stunning reports and dashboards enriched with AI capabilities.

Mac Laptop - Transparent PNG.png
strategy growth.jpg

The fundamental objective of this training program is to enable the participants to devise a comprehensive analytical approach and convert data into informed reporting & dashboards. The participants will learn to leverage Microsoft Power BI to solve core business problems and improve financial & business operations.  

The participants will take an in-depth dive into the wonders of Microsoft Power BI, igniting their interest for continuing skills development in this vital area. This training program is designed to add immensely to the participant’s ability to develop intelligent dashboards from published reports, discover better insight from the data & create practical recipes on the various tasks that one can perform with Microsoft Power BI.

 
Image by Annie Spratt
Image by Elena Kloppenburg

Program Benefits

Whether you are an enthusiastic finance professional or a business decision maker in other roles, attending this training program will significantly enhance your understanding and ability to deliver insights to make fast & informed business decisions.

 

This will lead both; the business processes to drive more friction-less and connected experiences, and the finance professionals to enhance their skills development.

 

Precisely, this training program will enable the business managers, finance professionals & entrepreneurs to understand how to convert data into insights and insights into better business decisions.

 

Key Highlights of Program Takeaways

Abstract Texture

In-depth knowledge with hands-on practice of the complete ecosystem of Microsoft Power BI.

Capability to design smart dashboards in Power BI and to utilize multiple ways of sharing.

Turning data into insights by utilizing built-in AI features, standard and custom visuals of Power BI.

Transforming & shaping data from multiple sources using Power Query.

Creating data models & understanding table relationships.

Solving Data Analysis problems with Power BI formula language named ‘DAX’.

Self-service Business Intelligence with Power BI.

Readily available information across multiple devices including PC’s, Tabs and Mobiles.

Full process automation, increased productivity and reduction in manual work.

Creation of highly professional dashboards from multiple data sources.

Creating mobile view to visualize business results anytime & anywhere.

Publishing & sharing dashboards on Power BI service.

Answers and solutions to the practical problems of the participants.

 

Program Outline

Gray Structure

Day-1

Module 1: What is Business Intelligence & Why to learn?

  • Introduction to Business Intelligence (BI)

  • BI vs Data Science

  • Understanding the Self-Service BI Workflow

  • The Framework of an Insight

  • What are the common BI tools?

  • Why to learn BI?

Module 2: Connecting & Transforming Data with “Power Query”

  • Getting to know the types of data connectors and the query editor

  • Getting data from Excel, text & CSV files

  • Combining all the files in a folder

  • Getting data from databases

  • Shaping and transforming data to fit in data model

  • Table transformations, text, number, and date specific tools

  • Grouping & aggregating, filtering, splitting & merging

  • Pivoting and un-pivoting columns

  • Merging and appending queries

  • Creating conditional columns

  • Working with ‘Transform’ and ‘Add column’ tools

  • Data source and query refresh settings

  • Understanding Power Query ‘M’ language and ‘Advance Query Editor’

  • Data connection best practices

Module 3: Creating and managing Data Models

  • Understanding what Data Model is and why we need it

  • Normalization and denormalization

  • Understanding ‘Facts’ and ‘Dimensions’ tables

  • In-depth understanding regarding Primary vs Foreign keys

  • Creating ‘Star Schemas’

  • Creating table relationships and understanding their cardinality

  • Understanding ‘filter flow’, and relationship types

  • Relationships vs Merged Tables

  • Cardinality of relationships & filter direction

  • Defining hierarchies and hiding fields in report view

Day-2

Module 4: Solving Data Analysis Problems with DAX

  • Intro to Data Analysis Expressions (DAX)

  • Similarities and differences with Excel formula language

  • Calculated Columns vs DAX Measures

  • Implicit vs Explicit Measures

  • Row Context vs Filter Context, Evaluation Contexts and Relationships

  • Knowing DAX Formula Syntax & Operators

  • Learning Measure calculation Step-by-Step

  • Getting to know the best practices in writing DAX functions

  • Common DAX functions with their category

  • Applying basic math and stat functions (SUM, AVERAGE, MAX, MIN, DIVIDE, COUNT, DISTINCTCOUNT)

  • Use of Logical functions (IF, AND, OR, SWITCH & SWITCH - TRUE)

  • Iterator (X) Functions (Working with iterators, SUMX & RANKX)

  • Use of The CALCULATE function (CALCULATE & FILTER, CALCULATE & ALL, CALCULATE & ALLSELECTED)

  • Table Functions (FILTER & ALL function, Adding Filter Context with FILTER function, RELATED & RELATEDTABLE functions)

  • Using Variables in DAX queries (Optimizing DAX queries using Variables)

  • Understanding time intelligence & applying Time Intelligence with DAX (SAMEPERIODLASTYEAR, DATEADD, DATESINPERIOD, DATEDIFF, DATESYTD, DATESQTD, DATESMTD, PARALLELPERIOD, TOTALYTD, TOTALQTD, TOTALMTD functions)

Module 5: Creating Smart Dashboards in Power BI Desktop

  • Top 15 Rules to design the best Dashboards

  • Knowing the report view and exploring its interface

  • Power BI desktop options and settings

  • Creating dashboard and adding visuals

  • Report filtering options & drill down pages

  • Adding & formatting buttons, shapes, and images

  • Adding slicers, Cards and KPI visuals

  • Customizing themes and creating bookmarks

  • Adding common charts like column, bar, Line, Area, Pie, Donut & combo

  • Adding advanced visuals like, Waterfall, funnel, Tree map and Scatter charts & maps

  • Working with ‘Analyze in Excel’ as an external tool

  • Creating ‘Mobile Layout’

  • Publishing online on Power BI Service

Day-3

Module 6: Adding Custom Visuals from AppSource

  • Accessing AppSource for importing Custom Visuals for Power BI

  • Zebra BI custom visual

  • Bullet Chart custom visual

  • Bubble chart

  • Ultimate waterfall custom visual

  • Smart Filter

Module 7: Power BI, Artificial Intelligence (AI) Visuals & Features

  • The Decomposition Tree visual

  • The Key Influencers visual

  • The Q&A visual

  • Anomaly detection

  • Smart Narratives visual

  • Analyze the changes

  • Quick Insights

Module 8: Power BI service on the web

  • Accessing Power BI Service and touring the interface

  • License types

  • Creating workspaces

  • Creating Data-Driven Alerts

  • Exploring Data with Q&A & Generating Quick Insights

  • Understanding the difference between Reports & Dashboards

  • Creating dashboard from multiple reports

  • Collaboration with others

  • Analyzing in Excel

  • Installing ‘Data Gateway’

  • Scheduling auto refresh

Module 9: Power BI Mobile App

  • Installing Power BI Mobile App

  • Creating Mobile view

  • Adding visuals, publishing, and viewing dashboards on Mobile app / tab

 

Who Should Attend

walking in office 5.jpg

Accounting & Finance Professionals / Financial Analysts.

BI Managers and Analysts.

Managers & Business Decision Makers.

Supply Chain & Planning Professionals.

HR Professionals.

Data Analysts.

Anyone interested in taking BI Certification.

Professionals who are advancing their careers in BI.

Participants who attended the One-Day Workshop on 24th November, 2020.

 

Fee & Schedule

Classroom Schedule

Next available session
Delivered on
Timings

Duration:​

03 Days

Delivered on:

Please Enquire:
contact@acstrainingcompany.com

Timings: 

10:00 am To 5:00 pm (30 min for Q & A included)

Location: 

Lahore

Full Program Fee
Certificate included
Mandatory Modules
Lunch included
tea, coffee, water included

Fee:

PKR:  -  (plus applicable sales tax)

Included:

Course material + ACS Certificate

Included:

Lunch + Tea + Coffee + Water

Participants to bring:

Laptop Computer

COVID-19 SOP's: Participants are expected to strictly take all the necessary measures including wearing a mask & keeping appropriate social distance. Join hands with ACS in protecting the environment.

Live Online Schedule

Next available session
Delivered on
Timings

Duration:​

03 Days

Delivered on:

Please Enquire:

contact@acstrainingcompany.com

Timings: 

10:00 am To 5:00 pm (30 min for Q & A included)

Location: 

Live Online

Full Program Fee
Mandatory Modules
Certificate included

Fee:

PKR:

Plus applicable sales tax

Included:

Course material 

Included:

ACS Certificate

Participants to have

Laptop Computer