Welcome to

Vidyarjan Academy

Learn

Power BI

Three Online Workshops on Sundays in July 2024

14 June – Get Started with Power BI
21 July – Visualizations in Power BI
28 July – Data Modeling in Power BI

9:30 am to 1:30 pm

Three Online Workshops

Attend one or two or all three workshops to progressively learn how to use Power BI Desktop for data visualization.

Get Started with Power BI

Attend this workshop to be able to use Power BI Desktop for developing simple dashboards from the tabular data stored in Excel or CSV files. You will perform the following activities in this workshop.

Learn about Power BI Product Family
Get and transform data from an Excel file about the states of India
Develop a simple dashboard with visuals such as bar chart, filled map, tree map, etc.
Get and transform data from a CSV file about the states of USA
Merge this data with the state-wise population data downloaded from web
Develop a simple dashboard with visuals such as card, pie chart, slicer, etc.
Get and transform data from an Excel file containing salaries data
Develop a simple dashboard with visuals such as column chart, doughnut chart, table, etc.List item

Visualizations in Power BI

If you have used Power BI for developing simple dashboards then this workshop will help you to use almost all the available visuals in Power BI Desktop. Additionally, you will learn how to use measures. You will perform the following activities in this workshop.

Learn about four types of Power BI reports and their structure
Explore the available visualization types in Power BI
Get and transform data from an Excel file containing superstore sales data
Use DAX to create new measures and columns
Develop a four-page report with navigation buttons and visuals such as gauge, matrix, decomposition tree, etc.
Apply filters and conditional formatting in the table visual
Get and transform data from an Excel file containing financial data
Develop a simple dashboard with visuals such as slicer, line chart, map, and column chart

Data Modeling in Power BI

This workshop focuses on working with data stored in multiple tables or sheets. After attending this workshop, you will learn how to model data using star schema and then build complex visualization. You will perform the following activities in this workshop.

Learn about semantic data model and star schema design
Get and transform data from an Excel file (customer details) and a text file (invoice data)
Design a model with one fact table and one dimension table
Get and transform data from Excel file (dimensions data) and CSV files (fact data)
Design a model with three fact tables and four dimension tables
Get and transform data from the folders of CSV files (fact data)
Design a model with three fact tables and three dimension tables (created from fact data)
Develop three separate multi-page reports with visuals such as decomposition tree, KPI, scatter plot, etc.

I have done a course on Introduction to Power BI with Vidyarjan Academy, conducted by Dr Shrikant Mulik. For someone like me with only a background in Excel, Shrikant was able to guide me step by step and provide an overview of Power BI in a very simple manner. I found the course very useful and recommend it for anyone wanting a comprehensive understanding of advanced data presentation tools.

Mr Sudarshan Shreenivas

About Faculty

Dr Shrikant Mulik has 24+ years of industry experience out of which he worked at L&T Infotech (LTI) for almost 18 years. He has also worked at NMIMS University for 1.5 years and at IIT Bombay for one year. He currently serves as CEO at Vidyarjan Consulting Private Limited. Shrikant has done his PhD at NMIMS University, MBA at IIT Bombay and B.E. (Computer) from Mumbai University.

upgrade yourself

Learn Skills for Career Growth

Seats are Limited so hurry up!

Scroll to Top
Let's Talk
1
Scan the code
Hello 👋
Can we help you?