Online & Classroom

Power BI Training Course

Months Icon 3 Months
38 Modules
Get In Touch

Key Features

OSACAD is committed to bringing you the best learning experience with high-standard features including

Key Features
Real-time Practice Labs

Learning by doing is what we believe. State-of-the-art labs to facilitate competent training.

Key Features
Physical & Virtual Online Classrooms

Providing the flexibility to learn from our classrooms or anywhere you wish considering these turbulent times.

Key Features
24/7 Support On Slack

Technical or Technological, we give you assistance for every challenge you face round-the-clock.

Key Features
Job Interview & Assistance

Guiding in & out, until you get placed in your dream job.

Key Features
Live projects with our industry partners

An inside look & feel at industry environments by handling real-time projects.

Key Features
Internship after course

Opportunity to prove your talent as an intern at our partner firms and rope for permanent jobs.

Why Power BI ?

Why Data Science
Streamlined publication and distribution

Instead of emailing large files or putting them on a shared drive, analysts upload reports and visualizations to the Power BI service, and their data is refreshed whenever the underlying dataset is updated

Why Data Science
Cortana integration

Power BI works with Microsoft’s digital assistant, Cortana. Users can verbally ask questions in natural language to access charts and graphs. This can be especially helpful for users with mobile devices

Why Data Science
Artificial Intelligence

Power BI users can access image recognition and text analytics, create machine learning models, and integrate with Azure Machine Learning

Who is This program for

  • Data Scientists,Statisticians,Business Analysts,Project Managers
  • Business Intelligence & Testing Professionals
  • Data Analysts and Functional Experts
  • Anyone who wish to embark on a career in analytics domain
Who is this program

Syllabus

