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

 

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.

 
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 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

SESSION - 1

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

SESSION - 3

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’

  • 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

SESSION - 5

Creating Smart Dashboards and reports

SESSION - 7

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

SESSION - 2

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’

SESSION - 4

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

SESSION - 6

Unleashing Artificial Intelligence (AI) Visuals

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

SESSION - 8

 

Power BI mobile app

  • Creating Mobile view

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

 
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

Duration:​

One Day

Delivered on:

Saturday, December 12th, 2020

Timings: 

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

Location: 

Lahore

Fee:

N/A

Included:

Course material + ACS Certificate

Included:

Lunch + Tea + Coffee + Water

Participants to bring:

Laptop Computer

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.

 

About ACS Training Company

Focusing on modern professional's CPD needs, ACS TRAINING COMPANY provides truly world-class business, financial & technology training, designed & developed for individuals seeking career growth as well as corporate business aiming for staff skills development.


Quick Links

Reach Us

ACS  Training Company

Lahore. Pakistan

 

Monday To Friday: 9:00 AM - 6:00 PM

Saturday & Sunday Closed

Mobile :  +92 307 1222 002

Tel :  +92 42 3523 4215

E-mail :  contact@acstrainingcompany.com

  • Facebook
  • Linkedin

CONTACT US

+92 307 1222 002

+92 42 3523 4215

Program Registration

arrow&v

For General Enquires