Description
Data visualization and Business intelligence both are required together and play a very important part in any organization’s management team. Business intelligence is a process that makes information easier to understand and data visualization is a method to tell a story of information.
Learning Objectives
On completing this course, learners will be able to:
- While learning about Power BI the very first aim is to know how to import Excel and other data sources into the Power BI to design impressive visuals
- Cleaned data only can provides amazing visualization
- Power Bi is powerful in extracting and meaningful insights from the data
- Charts, graphs, and dashboards are some common visualization forms of the data.
Course Content
- Importance of data visualization and different types of data that can be visually represented.
- Determination of the visualization which is most effective to display data for a given data set.
- Introduction to Power BI, Installation of Power BI,
- Introduction to power Pivot and Analysis using power Pivot
- Concept of Power Pivot,
- Introduction to Power Pivot environment
- Advantages of Power Pivot
- Power Query and Power View,
- Data Cleaning in Power BI using Power Query,
- Connecting data source in Power BI - Excel, CSV, live data source such as SQL, webpage etc,
- Index and Conditional Columns
- Writing functions and error handling
- DAX Expression,
- Measures, Calculated Members, Row, Filter & Evaluation Context, Context Interactions, Context over Relations, Schema Relations
- Building basic charts in Power BI,
- Chart formatting in Power BI,
- Annotation in Power BI,
- Summary Tables
- Filters in Power BI - Page level filter, visual level filter and report level filters in Power BI, Slicers
- Connecting Python to Power BI and running Python scripts,
- Dashboard Creation
Deliverables
- 20 hours of learning – Live online sessions
- One-year access to LMS
- Our course material
- Assessment tests
- Post-training support
- Certificate of completion post assessment
Who is it for?
- MIS Professionals
- Business intelligence managers
- Data scientists
- Entrepreneurs
- Students
- Business analysts
- Project managers
Cancellation and refund policy
The refund policy in case of withdrawal of nomination would work as follows:-
- A refund of 50% of the fee would be provided for cancellation requests received up to five working days before the training start date
- Participants who cancel in less than five working days, or there is no show on the training date are liable to pay the full course fee and would not be entitled to refunds.
Cancellations must be made via emails only. However desirous participants can be accommodated in the future batches of program, without paying anything extra. It is requested that willingness to attend any future program should be communicated at the earliest convenience.