Program Overview
This course will help the students in creating meaningful visualizations, converting raw data into meaningful and concrete information. They would be able to perform multiple tasks on any given data, like creating charts, graphs, geographic analysis using map features, KPI’s and many more.
The ETL (Extraction, Transformation and Loading) operations can be augmented using M-Query or Power Query features of Power BI Desktop. The DAX functionality of Power-Bi leverages the users to perform complex operations on datasets, data wrangling and massaging the data for sharing through Power BI Service platform which is handy for key stakeholders in decision making.
Power BI provides interactive visualizations with self-service business intelligence capabilities. Where end users can create reports, dashboards by themselves, without having to depend on any information from Reporting staff or database administrator.
Power BI is a straightforward tool; anyone can learn this who has a basic understanding of Excel. Learning Power BI is recommended for anyone who works with massive data and handles many reporting tasks regular basis. Power BI is one of the leading Business intelligence tools, gaining more and more popularity because of it’s easy to access, sharing capabilities also it’s economical pricing.
During the session, attendees will be working on real time business scenarios and case studies, exclusively prepared for enhancing analytical, preparation of impactful visualizations, calculations, and logical thinking capabilities.
Learning Outcomes
Upon completion of this program, participants will:
- Building and refine models, including adding calculated columns and measures
- You will learn the important M and DAX functions, to enable you to build your own formulas
- Utilizing the ETL tool of Power BI for creating meaning reports
- Getting familiar with the powerful features of DAX and Mquery language
- Using Dashboard functionality of Power Bi Service
Intended Audience
- Students
- HR, Finance and Banking professional
- Entrepreneurs
- Data and Business Scientists
- Data Science scholars
- IT professionals
- Government employees
- Educators, Researchers , Statisticians and Academicians
Program Outline
- Syllabus for Power BI
- Mquery
- Exploring Power
- Query Editor
- Home Tab
- Manage Columns
- Reduce Rows and use First Rows as Headers
- Sort and Filter
- Split columns
- Other Transform Activities – Group By
- Merge Queries and Expand Table
- Merge Queries with Group by and different types of joins
- Append Queries
- Append Three or more queries
- Combining files
- Transform - Text and Numbers
- Transform/ Add Column – Text- Format
- Merge Columns
- Extract
- Parse
- Number statistics and standard
- Adding Conditional Column
- Column from Examples
- Conditional Column
- Resolving Errors from Conditional Columns
- Index Column and Duplicate Column
- If Then Else
- Introduction to DAX functions including logical functions
- Getting multiple datasets and connecting them together
- Calculated Column
- Basic Operators
- IF, BLANK, ISBLANK
- AND, OR, NOT
- SWITCH
- Time Intelligence Functions
- First Date & Last Date
- Start of the month, Year, quarter and End of the month, year, quarter
- Previous and Next
- DatesinPeriod
- DATESMTD,DATESQTD,DATESYTD,TOTALMTD,TOTALQTD
- Dashboards
- Difference between Dashboards and Reports
- Manage tiles on dashboard, set mobile view, and other tilesoptions
- Dashboard Options
- Pin a Live report on dashboard
- Use QnA Feature