Description
Who Should Attend?
This course is ideal for those who want to understand and utilise the potential of Power BI. If you are a beginner, this training will help you use Power BI to deep dive and understand the data underneath your business so you can make better business decisions. You will build a firm foundation of knowledge to make Power BI your personal report and visualisation tool. If you are a Power BI veteran, this training will tie concepts together and fill in the gaps.
Microsoft® Excel knowledge is a prerequisite for this training.
About The Programme
This Two-Day programme takes users from being ‘Beginner’ to ‘Proficient’ Business Intelligence report generators.
Course Objectives
- To understand the parts and building blocks of Power BI
- To be able to get data from multiple sources into Power BI Desktop
- To be able to build relationships and model your data to prepare for reports
- To create new visualisations or build dashboards in Power BI service
- To publish and share your dashboards
- To be able to view and interact with shared dashboards and reports in Power BI Mobile Apps
- To learn how to find, connect to, and interact with data in Power BI
- To be able to use Excel and Power BI together and create powerful, connected reports and visuals
- To learn DAX basics and fundamentals – how to think about DAX, how it works, and the most useful features
What You Will Gain
- A sound working knowledge of Power BI elements
- An in-depth understanding of how to get data and build reports from scratch
- An understanding of how to bring your data to life, and reveal insights by using compelling visual representation in Power BI
- An ability to build user friendly dashboards and publish, export, share, and distribute your Power BI data insights
- An introduction to DAX, the language used to create Power BI queries
Programme Content
DAY ONE
- Getting Started
> Introduction To Power BI
> The Parts Of Power BI
> The Flow Of Work In Power BI
> Using Power BI
> Building Blocks Of Power BI
> Understanding Power BI Service - Getting Data
> Install And Run Power BI Desktop
> Connect To Data Sources In Power BI Desktop
> Clean And Transform Data With Power Query Editor
>> Shape Data
>> SConnect To Data
>> SCombine Data
> More Advanced Data Sources And Transformation
> Cleaning Irregularly Formatted Data - Modeling
> Introduction To Modeling Your Data
> How To Manage Your Data Relationships
> Create Calculated Columns
> Optimising Data Models
> Create Calculated Measures
> Create Calculated Tables
> Explore Your Time-Based Data - Visualisations
> Introduction To Visuals In Power BI
> Create And Customise Simple Visuals
> Combination Charts
> Slicers
> Map Visualisations
> Matrixes And Tables
DAY TWO
- Visualisations (Contd.)
> Scatter Charts
> Waterfall And Funnel Charts
> Gauges And Single-Number Cards
> Modify Colour In Charts And Visuals
> Shapes, Text Boxes And Images
> Page Layout And Formatting
> Group Interactions Among Visualisations
> Duplicate A Report Page
> Show Categories With No Data
> Summarisation And Category Options
> Z-Order
> Visual Hierarchies And Drill Down
> R Integration In Power BI Desktop - Exploring Data
> Quick Insights In Power BI
> Create And Configure A Dashboard
> Ask Questions Of Your Data With Natural Language
> Create Custom Q & A Suggestions
> Share Dashboards With Your Organization
> Edit Tile Details And Add Widgets
> Install And Configure A Personal Gateway - Publishing And Sharing
> Publish Power BI Desktop Reports
> Print And Export Dashboards And Reports
> Manually Republish And Refresh Your Data
> Introducing Power BI Mobile
> Create Groups In Power BI
> Build, Use, And Update Apps
> Integrate OneDrive For Business With Power BI
> Publish To Web - Introduction To DAX
> DAX Calculation Types
> DAX Functions
> Using Variables In DAX Expressions
> Table Relationships And DAX
> DAX Tables And Filtering
Before the course each delegate will be asked to complete a Pre-Course Briefing Form to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.
At the end of the course each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.
Total Investment: AED 2,600/- + VAT, which includes – Training Materials, Lunch and Refreshments. Discount available for multiple bookings.