Advance Excel for Dashboards & Business Intelligence

Program Introduction

Are you in need for making sense of tons of Data? Are you interested in analyzing your corporate data in more professional way? Access to business intelligence (BI) has become a priority for many companies. Business Intelligence Tools of Excel provide an expansive set of features that enable to extract information from complex data, create dynamic reports and presentations. In this training, learn how to manage, connect excel with different data sources, compile huge data sets and create data model with Excel PowerPivot, create a visually appealing Power View sheet, and use Power Map to integrate the data with Bing Maps to create a video presentation. Using Power BI Designer to create eye-catching visualization and dashboards share with your colleagues and let them access these reports on browsers and mobile devices.

Training Content

Discover, Combine & Clean Data with POWER QUERY

• Converting data formats with Power Query steps
• Parsing columns to aid analysis
• Constructing a single data set from multiple sources with the same field headings.
• Merge queries to combine multiple data sets
• Unpivoting columns to convert reports into tabular form
• Changing data type to avoid errors in Data model
• Understanding Power Query “M” Language

Build Data Model with Power Pivot

• Why we need Power Pivot?
• Navigating the interface
• Loading a single data source
• Creating a dashboard

Building the Data Model with Power Pivot

• Understanding what is data model & why users need data modeling?
• Importing data from different data sources
• Create linked table in Power Pivot using Excel Tables
• Deriving relationships from data sources with the relationship tools and the diagram view

De-normalizing data to simplify Data Model

• Acquiring data from related tables
• Defining calculated columns

Defining calculated fields for business performance

• Introduction to DAX language
• What is Row context & Filter context?
• Providing context for calculated fields within a PivotTable
• Determining between implicit and explicit calculated fields

Implementing DAX functions in Power Pivot

• Expressing information with calculated fields
• Exposing hidden information from data
• Troubleshooting and debugging DAX calculations

Exploiting data analytics with aggregation

• Quantifying and mining information with DAX functions
• Summarizing and aggregating data from other tables with theX functions
• Evaluating expressions with the CALCULATE () function and FILTERfunctions
• Overriding filter context using ALL () function

Mining for information with time intelligence formulas

• Parsing dates for time analysis& why calendar table is useful?
• YTD, QTD, MTD
• Creating Parameter table in Power Pivot
• Ranking over a calculated field

Setting key business targets with KPIs

• Analyzing performance with calculated fields
• Gauging performance against goals

Articulating and analyzing data

• Creating matrix, table & cards to present multiple information
• Inserting callouts cards to focus of important information
• Inserting products, employee & location pictures in dashboards
• Drilling down into data using a hierarchy

Designing effective dashboards

• Contextualizing calculated fields Power View filters
• Visualizing and comparing performance matrices with Power Viewmultipliers
• Globalizing location-based results to identify trends and patterns on a3D scale with Power Map

Creating Dashboards on Power BI Desktop

• Customizing Power BI Charts
• Introducing TreeMap, Funnel Charts, Water Fall Charts, Gauge Chart& KPI Charts
• Creating dynamic calendar table & integrating with Dataset
• ARC Gis Maps in Power BI Desktop
• Understanding Drill Down, Hierarchies, Color Saturation & ToolTips
• Inserting calculating columns and calculated fields (Measures)
• Exporting data from Power BI to CSV
• Importing Excel files containing Power Pivot Data Model,Power View Reports & KPI

Power BI Services

• Creating Power BI account to use its services
• Understanding Power BI online Data sets, Reports & Dashboards
• Ask Question in Dashboards using Q&A option

Power BI on Mobile Devices

• Sharing your dashboards with others
• Configuring Power BI account in Mobile devices
• Presenting Power BI Dashboards live on Power BI Presentation

Who Should Attend

Data analysts, Business intelligence professionals and anyone who wants to keep the pace with marvelous development of Microsoft in Business Intelligence for modern corporate World

For Further Details 

huma.alvi@wordpress-764963-3017117.cloudwaysapps.com    0322-2039799
shahzaib.ul.mulk@wordpress-764963-3017117.cloudwaysapps.com  0321-5359737

Click here to Download Flyer

Payment Details:

The cheque will be made under the name of “Pakistan Society for Training and Development” and dispatch it to following address;

Pakistan Society for Training and Development
Plot # TC-3, 34th Street, Khayaban-e-Seher
Phase V, DHA, Karachi 75500.

Cancellation Policy:

PSTD Cancellation Policy – Cancellations made at least 5 working days prior to the program will be refunded 50%. If a booking is canceled in less than 5 working days, no refunds can be given. Cancellations must be confirmed by a letter or email. Substitutions may be made at any time for the same program only. In case of the participant not showing up on the day of the training a replacement can be sent.