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?

  1. 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.
  2. We have created training classes and the ability to custom-create Quest training courses that meet your company’s specific needs.
  3. 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

 Iverson_logo_RGB  Proton-logo-720543 Microsoft-Dynamics-Partners

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.


  • 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

Share This Story

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

Share Your Comments

Inline Feedbacks
View all comments

About The Author

Search Articles


Follow Fard Solutions