Data Analytics with Power BI

The aim of the dashboard is to deliver the right findings and insights using the right KPIs and intuitive visualizations. The dashboard should convey a specific and clear message which should not need any external explanation.

– Fundamentals of KPIs and their respective visual format
– The visual variables used in visualizations
– What differentiates a good visualization from a bad one?
– Basic technical terminologies to get started with Power BI
– Different kinds of charts in Power BI– Introducing PowerBI Desktop

Power BI’s interface is rich in features and can connect to many different data sources. This part of the session covers the Power BI interface, the data storage formats, and the different features available.

– Connect different data sources
– Understand data statistically and visually
– Understanding Power Query Editor for data transformation and cleaning
– Working with multiple data files
– Understanding Data Normalization
– Understanding Facts and Dimension tables
– Create relationships among queries
– Making “dirty data” fit for analysis

Creating visuals by organizing data using hierarchies helps to summarize data in a more precise way. To further refine the data, you can apply different sorts of filters to find meaningful insights.

– Convert data types
– Create hierarchies in data to drill down
– Create groups
– Create basic visualizations
– Formatting visualization
– Apply in-built filters to a chart as slicers/ radio buttons/drop-down menu
– Understanding Focus Mode
– Adding interactivity in visuals for advanced presentation

While working with data and visualizations, it is very important to be able to narrow down what you see to make information easier to decipher. Filtering is an operation that helps you do that. This section deals with all possible and right ways to apply filters to data.

– Create Slicer
– Understanding and using the visualization pane for filtering
– Creating Visual Field filters
– Creating Top N Filters
– Adding page-level filters
– Understanding Filter Interaction in Reports

There could be cases where users would require plotting multiple dimensions in a visualization. For such cases, we would need to look toward more advanced visualizations. This module covers some of those visualizations and how one can choose the right visualization when needs to be plotted.

– Create Map Based Visualizations
– Create Gauge and TreeMap Visualizations
– Importing Custom Visualizations
– Create multiple report pages
– Understanding Drill through capabilities and cross-filtering on reports

To present our findings, we need to put everything together to form meaningful visualizations which can give us valid and important business insights. This section deals with how we can put various visualizations together to form a report.

– Create a report
– Machine Learning features in Power BI
– Build a narrative in your report
– Customising reports with shapes, images, text, backgrounds etc.
– Insight generation using Natural Language Processing in Power BI

There are some additional features provided in PowerBI which can make the process of building a report faster. In this section we discuss some of these new features and how they can be used.

– Using Natural Language Queries to make Visualizations
– Create a Visual using Q&A
– Understanding and using Quick Insights

Once a report has been locally built, its important to make it available to other people and share it. Also, making it portable is one of the key factors of today. This section will deal with how reports can be made readily available to various users.

– Understanding PowerBI Service (Participants require a business account)
– Publishing reports to PowerBI Service
– Accessing and sharing reports
– Installing the PowerBI mobile app
– Exploring the features of the PowerBI mobile app

After going through how you can create a report on PowerBI utilizing the basic features and business knowledge, its time to put it to the test! Working through a business case, and working in groups, we will try to come up with an apt report from the data, working through the different options PowerBI has to offer.

Notice
This course will be running and taught based on the PC Windows software and not Mac versions. (All Laptops and materials will be provided)

No prior PowerBI experience is required to take this Beginner Level Course. Having of some basic knowledge of Excel. charts and graphs would be an added advantage for you.