Microsoft Power BI Training & Certification

  • Course Duration40 Hrs.
  • Course ModeInstructor Led Training
  • Course Fee₹ 7800

About The Course

AI Council launches its certification in the field of Business as Business Intelligence certified professional. Microsoft Power BI is a latest tool in the field of Business data statistical analysis. Our training curriculum has been designed in such a way that our learner will have in depth experience of Power BI which is a set of tools and applications that lets you extract data from multiple unrelated sources and convert it into neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs and reports. Our online session comprises with Power BI architecture, Desktop, Services, Visualisations, Report generation, Mobile apps and business insights. On completion our learners will get official course material issued by Microsoft for Power BI

Key Features

Instructor–led training

Highly interactive instructor-led training

Free lifetime access to recorded classes

Get lifetime access of all recored classes in your profile

Regular assignment and assessments

Real-time projects after every module

Lifetime accessibility

Lifetime access and free upgrade to the latest version

3 Years of technical support

Lifetime 24/7 technical support and query resolution

Globally Recognized Certification

Get global industry-recognized certifications

Highlights

  • Stepping into Power BI concepts along with its components: - Desktop, Service & Mobile Apps
  • Deriving insights from tabular data after analysing it
  • Creating reports and visualizations
  • Become a Business Intelligence Professional
  • Using Salesforce Data, Azure SQL Database and SQL server analysis tabular data
  • Live project experience

Mode of Learning and Duration

  • Weekdays - 5 weeks
  • Weekend – 6 weeks
  • FastTrack Batch - 4 weeks
  • Weekdays – 5 weeks
  • Weekend – 6 weeks
  • FastTrack Batch - 4 weeks

 

Course Agenda

  • What is Microsoft Power BI
  • Key features of Power BI workflow
  • Desktop Application and BI Services
  • Self Service Business Intelligence (SSBI) tools
  • SSBI Tools
  • Flow of Power BI
  • Components of Power BI - Power View, Map, Query, Pivot, Power Q & A
  • Architecture of Power BI
  • Building Blocks of Power BI
  • Sourcing data from web (OData, Azure)
  • Building dashboard
  • Data visualization & publishing to cloud
  • DAX data computation
  • Row context & filter context
  • Analytics Pane,
  • Creating columns and measures, creating tables & binned tables
  • Data drill down and drill up
  • Data modelling and relationships
  • The Power BI components like
  • Understanding Power BI Desktop
  • Data Sources in Power BI Desktop
  • Aggregating data from multiple data sources
  • Connecting to a data Sources
  • Power Query Editor in Power BI
  • Clean and Transform your data with Query Editor
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
  • Views in Power BI Desktop
  • Data modelling and data relationships
  • Deploying data gateways & scheduling data refresh
  • Manage Data Relationship
  • Managing groups and row level security
  • Datasets, reports and dashboards
  • Working with calculated measures
  • Cross Filter Direction
  • Create calculated tables and measures
  • Optimizing Data Models
  • Power Pivot on Power BI Desktop ecosystem
  • Data visualization
  • Power View on Power BI Desktop & creating real world solutions using Power BI
  • Learning about Power Query for self-service ETL functionalities
  • Data mashup & working with Excel data
  • Learning about Power BI Personal Gateway
  • Extracting data from files, folders and databases
  • Azure SQL database and database source
  • Connecting to Analysis Services
  • SaaS functionalities of Power BI.
  • Introduction to Power Pivot
  • Various versions and relationships
  • Data Analysis Expressions & Measures
  • Calculated Members, Row, Filter & Evaluation Context
  • Context Interactions
  • Context over Relations & Schema Relations
  • Concepts of DAX
  • DAX Syntax & Data types
  • Calculation Types
  • DAX Functions
  • Measures in DAX
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • DAX Parameter Naming
  • Ranking and rank over groups
  • Power Pivot advanced functionalities with date and time functions
  • DAX advanced features
  • Embedding Power Pivot in Power BI Desktop
  • Detailing about Power BI data visualization
  • Power View and Power Map
  • Power BI Desktop visualization & formatting and customizing visuals
  • Charts in Power BI
  • SandDance visualization
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Filtering and sorting data using Power View & Practising Hierarchies
  • Power View on SharePoint and Excel
  • Top down and bottom up analytics
  • Comparing volume and value-based analytics
  • Gauges and Single Number Cards
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • What Are Custom Visuals?
  • Page layout and formatting
  • KPI Visuals
  • Z-Order
  • Authenticate a Power BI web application
  • Embedding dashboards in applications
  • Introduction to Power Q & A
  • Power BI Service
  • Dashboard vs. Reports
  • Quick Insights in Power BI
  • Creating Dashboards
  • Configuring a Dashboard
  • Power BI Q&A
  • Ask questions of your data with natural language
  • Getting answers in the form of charts
  • Power BI embedded
  • Graphs and data discovery methodologies
  • Ad hoc analytics building
  • Integrating with SaaS applications
  • Using Excel data in Power BI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services & My SQL
  • Power BI Development API
  • Using Power View and Power Pivot in Power BI
  • Power BI Publisher for Excel
  • Content packs
  • Power BI Mobile
  • Report Server Basics
  • Web Portal
  • Paginated Reports
  • Row level Security
  • Data Gateways
  • Scheduled Refresh
  • Resources (Rest API/ SOAP API’s/ URL Access)
  • R Integration in Power BI Desktop
  • R visuals in Power BI
  • R Powered Custom Visuals
  • Creating R visuals in Power BI
  • R Visuals in Power BI Service
  • R Scripts Security
  • Creating visual using Python

 

