POWER BI

Power BI Online Training Course

This training delivers you the highest quality of training with a hands-on approach and an industry-recognized curriculum. Training will be provided by our experienced and certified professionals in the respective fields. Training will include exposure to real-time work environments and will also prepare you to attend interviews confidently. You do not require prior knowledge of the courses listed. We give you an excellent opportunity for enhancing your career in the course of your choice. Each training module in IT consulting and training is specially designed so that by the end of the course you will be ready to face client interviews. 

Course Contents

  • Understanding the Power BI environment
  • Creating a Micrsoft Power BI Account
  • Installing Power BI Desktop

  • Working with the Fields and Visualisation Panes
  • Using Report View to create visualisations
  • Using Data View to sort and Format data

  • Importing a variety of data sources into Power BI Desktop
  • Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.

  • Understanding the Data Model
  • Using Relationship View
  • Creating Many-to-One relationships
  • Understanding Filter propagation

  • Adding visualisation to the Report Canvas
  • Understanding and controlling interactions between visualisations
  • Using Drill Down and Drill Through on visualisations
  • Creating and using Heirarchies
  • Importing custom visualisations
  • (Course attendees can practice creating and designing a variety of the many interactive visalisations available in Power BI)

  • Exploring the importance of custom calculation within the Data Model
  • Creating Calculated Columns & Measures
  • Understanding Evaluation Context
  • Using CountRows and DistinctCount Functions
  • Advanced DAX functions: SUMX and CALCULATE
  • Time Intelligence Functionsject system integration, ps-cd (fi-ca) integration, funds management integration)

  • Understanding the role of Queries in data import
  • Understanding Extract, Transform & Load (ETL)
  • Exploring a variety of data transformations
  • Working with Applied Steps
  • Creating and using Query Parameters

  • Publish your Report to PowerBI.com
  • Creating Dashboards
  • Using Quick Insights
  • Using Q & A for interactive data searching.

  • Connecting to a variety of Cloud-based data sources, including OneDrive, Google Analytics, Azure SQL Databases and Websites.
  • Using Excel's Power Pivot Data Model in Power BI Service

  • Creating a Power Pivot Data Model in Excel
  • Importing a Power Pivot data Model into Power BI Service
  • Creating a variety of visualisations in Power BI Service using Power Pivot data.

  • How to share your interactive Power BI Dashboards with people both inside and outside your organisation.
  • Sharing using Power BI, Web, PowerPoint and others
  • Creating and Managing Content Packs

  • Manually refreshing data
  • Installing and using the Personal Gateway
  • Installing and using the Enterprise Gateway
  • Creating a Scheduled Refresh

  • Understanding the mobile clients
  • Tablet Clients, Windows 10, iPad and Android
  • Differences between iPhone, Ipdad and Android clients

Request a Live Demo


MORE COURSE DETAILS

Frequently Asked Questions (FAQs)

If you wish to build your career, then this course is the perfect choice for you. We focus on providing you with in-depth knowledge of every course-related topic. Besides, we teach you the practical application of everything that you have learned in the form of theory.

Yes! Tech Smart IT Solutions not only focuses on the deliverance of theoretical knowledge but on the deliverance of practical knowledge as well. We familiarize the trainees with real-world challenges and the ways to tackle them.

Well, we have a team of instructors with over 10 years of experience in their respective field. They have enough experience in dealing with the students. On that note, you can assure yourself to receive profound knowledge and a friendly attitude from the instructors.

Yes, as of now, we are offering two types of discounts. These are – group discount and referral discount. You become eligible for a group discount when you enrol as a group, whereas, a referral discount is offered when the course is referred to you by someone who’s already enrolled for the course.

Of course! By the end of the training programme, you will be well-versed with every topic from the curriculum. Moreover, you will be able to get your hands-on solving real-world problems. Hence, both these will help you invite more career opportunities for yourself.