Best-in-class content by leading faculty and industry leaders in the form of videos,
cases and projects, assignments and live sessions.

  • The Microsoft Self-Service Business Intelligence Solution
  • The Power BI Universe
  • Installing Power BI Desktop
  • A First Power BI Desktop Dashboard
  • The Data Load Process
  • The Power BI Desktop Window
  • Your First Visualizations
  • Interactive Dashboards
  • Formatting Reports
  • Creating and Modifying Reports
  • The Power BI Desktop Query Editor
  • Data Sources
  • Loading Data
  • Loading Multiple Files from a Directory
  • Loading the Contents of a Folder
  • The Navigator Dialog
  • Adding Your Own Data
  • SQL Server
  • Oracle Databases
  • Other Relational Databases
  • Microsoft SQL Server Analysis Services Data Sources
  • SSAS Tabular Data Warehouses
  • Import or Connect Live
  • ODBC Sources
  • OLE DB Data Sources
  • Modifying Connections
  • Changing Permissions
  • Refreshing Data from Databases and Data Warehouses
  • DirectQueryandConnectLive
  • Microsoft SQL Server Data
  • SQL Server Analysis Services Dimensional Data
  • Microsoft SQL Server Analysis Services Tabular Data Sources
  • Direct Query with Non-Microsoft Databases
  • Direct Queryand In-MemoryTables
  • Direct Query and Refreshing the Data
  • Web and CloudServices
  • Web Pages
  • Salesforce
  • Microsoft Dynamics365
  • Azure SQL Database
  • AzureSQLDataWarehouse
  • Connecting to SQL Server on an Azure Virtual Machine
  • Azure Blob Storage
  • Azure Security
  • PowerBIDesktopQueries
  • Query or Load?
  • The Power BI Desktop Query Editor
  • DatasetShaping
  • Removing Records
  • Sorting Data
  • FilteringData
  • Grouping Records
  • Saving Changes the Query Editor
  • Exiting the Query Editor
  • Viewing Full Record
  • Power BI Desktop Query Editor Context Menus
  • Using the First Row As Headers
  • ChangingDataType
  • Replacing Values
  • TransformingColumnContents
  • FillingDownEmptyCells
  • ExtractingPartofaColumn’sContents
  • Duplicating Columns
  • Splitting Columns
  • Merging Columns
  • Custom Columns
  • Creating Columns from Examples
  • Adding Conditional Columns
  • Index Column
  • The Power BI Desktop Query Editor View Ribbon
  • Merging Data Appending Data
  • Changing the Data Structure
  • Parsing JSON Files
  • The List Tools Transform Ribbon
  • Convert a Column to a List
  • Parsing XML Data from a Column
  • Parsing JSON Data from a Column
  • Managing theTransformation Process
  • Modifying the Code for a Step
  • Modifying Data Source Settings in the Query Editor
  • Managing Queries
  • Pending Changes
  • Reusing Data Sources
  • Parameterizing Queries
  • Power BI Templates
  • Copying Data from Power BI Desktop Query Editor
  • Data Modeling in the Power BI Desktop Environment
  • Data Modelor Query?
  • The Power BI Desktop Data View Ribbons
  • Managing Power BI Desktop Data
  • Power BI Desktop DataTypes
  • Formatting Power BI Desktop Data
  • Preparing Data for Dashboards
  • Sorting Data in Power BI Desktop Tables
  • Adding Hierarchies
  • Creating and Modifying Groups
  • Deleting a Group
  • Designing a Power BI Desktop DataModel
  • Creating Relationships
  • Advanced RelationshipOptions
  • Managing Relationships BetweenTables
  • TypesofCalculations
  • Adding New Columns
  • Concatenating Column Contents
  • TweakingText
  • Simple Calculations
  • Calculating AcrossTables
  • Cascading Column Calculations
  • UsingFunctionsinNewColumns
  • Simple Logic: The IF( ) Function
  • Making Good Use of the Formula Bar
  • A First Measure: Number of Cars Sold
  • Basic Aggregations Measures
  • Using Multiple Measures
  • Cross-TableMeasures
  • More Advanced Aggregations
  • FilterContext
  • Filtering Data in Measures
  • Simple Filters
  • More Complex Filters
  • Calculating Percentages of Totals
  • Filtering on Measures
  • Displaying Rank
  • A Few Comments and Notes on Using Measures
  • Calculation Options
  • Simple Date Calculations
  • Adding Time Intelligence to a DataModel
  • Creating and Applying a DateTable
  • Calculating the Difference Between Two Dates
  • Applying Time Intelligence
  • Comparisons with Previous Time Periods
  • ComparisonwithaParallelPeriodinTime
  • Rolling Aggregations over a Period of Time
  • Power BI Desktop Dashboards
  • Working with Tables
  • Changing the Table Size and Position
  • Changing Column Order
  • Renaming Fields
  • Removing Columns from aTable
  • Table Granularity
  • Enhancing Tables
  • FormattingTables
  • TableStyle
  • Adding and Formatting Titles
  • ModifyingtheTableBackground
  • Table Borders
  • RowFormatting
  • Table Grid
  • Column Headers
  • Column Formatting
  • FormattingTotals
  • Conditional Formatting
  • Creating Matrix
  • Expanding and Drilling Down and Up
  • Visualize Source Data
  • Viewing Records
  • Including and Excluding Matrix Elements
  • Displaying Multiple Values As Rows
  • Formatting Matrix
  • SortingDatainMatrices
  • Cards
  • Multirow Cards
  • Switching Between Table Types
  • A First Chart
  • Basic Chart Modification
  • Essential Chart Adjustments
  • Donut Charts
  • Funnel Charts
  • Multiple Data Values in Charts
  • 100% Stacked Column and Bar Charts
  • Scatter Charts
  • BubbleCharts
  • WaterfallCharts
  • RibbonCharts
  • Dual-AxisCharts
  • Data Details
  • Drilling into and Expanding Chart Data Hierarchies
  • Including and Excluding Data Points
  • Multiple Chart Formatting
  • Chart Legends
  • Tooltips
  • Specific Chart Formatting
  • Bubble Chart Play Axis
  • Chart Analytics
  • Scatter Chart Symmetry Shading and Ratio Line
  • TreeMaps
  • Gauges
  • KPIs
  • RVisuals
  • Additional Visuals
  • Loading Custom Visuals
  • ARapidOverviewofaSelectionofCustomVisuals
  • Custom Slicers
  • Working with Bing Maps
  • Creating Maps in Power BI Desktop
  • Using Geographical Data
  • Drilling Down in Maps
  • Adjusting the Map Display in Power BI Desktop
  • Filled Maps
  • Shape Maps
  • Formatting Maps
  • ARCGis Maps
  • Filters
  • Visual-LevelFilters
  • Filtering Different Data Types
  • Advanced Text Filters
  • Specific Visualization-Level Filters
  • Multiple Filters
  • Page-Level Filters
  • Report-LevelFilters
  • Removing Filters
  • Filter Field Reuse
  • Using The Filter Hierarchy
  • Filtering Tips
  • Slicers
  • Date Slicers
  • Formatting Slicers
  • Using Charts As Slicers
  • Charts As Complex Slicers
  • Specifying Visual Interactions
  • What-If Slicers
  • Custom Visuals As Slicers
  • Choosing the Correct Approach to Interactive Data Selection
  • Formatting Ribbons
  • Formatting the Page
  • Aligningand Distributing Visuals
  • Adding Text Boxes to Annotate a Report
  • ModifyingthePageBackgroundColor
  • Images