Projects

Problem Statement: - Two ways analysis over transport cost with visualisation to identify leakage and plug it.

Description: - It is a Power BI project for analysing transportation cost through BI visualisation. We will figure out the outliers in the data pattern using top down analysis and bottom up analysis. It will be focused on creating a BI dashboard and creating a BI visualisations.

Problem Statement: - Analysing the demand and product availability in a supermarket to manage store.

Description: - It is a Power BI project we will create in order to analyse billing patterns or demand arises vs. the quantity available in the store for proper store management. We will build a set of visualization which will linked to dynamic measures in order to get desired insights. Power BI dashboard and visualisation will be a handy tool in the process.

Problem Statement: - Analyse different hospitals record to get a insights about cancer patients recovery rate.

Description: - It is a Power BI project to analyse how different hospitals are offering treatments to the cancer patients. We will analyse the patients admitted vs discharged fit or deceased. We will build a set of visualisation and dashboard linked with dynamic measures in order to flip some analytics from top down to bottom up to get required insights.

 


Certification

Career Support

We have a dedicated team which is taking care of our learners learning objectives.


FAQ

There is no such prerequisite if you are enrolling for Master’s Course as everything will start from scratch. Whether you are a working IT professional or a fresher you will find a course well planned and designed to incorporate trainee from various professional backgrounds.

AI Council offers 24/7 query resolution, you can raise a ticket with a dedicated support team and expect a revert within 24 Hrs. Email support can resolve all your query but if still it wasn’t resolved then we can schedule one-on-one session with our instructor or dedicated team. You can even contact our support after completing the training as well. There are no limits on number of tickets raised.
AI council provide two different modes for training one can choose for instructor lead training or learning with prerecorded video on demand. We also offer faculty development programs for college and schools. apart from this corporate training for organization/companies to enhance and update technical skills of the employees. We have highly qualified trainers who are working in the training industry from a very long time and have delivered the sessions and training for top colleges/schools and companies.
We are providing a 24/7 assistance for the ease of the student. Any query can be raised through the interface itself as well as can be communicated through email also. If someone is facing difficulties with above methods mentioned above we can arrange a one on one session with the trainer to help you with difficulties faced in learning. You can raise the query throughout the total training period as well as after the completion of the training.
AI Council offers you the latest, appropriate and most importantly the real-world projects throughout your training period. This makes student to gain industry level experience and converting the learning’s into solution to create the projects. Each Training Module is having Task or projects designed for the students so that you can evaluate your learning’s. You will be working on projects related to different industries such as marketing, e-commerce, automation, sales etc.
Yes, we do provide the job assistance so that a learner can apply for a job directly after the completion of the training. We have tied-ups with companies so when required we refers our students to those companies for interviews. Our team will help you to build a good resume and will trained you for your job interview.
After the successful completion of the training program and the submission of assignments/quiz, projects you have to secure at least B grade in qualifying exam, AI Council certified certificate will be awarded to you. Every certificate will be having a unique number through which same can be verified on our site.
To be very professional and transparent No, we don’t guarantee the job. the job assistance will help to provide you an opportunity to grab a dream job. The selection totally depends upon the performance of the candidate in the interview and the demand of the recruiter.
Our most of the programs are having both the modes of training i.e. instructor led and self-paced. One can choose any of the modes depending upon their work schedule. We provide flexibility to choose the type of training modes. While registering for courses you will be asked to submit your preference to select any of the modes. If any of the course is not offered in both modes so you can check in which mode, the training is going on and then you can register for the same. In any case if you feel you need any other training mode you can contact our team.
Yes, definitely you can opt for multiple courses at a time. We provide flexible timings. If you are having a desire for learning different topics while continuing with your daily hectic schedule our course timing and modes will help you a lot to carry on the learning’s.
Whenever you are enrolling in any of the courses we will send the notification you on your contact details. You will be provided with unique registration id and after successful enrollment all of the courses will be added to your account profile on our website.AI Council provides lifetime access to course content whenever needed.
A Capstone project is an outcome of the culminating learning throughout the academic years. It is the final project that represents your knowledge, efforts in the field of educational learning. It can be chosen by the mentor or by the students to come with a solution.
Yes, for obtaining the certificate of diploma programmer you have to submit the capstone project.