Visualisation and Data Analysis in Microsoft Power BI in Mumbai

Visualisation and Data Analysis in Microsoft Power BI

LIVE

25 Hours

Course offered by Trisha Jagtiani

6 reviews

overview batches reviews

Module 1: Introduction to Power BI (Duration-5hrs)

Get Started with Power BI
Overview: Power BI concepts
Sign up for Power BI
Overview: Power BI data sources
Connect to a SaaS solution
Upload a local CSV file
Connect to Excel data that can be refreshed
Connect to a sample
Create a Report with Visualizations
Explore the Power BI portal

Module 2: Viz and Tiles (Duration-5hrs)

Overview: Visualizations
Using visualizations
Create a new report
Create and arrange visualizations
Format a visualization
Create chart visualizations
Use text, map, and gauge visualizations and save a report
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
Download and use a custom visual from the gallery

Module 3: Reports and Dashboards (Duration-10hrs)

Modify and Print a Report
Rename and delete report pages
Add a filter to a page or report
Set visualization interactions
Print a report page
Send a report to PowerPoint
Create a Dashboard
Create and manage dashboards
Pina report tile to a dashboard
Pin a live report page to a dashboard
Pin a tile from another dashboard
Pin an Excel element to a dashboard
Manage pinned elements in Excel
Add a tile to a dashboard
Build a dashboard with Quick Insights
Set a Featured (default) dashboard
Ask Questions about Your Data
Ask a question with Power BI Q&A
Tweak your dataset for Q&A
Enable Cortana for Power BI

Module 4: Publishing Workbooks and Workspace (Duration-5hrs)

Share Data with Colleagues and Others
Publish a report to the web
Manage published reports
Share a dashboard
Create an app workspace and add users
Use an app workspace
Publish an app
Create a QR code to share a tile
Embed a report in SharePoint Online

Module 5: Other Power BI Components and Table Relationship (Duration-5hrs)

Use Power BI Mobile Apps
Get Power BI for mobile
View reports and dashboards in the iPad app
Use workspaces in the mobile app
Sharing from Power BI Mobile
Use Power BI Desktop
Install and launch Power BI Desktop
Get data
Reduce data
Transform data
Relate tables
Get Power BI Desktop data with the Power BI service
Export a report from Power BI service to Desktop

Module 6: DAX functions (Duration-5hrs)

New Dax functions
Date and time functions
Time intelligence functions
Filter functions
Information functions
Logical functions
Math & trig functions
Parent and child functions
Text functions

About the Trainer

5 Avg Rating

6 Reviews

20 Students

2 Courses

Trisha Jagtiani

Mcom

4 Years of Experience

She is a seasoned professional with over a decade of experience in the financial services industry. She started her career with a small stint in e-Clerx; she then moved on to join Prudential Process Management Services in the risk analytics department. Trisha was responsible for all MIS and reporting for Prudential globally.

This is where Trisha developed her excel skills and was recognized by the organization at every level. She was responsible for multiple projects of automating excel based reporting. Trisha has also traveled to US and UK extensively for excel automation projects. After a long stint with Prudential, she went on to join BNP Paribas in the Regulatory Reporting team, leading a team of analysts. She further mastered her excel skills in her new role.

Trisha has conducted over a 100 excel training sessions in the last couple of years. Her area of expertise with excel training range from excel for beginners to advanced and complex excel trainings.

In her spare time Trisha is fond of reading crime based fictional novels and loves to cook for her family.