45+
Hours of Content
7+
Case Study & Projects
40+
Live Sessions
30+
Assignments
8+
Capstone Projects to Choose From
10+
Tools, Languages & Libraries

Languages and Tools covered

Languages and Tools covered Languages and Tools covered Languages and Tools covered Languages and Tools covered Languages and Tools covered Languages and Tools covered

Hands On Projects

A Broader Analysis on Education System Across Globe

Building an Analytical Dashboard on Education System with all the features available in PowerBI

NewZealand Regional Tourism Expenditure Analysis and Forecast

Building an Regional Tourism Dashboard to analyse different KPI's and performing Forecasting mechanism.Involves Complex mechanisms like building of Drill Down dashboards along with Parameter Actions.

Indian COVID-19 Tracker

Building an interactive Dashboard for tracking the covid-19 cases in India via Regionwise, Statewise, Citywise, Districtwise using the live COVID-19 API

Certification

Our training is based on latest cutting-edge infrastructure technology which makes you ready for the industry.Osacad will Present this certificate to students or employee trainees upon successful completion of the course which will encourage and add to trainee’s resume to explore a lot of opportunities beyond position

Enroll Now
Learn From Home

First-Ever Hybrid Learning System

Enjoy the flexibility of selecting online or offline classes with Osacad first-ever hybrid learning model.
Get the fruitful chance of choosing between the privilege of learning from home or the
advantage of one-on-one knowledge gaining - all in one place.

Learn From Home

Learn from Home

Why leave the comfort and safety of your home when you can learn the eminent non-technical courses right at your fingertips? Gig up to upskill yourself from home with Osacad online courses.

Learn From Home

Learn from Classroom

Exploit the high-tech face-to-face learning experience with esteemed professional educators at Osacad. Our well-equipped, safe, and secure classrooms are waiting to get you on board!

OR
Our Alumina Works at
Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works Our Alumina Works

Testimonials

FAQ’s

Artificial Intelligence which is a global company with headquarters in Chicago, USA. Artificial Intelligence has partnered with GamaSec, a leading Cyber Security product company. Artificial Intelligence is focusing on building Cyber Security awareness and skills in India as it has a good demand in consulting and product support areas. The demand for which is predicted to grow exponentially in the next 3 years. The Artificial Intelligence training programs are conducted by individuals who have in depth domain experience. These training sessions will equip you with the fundamentalknowledge and skills required to be a professional cyber security consultant.

All graduates of commerce, law, science and engineering who want to build a career in cyber security can take this training.

There are a number of courses, which are either 3 months or 6 months long. To become a cyber security consultant we recommend at least 6 to 9 months of training followed by 6 months of actual project work.During project work you will be working under a mentor and experiencing real life customer scenarios.

You can get started by enrolling yourself. The enrollment can be initiated from this website by clicking on "ENROLL NOW". If you are having questions or difficulties regarding this, you can talk to our counselors and they can help you with the same.

Once you enroll with us you will receive access to our Learning Center. All online classrooms, recordings, assignments, etc. can be accessed here.

Get in touch with us

What do you benefit from this programs
  • Get an in-depth knowledge from basic to advanced level on PowerBI
  • Interactive Learning & Comprehensive hands-on sessions with PowerBI
  • Extensive Knowledge on DAX Expressions and slicers
  • Projects like visual analytics, creating dashboards, story-telling with PowerBI

I’m Interested

Related Courses

Python

Python is a powerful general-purpose programming language. It is used in web development, data science, creating software... Read More

R For Data Analysis

R is a programming language that is designed and used mainly in the statistics, data science, and scientific communities. R has... Read More

Python For Data Analysis

Python for Data Analysis is concerned with the nuts and bolts of manipulating, processing, cleaning, and crunching data in.... Read More

Tableau

Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying... Read More

Call Us