-compres.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.
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.
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
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
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’
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
-
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 - 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
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.