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?

  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.

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.

More Posts

Follow Me:
FacebookLinkedIn


Leave a Comment

2 Comments on "PowerBI Workshop"

Notify of
avatar
1000
Sort by:   newest | oldest | most voted
norlina@cp-malaysia.com
Guest

Hi, Could you train a group of people for PowerBI based on actual data

wpDiscuz