Using Business Intelligence for Data Driving Decision Making!
Omni Academy offer’s a unique Advanced Power BI course, training specially designed to meet the requirements of modern business worker need expertise with business intelligence tools and deep data analytics skills. Course participants will learn all the key analytical reports and dashboards creation functions and features using Power BI tools from basic to the mastery level of expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance.
Course Key Learning
Course is ideal for those looking to gain a firm understanding of how to produce and publish powerful visual reports and dashboard, perform data analysis by using the Power BI.
- Learn to use Power BI (Business Intelligence) Desktop to create highly visual reports and dashboards that can easily be shared with others.
- Get an understanding of how the reports and dashboards can interact with each other and the great level of interactivity the audience can use to drill, filter, and sort the reports.
- Data Visualization
- Industry Use Cases
Course Key Topic
Power Bi Desktop Basics
- Power BI Use Case
- Installation and Setup
What is Power Bi Desktop
- Introducing the Power BI Ecosystem
- Getting started with Power BI Desktop
Digital Storytelling
- Purpose of creating dashboard/reports
- Planning Reports & Dashboards
- Structure Reports & Dashboards
- Simple Data connections
- Connect to Excel data (single table)
- Connect to a data model created in Power Bi Desktop
Calculations
- Sum, Average
- Divide, Multiply
Power Bi standard visuals
- Chart, Table, Matrix
- Treemap, Funnel, Map
- KPI, Gauge
- Card, Multi Row Card, Slicer
Custom Visuals
- Import and use custom visuals
- Visuals interactions
- How to use Images, Shapes, and Textboxes on pages
Buttons and Bookmarks
- Add navigation to report
- Add interactivity to reports using buttons
Drill/Filter & Sort
- Page level filters
- Report level filter
- Drill through levels in visuals
- Sort data in visuals
- Sort by column
Tooltip Page
- Control Tooltips
- Create Tooltip pages
- Set interaction between visuals and tooltip pages
Layout and Formatting
- Format visuals, Format pages
- Work with themes, Snap Object to Grid
- Use gridlines, Lock Objects
- Selection Pane, Conditional Colour formatting
- Publishing Reports and Dashboard
Power BI Service and Excel PowerPivot
- Creating a PowerPivot Data Model
- Import data from PowerPivot to Power BI Service
- Using PowerPivot data to create visualisations in Power BI Service
Power BI Desktop for Visualisation Workshop
- Adding visualisations to Report Canvas
- Managing visualisation relationships
- Drill Down and Drill through techniques
- Use of Hierarchies
- Importing and using custom visualisations
Sharing Data with Power BI
- Share interactive Power BI dashboards
- Share through Power BI, PowerPoint, the web and other mediums
- Content Packs
Refreshing Data
- Refreshing data manually
- Scheduled Refresh
Power BI on Mobile Devices
- Meeting different mobile clients’ requirements
- Windows 10, Ipad, Android
Course Useful Downloads
Microsoft Power BI Report Builder
🎥 Your FREE eLEARNING Courses (Click Here)
Job Interview Preparation (Questions & Answers)
International Student Fee : 300$ | 1,125 AED | 1,125 SAR
Flexible Class Options
- Evening Classes | Corporate BootCamp Workshops | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes Available
Related Courses
Microsoft Office ( Complete Course )
Ms Office – Advanced Excel with Outlook
Oracle BI Training 11g R1 – Create Analyses and Dashboards
Oracle DBA 11g/12c Training
Tableau Basic to Advanced Training