DATA MODERNIZATION
Power BI Workshop
Need Of The Workshop
Organizations who would want to enable their business users to do self service analytics and leverage AI capability within Power BI to analyze their data in a rich and compelling manner. This workshop would cover people who have just started to evaluate Power BI to meet the organizational requirement around data visualization and analysis as well as cater to people who want to learn how to use Power BI to be more efficient with their data and make a greater impact on the day-to-day work, they do.
According to Gartner,75% of databases will be in the cloud by 2022.
Gartner goes on to add that the main driver for migrating data to the cloud is to
capture superior analytics and to take advantage of the pay as you go model.
35 % of organizations cite insufficient tools or technology as their primary challenge
35 % of organizations lack adequate in-house skills/knowledge
Who Can Attend
Business users who want to build their own reports and dashboards
Data analysts who want to learn advanced capabilities of power BI.
Business users who want to connect to multiple data sources and understand best practice for Data modeling.
Data analysts who want to build their own custom visual.
Outcome Of The Workshop
Understand data extraction, transformation , data visualization and AI features in Power BI.
Best practices for Power BI
Data profiling, Data lineage , streaming analytics , Data security and data governance in Power BI
Power Bi adoption plan
Agenda(Day-1) & Pre-requisites :: Power Bi Workshop
- Identify a data source (Preferably excel or csv or SQL database) on top of which a report can be built and demoed.
- Power Bi desktop installed on the user’s machine.
- Power Bi pro license – trial can be enabled.
- One week notice if the workshop must be run on a data source from your organization.
- If data source is not provided, Acuvate will share the data sources and the material for the hands-on-lab.
Agenda (Times are approximate and will be fluid with the class)
| Day 1 – Morning | |
| 09:00 AM – 09:10 AM | Introduction to Acuvate |
| 09:10 AM – 10:00 AM | Introduction to Power BI and Power BI Demo |
| 10:00 AM – 10:30 AM | Environment setup if not done already and showcase other reports |
| 10:30 AM – 10:45 AM | Break |
| 10:45 AM – 11:30 AM | Lab1 Accessing and Preparing data |
| 11:30 AM – 12:30 PM | Lab1 Solution + Questions |
| 12:30 PM – 1:30 PM | Break |
| Day 1 – Afternoon | |
| 1:30 PM – 2:15 PM | Lab2 Data modeling and Exploration |
| 2:15 PM – 3:15 PM | Lab2 Solution + Questions |
| 3:15 PM – 3:30 PM | Break |
| 3:30 PM – 4:15 PM | Lab3 Visualisation |
| 4:15 PM – 5:00 PM | Lab3 Solution + Questions |
Agenda (Day-2) :: Power Bi Workshop
Agenda (Times are approximate and will be fluid with the class)
| Day 2 – Morning | |
| 09:00 AM – 09:30 AM | Recap of Day 1 + Questions |
| 09:30 AM – 10:00 AM | Introduction to today’s lab and showcase report usecases |
| 10:00 AM – 10:45 AM | Lab 4 Publishing and accessing reports |
| 10:45 AM – 11:00 AM | Break |
| 11:00 AM – 12:00 PM | Lab 4 solution + Questions |
| 12:00 PM – 12:30 PM | AI features in Power BI |
| 12:30 PM – 1:30 PM | Break |
| Day 2 – Afternoon | |
| 1:30 PM – 2:15 PM | Lab 5 Building a dashboard and sharing |
| 2:15 PM – 3:15 PM | Lab 5 Solution + Questions (Identify report to be built/migrated) |
| 3:15 PM – 3:30 PM | Break |
| 3:30 PM – 4:15 PM | Lab 6 Best practices in data visualization – Tips and Tricks(Build your own report with your own data) |
| 4:15 PM – 5:00 PM | Lab 6 Solution + Questions |
Trusted by the best
