Overview
Power BI training course is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop
Objectives
At the end of Power BI training course, participants will learn
- About BI and how it will transform data and business
- About the Power BI desktop and managing and utilizing data with it
- Connecting data from different sources and data modelling with Power BI desktop
- How to custom create data visualizations and style reports for lucid data representation
- The working of Power BI and Excel
- How to share and collaborate with data with Power BI
- Power BI Data Analysis Expression(DAX), and its functions
Prerequisites
Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.
Course Outline
- Guided Learning for Power BI
- Using Power BI
- Building Blocks of Power BI
- A quick look at the Power BI service
- Getting Started with Power BI Desktop
- Connect to Data Sources in Power BI Desktop
- Clean and Transform your data with the Query Editor
- More Advanced Data Source and Transformation
- Type natural-language questions about your data on a dashboard
- Cleaning Irregularly Formatted Data
- How to Manage Your Data Relationships
- Create Calculated Columns
- Optimizing Data Models for Better Visuals
- Create measures and work with time-based functions
- Create Calculated Tables
- Explore Time-Based data
- Create and Customize Simple Visualizations
- How to use combination charts
- Create and format slicers
- How to use Map Visualizations
- How to use Tables and Matrixes
- How to use Scatter Charts
- How to use Waterfall and Funnel Charts
- How to use Gauges and Single Number Cards
- How to modify colors in charts and visuals
- Style your Reports with Shapes, Text Boxes and Images
- Page Layout and Formatting
- Duplicate a page report
- Show categories with No Data
- Customize Visuals with Summarization and Category Options
- Arrange the Z-order of Report Elements
- Visual hierarchies and drill down behaviour
- R visuals in Power BI
Transforming data with Relational Operators
- The Power BI service
- Create and Configure a Dashboard
- Create Custom Q&A Suggestions
- Share Dashboards with your organization
- Display Visuals and Tiles Full Screen
- Edit Tile Details
- Get More space on your Dashboard
- Install and Configure a personal gateway
- Import and Excel table into Power BI
- Import Excel files with data models and Power View sheets
- Connect One Drive for business to Power BI
- Publish Reports from Power BI Desktop to the Power BI Service
- Print and Export Power BI Dashboard
- Manually Republish and Refresh your Data
- Introducing Power BI Mobile
- Create a group in Power BI
- Create a content pack in Power BI
- Connect to a content pack in Power BI
- Connect to a content pack from group in Power BI
- Edit a content pack in Power BI
- Integrate OneDrive for business with Power BIPublishing and Sharing
- Publish Reports from Power BI Desktop to the Power BI Service
- Print and Export Power BI Dashboard
- Manually Republish and Refresh your Data
- Introducing Power BI Mobile
- Create a group in Power BI
- Create a content pack in Power BI
- Connect to a content pack in Power BI
- Connect to a content pack from group in Power BI
- Edit a content pack in Power BI
- Integrate OneDrive for business with Power BI
- DAX Calculation types
- DAX Functions
- Using Variable in DAX expressions
- Table Relationships and DAX
- DAX Tables and Filtering
Testimonials
Synergific Software Team has been very supportive, and working with them has been a best decision that we
could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!
Shamsudeen Bawa
Vice President, J.P Morgan, CIS, USA
Synergific Software has been of great help and I plan to continue to use your services in the future for
my business needs.
Farhan Hafiz
Data Architect, Fiserv
I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.
Dr. Sahdev Singh
Under Secretary, Ministry of Law & Justice, Govt. of India
I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.
M Chikanna Swamy
Director & Learning Head, Mindtree