- Instructor: Ramesh
- Lectures: 103
- Students: 60
- Duration: 5 weeks
Microsoft Power BI Online Course
Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services – Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms. These set of services are used by business users to consume data and build BI reports.
Power BI desktop app is used to create reports, while Power BI Services (Software as a Service- SaaS) is used to publish the reports.
Power BI – Architecture which includes power BI Desktop, Power BI Gateway, Power BI mobile Apps, and Power BI Services.
In this Power BI Online training you will be learning Power BI Components and its services which are used to publish reports and data visualizations. Power BI supported data sources such as Flat files, SQL Data base, Odata Feed, Blank Query, Azure cloud platform, Online services, Blank query  and other data sources such as Hadoop etc and its connection to extract the data from the source files and cleaning data using built in Query Editor, combining data from multiple sources. In this tutorial you will also learn how to shape a query by using Power BI Desktop. Power BI auditing, Power BI elastic search , Power BI paginated reports, Power BI slicer search, dax calculate filter and Power BI color theme and much more with Power BI Desktop you can create complex and visually rich reports.
You will also learn how  to connect different online services such as Exchange, Salesforce , Google Analytics and Facebook.
You will be learning DAX, which helps you get the most out of your Charts and Visualization and solve real business problems.
We cover DAX functions, operators, and constants that can be put into the form of formulae to calculate values with the help of data already present in your model.
This course will provide training on Technical Inception and Data Analyzing engagement with Power BI.
Turn data into opportunity. Drive better business decisions across your organization with Power BI.
After your course completion you will be having hands on experience on belowÂ
- How to connect data
- Transform and clean that data, to create a data model
- Create visuals, such as charts or graphs that provide visual representations of the data
- Create reports that are collections of visuals, on one or more report pages
- Share reports with others using the Power BI service    Â
- How to access your results from multiple devices using Power BI Mobile
- How to create custom visuals using typescript and the Power BI Developer Tools
- Power Bi is also a part of a few edx courses, preparation of data engineering, and managers who need skills for accessing big and long data. With our extensive power Bi training course, you will have a chance to grow your career and to open many career opportunities as a data scientist, product manager, business analyst, etc. Power Bi course will not only give you learning about this tool but will make your resume stand out from candidates in job queues.
Eligible Aspirants for Power BI Course
- Fresher who wanted to begin their career in Data Analyzing field
- One who interested in learning the skills in open mind
- People who want to understand how to create customized visuals with the Power BI Developer tools
Benefits of pursuing DevOps Course in ICONITINC
Aspirants will be benefited with unique features delivered by ICONIITINC
Unique Features in ICONIT INC
1.Limited Students :
We deploy dedicated trainers for each batch. Each batch consists of limited students maximum 10 in the group. Each student in the group is taken care individually. All the doubts in the session will be clarified on immediate basis. Trainers provide support in practical’s during projects.
You will be guided with case studies which help to get hands on experience on the projects as per the industry standards.
You will be attending live sessions of the trainer, no pre recorded videos.
2.Resume Preparation:
Candidate:
Why is Resume writing important?
Expert Says:
A resume is an important tool for your job search. It showcases your knowledge, your skills, experience, expertise, and accomplishments.
How ICONIT INC works here
We have remarkable proficiency in delivering job seekers the invaluable edge of dynamic, Text resumes that make them stand out from the competition. We professionally and effortlessly prosper in articulating the drawing out the strengths employers focus on when selecting candidates. Our ground-breaking, consultative approach has resulted in a strong success rate for our clients across the globe.
Our dedication and passion for bringing out the best from each draft we handle had provided us multiple opportunities for generating winning drafts for career transition and cross-functional resumes too. We are an enthusiastic and creative customer-focused writers, an experts at details, and producing quality work.
ICONITINC helps you to build a solid reputation, advance your career and command a higher salary
3.Mock Interviews
Mock interview reflects an actual job interview. It helps to test your on-going interview preparation. It gives an opportunity to prepare, up to level of the industry standards. It gives an idea of what to say and do during the interview. A mock interview is useful in reviewing your answers to common questions and assessing other technical Skills.
ICONIT INC arranges 3 mock interviews for your actual interview preparation. It helps to practice better and become perfect to do well in the actual interview.
4.Job Assistance
ICONIT INC will arrange 3 interviews from the top MNC’s.Candidate is purely responsible for clearing the interview.
-
Introduction to Power BI
-
Lecture 1.1Introduction to Power BI
-
Lecture 1.2Introduction to Business Intelligence
-
Lecture 1.3Key Benefits or Features of Power BI
-
Lecture 1.4Components of Power BI
-
Lecture 1.5Data Visualization, Reporting
-
Lecture 1.6Business Intelligence(BI), Traditional BI, Self-Serviced BI
-
Lecture 1.7Cloud Based BI, On Premise BI
-
Lecture 1.8Power BI Products
-
Lecture 1.9Power BI Desktop (Power Query, Power Pivot, Power View, Power Map, Power BI Q & A)
-
Lecture 1.10Flow of Work in Power BI Desktop
-
Lecture 1.11Power BI Service
-
-
Power BI Desktop
-
Lecture 2.1Overview of Power BI Desktop
-
Lecture 2.2Data Sources in Power BI Desktop
-
Lecture 2.3Power BI Desktop User Interface
-
Lecture 2.4Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
-
Lecture 2.5Overview of Power Query / Query Editor – Extract, Transform & Load Data
-
Lecture 2.6Connecting to Data Sources
-
Lecture 2.7Importing Data into Power BI or Query Editor
-
Lecture 2.8Query Editor in Power BI
-
Lecture 2.9Import, Direct Query
-
Lecture 2.10Limitations of Direct Query
-
Lecture 2.11Basics of M Language
-
Lecture 2.12Clean and Transform your data with Query Editor
-
Lecture 2.13Combining Data – Merging and Appending
-
Lecture 2.14Cleaning irregularly formatted data
-
Lecture 2.15Modeling Data
-
Lecture 2.16Manage Data Relationship
-
Lecture 2.17Cross Filter Direction
-
Lecture 2.18Creating New Measures and New Columns using DAX – Data View
-
Lecture 2.19Visualizing the Data using Power View and Power Maps – Report View
-
Lecture 2.20Saving and Publishing the Visuals or Reports
-
Lecture 2.21Logon to Power BI Service
-
Lecture 2.22View the Reports in PBI Service
-
-
Power Query
-
Lecture 3.1Introduction to Power Query – Extract, Transform & Load
-
Lecture 3.2Data types, Changing the Data type of a Column
-
Lecture 3.3Various Filters in Power Query( Text, Number, Date )
-
Lecture 3.4Inbuilt Column Transformations
-
Lecture 3.5Remove Columns / Remove Other Columns
-
Lecture 3.6Rename a Column
-
Lecture 3.7Reorder Columns or Sort Columns
-
Lecture 3.8Add Column / Custom Column
-
Lecture 3.9Split Columns
-
Lecture 3.10PIVOT, UNPIVOT Columns
-
Lecture 3.11In built Row Transformations
-
Lecture 3.12Header Row or Use First Row as Headers
-
Lecture 3.13Keep Top Rows, Keep Bottom Rows
-
Lecture 3.14Keep Range of Rows
-
Lecture 3.15Keep Duplicates, Keep Errors
-
Lecture 3.16Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows, Remove Duplicates
-
Lecture 3.17Combine Queries
-
Lecture 3.18Append Queries
-
Lecture 3.19Merge Queries
-
-
Power Pivot
-
Data Analysis Expressions (DAX)
-
Lecture 5.1Introduction to DAX
-
Lecture 5.2DAX Syntax
-
Lecture 5.3Data Types in DAX
-
Lecture 5.4Creating Calculated Columns, Creating Measures , Tables
-
Lecture 5.5Calculated Columns Vs Measures
-
Lecture 5.6Text Functions
-
Lecture 5.7Math & Statistical Functions
-
Lecture 5.8Date and Time Functions
-
Lecture 5.9Logical Functions
-
Lecture 5.10Filter Functions
-
Lecture 5.11Time Intelligence Functions
-
Lecture 5.12DAX queries
-
Lecture 5.13DAX Parameter Naming
-
Lecture 5.14Time Intelligence in DAX
-
-
Data Visualization(Power View)
-
Lecture 6.1Introduction to visuals in Power BI
-
Lecture 6.2Tables and Matrixes
-
Lecture 6.3Various Visualization Objects in Power BI
-
Lecture 6.4Slicers
-
Lecture 6.5Map Visualizations
-
Lecture 6.6Gauges and Single Number Cards
-
Lecture 6.7Modifying colors in charts and visuals
-
Lecture 6.8Shapes, text boxes, and images
-
Lecture 6.9What Are Custom Visuals?
-
Lecture 6.10KPI Visuals
-
Lecture 6.11Formatting Options in Reports
-
Lecture 6.12Page Layout
-
Lecture 6.13Various Filter types(Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters)
-
-
Power BI Service
-
Lecture 7.1Introduction to Power BI Service
-
Lecture 7.2Workspaces
-
Lecture 7.3Publishing The Reports
-
Lecture 7.4Creating Dashboards
-
Lecture 7.5Dashboard Vs Reports
-
Lecture 7.6Configuring a Dashboard
-
Lecture 7.7Power BI Q&A
-
Lecture 7.8Ask questions of your data with natural language
-
Lecture 7.9Data Gateways
-
Lecture 7.10Enterprise Vs Personal Gateway
-
Lecture 7.11Scheduled Refresh
-
-
Data sources
-
Advanced Analytics in Power BI
Leave feedback about this