Datalere Power BI
Power BI is the fastest growing visualization tool on the market and for good reasons. Power BI desktop offers the ability to create stunning looking visualizations from your organization’s disparate data sources. The Power BI service offers an online, interactive experience to securely share your organization’s insights to drive data-decision making for your organization.
Datalere has created training geared at getting your team leveraging Power BI Desktop and Power BI Service that includes lecture and hands-on exercises to reinforce the learning.
Organizations are leveraging Power BI due to its rich feature set, ease of use and low total cost of ownership. This training course is focused on getting your team familiar and using Power BI desktop and the Power BI Service within days, not months or a year it would take for your team to get up to speed on their own.
Who should attend:
Organizations with teams who are new to developing and publishing reports and dashboards with Power BI. This training will provide a practical hands-on approach to getting your team members working with Power BI within two days.
Each attendee should have access to a laptop or desktop they can utilize for the duration of the training with the current version of Power BI Desktop installed.
Part 1: Getting Data & Prepare Data
Learn how to get data and prepare data in Power BI, including importing data from sources such as Excel workbooks and CSVs, entering your own data, and additionally learn about the Power BI-equivalent of Excel’s pivot tables, text formatting such as rounding and case (proper, uppercase, lowercase), text-to-columns, and simple functions such as left(), mid(), right(), and trim().
Part 2: Modeling Data
Data modeling focuses on ensuring you have the needed measures, hierarchies, relationships, formatting of measures and columns. We’ll create simple calculated columns such as SUM and AVG.
Part 3: DAX
Learn how to perform calculations in Power BI using Power BI’s Excel-like syntax, DAX. We’ll cover topics such as IF statements, AND statements, concatenate, MIN, MAX, and DAYS.
Part 4: Creating Visualizations & Tables
Learn how to create visualizations and data tables in Power BI using standard line charts, area charts, pie charts, bar charts, scatter charts, and waterfall charts. We’ll additionally cover how to add a slicer, or a filter, to your visualizations and data tables.
Part 5: Publishing & Sharing to the Power BI Service
Learn how you can use Power BI to publish and share your dashboards throughout your organization easily.
Duration
This training is a three-day course that will include coffee and lunch breaks. Coffee and a light lunch is included.
Location
Training hosted at your location in a training or conference room to maximize the value of the training. The facility must have a basic setup of projector and screen along with tables and chairs for the attendees. If you do not have a training facility, we will locate a nearby facility to host the training.
The corporate world has depended on Excel to massage and built reports for years. With the accelerated growth of Power BI, professionals are now looking to expand upon their knowledge of Microsoft Excel and enable themselves to start building interactive visuals.
Power BI is a business intelligence tool developed by Microsoft designed for business users who are already familiar with Excel. It’s specifically designed to create interactive dashboards and reports using data from a variety of sources to be published and shared across organizations.
Benefits of Power BI over Excel:
- Easily share visualizations with your department and organization
- Mobile friendly visualizations
- Improved visualizations
- Accelerated development cycle with monthly updates
- Combine and work with data in multiple sources or workbooks
Who should attend:
Organizations with teams who are new to developing and publishing reports and dashboards with Power BI. This training will provide a practical hands-on approach to getting your team members working with Power BI within two days.
Each attendee should have access to a laptop or desktop they can utilize for the duration of the training with the current version of Power BI Desktop installed.
Getting Data & Manipulating Data: Part 1
Learn how to get data and manipulate data in Power BI, including importing data from sources such as Excel workbooks and CSVs, entering your own data, creating a simple calculated column (such as a SUM or AVG column), and additionally learn about the Power BI-equivalent of Excel’s pivot tables, text formatting such as rounding and case (proper, uppercase, lowercase), text-to-columns, and simple functions such as left(), mid(), right(), and trim().
Manipulating Data: Part 2
Continued learning in how to manipulate data in Power BI, including how to work with data from multiple sources, the Power BI-equivalent of a vlookup, sorting data, and applying a number format.
Calculations in Power BI using Excel-like Syntax
Learn how to perform calculations in Power BI using Power BI’s Excel-like syntax, DAX. We’ll cover topics such as IF statements, AND statements, concatenate, MIN, MAX, and DAYS.
Creating Visualizations & Tables
Learn how to create visualizations and data tables in Power BI using standard line charts, area charts, pie charts, bar charts, scatter charts, and waterfall charts. We’ll additionally cover how to add a slicer, or a filter, to your visualizations and data tables.
Publishing & Sharing to the Power BI Service
Learn how you can use Power BI to publish and share your dashboards throughout your organization easily.
Duration
This training is a full day course that will include coffee and lunch breaks. Coffee and a light lunch is included.
Location
Training will be conducted at your location in a training or conference room. The facility must have a basic setup of projector and screen along with tables and chairs for the attendees. If you do not have a training facility, we will locate a nearby facility to host the training at.