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.
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.
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
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.
Anyone interested in taking BI Certification.
Professionals who are advancing their careers in BI.
Fee & Schedule
Saturday, December 12th, 2020
10:00 am To 5:30 pm (30 min for Q & A included)
Course material + ACS Certificate
Lunch + Tea + Coffee + Water
Participants to bring:
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.