Details
You are an experienced business user of reports and dashboards and understand the role that reporting plays in the decision-making process of your organisation. You need to build reports and dashboards with the minimum involvement of the IT Department, using diverse data sources, for deployment on internal servers, Microsoft OneDrive, Web interfaces, tablets, and smartphones. You create reports and dashboards on an advanced level and / or make these available to colleagues for use on their own dashboards. You need a tool to support the process of creating these reports, and to manage the data and visualizations required by other reports and dashboards. The visualizations may be charts, tables, matrices, text boxes, slicers, etc Your company may use Microsoft Power BI, Microsoft SQL Server, Microsoft SSRS or MS Excel Dashboards Come and learn how to use Microsoft Power BI (Business Intelligence)
In this three day course, attendees will learn the fundamentals of creating their own rich interactive reports and sharing their insights with others.
We will cover
- An introduction to Power BI
- Importing and cleansing data for use in the model
- Modelling your data with DAX
- Creating interactive reports
- Sharing your reports with others
Cost
$689.70 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
3 dayBrochure:
Delivery Method
Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.
Audience
It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers
Pre-Requisites
No prior experience with Power BI or other BI tools is required, some experience with excel is desirable but not mandatory.
If you don't have admin rights on your computer please request your IT department to pre-install Power BI Desktop from https://aka.ms/pbidesktopstore
Course Outline / Curriculum
- Module 1: Introduction to power BI
- What is power BI
- Understanding the power BI architecture
- Installing power BI desktop
- Signup with the Power BI service
- Understanding Power BI licencing
- Module 2: Importing data using Power BI
- Loading data from files and databases
- Removing unwanted rows and columns
- Transforming data
- Cleansing and shaping data
- Using functions and parameters
- Discuss direct query and live query
- Power Query best practice
- Module 3: Enriching your data model with DAX
- Understanding table relationships (Active vs inactive & single direction vs both)
- Creating calculated columns and measures
- Extending your model using date tables (Calculated table)
- Create hierarchies
- Change date and number formats
- Understanding evaluation context
- Time intelligence functions
- Modelling best practice
- Module 4: Visualisations
- Chart types
- Formatting charts
- Understanding report, page and visual filters and slicers
- Designing interactive reports
- Enhanced reports with text boxes, annotation shapes and images
- Custom visuals
- Using report themes
- Visualisation best practice
- Module 5: Sharing report with the power BI Service
- Publishing reports to the Power BI service
- Understanding the difference between reports and dashboards
- Creating schedules and alerts
- Q&A
- Keeping data up-to-date with scheduled refresh and the data gateway
- Designing dashboards for mobile
- Creating Power BI apps
- Publish Power BI to web