2-DAY CLASS
LENGTH 14 HOUR CLASS TIME
Microsoft® Power Bi (Business Intelligence) “is a business analytics solution that lets you visualize your data
and share insights across your organization, or embed them in your app or website.” The solution comprises
several products and services, and value and versatility come from leveraging the individual elements, and
taking advantage of how they work together.
Upon completion of this course, you will be able to:
• Understand the differences between Power Bi and Excel
• Data model using DAX
• Enhance your reports and dashboards
How do you know whether Microsoft Power BI is right for you? Here are seven reasons to choose Power Bi:
1. A quick start. You’ll be able to get insights quickly with an uncomplicated setup, no required training,and included dashboards for services such as Sal esforce, Google Analytics, and Microsoft Dynamics.
2. Streamlined publication and distribution. Instead of emailing large files or putting them on a shared drive, analysts upload reports and visualizations to the Power BI service, and their data is refreshed whenever the underlying dataset is updated.
3. Real-time information. Dashboards update in real time, as data is pushed or streamed in, which gives viewers the ability to solve problems and identify opportunities quickly. Any report or dashboard can display and update real-time data and visuals. Sources of streaming data can be factory sensors, social media sources, or anything from which time-sensitive data can be collected or transmitted.
4. Ability to customize Power BI app navigation. An “app navigation experiences” feature gives report developers the power to customize navigation to help viewers find content quickly and understand the relationships between different reports and dashboards.
5. Ability to customize security features. Report developers can set up row-level security (RLS) access filters to ensure that viewers see only data relevant to them, mitigating the risk of people seeing data they shouldn’t.
6. Cortana integration. Power BI works with Microsoft’s digital assistant, Cortana. Users can verbally ask questions in natural language to access charts and graphs. This can be especially helpful for users with mobile devices.
7. Artificial Intelligence. Power BI users can access image recognition and text analytics, create machine learning models, and integrate with Azure Machine Learning.
Prerequisites:
The prerequisites for this course are a solid working knowledge of Windows and the use of a keyboard and mouse. It is also essential that you understand the advanced concepts related to data integration and Excel concepts
Classroom Outline:
DATA ANALYSIS WITH POWER BI
•Defining BI / Data Analysis / Visualization
•Power BI Desktop
•Excel vs Power BI
•Power BI Interface
CONNECTING TO YOUR DATA
•Navigator Window
•Importing vs Live Connection
•Relationship Types
•Cross Filter Direction
TRANSFORMING YOUR DATA
•Data View to Transform
•Power Query Editor
•Close & Apply vs Saving
•Combining Queries
•Adv Editor & M Language
DATA MODELING WITH DAX
•What is DAX
•Formula Bar
•DAX Error Checking
•Calculated Columns vs Measures
•Table Unions
VISUALIZATIONS FOR YOUR REPORTS
•Visualizations, Filters & Fields Pane
•Types of Visuals
•Microsoft Marketplace
•Enhancing Your Reports / Dashboards
INTERACTIVE VISUALIZATIONS
•Hierarchies
•Filters & Slicers
•Drill Through Filters
PUBLISHING TO THE POWER BI WEB APP
•Using Workspaces •Power BI Mobil App
This outline is a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.
In the world of Microsoft, the only constant thing is change. Office 365 has evolved into Microsoft 365. This is just a quick article
