top of page
B1 - 4.jpg

Business Intelligence with

Microsoft Power BI

One day power-packed workshop


Take your business analysis skills to the next level!

Saturday, December 12th, 2020

Make better & informed business decisions, reduce cost, identify new business opportunities and spot inefficient business processes

As a part of ACS's continued commitment with development of most promising and bright human resource, this workshop is being offered at a subsidized price.

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

Abstract Texture

Explore Further

Overview & Objectives
Who Should Attend
Workshop Takeaways
Fee & Schedule
overview and objectives

Workshop Overview & Objectives

The objective of this training workshop is to build a solid foundation and a deep understanding of how Power BI can enable you to solve business problems and improve financial & business operations.

Modern financial & business professionals are inundated with relevant and irrelevant business information & data. The fundamental focus of the workshop will be on exploring in detail how to convert data into insights and insights into better business decisions.

The participants will take an in-depth dive into the wonders of Power BI, igniting their interest for continuing skills development in this vital area. The workshop is designed not only to provide a very detailed and value adding walk-through but will also 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 you can perform with Microsoft Power BI.

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.

strategy growth.jpg
high resolution cfo.jpg
part time cfo.jpg
Business Plans.jpg

Workshop Benefits

Whether you are an enthusiastic finance professional or a business decision maker in other roles, attending this training workshop 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 comprehensive training workshop 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 takeaways

Key Highlights of Workshop Takeaways

White Feather

Develops detailed understanding of Data Analytics and BI.

Turning data to insights by utilizing built-in AI features of Power BI.

Transforming & shaping data from different sources using Power Query.

Creating data models & understanding table relationships.

Learning Power BI formula language called “Data Analysis Expressions (DAX)”.

Self-service Business Intelligence with Power BI.

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

Full process automation 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.


Workshop Outline

Architectural Structure


Getting data from multiple sources

  • Getting data from Excel

  • Knowing how to connect with live databases

  • Getting data from text & CSV files

  • Combining all the files in a folder


Creating Data Models

  • Normalization and denormalization

  • Creating ‘Star Schemas’

  • Understanding ‘Facts’ and ‘Dimensions’ tables

  • Creating table relationships and understanding their cardinality

  • Working with ‘filter flow’


Transforming Data with Power Query

  • Shaping and transforming data to fit in data model

  • Pivoting and un-pivoting

  • Creating conditional columns

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

  • Understanding ‘Advance Query Editor’


Uncovering the power of Data Analysis Expressions (DAX)

  • What is DAX?

  • Similarities and differences with Excel formula language

  • Calculated Columns vs. Measures

  • Implicit Measure vs. Explicit Measure

  • Row context vs. Filter context

  • Mining information with DAX functions

  • Common DAX functions

  • Time intelligence using DAX

  • Walk through DAX functions library

  • Understanding Data Storytelling and science of colors

  • Creating a complete dashboard in Power BI

  • Adding slicers, Cards and KPI visuals

  • Adding column, bar, Line, Area, Pie and Donut charts

  • Adding advanced visuals like, Waterfall, Funnel, Tree map, and Scatter charts

  • Adding custom visuals from AppSource


Creating Smart Dashboards and reports


Power BI service on the web

  • Publishing the dashboard online on Power BI Service

  • Understanding Workspaces

  • Creating single ‘Dashboard’ from multiple reports and dashboards

  • Installing ‘Data Gateway’ and scheduling auto refresh


Unleashing Artificial Intelligence (AI) Visuals

  • Adding ‘Decomposition Tree’ and ‘Smart Narratives’ AI visuals



Power BI mobile app

  • Creating Mobile view

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

Who is this workshop for
walking in office 5.jpg

Who Should Attend

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.

Fee & Schedule

Fee & Schedule

Next available session
Delivered on


One Day

Delivered on:

Saturday, December 12th, 2020


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



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




Course material + ACS Certificate


Lunch + Tea + Coffee + Water

Participants to bring:

Laptop Computer

Register Now

COVID-19 SOP's: Whilst we are Alhamdulillah out of COVID-19 lockdown, let’s make sure all the SOPs are still followed vigilantly. 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.

Register now
bottom of page