Microsoft Power BI Made Simple For Finance And Hr Professionals

New and powerful ways to start your dashboard reporting by using Power BI Desktop in organized and easy steps. This is designed by an Accountant who is well versed in financial analysis and your reporting needs.

Let’s explore and unbox this tool provided by Microsoft, that empowers you with real-time insight on what is happening in your business. Learn how to prepare data, load external data source, model the data, then create chart visualisation in easy steps.

What You Will Learn:

• How to get together and prepare data for ready use
• Start the BI tools in easy steps.
• Relate the data sets and explore different ways of relationship
• Model the data for easy dashboard set up and data analysis
• Hands-on application on case studies. Transform data source to dashboard reporting
• Explore ways to share and publish the dashboard in the powerful BI tools

Course Structure:

• Day 1
• What Is Power Bi Desktop?
• What is Power BI?
• How to get Power BI?
• Getting The Data Source
• Introduction to the window and terminology
• Getting the data – direct query / import data
• Recap : To get the data on your own
• Model The Data Effectively
• What is modelling?
• The essence in dashboard presentation
• Set up and manage relationships
• Add in new columns to enrich the data presentation
• Identify the difference between Calculated Columns and New Measures
• Exercise : Build your own data modelling
• Walk Through The Data Visualizations
• Begin with common bar and column charts to introduce how to use the Formatting panel
• Setting sort order
• Scatter & Bubble charts and play axis
• Slicers & Timeline Slicers
• Day 2
• Walk Through The Data Visualizations (contd)
• Interesting Drill Up / Down feature
• What is hierarchies in data visualization?
• Set up target line to benchmark your business performance
• Create informative Tables and conditional formatting
• How Cards and Gauges are useful in giving one glance to overall business goals?
• How can KPIs be used in dashboard presentation?
• Set up map visualizations
• Hands-on Workshop: Case Studies
• Apply what have learned on the case study: transform data source to dashboard presentation
• Overview Of Publishing And Sharing Dashboard
• Publish from Power BI Desktop
• Introduction of Power BI service
• Publishing for mobile apps