Fard Solutions Sdn. Bhd. » Blog Archive PowerBI Workshop

PowerBI Workshop

The estimated reading time for this post is 2 minutes

Training Summary:

Fard Solutions Consulting understands our client busy schedules that do not allow for prolonged travel to a distant training facility. For this matter we created In-House training whereby our trainer will personally conduct the training in clients’ office. Our training classes can accommodate classroom sizes from up to twenty five(25), but we have found fifteen (15) or fewer students per class to be the most productive experience for our participants. We ensure every participant has all the tools they need to succeed in every class.

What we offer?

Our participants enjoy a true technical, “hands-on” experience, with virtual images on each participant’s personalized computer. Our training lab utilizes our simple yet effective format of Learn it, Do it, Prove it. Every class is comprised of PowerPoint-driven lectures and “hands-on” labs.
We have created training classes and the ability to custom-create Quest training courses that meet your company’s specific needs.
At the end of the training we provide quick reference booklet to every participants which is the summary of every custom course we trained.

Conducted For

Course Information

Title: FS-5010A Microsoft PowerBI

Duration: 1 Day

Time: 09:00 am – 05:00 pm

Intended for Data Analysts who are responsible for the analytic of their data and report generation.

Prerequisites

Experience with Microsoft Excel.
Understanding of Data Analytic concept.

Course Outline

Introduction to Power BI, Power Pivot, Power Query, Power View, Power Map

Introduction to SSBI
SSBI Tools
What is Power BI?
Power BI – Flow of Activity
Building Blocks of Power BI
Power BI – Primary Tools : Power Pivot, Power Query, Power View, Power Map, Power Q&A, Power BI Desktop

Power BI Desktop

Data Sources and Connections (Excel and CSV files, database or web data, etc…)
Connect to Data in Power BI Desktop
How to use Query Editor in Power BI
Advanced Data Changes and Transformation
Modeling Data – Manage Data Relationship, Create Calculated Columns, Optimize Data Models
Shaping Data in Power Query
Combining data from multiple sources
Creating relationship between tables
Views in Power BI Desktop
Publishing to the Power BI cloud service

Data Analysis Expressions (DAX)

What is DAX?
Data Types in DAX
Calculation Types
DAX Functions : Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text, Aggregate
Measures in DAX
Table Relationships and DAX

Data visualization

Why Data Visualization
Practices for Data Visualization
How to use Visual in Power BI
Reports in Power BI
Charts in Power BI (Scatter, Waterfall, Funnel)
Slicers
Treemaps Visualizations
Tables Visualizations
Map Visualizations
Gauges and Single Number Cards

Introduction to Power BI Q&A and Data Insights

Power BI Q&A
Dashboard
Dashboard vs Reports
Creating a Dashboard
Dashboard Tiles
Pinning Tiles
Quick Insights with Power BI
Power BI Publisher for Excel

Custom Visualizations

Office Store
Downloading Custom Visuals
Importing Custom Visuals in Power BI Report
KPI Visuals
Data Binding in Power BI

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

Follow Me: