Data Analysis and Visualization with Power BI Course

Data is the new crude oil and the success of business in the 21st century is heavily reliant on the ability to mine and use consumers’ data, financial data and internal operations data to drive business decisions.

Our instructor-led Power BI training helps teams adopt Power BI for self-service business intelligence and analytics. Through this practical-based approach with hands-on labs and in- person guidance, attendees will be able to build and share stunning visualizations and valuable data insights quickly and easily with Power BI. This expertly designed framework will leave attendees with the knowledge they need to take full advantage of Power BI capabilities and set them up for success with the tool.

The question is, where do you start? During this three-days training, we’ll walk you through the necessary steps: we’ll import data with queries, create a data model with the necessary relationships and calculations, build an interactive report and publish it. Lastly, we’ll make a dashboard which you can share with your colleagues.

Objectives:

After completing this training, you will be able to:

• Describe key concepts in business intelligence
• Describe key concepts in data analysis
• Describe key concepts in data visualization
• Describe the rationale for self-service BI
• Describe considerations for self-service BI
• Import data via queries
• Create a dashboard
• Use queries to transform data into usable, meaningful tables
• Create a data model with relationships, custom sorting, a date dimension table, etc
• Use Excel as a Power BI data source
• Use databases as a Power BI data source and describe the R language
• Create Power BI Desktop queries
• Shape data and Combine data
• Set up interactions between charts
• Write simple DAX queries
• Create calculations and measures
• Use Power BI Desktop to create interactive data visualizations

Target Audience

The Microsoft Power BI Training is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. It is best suited for: Business Analysts, financial analyst, Business Intelligence Manager, economists, Statisticians and Analysts, Data Scientists and Project Managers

Course Outline

Introduction

• A history of Business Intelligence
• The development of Self Service
• Business Intelligence
• Introducing Power BI
• How does Power BI fit in?
• Introducing the three main tools – Power BI Service, Power BI desktop and Power BI Mobile
• When to use Power BI Desktop
• Free versus Pro Signing up to the Power BI online service
• Which sources of Data can I use in Power BI Desktop?

Power BI Desktop

• The BI Process
• Data Source and loading
• Introduction to the data source used in this course
• Creating Tables of Data
• Import data from Excel
• Import data from Web
• Renaming Queries
• Grouping Queries
• Including and Excluding Queries in report refresh
• Enabling or disabling Query loading
• Applying Queries
• Viewing Query dependencies
• Append Queries
• Merge Queries
• Merge Query Types
• Cleaning the resulting query

Using Data from an Excel Workbook

• Understanding your data
• Importing data from an Excel worksheet
• Excel Tables
• Importing table data from the Excel file
• Saving in Power BI Desktop

Visualisations

• ​Working with Formats and Visualisations
• From Visualizations to Reports
• Text B Text boxes Shapes
• Working with Filters
• ​Working with Desktops Files
• Q and A
• Making Visualizations with natural language queries
• Enabling Q and A in Power BI Desktop
• Create a Visual using Q and A
• Add categories to the Q and A expression
• Add conditions to Q and A
• Add grouping to the Q and A
• Specify a visual type

Refreshing your Data

• Power Query (Query Editor)
• Using Custom Visuals​
• Synchronise Slicers
• Report Themes
• Data Model and Transformation
• Date Transformations
• Power Query UI
• Data Modelling​
• Column Transformations
• DAX
• Functions
• Time   Intelligence Functions
• Power BI Templates and Parameters
• Connect   Excel   and Power BI

Desktop

• Extra Processes
• Dynamic Web Queries Using Parameters​

NB: All exercises and project files used on the course will be available for class use and take home.