Microsoft Power BI
Event Information
About this Event
Due to Covid-19 all sessions will be conducted online.
Microsoft Power BI
Why learn Power BI
We live in the world of data. In business, we receive various reports, charts, emails, and even printed handouts that contain a lot of information. As the data accumulates, it becomes very challenging to get required information instantly. Power BI is a smart solution that can connect to almost any source of information. It helps you to:
- Collect and clean data in an automated manner.
- Analyze and examine data with powerful DAX functions.
- Transform your enterprise data into rich visuals and provide business intelligence for enhanced decision making.
- Setup automated data refresh and publish reports to provide latest information to users.
- Propel organization into a data driven culture.
Who should attend?
- Data Analytics professionals
- Business Intelligence Managers
- Data Scientists
- Accountants
- Financial Analyst
- Project Managers
- Business Analysts
- New Graduates
- All other Analysts
Prerequisites
- Intermediate knowledge of Microsoft Excel 2013 or later.
Duration
- Five sessions of 2 hours each, Tuesdays & Thursdays
Session Type
- Classroom setting, Seats are limited to maximum of 5
What you will learn:
Module 1 Introduction
- Data Analysis, Data Analytics and Business intelligence
- Data Analytics Process – IMPACT Model
- Overview of Power BI
- Connecting to various data sources
- Basic data transformation
- Merge and Append queries
Module 2 Optimizing data models for reporting
- Creating and managing data relationships
- Creating and managing hierarchies.
- Creating calculated columns and measures
- Calculate tables on the fly
- Time intelligence analysis
- Including, excluding and grouping of data
- Data Analysis Expressions
Module 3 Data Visualization
- Visualize data using Line, bar and column charts.
- Measure business performance using Gauge, Card and KPI visuals.
- Analytics pane and Slicers
- Edit visuals relationship and adding custom tooltips
- Understanding combined visualizations and waterfall chart.
- Visual level, page level and report level filters.
- Cross report filters.
- Question and Answer Visual.
- Page view and page size.
- Bookmark and slide show.
Module 4 Working with Power BI Service
- Publishing reports and analysis to Power BI service
- Quick Insights
- Configuring a dashboard
- Featured and favorite dashboards
- Adding live contents to dashboards
- In focus and TV mode
- Natural language queries and featured questions
- Exporting data to CSV or Excel
- Configuring personal gateway
- Sharing and Annotating in Power Bi Mobile