-compres.jpg)
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 :
Please Enquire:
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.
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.
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.
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
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
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
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
Duration:
03 Days
Delivered on:
Please Enquire: contact@acssynergy.com
Timings:
10:00 am To 5:00 pm (30 min for Q & A included)
Location:
Please Enquire : contact@acsynergy.com
Fee:
Please Enquire : contact@acssynergy.com
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
Duration:
03 Days
Delivered on:
Please Enquire: contact@acssynergy.com
Timings:
10:00 am To 5:00 pm (30 min for Q & A included)
Location:
Please Enquire :contact@acssynergy.com