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.
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
DATA ANALYSIS WITH POWER BI
•Defining BI / Data Analysis / Visualization
•Power BI Desktop
•Excel vs Power BI
•Power BI Interface
CONNECTING TO YOUR DATA
•Importing vs Live Connection
•Cross Filter Direction
TRANSFORMING YOUR DATA
•Data View to Transform
•Power Query Editor
•Close & Apply vs Saving
•Adv Editor & M Language
DATA MODELING WITH DAX
•What is DAX
•DAX Error Checking
•Calculated Columns vs Measures
VISUALIZATIONS FOR YOUR REPORTS
•Visualizations, Filters & Fields Pane
•Types of Visuals
•Enhancing Your Reports / Dashboards
•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.