Introduction to Microsoft Power BI Dashboards

Speaker

Instructor: Joe Weil
Product ID: 706787
Training Level: Basic

Location
  • Duration: 100 Min
Analytics, data visualization, and Corporate Intelligence (BI) are hot subjects for many organizations and professional recruiters in today's fast-paced, high-tech, competitive business world. Organizations of all sizes are increasingly attempting to leverage the huge data resources at their disposal in order to uncover previously uncovered insights and achieve competitive advantages. MS Power BI - Excel's big brother – on steroids! – is the main tool for this, especially following the sale of Tableau! Just a few years ago, these "big data" desk-top technologies were out of reach. Microsoft Desktop Power BI is now available for free. Power BI Pro, a cloud-based service that costs $10 a month for a small business, is used by Fortune 1000 companies on an enterprise-wide basis at extremely competitive prices.
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info. Webinar All Access Pass Subscription

 

Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions

Why Should You Attend:

If you understand Excel charts and have an overview of Pivot Tables then you can leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This webinar takes you from Excel Dashboards to easier and more powerful MS Power BI dashboards. With this training you’ll learn the basics of implementing "do it yourself business intelligence" using Power BI.

Over the last few years, data has become the lifeblood of organizations. Those organizations that harness the power of big data business intelligence (BI) realize tangible competitive advantages. MS Power BI allows mangers to rely less on the IT department and achieve more self-service, control, agility and focused business intelligence (BI) using both the data warehouse and outside sources. With MS Power BI you can easily manipulate several databases. MS Power BI is easy, fast, and free.

Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data. Monitor the health of your business using a live dashboard, create rich interactive reports with Power BI Desktop.

The top BI trends for 2021 include:

  • Data literacy becomes a fundamental skill of the future
  • Modern BI such as Power BI becomes the new normal
  • Advanced analytics becomes more accessible
  • Those versatile in using big data analytics in conjunction with professional-level data visualizations for business intelligence decision making will have a path to the future.

In 2015 Microsoft introduced Power BI in its current form. Microsoft’s major BI competitor, Tableau, saw their stock price fall 50% within three months. Three years later Tableau was sold to another firm. Today Microsoft Power BI dominates the BI software market. Now you can learn the essential basics of MS Power BI in just 100 minutes.

If You Know Excel Beyond a Beginner’s Level You Can Easily Master the Essential Skills for the Jobs of Tomorrow and Take Your Career to the Next Level with MS Power BI.

Learning Objectives:

  • Introduction to Power BI and how to sign up for free
  • How to create your first online report and dashboard
  • How to download the Power BI Desktop Designer
  • Loading, transforming and filtering and cross-filtering data in Power BI
  • Creating tables and reports
  • Learning how to use the wide range of charts and visualizations
  • Creating relationships between tables of data
  • Creating powerful calculations, key metrics and key performance indicators
  • Creating interactive KPI dashboards almost instantly – easier than Excel

Areas Covered in the Webinar:

  • Introduction to Power BI Desktop
    • Downloading the Power BI Desktop for Free
    • Desktop Summary - Three Different Views and What They Do
    • An Overview of the Workflow in Power BI Desktop
    • Dashboard in Minutes - Overview
  • Loading the Data Model - Connecting Power BI Desktop to Data Sources
    • Connecting to Excel Data Sources
    • Connecting to CSV and text files
    • Connecting to a Folder of data
    • Connecting to a web URL
  • Introduction to the Query Editor Interface: Editing Data
    • Cleaning up and transforming data
    • Establishing Headers and Removing rows
    • Editing and Renaming Rows and Columns
    • Rearranging columns
    • Creating custom columns
    • Trim and Clean
    • Replacing Values
    • Splitting columns
    • Pivoting and Unpivoting Columns
  • Understanding Database Relationships: Power BI Data Modeling
    • The Data Model: Data & Relationship Power BI Desktop View
    • Adding Databases and Connecting Data Model Relationships
    • Creating Relationships Automatically and Manually
    • Primary Key, Foreign Keys and Index Columns
    • Understanding Cardinality: Many to Many and One To Many Relationships
    • Creating DIM and FACT Table(s)
    • Introducing the Star Schema
    • Creating a date table - date/time intelligence
  • Modeling with Power BI Desktop
    • Formatting Data
    • Performing Basic Mathematical Operations
    • DAX: Creating Calculated Columns and Measures
    • Using time intelligence functions
    • Formatting Dates
    • Using the SUMX function
  • Power BI Desktop Report View: Creating Interactive Visualizations/Dashboards
    • Walkthrough of Available Charts
    • Creating Your First Visualizations
    • Data, Format and Analytics Controls
    • Creating Column, Bar and Line Charts
    • Aggregating Data: Default Summarization & Sorting
    • Grouping data
    • Reference/Constant Lines
    • Stacked and 100% Graphs
    • Formatting, Colors, Charts and Sorting
    • Tables, Matrices & Conditional Formatting
    • Trend Analysis Graphs - Analytics
    • Cards, Multi-Row Cards, Gauges, Targets and KPIs
    • Scatterplots and Bubble plots
    • Scatter & Bubble Charts & Play Axis
    • Map Visualizations
    • Adding Color Saturation
    • Tree map v. Pie or Donut (Desert) Charts
    • Creating/Managing Hierarchies Including Date Hierarchies and Drill-Down /Up
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Creating Slicers & Timeline Slicers
    • Backgrounds, logos and images
    • Customizing Tooltip Messages
    • The Quick Calc Option
    • Downloading Custom Visuals and Slicers

Who Will Benefit:

  • Financial Professionals Including CFO's, Controllers, Accounting and Finance Managers and Staff
  • Financial Analysts, Budget Directors and Staff, CPAs, Auditors, Administrators and Managers
  • HR and Sales professionals who prepare reports using Excel
  • Engineers and Production Managers who prepare reports using Excel
  • IT Professionals Who Want an Fun, Easy Way To Prepare KPI Dashboards
Instructor Profile:
Joe Weil

Joe Weil
CEO, NCCE

Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. With over 25 years’ experience, Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.

Follow us :

 

 

Refund Policy

Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).

 

 

+1-888-717-2436

6201 America Center Drive Suite 240, San Jose, CA 95002, USA

Follow Us

facebook twitter linkedin youtube

 

Copyright © 2023 ComplianceOnline.com MetricStream
Our Policies: Terms of use | Privacy

PAYMENT METHOD: 100% Secure Transaction

payment method