Course Details
Microsoft
Power BI is a cloud based service that provides business intelligence tools for
sharing data, data visualizations, analysing and aggregating data for non-technical
users. Power BI integrates seamlessly with existing applications and user
friendly which offers advanced data services with precise and accurate business
intelligence mechanisms along with security in publishing the reports. As Power
BI has emerged as market leader in business analytics domain, Power BI skills,
certification can offer jobs in large MNC companies with handsome salaries.
Learn Power BI tutorial with examples and step by step guidance. Enroll in this
Power Bi course online today for Power BI jobs for freshers, power BI interview
questions and placements.
Introduction to Power BI
What is business Intelligence? , Traditional BI vs Self Serviced BI, Flow of Work in Power BI (Connecting to Data Source, Shaping the Data, Creating the visuals, hosting the report in powerbi.com, A Brief History of Power BI, Power BI Desktop Software Installation, Different Data Sources in Power BI, Connection Types in Power BI, Importing Data to Power BI, understanding Power Query Interface, Transforming Data with Power Query.
Data visualizations
Why we need to visualizations?, visualizing a Timeline Report with Line Chart, Filters in Power BI( Visual, Page and report), Formatting Power BI Charts, Adding a new chart to the canvas, Creating a Top N Report with Bar Chart, Controlling Visual Interactions on the canvas, working with shapes and textbox, Creating a Top N Report with Bar Chart,
Data Modelling and Relationships
Why to build a data model, Building a Data Model, Hierarchies in tables, Relationships between tables (One-One, One-Many, Many-Many)
Inro to DAX and Measures Creation
Difference between calculated columns and measures, Date and Time Functions, Filter Functions, information functions, Math functions, Text Functions, Time Intelligence Functions, Statistical Functions, Table Manipulation Functions, Relationship Functions
.
Real Time Business Use cases
Visualizing monthly revenue vs SPLY on line chart, creating forecast from line chart, visualizing Monthly Variance with waterfall chart, Creating a Matrix Table report with data bars, Creating Donut Chart, visualizing Current and Previous Period with Clustered Bar Chart, visualizing changes in ranking using ribbon chart
.
Taking the project to the cloud with power BI pro (service)
Why We need Power BI PRO, Creating Power BI Service account, Power BI: Desktop(free) Vs Pro Vs Premium, Exploring the Power BI Pro Interface, Understanding the Workspaces, Understanding the Datasets in Power BI Pro, Manage Roles, Create Roles and Testing Roles
Row Level Security Power BI
Adding Members to Roles in Power BI Service, Creating the Users Table and Adding to the Model, Capturing the users using the Username() or UserPrincipalName() Functions
Requirements
- Excel modeling, excel functions like pivot tables etc are desired but not required.
- Experience in SQL is desired but not required
- Power BI desktop software for practice.
Skills Acquired
- Developing visual reports, dashboards and ability to identify KPI using Power BI desktop.
- Importing, transforming data and conecting data sources for business intelligence.
- Transforming data into visualizations and client friendly reports.
- Skills in DAX queries in building reports
- Design, develop, test, and deploy Power BI scripts and perform detailed analytics.
- Ability to redefine and make technical/strategic changes to Business Intelligence systems
FAQ
Answer: In short, Yes. Business Intelligence and Data Analytics market is growing at an extremely fast rate and Power BI is the market leader in the industry. So, if you are a fresher, you need is to have a good knowledge in MS Excel and Power BI to get hired depending on requirements of the company. Kindly contact us for any job assistance to become a Power BI developer.
Answer: According to glassdoor, the national average of salaries of Power BI developer in India is about 5.5-6 lakhs per annum. With a 3 year experience the salary can go as high as 10 lakhs per annum
Answer: Yes, this is Power BI tutorial for beginners with step by step guidance. Please watch the demo class for a good understanding.
Answer: Yes, there are sample projects in this course. Kindly enroll for complete access.
